启动SparkSql，报javax.jdo.JDOFatalInternalException: Error creating transactional connection factory

最新推荐文章于 2023-12-27 14:59:51 发布

森屿旅人996

最新推荐文章于 2023-12-27 14:59:51 发布

阅读量2k

点赞数 3

分类专栏： Spark 文章标签： hive jar jdbc spark 大数据

本文链接：https://blog.youkuaiyun.com/weixin_46086427/article/details/107473106

版权

Spark 专栏收录该内容

9 篇文章

订阅专栏

启动SparkSql，报错如下：

20/07/20 08:02:48 WARN metastore.HiveMetaStore: Retrying creating default database after error: Error creating transactional connection factory
javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
NestedThrowablesStackTrace:
java.lang.reflect.InvocationTargetException
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.
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.

在这里插入图片描述

报错原因：

因为spark与hive配置的Mysql作为元数据，需要对应的jar包依赖，缺少了mysql-connector的jar包

解决办法：

拷贝hive的lib下的mysql-connector-java-5.1.46-bin.jar这个jar包到spark的jars下，这样就搞定了

[hadoop@hrbu30 lib]$ cp /opt/wdp/hive/lib/mysql-connector-java-5.1.46-bin.jar /opt/wdp/spark/jars/