[
https://issues.apache.org/jira/browse/HIVE-28292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on HIVE-28292 started by Wechar.
-------------------------------------
> 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
>
> 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)
