drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-2176) IndexOutOfBoundsException for count(*) on a subquery which does order-by
Date Mon, 27 Apr 2015 18:32:39 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Abhishek Girish closed DRILL-2176.
----------------------------------

> 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
>          Components: SQL Parser
>    Affects Versions: 0.7.0
>            Reporter: Aman Sinha
>            Assignee: Aman Sinha
>             Fix For: 0.9.0
>
>
> 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)

Mime
View raw message