I am using Spark(1.5.0) for utilizing Spark-SQL feature using Spark ThriftServer application and also using Simba Spark ODBC Driver for getting connection.
Using Tableau, I am able to connect and able to do Spark-SQL operations.
But when, I tried to connect Spark-SQL to MS-Excel, It goes connected but not listing database and table names. And I also tried Microsoft Query
option of MS-Excel according to Doc to execute custom SQL queries (select * default.airline
), but it's throwing error with query (select * from SPARK.default.airline
) with catalog name SPARK
.
Problem is that how to remove that catalog name from the query, I tried with all the available options.