[ 
https://issues.apache.org/jira/browse/SPARK-12403?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Lunen updated SPARK-12403:
--------------------------
    Description: 
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"

  was:
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 default.lunentest')



> "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