[
https://issues.apache.org/jira/browse/SPARK-12403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15062062#comment-15062062
]
Lunen commented on SPARK-12403:
-------------------------------
Something must have changed on the Thriftserver side because test DB and tables
are created in the exact same way.
Comparing
WORKING: 1.3.1 and 1.4.1
NOT WORKING 1.5.x
As I said earlier, I can do a "SHOW DATABASES" and "SHOW TABLES" without any
issues, but not any SELECT.
> "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: [email protected]
For additional commands, e-mail: [email protected]
