首页 > 其他分享 >hive启动时有一堆WARN信息

hive启动时有一堆WARN信息

时间:2023-12-02 23:22:06浏览次数:33  
标签:DataNucleus 22 23 时有 hive WARN type

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

 

标签:DataNucleus,22,23,时有,hive,WARN,type
From: https://www.cnblogs.com/liucaizhi/p/17872462.html

相关文章

  • Hive的安装与配置
    第1关:Hive的安装与配置在修改conf下面的hive-site.xml文件这里,题目给的信息是错误的,正确的内容如下:<?xmlversion="1.0"encoding="UTF-8"standalone="no"?><?xml-stylesheettype="text/xsl"href="configuration.xsl"?><configura......
  • hive启动出现Either your MetaData is incorrect, or you need to enable "datanucleu
    hive启动出现:Requiredtablemissing:"`VERSION`"inCatalog""Schema"".DataNucleusrequiresthistabletoperformitspersistenceoperations.EitheryourMetaDataisincorrect,oryouneedtoenable"datanucleus.schema......
  • hive升级元数据报错The reference to entity "useSSL" must end with the ';' delimit
    使用Hive自带的schematool工具升级元数据,也就是把最新的元数据重新写入MySQL数据库中。执行以下命令cd/usr/local/hive./bin/schematool-initSchema-dbTypemysql出现Thereferencetoentity"useSSL"mustendwiththe';'delimiter.修改之前配置的hive-site.xml原......
  • react项目vite报错:UnhandledPromiseRejectionWarning: SyntaxError: Unexpected toke
    问题:vite报错:UnhandledPromiseRejectionWarning:SyntaxError:Unexpectedtoken'??='今天clone一个vite的项目,安装依赖后运行npmrundev报错:UnhandledPromiseRejectionWarning:SyntaxError:Unexpectedtoken'??='atLoader.moduleStrategy(internal/modules......
  • PG14归档失败解决办法archiver failed on wal_lsn
    案例1:pg_wal下有wal_lsn文件案例1适用于以下场景:pg_wal下有该wal_lsn文件而归档目录下无该wal_lsn文件pg_wal和归档目录下同时都有该wal_lsn文件问题描述昨晚Repmgr+PG14主备主库因wal日志撑爆磁盘,删除主库过期wal文件重做备库后上午进行主备状态巡查,主库向备库发送wal文件正常,但......
  • hadoop高可用集群集成hive
    hive和hadoop的关系从上图可以看出实际上外界是通过thriftserver这个节点和hadoop的hdfs以及rm进行交互的,中间为driver因此当我修改完hadoop集群为高可用的时候,hive也需要重新配置环境以下是我hive的全新配置<configuration><!--Hive元数据存储配置--><propert......
  • java使用hive-jdbc查询超时:java.sql.SQLException: org.apache.thrift.transport.TTra
     java.sql.SQLException:org.apache.thrift.transport.TTransportException:java.net.SocketTimeoutException:Readtimedout  atorg.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:262)  atorg.apache.hive.jdbc.HivePreparedStatement.execute(......
  • 多线程连接池报错报警告[connectionpool.py:305 ] [WARNING] Connection pool is full
    第一种方法:按照建议WebDriverWait帮助解决了问题 fromselenium.webdriver.support.uiimportWebDriverWaitfromselenium.webdriver.supportimportexpected_conditionsasECfromselenium.webdriver.common.byimportByfromselenium.common.exceptionsimportT......
  • Hive
    因为传统数仓的不足,大家希望使用上分布式存储,也就是HDFS。然而使用HDFS后发现,基于数据库的数据仓库用SQL就能做查询,现在换到HDFS上面,只能用Mapreduce任务去做分析。给分析代码极大的不便,因此需要一个框架,使用SQL来做HDFS的查询。Hive正是基于类似SQL的语言完成对hdfs数据的查询......
  • [WARNING] The POM for com.alibaba:druid:jar:1.1.21 is invalid, transitive depend
    这个警告表明Maven在尝试下载或处理com.alibaba:druid:1.1.21这个依赖项时遇到了问题。警告的具体内容是说POM(ProjectObjectModel)文件无效,这可能会导致Maven无法正确地处理传递性依赖关系。有几种可能的原因和解决方法:1.网络问题:Maven可能无法从Maven仓库正确下载d......