save DF to JDBC

2015-10-05 Thread Ruslan Dautkhanov
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

RE: save DF to JDBC

2015-10-05 Thread Young, Matthew T
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

Re: save DF to JDBC

2015-10-05 Thread Richard Hillegas
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 >

Re: save DF to JDBC

2015-10-05 Thread Ruslan Dautkhanov
"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