Hive Quiz 1

1. The partition of an Indexed table is dropped. Then,

Corresponding partition from all indexes are dropped.
No indexes are dropped
Indexes refresh themselves automatically
Error is shown asking to first drop the indexes

2. What Hive cannot offer?

Storing data in tables and columns
Online transaction processing
Handling date time data
Partitioning stored data

3. The results of a hive query can be stored as:

Local file
HDFS file
Both
Cannot be stored

4. Which of the following is not a complex data type in Hive?

Matrix
Array
Map
STRUCT

5. If the database contains some tables, it can be forced to drop without dropping the tables by using the keyword:

RESTRICT
OVERWRITE
DROP
CASCADE

6. Using the ALTER DATABASE command, you can change the:

Database name
Database creation time
Directory where the database is stored
DB properties

7. In Hive you can copy:

The schema without the data
The data without the schema
Both schema and its data
Neither the schema nor its data

8. To see the data type details of only a column (not the table), we should use the command:

DESCRIBE EXTENDED
DESCRIBE FORMATTED
DESCRIBE COLUMN
DESCRIBE

Score:

Correct Answers: