shihuafeng created DRILL-8526:
---------------------------------
Summary: Hive Predicate Push Down for ORC and Parquet
Key: DRILL-8526
URL: https://issues.apache.org/jira/browse/DRILL-8526
Project: Apache Drill
Issue Type: Improvement
Components: Storage - Hive
Affects Versions: 1.22.0
Reporter: shihuafeng
Fix For: 1.22.0
Attachments: image-2025-06-24-18-08-34-427.png,
image-2025-06-24-18-08-54-768.png
Drill do not support filter push down for orc format. i do it and test.
When a large amount of data is filtered out, Predicate PushDown can
significantly improve the query performance of ORC format
Through comparative testing of the following TPCH SQL queries, ORC format with
filter pushdown achieves nearly a 5-20x performance improvement over execution
without pushdown.
sql : select * from hive.lineitem_o where L_ORDERKEY=1;
the data of table lineitem_o: 6001215
with out push down
!image-2025-06-24-18-08-34-427.png!
push down
!image-2025-06-24-18-08-54-768.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
