Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-31113

Support DDL "SHOW VIEWS"

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: 3.0.0
    • Component/s: SQL
    • Labels:
      None
    • Target Version/s:

      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

            Activity

              People

              • Assignee:
                EricWu Xin Wu
                Reporter:
                smilegator Xiao Li
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: