You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Rajkumar Singh (JIRA)" <ji...@apache.org> on 2018/05/05 22:57:00 UTC

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

Rajkumar Singh created HIVE-19432:
-------------------------------------

             Summary: 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


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)