[ https://issues.apache.org/jira/browse/HIVE-19432?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16656012#comment-16656012 ]
Sergey Shelukhin commented on HIVE-19432: ----------------------------------------- Hmm... [~Rajkumar Singh] [~ashutoshc] what kind of testing was done for this? I'm looking at a log where very large number of DBs is present, and with network/etc. overhead for each individual call per database, instead of using the pattern, it takes 10+ minutes to fetch all tables. Seems like a single patterned call, before this patch, would have been faster. > 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 > Fix For: 4.0.0 > > Attachments: HIVE-19432.01.patch, HIVE-19432.01.patch, > 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)