Aman Sinha created DRILL-2176:
---------------------------------
Summary: IndexOutOfBoundsException for count(*) on a subquery
which does order-by
Key: DRILL-2176
URL: https://issues.apache.org/jira/browse/DRILL-2176
Project: Apache Drill
Issue Type: Bug
Affects Versions: 0.7.0
Reporter: Aman Sinha
Assignee: Aman Sinha
The IOBE occurs in creating the collation trait in Calcite.
{code}
0: jdbc:drill:zk=local> select count(*) from (select n_nationkey, n_regionkey
from cp.`tpch/nation.parquet` order by 1, 2);
Query failed: IndexOutOfBoundsException: index (1) must be less than size (1)
{code}
Full stack trace:
{code}
aused by: java.lang.IndexOutOfBoundsException: index (1) must be less than size
(1)
at
com.google.common.base.Preconditions.checkElementIndex(Preconditions.java:305)
~[guava-14.0.1.jar:na]
at
com.google.common.base.Preconditions.checkElementIndex(Preconditions.java:284)
~[guava-14.0.1.jar:na]
at
com.google.common.collect.SingletonImmutableList.get(SingletonImmutableList.java:45)
~[guava-14.0.1.jar:na]
at org.eigenbase.rex.RexBuilder.makeInputRef(RexBuilder.java:764)
~[optiq-core-0.9-drill-r18.jar:na]
at org.eigenbase.rel.SortRel.<init>(SortRel.java:94)
~[optiq-core-0.9-drill-r18.jar:na]
at org.eigenbase.rel.SortRel.<init>(SortRel.java:59)
~[optiq-core-0.9-drill-r18.jar:na]
at
org.eigenbase.rel.RelCollationTraitDef.convert(RelCollationTraitDef.java:78)
~[optiq-core-0.9-drill-r18.jar:na]
at
org.eigenbase.rel.RelCollationTraitDef.convert(RelCollationTraitDef.java:1)
~[optiq-core-0.9-drill-r18.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.changeTraitsUsingConverters(VolcanoPlanner.java:1011)
~[optiq-core-0.9-drill-r18.jar:na]
at
org.eigenbase.relopt.volcano.VolcanoPlanner.changeTraitsUsingConverters(VolcanoPlanner.java:1102)
~[optiq-core-0.9-drill-r18.jar:na]
at
org.eigenbase.relopt.volcano.AbstractConverter$ExpandConversionRule.onMatch(AbstractConverter.java:108)
~[optiq-core-0.9-drill-r18.jar:na]
{code}
This might be related to CALCITE-569 (and possibly DRILL-1978) but the stack
traces are different, so I am treating this as a separate issue.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
