Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1132

CTAS statement gives IndexOutOfBoundsException during planning

    Details

      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.

        Attachments

          Activity

            People

            • Assignee:
              DrillCommitter DrillCommitter
              Reporter:
              amansinha100 Aman Sinha
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: