drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1132) CTAS statement gives IndexOutOfBoundsException during planning
Date Sat, 12 Jul 2014 01:30:05 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1132?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14059573#comment-14059573
] 

Aman Sinha commented on DRILL-1132:
-----------------------------------


The same problem occurs for the following query with 3 GROUP-BY columns
  create table tt9 as select n_nationkey, n_regionkey, n_name from nation group by n_nationkey,
n_regionkey, n_name;

The problem is that when we project the output of the WriterPrel, it has a RowType of 2 columns
only:  
         RecordType(VARCHAR(255) Fragment, BIGINT Number of records written)

Whereas we are trying to create a converted Rel with collation and distribution on 3 columns
(see below).  Will discuss the desired behavior with relevant folks and provide a fix.

18:22:03.239 [2b29914b-7b51-4f6e-948e-5986a447bea5:foreman] ERROR o.a.drill.exec.work.foreman.Foreman
- Error 7f0c2271-ef9a-49ee-bc22-3feb6666b25b: Failure while setting up Foreman.
java.lang.IndexOutOfBoundsException: index (2) must be less than size (2)
        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.RegularImmutableList.get(RegularImmutableList.java:81)
~[guava-14.0.1.jar:na]
        at org.eigenbase.rex.RexBuilder.makeInputRef(RexBuilder.java:731) ~[optiq-core-0.7-20140710.204128-10.jar:na]
        at org.eigenbase.rel.SortRel.<init>(SortRel.java:94) ~[optiq-core-0.7-20140710.204128-10.jar:na]
        at org.eigenbase.rel.SortRel.<init>(SortRel.java:59) ~[optiq-core-0.7-20140710.204128-10.jar:na]
        at org.eigenbase.rel.RelCollationTraitDef.convert(RelCollationTraitDef.java:77) ~[optiq-core-0.7-20140710.204128-10.jar:na]
        at org.eigenbase.rel.RelCollationTraitDef.convert(RelCollationTraitDef.java:36) ~[optiq-core-0.7-20140710.204128-10.jar:na]
        at org.eigenbase.relopt.volcano.VolcanoPlanner.changeTraitsUsingConverters(VolcanoPlanner.java:1002)
~[optiq-core-0.7-20140710.204128-10.jar:na]
        at org.eigenbase.relopt.volcano.VolcanoPlanner.changeTraitsUsingConverters(VolcanoPlanner.java:1094)
~[optiq-core-0.7-20140710.204128-10.jar:na]
        at org.eigenbase.relopt.volcano.AbstractConverter$ExpandConversionRule.onMatch(AbstractConverter.java:107)
~[optiq-core-0.7-20140710.204128-10.jar:na]
        at org.eigenbase.relopt.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:221)
~[optiq-core-0.7-20140710.204128-10.jar:na]
        at org.eigenbase.relopt.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:653)
~[optiq-core-0.7-20140710.204128-10.jar:na]
        at net.hydromatic.optiq.prepare.PlannerImpl.transform(PlannerImpl.java:271) ~[optiq-core-0.7-20140710.204128-10.jar:na]

> CTAS statement gives IndexOutOfBoundsException during planning
> --------------------------------------------------------------
>
>                 Key: DRILL-1132
>                 URL: https://issues.apache.org/jira/browse/DRILL-1132
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>            Reporter: Aman Sinha
>
> Using TPCH schema, the following CTAS statement fails with IOBE during planning: 
> CREATE TABLE T6 AS SELECT  n_regionkey, count(*), n_nationkey  
>   FROM nation
> GROUP BY n_regionkey, n_nationkey;
> message: "Failure while setting up Foreman. < AssertionError:[ Internal error: Error
while applying rule ExpandConversionRule, args [rel#18181:AbstractConverter.PHYSICAL.HASH_DISTRIBUTED([[$0],
[$2]]).[0, 2](child=rel#17954:Subset#9.PHYSICAL.HASH_DISTRIBUTED([[$0]]).[],convention=PHYSICAL,DrillDistributionTraitDef=HASH_DISTRIBUTED([[$0],
[$2]]),sort=[0, 2])] ] < IndexOutOfBoundsException:[ index (2) must be less than size (2)
]"
> ]
> NOTE:  running the SELECT portion of the CTAS succeeds. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message