The postgres jdbc driver needs to be added to the  classpath of your spark workers.  You can do a search for how to do that (multiple ways).

2015-12-22 17:22 GMT-08:00 b2k70 <>:
I see in the Spark SQL documentation that a temporary table can be created
directly onto a remote PostgreSQL table.

USING org.apache.spark.sql.jdbc
url "jdbc:postgresql://<PostgreSQL_Hostname_IP>/<database_name>",
dbtable "impressions"
When I run this against our PostgreSQL server, I get the following error.

Error: java.sql.SQLException: No suitable driver found for
jdbc:postgresql://<PostgreSQL_Hostname_IP>/<database_name> (state=,code=0)

Can someone help me understand why this is?

Thanks, Ben

View this message in context:
Sent from the Apache Spark User List mailing list archive at

To unsubscribe, e-mail:
For additional commands, e-mail: