juliuszsompolski commented on issue #27897: [SPARK-31113][SQL] Add SHOW VIEWS command URL: https://github.com/apache/spark/pull/27897#issuecomment-602519201 Thank you for this PR implementing `SHOW VIEWS`! It comes at a handy moment, as we discovered that without `SHOW VIEWS`, Simba ODBC driver implementation of `SQLGetTables` break with Hive 2.3 profile. Simba ODBC drivers implemented a workaround because of missing implementation of `GetTablesOperation` in Spark 2.4 and below, where they implemented `SQLGetTables` using `SHOW SCHEMAS`, `SHOW TABLES` and `SHOW VIEWS`. They base the capability to issue `SHOW VIEWS` on Hive version (which they obtain via `set -v`). When we switch to Hive 2.3 profile, Simba driver assumes that `SHOW VIEWS` is supported, and issues it, failing the `SQLGetTables` call when it fails. Because of this issue, Tableau and PowerBI, which use the Simba ODBC driver, do not work with Spark 3.0 with Hive 2.3. Simba is working on a fix, to use the proper `SparkGetTablesOperation` that was implemented for 3.0, instead of the workaround they do now, but it will take some time, plus then it would take some time for vendors such as Tableau and PowerBI to pick up the new drivers... For the reasons above, would it be possible to get `SHOW VIEWS` into Spark 3.0, so at launch it is not broken with Tableau and PowerBI? WDYT @wangyum @gatorsmile @cloud-fan @maropu @dongjoon-hyun ?
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
