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