Re: Does SparkSql has official jdbc/odbc driver?

[Mich Talebzadeh]

Many vendors like Progress Direct provide JDBC/ODBC drivers for Hive.

As stated before Spark is effectively a query tool not a Data Warehouse
like Hive.

I am curious to know why you want to use Spark SQL on Hive tables whereas
Hive itself provides richer SQL (in other words Spark SQL is a subset of
Hive SQL). It may make more sense to use hive directly via JDBC etc if you
just want to use Spark SQL without Functional programming.

HTH




In general you can use

Dr Mich Talebzadeh



LinkedIn * 
https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
*



http://talebzadehmich.wordpress.com



On 29 March 2016 at 09:27, Sage Meng  wrote:

> 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 :
>
>> 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  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 :
>>
>>> 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
>>> .
>>>
>>> -
>>> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
>>> For additional commands, e-mail: user-h...@spark.apache.org
>>>
>>>
>>
>>
>

Re: Does SparkSql has official jdbc/odbc driver?

[Jorge Machado]

This is for Hive not for Spark, these updates differ from updates on rdbms.
What they actually do they add it at the end of your file and then it uses a 
compaction process that only keeps the last record. 

Take a look at : 
https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions 



"Basic Design
HDFS does not support in-place changes to files.  It also does not offer read 
consistency in the face of writers appending to files being read by a user.  In 
order to provide these features on top of HDFS we have followed the standard 
approach used in other data warehousing tools.  Data for the table or partition 
is stored in a set of base files.  New records, updates, and deletes are stored 
in delta files.  A new set of delta files is created for each transaction (or 
in the case of streaming agents such as Flume or Storm, each batch of 
transactions) that alters a table or partition.  At read time the reader merges 
the base and delta files, applying any updates and deletes as it reads. "

Jorge Machado
www.jmachado.me 








> On 29/03/2016, at 10:33, Jorge Machado  wrote:
> 
> This is for Hive not for Spark, there updates from different as updates on 
> rdbms.
> What they actually do they add it and the end of your file and then it uses a 
> compaction process that only keeps the last record. 
> 
> Take a look at : 
> https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions 
> 
> 
> 
> "Basic Design
> HDFS does not support in-place changes to files.  It also does not offer read 
> consistency in the face of writers appending to files being read by a user.  
> In order to provide these features on top of HDFS we have followed the 
> standard approach used in other data warehousing tools.  Data for the table 
> or partition is stored in a set of base files.  New records, updates, and 
> deletes are stored in delta files.  A new set of delta files is created for 
> each transaction (or in the case of streaming agents such as Flume or Storm, 
> each batch of transactions) that alters a table or partition.  At read time 
> the reader merges the base and delta files, applying any updates and deletes 
> as it reads. "
> 
> Jorge Machado
> www.jmachado.me 
> 
> 
> 
> 
> 
>> On 29/03/2016, at 10:27, Sage Meng > > wrote:
>> 
>> 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 > >:
>> 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 >> > 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 >> >:
>>> 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 

Re: Does SparkSql has official jdbc/odbc driver?

[Jorge Machado]

This is for Hive not for Spark, there updates from different as updates on 
rdbms.
What they actually do they add it and the end of your file and then it uses a 
compaction process that only keeps the last record. 

Take a look at : 
https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions 



"Basic Design
HDFS does not support in-place changes to files.  It also does not offer read 
consistency in the face of writers appending to files being read by a user.  In 
order to provide these features on top of HDFS we have followed the standard 
approach used in other data warehousing tools.  Data for the table or partition 
is stored in a set of base files.  New records, updates, and deletes are stored 
in delta files.  A new set of delta files is created for each transaction (or 
in the case of streaming agents such as Flume or Storm, each batch of 
transactions) that alters a table or partition.  At read time the reader merges 
the base and delta files, applying any updates and deletes as it reads. "

Jorge Machado
www.jmachado.me





> On 29/03/2016, at 10:27, Sage Meng  wrote:
> 
> 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  >:
> 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 > > 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 >:
>> 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 
>> .
>> 
>> -
>> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org 
>> 
>> For additional commands, e-mail: user-h...@spark.apache.org 
>> 
>> 
>> 
> 
> 

Re: Does SparkSql has official jdbc/odbc driver?

[Sage Meng]

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 :

> 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  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 :
>
>> 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
>> .
>>
>> -
>> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
>> For additional commands, e-mail: user-h...@spark.apache.org
>>
>>
>
>

Re: Does SparkSql has official jdbc/odbc driver?

[Jorge Machado]

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  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 >:
> 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.
> 
> -
> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org 
> 
> For additional commands, e-mail: user-h...@spark.apache.org 
> 
> 
> 

Re: Does SparkSql has official jdbc/odbc driver?

[Sage Meng]

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 :

> 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.
>
> -
> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
> For additional commands, e-mail: user-h...@spark.apache.org
>
>

Re: Does SparkSql has official jdbc/odbc driver?

[alexpw]

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.

-
To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
For additional commands, e-mail: user-h...@spark.apache.org

RE: Does SparkSql has official jdbc/odbc driver?

[Raymond Honderdors]

For now they are for free




Sent from my Samsung Galaxy smartphone.


 Original message 
From: Sage Meng <lkke...@gmail.com>
Date: 3/28/2016 04:14 (GMT+02:00)
To: Raymond Honderdors <raymond.honderd...@sizmek.com>
Cc: mich.talebza...@gmail.com, user@spark.apache.org
Subject: Re: Does SparkSql has official jdbc/odbc driver?

Hi Raymond Honderdors,
   are odbc/jdbc drivers for spark sql from databricks free, or the drivers 
from databricks can only be used on databricks's spark-sql release?

2016-03-25 17:48 GMT+08:00 Raymond Honderdors 
<raymond.honderd...@sizmek.com<mailto:raymond.honderd...@sizmek.com>>:

Recommended drivers for spark / thrift are the once from databricks (simba)

My experiance is that the databricks driver works perfect on windows and linux
On windows you can get the microsoft driver
Both are odbc

Not jet tried the jdbc drivers

Sent from Outlook Mobile<https://aka.ms/blhgte>



On Fri, Mar 25, 2016 at 1:23 AM -0700, "Mich Talebzadeh" 
<mich.talebza...@gmail.com<mailto:mich.talebza...@gmail.com>> wrote:

JDBC drivers are specific to the databases you are accessing. they are produced 
by the database vendors, For example Oracle one is called ojdbc6.jar and Sybase 
is called jconn4.jar. Hive has got its own drivers

There are companies that produce JDBC or ODBC drivers for various databases 
like Progress Direct,

Spark is a query tools not a database, so it does not have its own drivers.

HTH


Dr Mich Talebzadeh



LinkedIn  
https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw



http://talebzadehmich.wordpress.com<http://talebzadehmich.wordpress.com/>



On 25 March 2016 at 06:33, sage <lkke...@gmail.com<mailto:lkke...@gmail.com>> 
wrote:
Hi all,
Does SparkSql has official jdbc/odbc driver? I only saw third-party's
jdbc/odbc driver.



--
View this message in context: 
http://apache-spark-user-list.1001560.n3.nabble.com/Does-SparkSql-has-official-jdbc-odbc-driver-tp26591.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.

-
To unsubscribe, e-mail: 
user-unsubscr...@spark.apache.org<mailto:user-unsubscr...@spark.apache.org>
For additional commands, e-mail: 
user-h...@spark.apache.org<mailto:user-h...@spark.apache.org>

Re: Does SparkSql has official jdbc/odbc driver?

[Sage Meng]

Hi Raymond Honderdors,
   are odbc/jdbc drivers for spark sql from databricks free, or the drivers
from databricks can only be used on databricks's spark-sql release?

2016-03-25 17:48 GMT+08:00 Raymond Honderdors :

> Recommended drivers for spark / thrift are the once from databricks (simba)
>
> My experiance is that the databricks driver works perfect on windows and
> linux
> On windows you can get the microsoft driver
> Both are odbc
>
> Not jet tried the jdbc drivers
>
> Sent from Outlook Mobile 
>
>
>
> On Fri, Mar 25, 2016 at 1:23 AM -0700, "Mich Talebzadeh" <
> mich.talebza...@gmail.com> wrote:
>
> JDBC drivers are specific to the databases you are accessing. they are
> produced by the database vendors, For example Oracle one is called
> ojdbc6.jar and Sybase is called jconn4.jar. Hive has got its own drivers
>
> There are companies that produce JDBC or ODBC drivers for various
> databases like Progress Direct,
>
> Spark is a query tools not a database, so it does not have its own
> drivers.
>
> HTH
>
> Dr Mich Talebzadeh
>
>
>
> LinkedIn * 
> https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
> *
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> On 25 March 2016 at 06:33, sage  wrote:
>
>> Hi all,
>> Does SparkSql has official jdbc/odbc driver? I only saw third-party's
>> jdbc/odbc driver.
>>
>>
>>
>> --
>> View this message in context:
>> http://apache-spark-user-list.1001560.n3.nabble.com/Does-SparkSql-has-official-jdbc-odbc-driver-tp26591.html
>> Sent from the Apache Spark User List mailing list archive at Nabble.com.
>>
>> -
>> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
>> For additional commands, e-mail: user-h...@spark.apache.org
>>
>>
>

Re: Does SparkSql has official jdbc/odbc driver?

[Raymond Honderdors]

Recommended drivers for spark / thrift are the once from databricks (simba)

My experiance is that the databricks driver works perfect on windows and linux
On windows you can get the microsoft driver
Both are odbc

Not jet tried the jdbc drivers

Sent from Outlook Mobile



On Fri, Mar 25, 2016 at 1:23 AM -0700, "Mich Talebzadeh" 
> wrote:

JDBC drivers are specific to the databases you are accessing. they are produced 
by the database vendors, For example Oracle one is called ojdbc6.jar and Sybase 
is called jconn4.jar. Hive has got its own drivers

There are companies that produce JDBC or ODBC drivers for various databases 
like Progress Direct,

Spark is a query tools not a database, so it does not have its own drivers.

HTH


Dr Mich Talebzadeh



LinkedIn  
https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw



http://talebzadehmich.wordpress.com



On 25 March 2016 at 06:33, sage > 
wrote:
Hi all,
Does SparkSql has official jdbc/odbc driver? I only saw third-party's
jdbc/odbc driver.



--
View this message in context: 
http://apache-spark-user-list.1001560.n3.nabble.com/Does-SparkSql-has-official-jdbc-odbc-driver-tp26591.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.

-
To unsubscribe, e-mail: 
user-unsubscr...@spark.apache.org
For additional commands, e-mail: 
user-h...@spark.apache.org

Re: Does SparkSql has official jdbc/odbc driver?

[Mich Talebzadeh]

JDBC drivers are specific to the databases you are accessing. they are
produced by the database vendors, For example Oracle one is called
ojdbc6.jar and Sybase is called jconn4.jar. Hive has got its own drivers

There are companies that produce JDBC or ODBC drivers for various databases
like Progress Direct,

Spark is a query tools not a database, so it does not have its own drivers.

HTH

Dr Mich Talebzadeh



LinkedIn * 
https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
*



http://talebzadehmich.wordpress.com



On 25 March 2016 at 06:33, sage  wrote:

> Hi all,
> Does SparkSql has official jdbc/odbc driver? I only saw third-party's
> jdbc/odbc driver.
>
>
>
> --
> View this message in context:
> http://apache-spark-user-list.1001560.n3.nabble.com/Does-SparkSql-has-official-jdbc-odbc-driver-tp26591.html
> Sent from the Apache Spark User List mailing list archive at Nabble.com.
>
> -
> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
> For additional commands, e-mail: user-h...@spark.apache.org
>
>

Re: Does SparkSql has official jdbc/odbc driver?

[Takeshi Yamamuro]

Hi,

No, you need to use the third-party's ones.

// maropu

On Fri, Mar 25, 2016 at 3:33 PM, sage  wrote:

> Hi all,
> Does SparkSql has official jdbc/odbc driver? I only saw third-party's
> jdbc/odbc driver.
>
>
>
> --
> View this message in context:
> http://apache-spark-user-list.1001560.n3.nabble.com/Does-SparkSql-has-official-jdbc-odbc-driver-tp26591.html
> Sent from the Apache Spark User List mailing list archive at Nabble.com.
>
> -
> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
> For additional commands, e-mail: user-h...@spark.apache.org
>
>


-- 
---
Takeshi Yamamuro