Following quiz provides Multiple Choice Questions (MCQs) related to Hive. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
The schema only refers to the data stored and data is not validated against schema when inserted or loaded.
Q 2 - The drawback of managed tables in hive is
As they are managed by Hive metadata, other applications cannot access it.
Q 3 - If the directory for a partition does not exist, and a query is executed for this partition then
The map reduce job is triggered but no result will be returned.
Q 4 - The position of a specific column in a Hive table
It is up to the user to ensure the synchronization between schema and data
STRUCT elements are key-value pairs and the elements are accessed by dot notation.
Q 6 - The DISTRIBUTED by clause is used to ensure that
The DISTRIBUTED BY clause send a range of values to the same reducer.
Q 7 - If an Index is dropped then
AN index can be dropped only after dropping the table on which index is created.
Q 8 - Setting the local mode execution to true causes
Local mode avoid creating mapreduce job while running the job in a single machine.
Q 9 - Which file controls the logging of Mapreduce Tasks?
This property controls the logging in Mapreduce tasks
Q 10 - Which of the following File Formats are supported by Hive?
Hive supports all these three file formats as they are also supported by Hadoop in general