禁用配置单元中的信息日志



我已经安装了带有hadoop(3.2.1版(的Hive(3.1.2版(作为单节点集群。每当我登录到hive-shell并执行显示数据库的基本查询时,我都会得到一堆想要隐藏的INFO日志。

2021-05-26T16:12:44,244 INFO [main] org.apache.hadoop.hive.conf.HiveConf - Using the default value passed in for log id: f7369a83-e107-48ed-91cc-569ba580c7c8
2021-05-26T16:12:44,244 INFO [main] org.apache.hadoop.hive.ql.session.SessionState - Updating thread name to f7369a83-e107-48ed-91cc-569ba580c7c8 main
OK
default
development
retail_ods
retail_stage
Time taken: 0.026 seconds, Fetched: 4 row(s)
2021-05-26T16:12:44,285 INFO [f7369a83-e107-48ed-91cc-569ba580c7c8 main] org.apache.hadoop.hive.conf.HiveConf - Using the default value passed in for log id: f7369a83-e107-48ed-91cc-569ba580c7c8
2021-05-26T16:12:44,285 INFO [f7369a83-e107-48ed-91cc-569ba580c7c8 main] org.apache.hadoop.hive.ql.session.SessionState - Resetting thread name to  main

这是我的hive-log4j2.properties文件。我已将日志级别更改为ERROR,但它不起作用。

hive.root.logger=ERROR,DRFA
hive.log.dir=${java.io.tmpdir}/${user.name}
hive.log.file=hive.log
log4j.rootLogger=${hive.root.logger}, EventCounter
log4j.threshold=${hive.log.threshold}
log4j.appender.DRFA=org.apache.log4j.DailyRollingFileAppender
log4j.appender.DRFA.File=${hive.log.dir}/${hive.log.file}
log4j.appender.DRFA.DatePattern=.yyyy-MM-dd
log4j.appender.DRFA.MaxBackupIndex= 10
log4j.appender.DRFA.MaxFileSize = 100MB
log4j.appender.DRFA.layout=org.apache.log4j.PatternLayout
log4j.appender.DRFA.layout.ConversionPattern=%d{ISO8601} %-5p [%t]: %c{2} (%F:%M(%L)) - %m%n
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.target=System.err
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=%d{yy/MM/dd HH:mm:ss} [%t]: %p %c{2}: %m%n
log4j.appender.console.encoding=UTF-8
log4j.appender.EventCounter=org.apache.hadoop.hive.shims.HiveEventCounter
log4j.category.DataNucleus=ERROR,DRFA
log4j.category.Datastore=ERROR,DRFA
log4j.category.Datastore.Schema=ERROR,DRFA
log4j.category.JPOX.Datastore=ERROR,DRFA
log4j.category.JPOX.Plugin=ERROR,DRFA
log4j.category.JPOX.MetaData=ERROR,DRFA
log4j.category.JPOX.Query=ERROR,DRFA
log4j.category.JPOX.General=ERROR,DRFA
log4j.category.JPOX.Enhancer=ERROR,DRFA

log4j.logger.org.apache.zookeeper.server.NIOServerCnxn=WARN,DRFA
log4j.logger.org.apache.zookeeper.ClientCnxnSocketNIO=WARN,DRFA

请告诉我如何将所有这些信息日志隐藏在蜂箱外壳中。

Mine在hive-site.xml(安装文件夹的/conf目录内(中添加此属性后工作:

<property>
<name>hive.async.log.enabled</name>
<value>false</value> 
</property>

最新更新