spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Boesch <java...@gmail.com>
Subject Re: Spark SQL 1.5.2 missing JDBC driver for PostgreSQL?
Date Wed, 23 Dec 2015 02:25:13 GMT
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 <bbuild11@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-unsubscribe@spark.apache.org
> For additional commands, e-mail: user-help@spark.apache.org
>
>

Mime
View raw message