hdinsight.github.io

How do I launch Hive shell with specific configurations on HDInsight cluster?

Issue:

Need to override or specify Hive shell configurations at launch time on HDInsight clusters.

Resolution Steps:

1) Specify a configuration key value pair while starting Hive shell (check Further Reading section below):

hive -hiveconf a=b 

2) List all effective configurations on Hive shell with the following command:

hive> set;

For example, use the following command to start hive shell with debug logging enabled on console:

hive -hiveconf hive.root.logger=ALL,console 

Further Reading:

1) Hive configuration properties