Vitalii Diravka created DRILL-6173:
--------------------------------------
Summary: Support transitive closure during filter push down and
partition pruning
Key: DRILL-6173
URL: https://issues.apache.org/jira/browse/DRILL-6173
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Affects Versions: 1.12.0
Reporter: Vitalii Diravka
Assignee: Vitalii Diravka
Fix For: Future
There is Calcite rule JoinPushTransitivePredicatesRule but it does not work in
Drill.
Applying it in Drill will allow for equi-join queries to push filter condition
from one table to another:
{code:sql}
select *
from A, B
where
A.id = B.id and
B.id = 100
{code}
In that case it is possible that Scan operator for A table will not scan all
data.
For table A it can lead for applying:
1. [Partition pruning for Hive or file system Parquet
tables|https://drill.apache.org/docs/partition-pruning-introduction/]
2. [Parquet filter
pushdown|https://drill.apache.org/docs/parquet-filter-pushdown/]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
