katty he created HIVE-27990:
-------------------------------
Summary: partition with string and filter with Date can be push
down?
Key: HIVE-27990
URL: https://issues.apache.org/jira/browse/HIVE-27990
Project: Hive
Issue Type: Improvement
Affects Versions: 3.1.2
Reporter: katty he
i have a table with string partition like table a (create tale a ( name string)
partitioned by (dt string) ), and a sql: select * from a where cast (dt as
date) >= DATE_SUB('2024-01-08', 6), in hive 3.1.2, DATE_SUB return date, and
all the partitions are scanned based on log, which will costy a lot, can we
change code with MetaStoreDirectSql.java to push down and reduce the scanned
partitions?
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
