hive启动时有一堆WARN信息
比如：
SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/local/hive/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/local/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Hive Session ID = e43a63d5-0216-4f19-82c9-de01f792b868 Logging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-3.1.3.jar!/hive-log4j2.properties Async: true 23/12/02 22:52:54 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored 23/12/02 22:52:55 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored 23/12/02 22:52:55 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored 23/12/02 22:52:55 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored 23/12/02 22:52:55 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored 23/12/02 22:52:55 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored 23/12/02 22:52:55 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored 23/12/02 22:52:56 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored 23/12/02 22:52:56 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored 23/12/02 22:52:56 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored 23/12/02 22:52:56 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored 23/12/02 22:52:56 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored 23/12/02 22:52:56 WARN DataNucleus.MetaData: Metadata has jdbc-type of null yet this is not valid. Ignored Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases. Hive Session ID = da9496fe-1eec-4871-94aa-a6df0e7bf20a
在安装hive的conf目录下，新建log4j.properties日志的配置文件，添加以下内容
log4j.rootLogger=ERROR, CA log4j.appender.CA=org.apache.log4j.ConsoleAppender log4j.appender.CA.layout=org.apache.log4j.PatternLayout log4j.appender.CA.layout.ConversionPattern=%-4r [%t] %-5p %c %x - %m%n
重启hive即可
修改后：
SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/local/hive/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/local/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Hive Session ID = 652db4a7-476d-4419-9c08-74e27c3de83a Logging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-3.1.3.jar!/hive-log4j2.properties Async: true Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases. Hive Session ID = 24be6714-f296-4d69-9ad4-9072c097c89b