Hive Interview Questions

Q: What Hive can not offer

The correct answer is Online transaction processing

Q: The drawback of managed tables in hive is

The correct answer is They cannot be shared with other applications

Q: The main advantage of creating table partition is

The correct answer is faster query performance

Q: If we change the partition location of a hive table using ALTER TABLE option then the data for that partition in the table

The correct answer is has to be moved manually into new location

Q: The property set to run hive in local mode as true so that it runs without creating a mapreduce job is

The correct answer is hive.exec.mode.local.auto

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. What Hive can not offer

A. storing data in tables and columns

B. Online transaction processing

C. Handling date time data

D. Partitioning stored data

Correct Answer is : Online transaction processing

2. The drawback of managed tables in hive is

A. they are always stored under default directory

B. They cannot grow bigger than a fixed size of 100GB

C. They can never be dropped

D. They cannot be shared with other applications

Correct Answer is : They cannot be shared with other applications

3. The main advantage of creating table partition is

A. Effective storage memory utilization

B. faster query performance

C. Less RAM required by namenode

D. simpler query syntax

Correct Answer is : faster query performance

4. If we change the partition location of a hive table using ALTER TABLE option then the data for that partition in the table

A. also moves automatically to the new location

B. has to be dropped and recreated

C. has to be backed up into a second table and restored

D. has to be moved manually into new location

Correct Answer is : has to be moved manually into new location

5. The property set to run hive in local mode as true so that it runs without creating a mapreduce job is

A. hive.exec.mode.local.auto

B. hive.exec.mode.local.override

C. hive.exec.mode.local.settings

D. hive.exec.mode.local.config

Correct Answer is : hive.exec.mode.local.auto

Hive interview questions