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.
Q 1 - The default delimiter in hive to separate the element in STRUCT is
The four default delimiters are − \n for record separator,
001\ for field separator
002\ for element separator in ARRAY or STRUCT
003\ for element separator in MAP
Q 2 - On dropping a managed table
As it is hive managed table both the data and schema definition are dropped.
Q 3 - The partitioning of a table in Hive creates more
Partitions of a table creates more subdirectories under it.
Q 4 - If the schema of the table does not match with the data types present in the file containing the table then HIve
Hive always tries to read the data as it is Schema on Read.
Q 5 - The performance of an aggregate query is improved by setting which of the following property as true?
SET hive.map.aggr = true;
Q 6 - The name of a view in Hive
Views and tables are treated similarly in the hive metadata
Q 7 - The identifiers in HiveQL are
Hive is case insensitive
Q 8 - The disadvantage of compressing files in HDFS is
When files are not splitable , querying them becomes inefficient.
Q 9 - The explode() function in hive takes an array of input and iterates through it returning each element as a separate row. This is an example of
SELECT explode(array(1,2,3)) AS element FROM src;
gives 1 2 3 so it is table generating function
Q 10 - Calling a unix bash script inside a Hive Query is an example of
In this type of streaming the code resides in the script being called and Hive is not aware of the code.