已解决：pyspark调用mysql 报错 java.sql.SQLException: No suitable driver

最新推荐文章于 2024-03-13 23:30:00 发布

waylyw

最新推荐文章于 2024-03-13 23:30:00 发布

阅读量1.8k

点赞数 4

分类专栏： java python spark 文章标签： java python spark linux

本文链接：https://blog.youkuaiyun.com/lyw5200/article/details/111317472

版权

python 同时被 3 个专栏收录

15 篇文章

订阅专栏

java

4 篇文章

订阅专栏

spark

3 篇文章

订阅专栏

centos-python3环境下，调用pyspark库连接mysql数据库时报错：java.sql.SQLException: No suitable driver

具体如下：

  File "/usr/local/lib/python3.6/site-packages/pyspark/sql/readwriter.py", line 155, in load
    return self._df(self._jreader.load())
  File "/usr/local/lib/python3.6/site-packages/py4j/java_gateway.py", line 1133, in __call__
    answer, self.gateway_client, self.target_id, self.name)
  File "/usr/local/lib/python3.6/site-packages/pyspark/sql/utils.py", line 63, in deco
    return f(*a, **kw)
  File "/usr/local/lib/python3.6/site-packages/py4j/protocol.py", line 319, in get_return_value
    format(target_id, ".", name), value)
py4j.protocol.Py4JJavaError: An error occurred while calling o25.load.
: java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getDriver(DriverManager.java:315)
	at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions$$anonfun$7.apply(JDBCOptions.scala:84)
	at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions$$anonfun$7.apply(JDBCOptions.scala:84)
	at scala.Option.getOrElse(Option.scala:121)
	at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.<init>(JDBCOptions.scala:83)
	at org.apache.spark.sql.execution.datasources.jdbc.JDBCOptions.<init>(JDBCOptions.scala:34)
	at org.apache.spark.sql.execution.datasources.jdbc.JdbcRelationProvider.createRelation(JdbcRelationProvider.scala:32)
	at org.apache.spark.sql.execution.datasources.DataSource.resolveRelation(DataSource.scala:330)
	at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:152)
	at org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:125)
	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:280)
	at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:132)
	at py4j.commands.CallCommand.execute(CallCommand.java:79)
	at py4j.GatewayConnection.run(GatewayConnection.java:214)
	at java.lang.Thread.run(Thread.java:748)

报错原因：由于pyspark底层调用java，而java未找到jdbc

解决方法，下载 mysql-connector-java-8.0.22.jar 文件，并复制到 java 安装目录下的 jre/lib/ext 文件夹下

再次运行程序正常运行