You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "bharath v (JIRA)" <ji...@apache.org> on 2019/07/26 21:32:00 UTC

[jira] [Created] (IMPALA-8797) Blacklist "sys" and "information_schema" databases from Hive

bharath v created IMPALA-8797:
---------------------------------

             Summary: Blacklist "sys" and "information_schema" databases from Hive
                 Key: IMPALA-8797
                 URL: https://issues.apache.org/jira/browse/IMPALA-8797
             Project: IMPALA
          Issue Type: Improvement
          Components: Catalog, Frontend
    Affects Versions: Impala 3.2.0
            Reporter: bharath v
            Assignee: Jiawei Wang


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.



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)