[jira] [Created] (DRILL-1132) CTAS statement gives IndexOutOfBoundsException during planning

[Aman Sinha (JIRA)]

Aman Sinha created DRILL-1132:
---------------------------------

             Summary: 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)