[
https://issues.apache.org/jira/browse/HIVE-19432?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16464931#comment-16464931
]
ASF GitHub Bot commented on HIVE-19432:
---------------------------------------
GitHub user rajkrrsingh opened a pull request:
https://github.com/apache/hive/pull/341
HIVE-19432 : GetTablesOperation is too slow if the hive has too many …
GetTablesOperation is too slow since it does not check for the
authorization for databases and try pulling all the tables from all the
databases using getTableMeta. for the operation like follows
```
con.getMetaData().getTables("", "", "%", new String[] \{ "TABLE", "VIEW" });
```
build the getTableMeta call with wildcard *
```
metastore.HiveMetaStore: 8: get_table_metas : db=* tbl=*
```
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/rajkrrsingh/hive HIVE-19432
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/hive/pull/341.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #341
----
commit ee684cedcea545a17658be204b3b07e2fdbc56ed
Author: Rajkumar singh <rajkrrsingh@...>
Date: 2018-05-05T23:11:04Z
HIVE-19432 : GetTablesOperation is too slow if the hive has too many
databases and tables
----
> HIVE-7575: GetTablesOperation is too slow if the hive has too many databases
> and tables
> ---------------------------------------------------------------------------------------
>
> Key: HIVE-19432
> URL: https://issues.apache.org/jira/browse/HIVE-19432
> Project: Hive
> Issue Type: Improvement
> Components: Hive, HiveServer2
> Affects Versions: 2.2.0
> Reporter: Rajkumar Singh
> Assignee: Rajkumar Singh
> Priority: Major
> Labels: pull-request-available
> Attachments: HIVE-19432.patch
>
>
> GetTablesOperation is too slow since it does not check for the authorization
> for databases and try pulling all the tables from all the databases using
> getTableMeta. for operation like follows
> {code}
> con.getMetaData().getTables("", "", "%", new String[] \{ "TABLE", "VIEW" });
> {code}
> build the getTableMeta call with wildcard *
> {code}
> metastore.HiveMetaStore: 8: get_table_metas : db=* tbl=*
> {code}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)