spark on yarn报错找不到mysql驱动 com.mysql.cj.jdbc.Driver

最新推荐文章于 2023-08-18 12:15:46 发布

JasonZ_1

最新推荐文章于 2023-08-18 12:15:46 发布

阅读量608

点赞数

文章标签： spark mysql

本文链接：https://blog.csdn.net/qq_42392337/article/details/131190426

版权

当尝试在Spark上运行YARN模式下读取MySQL数据库表时，出现错误‘java.lang.ClassNotFoundException:com.mysql.cj.jdbc.Driver’。问题的根本原因是缺少MySQL的jdbc驱动。解决方案是将MySQL的jdbc驱动jar包复制到集群所有节点的JDK库的ext目录下，并确保在Spark的YARN目录中也上传了该驱动包。

摘要由CSDN通过智能技术生成

spark 读取mysql数据库表，master指定使用本地模式"local[*]"没问题，但指定yarn模式报错 not found com.mysql.cj.jdbc.Driver

spark read mysql table to hive ods task Error, error info: An error occurred while calling o51.load.
	: java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
		at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
		at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
		at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
		at org.apache.spark.sql.execution.datasources.jdbc.DriverRegistry$.register(DriverRegistry.scala:46)
		at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.$anonfun$driverClass$1(JDBCOptions.scala:101)
		at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.$anonfun$driverClass$1$adapted(JDBCOptions.scala:101)
		at scala.Option.foreach(Option.scala:407)
		at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.<init>(JDBCOptions.scala:101)
		at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.<init>(JDBCOptions.scala:39)
		at org.apache.spark.sql.execution.datasources.jdbc.JdbcRelationProvider.createRelation(JdbcRelationProvider.scala:34)
		at org.apache.spark.sql.execution.datasources.DataSource.resolveRelation(DataSource.scala:350)
		at org.apache.spark.sql.DataFrameReader.loadV1Source(DataFrameReader.scala:228)
		at org.apache.spark.sql.DataFrameReader.$anonfun$load$2(DataFrameReader.scala:210)
		at scala.Option.getOrElse(Option.scala:189)
		at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:210)
		at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:171)
		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:498)
		at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:244)
		at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:357)
		at py4j.Gateway.invoke(Gateway.java:282)
		at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)
		at py4j.commands.CallCommand.execute(CallCommand.java:79)
		at py4j.ClientServerConnection.waitForCommands(ClientServerConnection.java:182)
		at py4j.ClientServerConnection.run(ClientServerConnection.java:106)
		at java.lang.Thread.run(Thread.java:748)