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

Show tables statement to include views and materialized views

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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
          Jesus Camacho Rodriguez
        2. HIVE-21301.patch
          21 kB
          Jesus Camacho Rodriguez

        Issue Links

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              jcamachorodriguez Jesus Camacho Rodriguez Assign to me
              Reporter:
              jcamachorodriguez Jesus Camacho Rodriguez

              Dates

              • Created:
                Updated:
                Resolved:

              Time Tracking

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

                Issue deployment