[DRILL-1132] CTAS statement gives IndexOutOfBoundsException during planning

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Query Planning & Optimization
• Assignee: DrillCommitter
• Reporter: Aman Sinha
• Due: 19/Aug/14
• Created: 11/Jul/14 18:58
• Updated: 29/Aug/14 17:55
• Resolved: 29/Aug/14 17:55

Description

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.