question Re: hiveserver2 debugging in Support Questions

hiveserver2 debugging

Sreedhar_ch — Thu, 26 May 2016 17:01:03 GMT

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..

Re: hiveserver2 debugging

joao_ascenso — Thu, 26 May 2016 17:25:09 GMT

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.

Re: hiveserver2 debugging

Sreedhar_ch — Fri, 27 May 2016 17:05:14 GMT

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..

Re: hiveserver2 debugging

samuel_peeters — Wed, 13 Mar 2019 14:45:41 GMT

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