[ 
https://issues.apache.org/jira/browse/SPARK-12403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15062114#comment-15062114
 ] 

Lunen commented on SPARK-12403:
-------------------------------

Sorry, which driver are you referring to? ODBC? If it's the Databricks ODBC 
driver, they have only released one driver mid last year. It's been working on 
all previous thriftserver versions. I've also tried other paid for ODBC drivers 
in the market without any luck.(Progress and Microsoft)

> "Simba Spark ODBC Driver 1.0" not working with 1.5.2 anymore
> ------------------------------------------------------------
>
>                 Key: SPARK-12403
>                 URL: https://issues.apache.org/jira/browse/SPARK-12403
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.5.1, 1.5.2
>         Environment: ODBC connector query 
>            Reporter: Lunen
>             Fix For: 1.3.1
>
>
> We are unable to query the SPARK tables using the ODBC driver from Simba 
> Spark(Databricks - "Simba Spark ODBC Driver 1.0")  We are able to do a show 
> databases and show tables, but not any queries. eg.
> Working:
> Select * from openquery(SPARK,'SHOW DATABASES')
> Select * from openquery(SPARK,'SHOW TABLES')
> Not working:
> Select * from openquery(SPARK,'Select * from lunentest')
> The error I get is:
> OLE DB provider "MSDASQL" for linked server "SPARK" returned message 
> "[Simba][SQLEngine] (31740) Table or view not found: spark..lunentest".
> Msg 7321, Level 16, State 2, Line 2
> An error occurred while preparing the query "Select * from lunentest" for 
> execution against OLE DB provider "MSDASQL" for linked server "SPARK"



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

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

Reply via email to