Cloudera Manager_java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

最新推荐文章于 2022-08-15 14:57:14 发布

Solarzhou

最新推荐文章于 2022-08-15 14:57:14 发布

阅读量900

点赞数

本文链接：https://blog.csdn.net/ZT7524/article/details/103203603

版权

数据库同时被 2 个专栏收录

3 篇文章 0 订阅

订阅专栏

Scala

3 篇文章 0 订阅

订阅专栏

实验环境

Cloudera manager6.3；

相关报错

笔者使用Cloudera Manager6.3来进行管理，当打开spark-shell交互式终端，读取mysql数据库中的数据时出现如下报错：

scala> val jdbcDF = spark.read.format("jdbc").option("url", "jdbc:mysqll://hadoop210:3306/rdd").option("driver", "com.mysql.jdbc.Driver").option("dbtable", "t").option("user", "root").option("password", "000000").load() 
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  at scala.reflect.internal.util.AbstractFileClassLoader.findClass(AbstractFileClassLoader.scala:62)
  at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
  at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
  at org.apache.spark.sql.execution.datasources.jdbc.DriverRegistry$.register(DriverRegistry.scala:45)
  at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions$$anonfun$5.apply(JDBCOptions.scala:99)
  at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions$$anonfun$5.apply(JDBCOptions.scala:99)
  at scala.Option.foreach(Option.scala:257)
  at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.<init>(JDBCOptions.scala:99)
  at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.<init>(JDBCOptions.scala:35)
  at org.apache.spark.sql.execution.datasources.jdbc.JdbcRelationProvider.createRelation(JdbcRelationProvider.scala:32)
  at org.apache.spark.sql.execution.datasources.DataSource.resolveRelation(DataSource.scala:317)
  at org.apache.spark.sql.DataFrameReader.loadV1Source(DataFrameReader.scala:223)
  at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:211)
  at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:167)
  ... 49 elided