[
https://issues.apache.org/jira/browse/HIVE-27493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
dzcxzl reassigned HIVE-27493:
-----------------------------
Assignee: dzcxzl
> 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
> Assignee: dzcxzl
> Priority: Major
>
> 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)
