Debug Hive query and startup

Start hive with following command.

 

bin/hive --hiveconf hive.root.logger=DEBUG,console

 

Logs

 

The logs of the user queries and metastore can be analysed by

User query logs

 

/etc/hive/hive-log4j.properties

 

Configure the variable

 

hive.log.dir

 

Hive metastore logs

 

/etc/hive-metastore/hive-log4j.properties

 

Configure the variable

 

hive.log.dir

 

A very good presentation on how to debug hive errors

 

 

De-Bugging Hive with Hadoop-in-the-Cloud from Hadoop_Summit