Description
It is nice to have a `SHOW VIEWS` command similar to Hive (https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-ShowViews).
Although this is adding a new feature, this resolved the regression bug in the below.
According to the report, https://github.com/apache/spark/pull/27897#issuecomment-602519201,
Tableau and PowerBI, which use the Simba ODBC driver, do not work with Spark 3.0 with Hive 2.3.
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.
Attachments
Issue Links
- is duplicated by
-
SPARK-31033 Support 'SHOW views' command
-
- Resolved
-
- relates to
-
SPARK-23710 Upgrade the built-in Hive to 2.3.5 for hadoop-3.2
-
- Resolved
-
- links to