Question

To force Hive to be more verbose, it can be started with ___________

(a) *hive –hiveconf hive.root.logger=INFO,console*

(b) *hive –hiveconf hive.subroot.logger=INFO,console*

(c) *hive –hiveconf hive.root.logger=INFOVALUE,console*

(d) All of the mentioned

The question was posed to me in an internship interview.

This intriguing question originated from Querying Data with HiveQL in chapter Hive and HBase of Hadoop

Answer 1

Correct answer is (a) *hive –hiveconf hive.root.logger=INFO,console*

The best explanation: This Statement will spit orders of magnitude more information to the console and will likely include any information the AvroSerde is trying to get you about what went wrong.