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

UNSUPPORTED_OPERATION ERROR: Hash aggregate does not support schema change

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not A Problem
    • Affects Version/s: 1.16.0
    • Fix Version/s: None
    • Component/s: Server
    • Labels:
      None

      Description

      TPC-DS sql7, scale is 10G.

      select

         i_item_id,

         avg(ss_quantity) agg1,

         avg(ss_list_price) agg2,

         avg(ss_coupon_amt) agg3,

         avg(ss_sales_price) agg4

      from store_sales, customer_demographics, date_dim, item, promotion

      where 

          ss_sold_date_sk = d_date_sk and

          ss_item_sk = i_item_sk and

          ss_cdemo_sk = cd_demo_sk and

          ss_promo_sk = p_promo_sk and

          cd_gender = 'F' and

          cd_marital_status = 'W' and

          cd_education_status = 'College' and

         (p_channel_email = 'N' or p_channel_event = 'N') and

         d_year = 2001

      group by i_item_id

      order by i_item_id

      limit 100;

       

      exception stack:

      UNSUPPORTED_OPERATION ERROR: Hash aggregate does not support schema change

       Prior schema:

      BatchSchema [fields=[[`i_item_id`(varchar:optional)],[`ss_quantity` (int:optional)], [`ss_list_price` (int:optional)] ,[`ss_coupon_amt` (int:optional)], [`ss_sales_price`(int:optional)],selectionVector=NONE]

      New schema:

      BatchSchema [fields=[[`i_item_id`(varchar:optional)][`ss_quantity` (int:optional)],[`ss_list_price` (vardecimal(7,2):optional), children=([`$bit$` (uint1:required)], [`ss_list_price` (vardecimal(7,2):optional), children=([`$offset$` (uint4:required)],  [`ss_coupon_amt` (vardecimal(7,2):optional), children=([`$bit$` (uint1:required)], [`ss_coupon_amt` (vardecimal(7,2):optional), children=([`$offset$` (uint4:required)],  [`ss_sales_price` (vardecimal(7,2):optional), children=([`$bit$` (uint1:required)], [`ss_sales_price` (vardecimal(7,2):optional), children=([`$offset$` (uint4:required)],  ,selectionVector=NONE]

              

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              sucab Changbo Shu
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: