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

Blacklist "sys" and "information_schema" databases from Hive

    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

          is related to

          Sub-task - The sub-task of the issue IMPALA-12583 Support reading hive "information_schema" views in Impala

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. IMPALA-9052 Events processor goes into error state if there are events on blacklisted db or table

          • Major - Major loss of function.
          • Resolved
          links to

          Web Link Code Review

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: