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.

        Activity

          People

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

            Dates

            • Due:
              Created:
              Updated:
              Resolved:

              Development