Hi, according to https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-NewConfigurationParametersforTransactions it seems that insert/delete/update can be supported, but I haven't try it.
2016-03-29 16:23 GMT+08:00 Jorge Machado <jom...@me.com>: > Hi, > > you should know that “Spark” is not a relation database. So updates on > data as you are used to in RDMS are not possible. > > Jorge Machado > www.jmachado.me > > > > > > On 29/03/2016, at 10:21, Sage Meng <lkke...@gmail.com> wrote: > > thanks, I found that I can use hive's jdbc driver to connect to spark sql. > > I am curious whether simba's jdbc/odbc drivers to spark sql can support > all standard sql statements, since I haven't tried third-party's jdbc/odbc > driver and it seems that hive's jdbc driver can't support > insert/delete/update sql well. > > 2016-03-29 15:47 GMT+08:00 alexpw <al...@simba.com>: > >> sage wrote >> > Hi all, >> > Does SparkSql has official jdbc/odbc driver? I only saw >> third-party's >> > jdbc/odbc driver. >> >> Hi Sage, >> >> Databricks licenses ODBC driver from Simba Technologies. Here's the link >> to >> announcement: >> >> https://databricks.com/blog/2014/04/30/databricks-partners-with-simba-to-deliver-shark-odbc-driver.html >> >> The driver is available from Databricks website for free: >> https://databricks.com/spark/odbc-driver-download but is licensed for use >> only within Databricks Cloud: >> >> "3. Scope of use: You can use this driver only to connect a third party >> application (including Microsoft Excel or Tableau) to Spark SQL within >> Databricks Cloud, using the ODBC protocol." >> >> You can read the Terms of Use here: >> https://databricks.wufoo.com/embed/p1xbn36500t2zce/#fo7li1501 >> >> If you plan to use ODBC driver with Spark on any other platform, you can >> purchase license from Simba Technologies. Simba also have JDBC driver for >> Spark built use the same SQL Engine as the ODBC. Both drivers are >> available >> for free evaluation and purchase here: >> http://www.simba.com/drivers/spark-jdbc-odbc/ >> >> Thanks, >> >> Alex Popov >> Marketing Manager, Simba Technologies Inc. >> >> >> >> -- >> View this message in context: >> http://apache-spark-user-list.1001560.n3.nabble.com/Does-SparkSql-has-official-jdbc-odbc-driver-tp26591p26620.html >> Sent from the Apache Spark User List mailing list archive at Nabble.com >> <http://nabble.com>. >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org >> For additional commands, e-mail: user-h...@spark.apache.org >> >> > >
