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
