Apache Hive is developed by
*
Apache
Facebook
Yahoo
Hadoop Inc.
Apache Hive is a
*
ETL Tool
Warehouse
Database
File System
Which is a complex data type in Hive
*
Spare
List
Struct
Boolean
Which option will block the deletion of the database if it holds tables
*
RESTRICT
XACT_ABORT ON
CASCADE
STOP
Which one is wrong statement?
*
LOAD DATA INPATH 'Desktop/Test.csv' INTO TABLE Test;
LOAD DATA INPATH '/user/cloudera/Test.csv' INTO TABLE Test;
INSERT INTO Test SELECT * FROM TempTest;
LOAD DATA LOCAL INPATH 'Desktop/Test.csv' INTO TABLE Test;
Which one is true for Hive Partitions?
*
Partitions can be added after table creation
Partitions can be dropped
Partition name can be changed
All the above
Display list of the tables from Hive database
*
SHOW TABLES
DISPLAY TABLE
DIR
LIST TABLES
Which statement will return an error?
*
CREATE PARQUET TABLE parquet_table(id INT);
CREATE TABLE parquet_table AS SELECT id FROM sourcetable AS PARQUET;
CREATE TABLE parquet_table(id INT) STORED AS PARQUET;
CREATE TABLE parquet_table AS SELECT id FROM sourcetable;
Which one is NOT true for Hive Partitions
*
Partitioning allows you to store data in local file system
Partitioning distributes execution load horizontally.
Partitioning separates large datasets into manageable chunks
Partitioning improves query performance
By default, Hive stores metadata in
*
Apache Derby
Local System
Apache HDFS
MySQL
Which property to be used to enable dynamic partition?
*
set hive.exec.partition.dynamic.mode = nonstrict;
set hive.exec.dynamic.parition.mode = strict;
set hive.exec.dynamic.parition.mode = nonstrict;
set hive.exec.partition.dynamic.mode = strict;
Array in Apache Hive is
*
a collection of elements of different data types
a collection of homogeneous elements
a collection of tables
a key-value pair
Array in Apache Hive is
*
Special Data Type
Difficult Data Type
Complex Data Type
Primitive Data Type
Which file formats are supported by Apache Hive
*
All are correct
Text File Format & Sequence File Format
RC File Format & ORC File Format
Parquet & Avro
The metadata doesn't contain
*
Data
Column Names
Partitions Information
Bucketing Information
Your Name
First Name
Last Name
Your Email ID
Email