The following is the type of table supported by Hive
*
All are correct
Managed Tables
Interior Tables
Fact Tables
The database stores it's files in a directory called
*
Metastore
Metastoredb
Metastore_db
Metastore.db
By default, the location of the warehouse is
*
metastore.db
metastore_db
file://user/hive/warehouse
file:///user/hive/warehouse
Table names and column names are case _______
*
insensitive
sensitive
Uppercase
None
Map in Apache Hive is a collection of
*
Geographic Locations
Tables
homogeneous elements
Key Value Pair
Apache Hive can be run in
*
None
Both Interactive and Non-Interactive Mode
Interactive Mode
Non Interactive Mode
Views in Apache Hive are
*
Slightly different with SQL Views
Virtual Tables
not meant for DML operations
Physical Files
Which is not true about indexing in Apache Hive?
*
Functions the same way as in SQL
Index helps speed up the querying process
A method to split the data
A method to quickly lookup the requested data
When you want Hive to completely manage the lifecycle of the table and data, then use ___________
*
External Table
Permanent Table
View
Internal Table
In order to display column names in the result-set, which property you'll use?
*
SET hive.columns.names.display=true;
SET hive.cli.display.column.names=true;
SET hive.cli.exec.print.header=true;
SET hive.cli.print.header=true;
Enter your email address
Email
Name
First Name
Last Name