hive报错

最新推荐文章于 2025-01-06 20:56:55 发布
最新推荐文章于 2025-01-06 20:56:55 发布
阅读量892 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： hadoop
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u014545085/article/details/103283790
在尝试启动Hive时遇到一个运行时异常，原因是无法实例化`org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient`。错误追踪显示由于`com.mysql.jdbc.Driver`不在CLASSPATH中，导致数据存储驱动未找到。为解决问题，需要将MySQL的JDBC驱动jar包添加到Hive的lib目录下。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

hive报错

Logging initialized using configuration in jar:file:/usr/local/hive/lib/hive-common-1.2.1.jar!/hive-log4j.properties
Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
        at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:522)
        at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677)
        at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:483)
        at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
        at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
        at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1523)
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:86)
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:132)
        at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:104)
        at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:3005)
        at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:3024)
        at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:503)
        ... 8 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
        at org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1521)
        ... 14 more
Caused by: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
NestedThrowables:
java.lang.reflect.InvocationTargetException
        at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:587)
        at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:788)
        at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:333)
        at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:202)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:483)
        at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.jdo.JDOHelper.invoke(JDOHelper.java:1960)
        at javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1166)
        at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:808)
        at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:701)
        at org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:365)
        at org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:394)
        at org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:291)
        at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:258)
        at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76)
        at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:57)
        at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:66)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:593)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:571)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:624)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:461)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:66)
        at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:72)
        at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:5762)
        at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:199)
        at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.<init>(SessionHiveMetaStoreClient.java:74)
        ... 19 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
        at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631)
        at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:325)
        at org.datanucleus.store.AbstractStoreManager.registerConnectionFactory(AbstractStoreManager.java:282)
        at org.datanucleus.store.AbstractStoreManager.<init>(AbstractStoreManager.java:240)
        at org.datanucleus.store.rdbms.RDBMSStoreManager.<init>(RDBMSStoreManager.java:286)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
        at org.datanucleus.plugin.NonManagedPluginRegistry.createExecutableExtension(NonManagedPluginRegistry.java:631)
        at org.datanucleus.plugin.PluginManager.createExecutableExtension(PluginManager.java:301)
        at org.datanucleus.NucleusContext.createStoreManagerForProperties(NucleusContext.java:1187)
        at org.datanucleus.NucleusContext.initialise(NucleusContext.java:356)
        at org.datanucleus.api.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:775)
        ... 48 more
Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the "BONECP" plugin to create a ConnectionPool gave an error : The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.
        at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:259)
        at org.datanucleus.store.rdbms.ConnectionFactoryImpl.initialiseDataSources(ConnectionFactoryImpl.java:131)
        at org.datanucleus.store.rdbms.ConnectionFactoryImpl.<init>(ConnectionFactoryImpl.java:85)
        ... 66 more
Caused by: org.datanucleus.store.rdbms.connectionpool.DatastoreDriverNotFoundException: The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.
        at org.datanucleus.store.rdbms.connectionpool.AbstractConnectionPoolFactory.loadDriver(AbstractConnectionPoolFactory.java:58)
        at org.datanucleus.store.rdbms.connectionpool.BoneCPConnectionPoolFactory.createConnectionPool(BoneCPConnectionPoolFactory.java:54)
        at org.datanucleus.store.rdbms.ConnectionFactoryImpl.generateDataSources(ConnectionFactoryImpl.java:238)
        ... 68 more
hadoop@ubuntu:/usr/local/hive$ LS

 

 

错误栈信息里面说了，缺少mysql的驱动

Caused by: org.datanucleus.store.rdbms.connectionpool.DatastoreDriverNotFoundException: The specified datastore driver ("com.mysql.jdbc.Driver ") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.

 

找个jdbc的jar包扔到$HIVE_HOME/lib下

解决该问题。

hdfs开启高可用之后HIVE报错
weixin_41367158的博客
02-29 183
有namenode有两个节点master01和master03 ,之前是master01为活跃状态，后来将master03加入到高可用，master03切换到alive状态。但是发现启用hive的时候报错。发现还是找master01的元数据信息，因为master01处于standby状态。没有办法完成hdfs自动切换，尤其是hive。根本的解决办法是将所有指向原hdfs地址的ip修改为HA后的新hdfs组ID才可以。
hive报错汇总
qnstar_的博客
09-24 621
【错误1】 WARN: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with e
hive报错：Logging initialized using configuration in jar:file:/home/software/apache-hive-1.2.0-bin/lib/
qq_45453185的博客
12-04 3917
在hive的bin目录下输入sh hive报错: [root@hadoop01 apache-hive-1.2.0-bin]# cd bin [root@hadoop01 bin]# sh hive Logging initialized using configuration in jar:file:/home/software/apache-hive-1.2.0-bin/lib/hive-co...
Logging initialized using configuration in jar:file:/usr/local/apache-hive-2.3.4/lib/hive-common-2.3
huicooling的博客
01-26 1万+
执行./hive后，一直卡在这里Logging initialized using configuration in jar:file:/usr/local/apache-hive-2.3.4/lib/hive-common-2.3.4.jar!/hive-log4j2.properties Async: true 最后给我报错： Exception in thread "main" jav...
Logging initialized using
yelinlan的博客
06-01 668
Logging initialized using ‘class org.apache.ibatis.logging.stdout.StdOutImpl’ adapter 把断点清了。
Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter.
A948423110的博客
12-26 1463
** Logging initialized using ‘class org.apache.ibatis.logging.stdout.StdOutImpl’ adapter. ** **Debug启动一直卡着不动,**魔力转圈圈 百度,谷歌半天… 说SQL和实体类映射问题,但是找了半天问题还是在… –缓存清空–关机–都没用, 最后发现是service层有个断点 最后去掉就启动成功… ...
Logging initialized using ‘class org.apache.ibatis.logging.log4j.Log4jImpl’ adapter.
f的博客
05-07 7906
你是否遇到过下面的情况，控制台无限的输出下面的日志： Logging initialized using ‘class org.apache.ibatis.logging.log4j.Log4jImpl’ adapter. Logging initialized using ‘class org.apache.ibatis.logging.log4j.Log4jImpl’ adapter....
hdfs开启高可用+hive报错
02-29
### HDFS高可用机制与Hive兼容性问题详解 #### 一、背景介绍 Hadoop分布式文件系统（HDFS）是Hadoop项目的核心组件之一，主要用于存储海量数据。随着业务需求的增长，单一NameNode节点已经无法满足大规模集群的高...
hive 报错
最新发布
05-30
### Hive 报错解决方案 在使用 Hive 时，可能会遇到多种报错情况。以下是针对不同场景的解决方案，结合了提供的引用内容和专业知识。 #### 1. **PyHive 在 Windows 环境下连接 Hive 报错** 当在 Windows 环境中...
Hive报错和解决办法
bigdata_wangzhe的博客
03-19 1899
firstBadLink错误 报错： Caused by: java.io.IOException: Bad connect ack with firstBadLink as 192.168.2.24:50010 解决方法：动态分区数太多，需要提高文件句柄数， root账户下vi /etc/security/limits.conf End of file hadoop - nofile 65536 metastore报错 报错： Binary logging not possible. Message: T
Logging initialized using ‘class org.apache.ibatis.logging.log4j.Log4jImpl‘ adapter.
博风_刺耳的博客
04-05 3278
spring无法启动，控制台一直打印日志： Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter. 这种情况是mybatis初始化时与日志集成时的异常，问题可能出在log4j或者mybatis配置中。 由于本人遇到该问题时，是修改了mybatis的dao -> map...
Logging initialized using ‘class org.apache.ibatis.logging.stdout.StdOutImpl‘ adapter.
qq_54217747的博客
07-19 584
被这个错误搞蒙了，搜了很多解决方案，说是xml错了，但是改来改去还是错，有没有帮看看的兄弟。
Logging initialized using ‘class org.apache.ibatis.logging.stdout.StdOutImpl
RT_0114的博客
07-30 3135
遇到这个错别慌，肯定是你自己的问题。 首先你是debug启动的吗？ 如果是那么你试着不要debug启动。 如果起来了，那么好继续往下，如果没起来那么就继续百度找吧。 先说我的原因吧，我在一个方法上打了个断点导致启动一直在解析xml。把所有断点去掉就ok。 ...
Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter
热门推荐
万米高空的博客
05-24 9万+
SSM框架项目启动发现启动不起来，反而控制台无限输出：Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter. ，这个错误只有在和Spring集成的情况下才会出现。 每次只要出现这个错误都意味着Mybatis的存放sql操作的XML出错了，但是具体是那个XML还没法直接确认，因为这...
Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter 致springboot错误
automannn
08-28 6万+
  今天实验的时候，遇到一个问题：   Logging initialized using 'class org.apache.ibatis.logging.stdout.StdOutImpl' adapter  致使springboot不能正常运行。。     解决之前遇到的情况类似于：      spirngboot框架不能正常运行，bean包不能正确配置，所有的配置以及结构都是正常的。...
Logging initialized using ‘class org.apache.ibatis.logging.stdout.StdOutImpl‘ adapter.Property
伟大是熬出来的
01-04 1357
重新启动则会展示具体的错误信息。把项目中的日志输出先删了。console输出日志。根据错误日志解决问题。
【无标题】Logging initialized using ‘class org.apache.ibatis.logging.stdout.StdOutImpl‘ adapter.Loading
2301_76231651的博客
01-06 3389
项目运行成功但是日志中出现如下红字：这个日志信息表明应用程序正在加载 MySQL JDBC 驱动，并提供了一些关于驱动类使用的警告信息。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值