> On Sept. 23, 2014, 8:24 p.m., Jinfeng Ni wrote: > > exec/java-exec/src/main/java/org/apache/drill/exec/planner/logical/DirPathBuilder.java, > > line 206 > > <https://reviews.apache.org/r/25925/diff/1/?file=701928#file701928line206> > > > > For the constant string "dir", it is configurable via > > ExecConstants.FILESYSTEM_PARTITION_COLUMN_LABEL. It would be better to get > > the partition column label through the configuration. Otherwise, this rule > > will not work, if user chooses a different column label in drill's > > configuration file.
Yes, I will change the reference to use the configurable label. > On Sept. 23, 2014, 8:24 p.m., Jinfeng Ni wrote: > > exec/java-exec/src/main/java/org/apache/drill/exec/planner/logical/DirPathBuilder.java, > > line 177 > > <https://reviews.apache.org/r/25925/diff/1/?file=701928#file701928line177> > > > > Here, seems the code assumes the RHS would be a string literal. What if > > RHS is not a string literal, but another reguar column (RexInputRef)? > > > > For example, dir0 = regular_column ? > > > > The issue is that the visitor would return SchemaPath for either > > RexInputRef, or string literal. Then, the code would not be able to > > differentiate these two cases. Talked to Jinfeng about this and decided that for now the RHS does not need the visitor traversal; instead simply checking for the literal is sufficient. In the general case, the RHS could be a complex expression but that will need either evaluation or go through the interpreter; we will address that in the future. - Aman ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/25925/#review54303 ----------------------------------------------------------- On Sept. 23, 2014, 4:36 a.m., Aman Sinha wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/25925/ > ----------------------------------------------------------- > > (Updated Sept. 23, 2014, 4:36 a.m.) > > > Review request for drill and Jinfeng Ni. > > > Bugs: DRILL-1386 > https://issues.apache.org/jira/browse/DRILL-1386 > > > Repository: drill-git > > > Description > ------- > > > Suppose we have following directory hierarchy for either Parquet or JSON > format: > orders/2012/Jan...Dec, orders/2013/Jan...Dec, orders/2014/Jan...Dec} > In this patch we attempt to push the following types of filters (More types > of filters will be added in the future): > 1. SELECT * FROM <path>/orders WHERE o_custkey = 5 AND dir0 = '2014' > AND dir1 = 'June' > 2. SELECT * FROM <path>/orders WHERE (dir0 = '2013' AND dir1 = 'June') > OR (dir0 = '2014' AND dir1 = 'June') > For (1) dirPath = <path>/orders/2014/June > For (2) there are 2 dirPaths: {<path>/orders/2013/June, > <path>/orders/2014/June} > > A new rule DrillPushPartitionFilterIntoScan has been added which makes use of > a helper class DirPathBuilder. > There are couple of pending issues that need to be resolved based on testing. > > > > Diffs > ----- > > > exec/java-exec/src/main/java/org/apache/drill/exec/physical/base/AbstractFileGroupScan.java > PRE-CREATION > > exec/java-exec/src/main/java/org/apache/drill/exec/physical/base/FileGroupScan.java > PRE-CREATION > > exec/java-exec/src/main/java/org/apache/drill/exec/planner/common/DrillScanRelBase.java > 0934818 > > exec/java-exec/src/main/java/org/apache/drill/exec/planner/logical/DirPathBuilder.java > PRE-CREATION > > exec/java-exec/src/main/java/org/apache/drill/exec/planner/logical/DrillPushPartitionFilterIntoScan.java > PRE-CREATION > > exec/java-exec/src/main/java/org/apache/drill/exec/planner/logical/DrillRuleSets.java > dbb85b2 > > exec/java-exec/src/main/java/org/apache/drill/exec/planner/logical/DrillScanRel.java > 5a0cc08 > > exec/java-exec/src/main/java/org/apache/drill/exec/store/dfs/easy/EasyGroupScan.java > 8efcd2c > > exec/java-exec/src/main/java/org/apache/drill/exec/store/parquet/ParquetGroupScan.java > 86e5224 > exec/java-exec/src/test/java/org/apache/drill/TestExampleQueries.java > c54772f > > Diff: https://reviews.apache.org/r/25925/diff/ > > > Testing > ------- > > New manual tests in TestExampleQueries; these are not automated yet due to > the fact that directory hierarchies have to be created. > > > Thanks, > > Aman Sinha > >
