[
https://issues.apache.org/jira/browse/HIVE-28292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17882163#comment-17882163
]
Denys Kuzmenko commented on HIVE-28292:
---------------------------------------
Merged to master
Thanks [~wechar] for the patch!
> Optimize SHOW TABLES|VIEWS statements
> -------------------------------------
>
> Key: HIVE-28292
> URL: https://issues.apache.org/jira/browse/HIVE-28292
> Project: Hive
> Issue Type: Improvement
> Components: Hive
> Reporter: Wechar
> Assignee: Wechar
> Priority: Major
> Labels: pull-request-available
>
> There are some improvement points in {{SHOW TABLES}} statement:
> 1. pattern is not pushed to metastore server
> 2. get table objects even if only table name and table type is needed.
> 3. index {{UNIQUETABLE(TBL_NAME, DB_ID)}} in {{TBLS}} table is not efficient
> enough compared to index {{(DB_ID, TBL_NAME)}} when querying tables by name
> pattern.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
