[
https://issues.apache.org/jira/browse/SPARK-12403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15092427#comment-15092427
]
Yin Huai commented on SPARK-12403:
----------------------------------
[~lunendl] Also, have you reported to simba? If there is any public page that
can tracks that issue, it will be good to post it at here.
(btw, from the error message, looks like the odbc driver got the wrong database
name. I am not sure if it is a problem of the odbc driver or the spark sql's
thrift server. We will try to investigate when we get a chance.)
> "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.0, 1.5.1, 1.5.2
> Environment: ODBC connector query
> Reporter: Lunen
>
> 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
