Hive Online Quiz



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 : A

Explanation

Each database becomes a directory and each table becomes a file in that directory

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.

Answer : C

Explanation

CONCAT function accepts any number of arguments

Answer : A

Explanation

The DISTRIBUTED BY clause send a range of values to the same reducer.

Answer : C

Explanation

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

Q 8 - The Property that decides what is the maximum number of files that can be sampled during the use of the LIMIT clause is

A - hive.limit.optimize.file.max

B - hive.limit.optimize.limit.file

C - hive.limit.optimize.file.restrict

D - hive.limit.optimize.limit.most

Answer : B

Explanation

This property decides the number files to be looked into for the sample result.

Answer : B

Explanation

Macros are created for the purpose of calling other functiuons

hive_questions_answers.htm
Advertisements