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.01.patch
          22 kB
          jcamachorodriguez
        2. HIVE-21301.patch
          21 kB
          jcamachorodriguez

        Issue Links

          Activity

            People

              jcamacho Jesús Camacho Rodríguez
              jcamacho Jesús Camacho Rodríguez
              Votes:
              0 Vote for this issue
              Watchers:
              3 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 - 20m
                  20m