[DRILL-2176] IndexOutOfBoundsException for count(*) on a subquery which does order-by

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.7.0
• Fix Version/s: 0.9.0
• Component/s: SQL Parser
• Assignee: Aman Sinha
• Reporter: Aman Sinha
• Created: 06/Feb/15 16:48
• Updated: 27/Apr/15 18:31
• Resolved: 03/Apr/15 23:02

Description

The IOBE occurs in creating the collation trait in Calcite.

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)

Full stack trace:

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]

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.

Issue Links

• duplicates: DRILL-1978 Using order by with a cast function and array index fails to plan.