question Re: How to set the logging level of the hiveserver2Interactive.log to DEBUG in HDP3? in Support Questions https://community.cloudera.com/t5/Support-Questions/How-to-set-the-logging-level-of-the-hiveserver2Interactive/m-p/305036#M222282 <P><SPAN><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/48971">@kuldeephawks</a>&nbsp;</SPAN></P><P><SPAN>1. Enable debug for HiveServer Interactive from Ambari -&gt; Hive -&gt; Configs -&gt; Advanced hive-log4j2.</SPAN><BR /><SPAN>Update below property and set it to DEBUG:</SPAN><BR /><SPAN>property.hive.log.level = DEBUG</SPAN><BR /><SPAN>2. Restart HSI</SPAN></P><P>&nbsp;</P><P><SPAN>or</SPAN></P><P>&nbsp;</P><P><SPAN>From ambari &gt; Hive &gt; Configs &gt; Hive log level &gt; change to DEBUG from INFO.</SPAN></P> Thu, 29 Oct 2020 00:41:50 GMT balajip 2020-10-29T00:41:50Z How to set the logging level of the hiveserver2Interactive.log to DEBUG in HDP3? https://community.cloudera.com/t5/Support-Questions/How-to-set-the-logging-level-of-the-hiveserver2Interactive/m-p/305031#M222277 <P>I want to set logging level of&nbsp; hiveserver2Interactive.log to DEBUG in HDP-3.1.</P><P>could anyone help here?</P> Wed, 28 Oct 2020 19:00:02 GMT https://community.cloudera.com/t5/Support-Questions/How-to-set-the-logging-level-of-the-hiveserver2Interactive/m-p/305031#M222277 kuldeephawks 2020-10-28T19:00:02Z Re: How to set the logging level of the hiveserver2Interactive.log to DEBUG in HDP3? https://community.cloudera.com/t5/Support-Questions/How-to-set-the-logging-level-of-the-hiveserver2Interactive/m-p/305036#M222282 <P><SPAN><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/48971">@kuldeephawks</a>&nbsp;</SPAN></P><P><SPAN>1. Enable debug for HiveServer Interactive from Ambari -&gt; Hive -&gt; Configs -&gt; Advanced hive-log4j2.</SPAN><BR /><SPAN>Update below property and set it to DEBUG:</SPAN><BR /><SPAN>property.hive.log.level = DEBUG</SPAN><BR /><SPAN>2. Restart HSI</SPAN></P><P>&nbsp;</P><P><SPAN>or</SPAN></P><P>&nbsp;</P><P><SPAN>From ambari &gt; Hive &gt; Configs &gt; Hive log level &gt; change to DEBUG from INFO.</SPAN></P> Thu, 29 Oct 2020 00:41:50 GMT https://community.cloudera.com/t5/Support-Questions/How-to-set-the-logging-level-of-the-hiveserver2Interactive/m-p/305036#M222282 balajip 2020-10-29T00:41:50Z Re: How to set the logging level of the hiveserver2Interactive.log to DEBUG in HDP3? https://community.cloudera.com/t5/Support-Questions/How-to-set-the-logging-level-of-the-hiveserver2Interactive/m-p/305158#M222333 <P>Thank you! This was helpful.</P> Fri, 30 Oct 2020 07:09:10 GMT https://community.cloudera.com/t5/Support-Questions/How-to-set-the-logging-level-of-the-hiveserver2Interactive/m-p/305158#M222333 kuldeephawks 2020-10-30T07:09:10Z