hive The specified datastore driver (“com.mysql.jdbc.Driver“) was not found

最新推荐文章于 2023-09-06 16:44:34 发布
最新推荐文章于 2023-09-06 16:44:34 发布
阅读量4.2k 收藏 2
点赞数 2
CC 4.0 BY-SA版权
分类专栏： 大数据-hive 文章标签： hive mysql spark
本文为博主九师兄（QQ:541711153 欢迎来探讨技术）原创文章，未经允许博主不允许转载。
本文链接：https://blog.youkuaiyun.com/qq_21383435/article/details/80910017
在项目中遇到Hive连接MySQL时出现错误，指定的datastore驱动未找到。检查发现已有mysql连接jar包，将其加入classpath及放到$SPARK_HOME/jars中仍无法解决问题。最终通过修改配置文件成功解决，确保了Hive能够正常创建数据库。

文章目录


在这里插入图片描述

1 .项目

这里写图片描述

2.环境搭建

必看:https://blog.youkuaiyun.com/qq_21383435/article/details/80598613

3.运行环境

hadoop

lcc@lcc hadoop$ jps
1329 RunJar
545
1219 RunJar
980 SecondaryNameNode
1093 ResourceManager
791 NameNode
1271 RunJar
2058 Jps
1180 NodeManager
669 NailgunRunner
877 DataNode
2015 Launcher
lcc@lcc hadoop$

hive的metastore服务

lcc@lcc ~$ hive --service metastore
Starting Hive Metastore Server
SLF4J: Class path contains multiple SLF4J
了解本专栏 订阅专栏 解锁全文
Spark SQL报错：The specified datastore driver (“com.mysql.jdbc.Driver“) was not found in the CLASSPATH.
zhengzaifeidelushang的博客
08-13 944
Spark SQL报错：The specified datastore driver (“com.mysql.jdbc.Driver”) was not found in the CLASSPATH. 启动Spark SQL报错： ./spark-sql Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the "BONECP" plugin to create a ConnectionPool gave
The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH
weixin_43616627的博客
01-13 4404
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已解决 要执行的代码如下： object HiveRead { def mai...
Spark SQL 读取Hive数据报错:The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the C
muyingmiao的专栏
10-14 988
将Hive的配置文件拷贝到Spark中后，启动spark-shell scala> spark.sql("show databases").show 报错如下 org.datanucleus.store.rdbms.connectionpool.DatastoreDriverNotFoundException: The specified datastore driver ("com.mys...
Hive metastore启动报错The specified datastore driver(“com.mysql.jdbc.Driver“) was not found in the CLASS
数据源的港湾
11-04 1381
现象 某集群有两个Hive metastore，其中一个正常运行，另一个启动报错，报错的Hive metastore日志报错信息如下， 上午9点56:55.875分 WARN HiveMetaStore [main]: Retrying creating default database after error: Error creating transactional connection factory javax.jdo.JDOFatalInternalException: Error creati
Hive学习2_错误： The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH
wang_zhenwei的博客
01-22 8347
在启动Hive时，报错： The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH 详细描述见一篇英文文档。 I'm trying to install Apache Hive, I insert HIVE_HOME and HADOOP_HOME into hi
启动hiveThe specified datastore driver (com.mysql.jdbc.Driver) was not found in the CLASSPATH
01-02 6219
在进行hive-1.1.0-cdh5.7.0 的编译安装的时候再启动hive的时候出现下面的异常信息： [hadoop@zydatahadoop001 conf]$ hive which: no hbase in (/usr/java/jdk1.8.0_45/bin:/opt/software/hive/bin:/opt/software/hadoop-cdh/sbin:/opt/softw...
CDH Sqoop 同步Mysql 数据至hive 报错The specified datastore driver (“org.apache.derby.jdbc.EmbeddedDriver“)
爱摄影的小章同学的博客
05-12 1065
CDH Sqoop 同步Mysql 数据至hive 报错，报错内容为 Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the “BONECP” plugin to create a ConnectionPool gave an error : The specified datastore driver (“org.apache.derby.jdbc.EmbeddedDriver”) was not fou
Spark连接Hive时报错The specified datastore driver (“com.mysql.jdbc.Driver“) was not found in the CLASSPAT
weixin_39876938的博客
09-06 512
Spark连接Hive时报错The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPAT
【报错解决】The specified datastore driver (“com.mysql.jdbc.Driver “) was not found in the CLASSPATH. Plea
邵奈一的博客
03-19 4391
今天打开了好多年没有用的大数据虚拟机集群，发现了一些莫名其妙的问题，比如我用 spark-shell ，竟然报错了： Caused by: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient ... Caused by: java.lang.reflect.InvocationTargetException ... Caused by:
com.mysql.jdbc.Driver was not found, trying direct instantiat
l_z_w99的博客
11-23 4148
连接数据库出错了？ 出现警告：Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of ...
【解决MySQL-jdbc连接问题】com.mysql.jdbc.Driver was not found, trying direct instantiat
oqqChin12的博客
06-12 6361
driver 目前用的是 com.mysql.jdbc.Driver，新版已经变为 com.mysql.cj.jdbc.Driver。而且接口有时候能访问成功，有时候的超时连接，异常的慢。经查询，是由于时区配置的有歧义。
Hive踩坑之The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH，找不到驱动
liuhehe123的博客
02-26 6716
在mysql中创建hive数据库，并允许hive接入 mysql> create database hive; #这个hive数据库与hive-site.xml中localhost:3306/hive的hive对应，用来保存hive元数据 mysql> grant all on *.* to hive@localhost identified by 'hive'; #将所...
报错：The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please c...
weixin_30776273的博客
05-08 628
报错背景： CDH中集成hive插件，启动报错。 报错现象： [main]: Metastore Thrift Server threw an exception... javax.jdo.JDOFatalInternalException: Error creating transactional connection factory at org.datanucleu...
运行Spark SQL报The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH.
博客
10-31 2892
想启动spark-sql，结果报了 Caused by: org.datanucleus.store.rdbms.connectionpool.DatastoreDriverNotFoundException: The specified datastore driver (“com.mysql.jdbc.Driver”) was not found in the CLASSPATH. Pleas...
Spark shell The specified datastore driver (“com.mysql.jdbc.Driver“) was not found in the CLASSPATH
Aimmon
11-08 731
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 Driver class not found: com.mysql.jdbc.Driver
Twinkle_康康
04-14 2370
JDBC Driver class not found: com.mysql.jdbc.Driver 出现这个异常的问题大多数都是mysql的驱动包没有添加到lib包里面 或者没有配置到项目中去！ 查看自己lib包下是否有mylsql的驱动包 或者到项目里面看添加配置没有  选中项目包------>右键----->properties------->java build path--->
spark-shell启动时报错com.mysql.jdbc.Driver was not found
SKTMVPACE的博客
11-20 1033
启动spark-shell报找不到mysql jdbc 的驱动 具体错误代码： 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 specificati
spark shell 启动报找不到 com.mysql.jdbc.Driver was not found
py_tamir的博客
02-28 2813
问题 spark shell 启动报找不到 com.mysql.jdbc.Driver was not found 解决 1./apache-hive-1.2.1-bin/lib/目录中添加 mysql-connector-java-5.1.35-bin.jar 2. 转到spark 目录中 启动spark-shell /bin/spark-shell --master s...
Registered driver with driverClassName=com.mysql.jdbc.Driver was not found的问题
热门推荐
baidu_35425626的博客
09-26 1万+
Registered driver with driverClassName=com.mysql.jdbc.Driver was not found的问题 找到com.mysql.jdbc.Driver的源码 里面有这么一段 static { System.err.println("Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driv
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.
最新发布
03-19
嗯，用户遇到了NucleusException异常，具体是BONECP连接池插件找不到com.mysql.jdbc.Driver这个驱动。首先，我需要回忆一下类似的问题，比如引用中提到的Hive和Spark的错误，都是因为缺少MySQL驱动包。所以，可能这...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

九师兄

你的鼓励是我做大写作的动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值