Hive Online Quiz


Advertisements


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.

Questions and Answers

Q 1 - The results of a hive query can be stored as

A - local file

B - hdfs file

C - both

D - can not be stored

Answer : C

Explanation

Using the command INSERT OVERWRITE DITECTORY ….. data can be exported to both local and hdfs file system.

Answer : B

Explanation

Hive does not recursively delete the directory. So tables must be dropped first.

Answer : B

Explanation

It is a program to read and write files using Java Input and Output formats.

Q 4 - While querying a hive table for a column with MAP data type, the elements in the column are referenced by

A - Index

B - Key

C - Value

D - nested Index

Answer : B

Explanation

The MAP data type is a key-value pair and not index based.

Q 5 - The performance of an aggregate query is improved by setting which of the following property as true?

A - hive.map.group

B - hive.map.aggr

C - hive.map.sort

D - hive.map.sum

Answer : B

Explanation

SET hive.map.aggr = true;

Answer : C

Explanation

TBLPROPERTIES stores some documentation about the table like created date time etc.

Answer : C

Explanation

Hive does not manage the Index like RDBMS. SO it has to be built manually.

Answer : C

Explanation

When files are not splitable , querying them becomes inefficient.

Q 10 - When one of the join tables is small enough to fit into memory, The type of join used by Hive is

A - Inner Join

B - Map join

C - Reduce Join

D - Sort Join

Answer : B

Explanation

As one of the tables already fits into the memory each row of the big table is quickly compared with each row of small table using Map Join.


hive_questions_answers.htm

Advertisements