How to set the logging level of the hiveserver2.log

[#1]

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.

[#2 · Accepted solution]

@mungeol heo you can change the logging level of hiveserver2 using ambari, go to hive--> config --> Advanced hive-log4j --> replace hive.root.logger=INFO,DRFA with hive.root.logger=DEBUG,DRFA and restart hiveserver2

[#3]

The answer for the second question is that they use different hive-log4j.properties.

Check https://community.hortonworks.com/questions/115159/hive-servers-in-same-cluster-use-different-hive-l...