[SPARK-9985] DataFrameWriter jdbc method ignore options that have been set

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Assignee: Shixiong Zhu
• Reporter: Richard Garris
• Created: 14/Aug/15 19:50
• Updated: 16/Aug/15 15:43
• Resolved: 16/Aug/15 14:50

Description

I am working on an RDBMS to DataFrame conversion using Postgres and am hitting a wall where everytime I try to use the Postgresql JDBC driver to get a java.sql.SQLException: No suitable driver found error
Here is the stack trace:

at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:187)
at org.apache.spark.sql.jdbc.package$JDBCWriteDetails$.savePartition(jdbc.scala:67)
at org.apache.spark.sql.jdbc.package$JDBCWriteDetails$$anonfun$saveTable$1.apply(jdbc.scala:189)
at org.apache.spark.sql.jdbc.package$JDBCWriteDetails$$anonfun$saveTable$1.apply(jdbc.scala:188)
at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:878)
at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:878)
at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1765)
at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:1765)
at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:63)
at org.apache.spark.scheduler.Task.run(Task.scala:70)
at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:213)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

It appears that DataFrameWriter and DataFrameReader ignores options that we set before invoking jdbc.

Issue Links

• duplicates: SPARK-8463 No suitable driver found for write.jdbc