[HIVE-19432] HIVE-7575: GetTablesOperation is too slow if the hive has too many databases and tables

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Hive, HiveServer2
• Labels: pull-request-available
• Assignee: Rajkumar Singh
• Reporter: Rajkumar Singh
• Created: 05/May/18 22:56
• Updated: 17/Nov/22 08:55
• Resolved: 01/Jun/18 20:46

Description

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

con.getMetaData().getTables("", "", "%", new String[] \{ "TABLE", "VIEW" });

build the getTableMeta call with wildcard *

 metastore.HiveMetaStore: 8: get_table_metas : db=* tbl=*

 

Issue Links

• links to: GitHub Pull Request #341
• links to: GitHub Pull Request #341