to bring hive log level to ERROR

[#1]

Hello All,

we need to bring down the hive log level to ERROR

follow are the files related to hive log properties, . in which file we need to change INFO to ERROR

find / -name "hive-*.properties"

/etc/hive/2.5.0.0-1245/0/hive-log4j.properties /etc/hive/2.5.0.0-1245/0/hive-exec-log4j.properties

/etc/hive/2.5.0.0-1245/0/conf.server/hive-log4j.properties

/etc/hive/2.5.0.0-1245/0/conf.server/hive-exec-log4j.properties

/etc/hive/conf.backup/hive-log4j.properties

/etc/hive/conf.backup/hive-exec-log4j.properties

/usr/hdp/2.5.0.0-1245/etc/hive/conf.dist/hive-log4j.properties

/usr/hdp/2.5.0.0-1245/etc/hive/conf.dist/hive-exec-log4j.properties

this we want to automate through power shell, kindly guide us how to do this.

[#2 · Accepted solution]

Hi @Mallik Sunkara

If you want to change logging to ERROR for Hive services (not from Ambari), then change the logging under below files:

/etc/hive/2.5.0.0-1245/0/conf.server/hive-log4j.properties

/etc/hive/2.5.0.0-1245/0/conf.server/hive-exec-log4j.properties

Also, fyi, if the services are Ambari, then these changes would be reverted when the services are restarted from Ambari.