[
https://issues.apache.org/jira/browse/IMPALA-8797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16894521#comment-16894521
]
Quanlong Huang commented on IMPALA-8797:
----------------------------------------
It'd be better to support this as startup options, e.g.
--blacklist_dbs="sys,information_schema" and
--blacklist_tables="default.fooTbl,myDb.barTbl". Impala admins always have
requirements to reject queries on some tables, e.g. with too many
partitions/files/blocks.
> 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
> Priority: Major
>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
