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

CREATE VIEW followup: extend metastore get_tables API to allow filtering by table type (view, external table, etc.)

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.6.0
    • None
    • Metastore
    • None

    Description

      e.g. to get tables which start with x, excluding views:

      get_tables_by_type('default', 'x.*', 'EXTERNAL_TABLE|MANAGED_TABLE');

      Besides direct use, this can also be used to simplify the JDBC getTables() API, which allows filtering by type.

      Attachments

        Issue Links

        is related to

        New Feature - A new feature of the product, which has yet to be developed. HIVE-972 Support views

        • Major - Major loss of function.
        • Closed

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            pauly Paul Yang Assign to me
            jvs John Sichi
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Slack

                Issue deployment