shezm created HIVE-25867:
----------------------------
Summary: Partition filter condition should pushed down to
metastore query if it is equivalence Predicate
Key: HIVE-25867
URL: https://issues.apache.org/jira/browse/HIVE-25867
Project: Hive
Issue Type: Improvement
Components: Standalone Metastore
Reporter: shezm
Fix For: 4.0.0
The colnum type of the partition is different from the column type of the hql
query, the metastore will not push down the query to the RDBMS, but will
instead get all PARTITIONS.PART_NAME of the hive table then filter it according
to the hql Expression.
https://github.com/apache/hive/blob/5b112aa6dcc4e374c0a7c2b24042f24ae6815da1/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java#L1316
If the hive table has too many partitions and there are multiple hql queries at
the same time,RDBMS will increasing CPU IO_WAIT and affect performance.
If the partition filter condition in hql is an equivalent predicate, the
metastore should be pushed down to RDBMS, which can optimize the query
performance of hive large tables.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
