You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Wechar (Jira)" <ji...@apache.org> on 2024/05/30 18:36:00 UTC

[jira] [Updated] (HIVE-28292) Optimize SHOW TABLES|VIEWS statements

     [ https://issues.apache.org/jira/browse/HIVE-28292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Wechar updated HIVE-28292:
--------------------------
    Description: 
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.

> 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)