[
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
