http://spark.apache.org/docs/latest/sql-programming-guide.html#jdbc-to-other-databases
Spark JDBC can read data from JDBC, but can it save back to JDBC?
Like to an Oracle database through its jdbc driver.
Also looked at SQL Context documentation
haven’t tried Oracle database, but I would expect it to work at least
somewhat.
From: Ruslan Dautkhanov [mailto:dautkha...@gmail.com]
Sent: Monday, October 05, 2015 2:44 PM
To: user <user@spark.apache.org>
Subject: save DF to JDBC
http://spark.apache.org/docs/latest/sql-programming-guide.htm
ies)
Hope this helps,
Rick Hillegas
STSM, IBM Analytics, Platform - IBM USA
Ruslan Dautkhanov <dautkha...@gmail.com> wrote on 10/05/2015 02:44:20 PM:
> From: Ruslan Dautkhanov <dautkha...@gmail.com>
> To: user <user@spark.apache.org>
> Date: 10/05/2015 02:45 PM
>
"decimal_col"
> )
>
> val properties = new java.util.Properties()
>
> allTypes.write.jdbc("jdbc:derby:/Users/rhillegas/derby/databases/derby1",
> "all_spark_types", properties)
>
> Hope this helps,
>
> Rick Hillegas
> STSM, IBM Analytics