Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21301

Show tables statement to include views and materialized views

    XMLWordPrintableJSON

    Details

      Description

      HIVE-19974 introduced backwards incompatible change, with SHOW TABLES statement showing only managed/external tables in the system.
      This issue will restore old behavior, with SHOW TABLES showing all queryable entities, including views and materialized views.
      Instead, to provide information about table types, SHOW EXTENDED TABLES statement is introduced, which includes an additional column with the table type for each of the tables listed.
      Besides, the possibility to filter the show tables statements with a WHERE `table_type` = 'ANY_TYPE' clause is introduced.

        Attachments

        1. HIVE-21301.patch
          21 kB
          Jesus Camacho Rodriguez
        2. HIVE-21301.01.patch
          22 kB
          Jesus Camacho Rodriguez

          Issue Links

            Activity

              People

              • Assignee:
                jcamachorodriguez Jesus Camacho Rodriguez
                Reporter:
                jcamachorodriguez Jesus Camacho Rodriguez
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 10m
                  10m