You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/04/17 20:44:00 UTC
[jira] [Commented] (DRILL-6173) Support transitive closure during
filter push down and partition pruning
[ https://issues.apache.org/jira/browse/DRILL-6173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16441476#comment-16441476 ]
ASF GitHub Bot commented on DRILL-6173:
---------------------------------------
GitHub user vdiravka opened a pull request:
https://github.com/apache/drill/pull/1216
DRILL-6173: Support transitive closure during filter push down and pa…
…rtition pruning
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/vdiravka/drill DRILL-6173
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/1216.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1216
----
commit ad673cd8030ce1540a1c5bb5a55f6a2c8dbcb5d3
Author: Vitalii Diravka <vi...@...>
Date: 2018-04-17T11:38:03Z
DRILL-6173: Support transitive closure during filter push down and partition pruning
----
> 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: Improvement
> Components: Query Planning & Optimization
> Affects Versions: 1.12.0
> Reporter: Vitalii Diravka
> Assignee: Vitalii Diravka
> Priority: Major
> Labels: doc-impacting
> Fix For: 1.14.0
>
>
> 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)