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 <bbuil...@gmail.com>: > I see in the Spark SQL documentation that a temporary table can be created > directly onto a remote PostgreSQL table. > > CREATE TEMPORARY TABLE <table_name> > USING org.apache.spark.sql.jdbc > OPTIONS ( > 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: > http://apache-spark-user-list.1001560.n3.nabble.com/Spark-SQL-1-5-2-missing-JDBC-driver-for-PostgreSQL-tp25773.html > Sent from the Apache Spark User List mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscr...@spark.apache.org > For additional commands, e-mail: user-h...@spark.apache.org > >
