Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-8797

Blacklist "sys" and "information_schema" databases from Hive

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • Impala 3.2.0
    • Impala 3.4.0
    • Catalog, Frontend
    • None
    • ghx-label-3

    Description

      HMS exposes these two databases "sys" and "information_schema" which contain tables that expose the underlying meta information in a queryable format. However, Impala cannot read them because they come with custom serde that Impala doesn't support.

      From a usability point of view, we should black list those databases from loading, so that users don't see them when querying the database list. I think that is reasonable because they can't query them anyway.

      Attachments

        Issue Links

        There are no Sub-Tasks for this issue.

        Activity

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

          People

            stigahuang Quanlong Huang
            bharathv Bharath Vissapragada
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment