VeloxColumnarToRow
  TakeOrderedAndProjectExecTransformer [i_item_id,agg1,agg2,agg3,agg4]
    WholeStageCodegenTransformer (7)
      ProjectExecTransformer [i_item_id,avg(cs_quantity),avg(UnscaledValue(cs_list_price)),avg(UnscaledValue(cs_coupon_amt)),avg(UnscaledValue(cs_sales_price))]
        RegularHashAggregateExecTransformer [i_item_id,sum,count,sum,count,sum,count,sum,count] [avg(cs_quantity),avg(UnscaledValue(cs_list_price)),avg(UnscaledValue(cs_coupon_amt)),avg(UnscaledValue(cs_sales_price)),sum,count,sum,count,sum,count,sum,count]
          InputIteratorTransformer
            InputAdapter
              ColumnarExchange [i_item_id,sum,count,sum,count,sum,count,sum,count] #1
                VeloxResizeBatches
                  WholeStageCodegenTransformer (6)
                    ProjectExecTransformer [i_item_id,sum,count,sum,count,sum,count,sum,count]
                      FlushableHashAggregateExecTransformer [i_item_id,cs_quantity,_pre_x,_pre_x,_pre_x] [sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count]
                        ProjectExecTransformer [cs_quantity,i_item_id,cs_list_price,cs_coupon_amt,cs_sales_price]
                          BroadcastHashJoinExecTransformer [cs_promo_sk,p_promo_sk]
                            ProjectExecTransformer [cs_promo_sk,cs_quantity,cs_list_price,cs_sales_price,cs_coupon_amt,i_item_id]
                              BroadcastHashJoinExecTransformer [cs_item_sk,i_item_sk]
                                ProjectExecTransformer [cs_item_sk,cs_promo_sk,cs_quantity,cs_list_price,cs_sales_price,cs_coupon_amt]
                                  BroadcastHashJoinExecTransformer [cs_sold_date_sk,d_date_sk]
                                    ProjectExecTransformer [cs_item_sk,cs_promo_sk,cs_quantity,cs_list_price,cs_sales_price,cs_coupon_amt,cs_sold_date_sk]
                                      BroadcastHashJoinExecTransformer [cs_bill_cdemo_sk,cd_demo_sk]
                                        FilterExecTransformer [cs_bill_cdemo_sk,cs_item_sk,cs_promo_sk]
                                          FileSourceScanExecTransformer parquet spark_catalog.default.catalog_sales [cs_bill_cdemo_sk,cs_item_sk,cs_promo_sk,cs_quantity,cs_list_price,cs_sales_price,cs_coupon_amt,cs_sold_date_sk]
                                            ColumnarSubqueryBroadcast [d_date_sk] #1
                                              ColumnarBroadcastExchange #2
                                                WholeStageCodegenTransformer (1)
                                                  ProjectExecTransformer [d_date_sk]
                                                    FilterExecTransformer [d_year,d_date_sk]
                                                      FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_date_sk,d_year]
                                        InputIteratorTransformer
                                          InputAdapter
                                            ColumnarBroadcastExchange #3
                                              WholeStageCodegenTransformer (2)
                                                ProjectExecTransformer [cd_demo_sk]
                                                  FilterExecTransformer [cd_gender,cd_marital_status,cd_education_status,cd_demo_sk]
                                                    FileSourceScanExecTransformer parquet spark_catalog.default.customer_demographics [cd_demo_sk,cd_gender,cd_marital_status,cd_education_status]
                                    InputIteratorTransformer
                                      InputAdapter
                                        ReusedExchange [d_date_sk] #2
                                InputIteratorTransformer
                                  InputAdapter
                                    ColumnarBroadcastExchange #4
                                      WholeStageCodegenTransformer (4)
                                        FilterExecTransformer [i_item_sk]
                                          FileSourceScanExecTransformer parquet spark_catalog.default.item [i_item_sk,i_item_id]
                            InputIteratorTransformer
                              InputAdapter
                                ColumnarBroadcastExchange #5
                                  WholeStageCodegenTransformer (5)
                                    ProjectExecTransformer [p_promo_sk]
                                      FilterExecTransformer [p_channel_email,p_channel_event,p_promo_sk]
                                        FileSourceScanExecTransformer parquet spark_catalog.default.promotion [p_promo_sk,p_channel_email,p_channel_event]
