[ 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: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org