[ https://issues.apache.org/jira/browse/DRILL-7521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17013413#comment-17013413 ]
Changbo Shu commented on DRILL-7521: ------------------------------------ through test, disable drill's broadcast_join, this sql is normal. > UNSUPPORTED_OPERATION ERROR: Hash aggregate does not support schema change > -------------------------------------------------------------------------- > > Key: DRILL-7521 > URL: https://issues.apache.org/jira/browse/DRILL-7521 > Project: Apache Drill > Issue Type: Bug > Components: Server > Affects Versions: 1.16.0 > Reporter: Changbo Shu > Priority: Major > > 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)], {color:#FF0000}[`ss_list_price` (int:optional)] > ,{color}{color:#FF0000}[`ss_coupon_amt` (int:optional)], > {color}{color:#FF0000}[`ss_sales_price`(int:optional)]{color},selectionVector=NONE] > New schema: > BatchSchema [fields=[[`i_item_id`(varchar:optional)], [`ss_quantity` > (int:optional)],{color:#FF0000}[`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)]{color}, ,selectionVector=NONE] > -- This message was sent by Atlassian Jira (v8.3.4#803005)