The answer for the first question is addressed below. ambari -> go to hive--> config --> Advanced hive-log4j --> replace hive.root.logger=INFO,DRFA with hive.root.logger=DEBUG,DRFA and restart hiveserver2
Reference: https://community.hortonworks.com/questions/115152/how-to-set-the-logging-level-of-the-hiveserver2log.html On Fri, Jul 28, 2017 at 12:32 PM, Mungeol Heo <mungeol....@gmail.com> wrote: > Hello. > > As I mentioned at the title of this question, I wonder how to set the > logging level of the hiveserver2.log file in HDP. > > And I am also curios about why one of my hiveserver2.log file's > logging level is debug while another is not. > > ------- First hiveserver2.log which has debug log ------- > > 2017-05-10 13:47:34,201 DEBUG [main]: common.LogUtils > (LogUtils.java:logConfigLocation(147)) - Using hive-site.xml found on > CLASSPATH at /etc/hive/2.5.0.0-1245/0/conf.server/hive-site.xml > > 2017-05-10 13:47:34,206 DEBUG [main]: server.HiveServer2 > (HiveServer2.java:main(558)) - Logging initialized using configuration > in > jar:file:/usr/hdp/2.5.0.0-1245/hive/lib/hive-common-1.2.1000.2.5.0.0-1245.jar!/hive-log4j.properties > > 2017-05-10 13:47:34,227 INFO [main]: server.HiveServer2 > (HiveStringUtils.java:startupShutdownMessage(693)) - STARTUP_MSG: > > ------- Second hiveserver2.log which has no debug log ------- > > 2017-03-13 20:02:37,674 INFO [main]: server.HiveServer2 > (HiveStringUtils.java:startupShutdownMessage(693)) - STARTUP_MSG: > > Any help will be very thankful.
