You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Quanlong Huang (JIRA)" <ji...@apache.org> on 2019/07/27 18:23:00 UTC
[jira] [Commented] (IMPALA-8797) Blacklist "sys" and
"information_schema" databases from Hive
[ 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: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org