You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "dzcxzl (Jira)" <ji...@apache.org> on 2023/07/10 06:58:00 UTC

[jira] [Created] (HIVE-27493) HMS optimizes the SQL query index of getPartitionsByFilter method

dzcxzl created HIVE-27493:
-----------------------------

             Summary: HMS optimizes the SQL query index of getPartitionsByFilter method
                 Key: HIVE-27493
                 URL: https://issues.apache.org/jira/browse/HIVE-27493
             Project: Hive
          Issue Type: Improvement
          Components: Metastore, Standalone Metastore
            Reporter: dzcxzl


Current
{code:java}
[pool-4-thread-1] DEBUG metastore.MetaStoreDirectSql: Direct SQL query in 352.763678ms + 0.026622ms, the query is [select "PARTITIONS"."PART_ID" from "PARTITIONS"  inner join "TBLS" on "PARTITIONS"."TBL_ID" = "TBLS"."TBL_ID"     and "TBLS"."TBL_NAME" = ?   inner join "DBS" on "TBLS"."DB_ID" = "DBS"."DB_ID"      and "DBS"."NAME" = ? inner join "PARTITION_KEY_VALS" "FILTER0" on "FILTER0"."PART_ID" = "PARTITIONS"."PART_ID" and "FILTER0"."INTEGER_IDX" = 0 inner join "PARTITION_KEY_VALS" "FILTER1" on "FILTER1"."PART_ID" = "PARTITIONS"."PART_ID" and "FILTER1"."INTEGER_IDX" = 1 where ( (("FILTER0"."PART_KEY_VAL" = ?) and ("FILTER1"."PART_KEY_VAL" = ?)) )] {code}
Add PART_KEY_VAL index to table PARTITION_KEY_VALS
{code:java}
[pool-4-thread-2] DEBUG metastore.MetaStoreDirectSql: Direct SQL query in 13.770586ms + 0.016063ms{code}
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)