You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@spark.apache.org by Niranda Perera <ni...@gmail.com> on 2015/07/09 14:09:47 UTC

databases currently supported by Spark SQL JDBC

Hi,

I'm planning to use Spark SQL JDBC datasource provider in various RDBMS
databases.

what are the databases currently supported by Spark JDBC relation provider?

rgds

-- 
Niranda
@n1r44 <https://twitter.com/N1R44>
https://pythagoreanscript.wordpress.com/

Re: databases currently supported by Spark SQL JDBC

Posted by JaeSung Jun <ja...@gmail.com>.

As long as JDBC driver is provided, any database can be used in JDBC
datasource provider.
you can provide driver class in options field like followings :

CREATE TEMPORARY TABLE jdbcTable
USING org.apache.spark.sql.jdbc
OPTIOS(
url "jdbc:oracle:thin:@myhost:1521:orcl"
driver "oracle.jdbc.driver.OracleDriver"
dbtable "users"
)

thx
jason

On 9 July 2015 at 22:09, Niranda Perera <ni...@gmail.com> wrote:

> Hi,
>
> I'm planning to use Spark SQL JDBC datasource provider in various RDBMS
> databases.
>
> what are the databases currently supported by Spark JDBC relation provider?
>
> rgds
>
> --
> Niranda
> @n1r44 <https://twitter.com/N1R44>
> https://pythagoreanscript.wordpress.com/
>

Re: databases currently supported by Spark SQL JDBC

Posted by ayan guha <gu...@gmail.com>.

I suppose every RDBMS has a jdbc driver to connct to. I know Oracle, MySQL,
SQL Server, Terdata, Netezza have.

On Thu, Jul 9, 2015 at 10:09 PM, Niranda Perera <ni...@gmail.com>
wrote:

> Hi,
>
> I'm planning to use Spark SQL JDBC datasource provider in various RDBMS
> databases.
>
> what are the databases currently supported by Spark JDBC relation provider?
>
> rgds
>
> --
> Niranda
> @n1r44 <https://twitter.com/N1R44>
> https://pythagoreanscript.wordpress.com/
>

-- 
Best Regards,
Ayan Guha