[
https://issues.apache.org/jira/browse/DRILL-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14943566#comment-14943566
]
Victoria Markman commented on DRILL-3639:
-----------------------------------------
This issue is fixed in 1.2.0
#Thu Oct 01 23:19:53 UTC 2015
git.commit.id.abbrev=fe2b743
{code}
0: jdbc:drill:schema=dfs> explain plan for select * from
hive.lineitem_text_partitioned_hive_hier_intint where (`year`=1993 and
l_orderkey>29600) or (`year`=1984+`month` and l_orderkey>29700);
+------+------+
| text | json |
+------+------+
| 00-00 Screen
00-01 Project(l_orderkey=[$0], l_partkey=[$1], l_suppkey=[$2],
l_linenumber=[$3], l_quantity=[$4], l_extendedprice=[$5], l_discount=[$6],
l_tax=[$7], l_returnflag=[$8], l_linestatus=[$9], l_shipdate=[$10],
l_commitdate=[$11], l_receiptdate=[$12], l_shipinstruct=[$13],
l_shipmode=[$14], l_comment=[$15], year=[$16], month=[$17])
00-02 Project(l_orderkey=[$0], l_partkey=[$1], l_suppkey=[$2],
l_linenumber=[$3], l_quantity=[$4], l_extendedprice=[$5], l_discount=[$6],
l_tax=[$7], l_returnflag=[$8], l_linestatus=[$9], l_shipdate=[$10],
l_commitdate=[$11], l_receiptdate=[$12], l_shipinstruct=[$13],
l_shipmode=[$14], l_comment=[$15], year=[$16], month=[$17])
00-03 SelectionVectorRemover
00-04 Filter(condition=[OR(AND(=($16, 1993), >($0, 29600)),
AND(=($16, +(1984, $17)), >($0, 29700)))])
00-05 Scan(groupscan=[HiveScan [table=Table(dbName:default,
tableName:lineitem_text_partitioned_hive_hier_intint),
inputSplits=[maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1991/7/lineitemag.tbl:0+107400,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1992/8/lineitemah.tbl:0+107897,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/1/lineitemaa.tbl:0+107685,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/10/lineitemaj.tbl:0+107386,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/11/lineitemak.tbl:0+107985,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/12/lineitemal.tbl:0+12047,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/2/lineitemab.tbl:0+107417,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/3/lineitemac.tbl:0+108302,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/4/lineitemad.tbl:0+108360,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/5/lineitemae.tbl:0+107946,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/6/lineitemaf.tbl:0+108094,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/7/lineitemag.tbl:0+108185,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/8/lineitemah.tbl:0+107977,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1993/9/lineitemai.tbl:0+108110,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1994/10/lineitemaj.tbl:0+107846,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1995/11/lineitemak.tbl:0+107802,
maprfs:///drill/testdata/partition_pruning/hive/text/lineitem_hierarchical_intint/1996/12/lineitemal.tbl:0+12107],
columns=[`*`], partitions= [Partition(values:[1991, 7]),
Partition(values:[1992, 8]), Partition(values:[1993, 1]),
Partition(values:[1993, 10]), Partition(values:[1993, 11]),
Partition(values:[1993, 12]), Partition(values:[1993, 2]),
Partition(values:[1993, 3]), Partition(values:[1993, 4]),
Partition(values:[1993, 5]), Partition(values:[1993, 6]),
Partition(values:[1993, 7]), Partition(values:[1993, 8]),
Partition(values:[1993, 9]), Partition(values:[1994, 10]),
Partition(values:[1995, 11]), Partition(values:[1996, 12])]]])
{code}
> Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet
> ------------------------------------------------------------------------------
>
> Key: DRILL-3639
> URL: https://issues.apache.org/jira/browse/DRILL-3639
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.1.0
> Reporter: 徐波
> Assignee: Jinfeng Ni
> Fix For: 1.2.0
>
>
> exception:
> (org.apache.drill.exec.work.foreman.ForemanException) Unexpected exception
> during fragment initialization: Internal error: Error while applying rule
> PruneScanRule:Filter_On_Scan_Parquet
> Caused By (java.lang.AssertionError) null
>
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator$EvalVisitor.isBitOn():490
>
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator$EvalVisitor.visitBooleanAnd():434
>
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator$EvalVisitor.visitBooleanOperator():332
>
> org.apache.drill.exec.expr.fn.interpreter.InterpreterEvaluator$EvalVisitor.visitBooleanOperator():147
> org.apache.drill.common.expression.BooleanOperator.accept():36
> my sql:
> select col1 from hdfs.root.`/dir/table1` where col2<cast('222222222.0' as
> double) and col3=101 limit 10
> col2 is not a partition column and col3 is a partition column, so the
> FindPartitionConditions get a wrong condition like
> 'AND(CAST('222222222.0'):DOUBLE NOT NULL, =($1, 101))'
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
