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