From user-return-48474-apmail-spark-user-archive=spark.apache.org@spark.apache.org Wed Dec 23 01:22:29 2015 Return-Path: X-Original-To: apmail-spark-user-archive@minotaur.apache.org Delivered-To: apmail-spark-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 67E0D18F2E for ; Wed, 23 Dec 2015 01:22:29 +0000 (UTC) Received: (qmail 74585 invoked by uid 500); 23 Dec 2015 01:22:25 -0000 Delivered-To: apmail-spark-user-archive@spark.apache.org Received: (qmail 74494 invoked by uid 500); 23 Dec 2015 01:22:25 -0000 Mailing-List: contact user-help@spark.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list user@spark.apache.org Received: (qmail 74484 invoked by uid 99); 23 Dec 2015 01:22:25 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Dec 2015 01:22:25 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 2770B180455 for ; Wed, 23 Dec 2015 01:22:25 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.737 X-Spam-Level: *** X-Spam-Status: No, score=3.737 tagged_above=-999 required=6.31 tests=[DKIM_ADSP_CUSTOM_MED=0.001, FREEMAIL_ENVFROM_END_DIGIT=0.25, NML_ADSP_CUSTOM_MED=1.2, SPF_SOFTFAIL=0.972, URIBL_BLOCKED=0.001, URI_HEX=1.313] autolearn=disabled Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id TesILulimcM8 for ; Wed, 23 Dec 2015 01:22:15 +0000 (UTC) Received: from mwork.nabble.com (mwork.nabble.com [162.253.133.43]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTP id 5C529439DB for ; Wed, 23 Dec 2015 01:22:15 +0000 (UTC) Received: from mben.nabble.com (unknown [162.253.133.72]) by mwork.nabble.com (Postfix) with ESMTP id C89296D269C7 for ; Tue, 22 Dec 2015 17:20:26 -0800 (PST) Date: Tue, 22 Dec 2015 18:22:14 -0700 (MST) From: b2k70 To: user@spark.apache.org Message-ID: <1450833734985-25773.post@n3.nabble.com> Subject: Spark SQL 1.5.2 missing JDBC driver for PostgreSQL? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I see in the Spark SQL documentation that a temporary table can be created directly onto a remote PostgreSQL table. CREATE TEMPORARY TABLE USING org.apache.spark.sql.jdbc OPTIONS ( url "jdbc:postgresql:///", 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:/// (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