hiveserver2 debugging

[#1]

Hi team....Anyone aware how to get into debug mode for beeline command shell...like in hive we use hive -hiveconf hive.root.logger=Debug,console..do we have anything for beeline..the same is not working at beeling ..I don't want to restart the hiveserver ..as this is in production will impact other due to stop and start..

[#2 · Accepted solution]

Hi Ammu,

beeline has a flag --verbose=[true/false] that will output more information, I use that option regularly to get back more information about stacktraces.

related: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-BeelineComma...

[#3]

thanks for the info but looks like this is not informative for issue debugging..and I got update ..we can't change logger debug mode once hiveserver2 started...this feature is available only with HDP2.3 onwards it seems..

anyway thanks for looking into this..

[#4]

Edit the /etc/hive/conf/beeline-log4j.properties you created by copying from beeline-log4j.properties.template and specify log4j.rootLogger=DEBUG, console