VeloxColumnarToRow
  TakeOrderedAndProjectExecTransformer [ca_country,ca_state,ca_county,i_item_id,agg1,agg2,agg3,agg4,agg5,agg6,agg7]
    WholeStageCodegenTransformer (11)
      ProjectExecTransformer [i_item_id,ca_country,ca_state,ca_county,avg(cast(cs_quantity as decimal(12,2))),avg(cast(cs_list_price as decimal(12,2))),avg(cast(cs_coupon_amt as decimal(12,2))),avg(cast(cs_sales_price as decimal(12,2))),avg(cast(cs_net_profit as decimal(12,2))),avg(cast(c_birth_year as decimal(12,2))),avg(cast(cd_dep_count as decimal(12,2)))]
        RegularHashAggregateExecTransformer [i_item_id,ca_country,ca_state,ca_county,spark_grouping_id,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count] [avg(cast(cs_quantity as decimal(12,2))),avg(cast(cs_list_price as decimal(12,2))),avg(cast(cs_coupon_amt as decimal(12,2))),avg(cast(cs_sales_price as decimal(12,2))),avg(cast(cs_net_profit as decimal(12,2))),avg(cast(c_birth_year as decimal(12,2))),avg(cast(cd_dep_count as decimal(12,2))),sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count]
          InputIteratorTransformer
            InputAdapter
              ColumnarExchange [i_item_id,ca_country,ca_state,ca_county,spark_grouping_id,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count] #1
                VeloxResizeBatches
                  WholeStageCodegenTransformer (10)
                    ProjectExecTransformer [i_item_id,ca_country,ca_state,ca_county,spark_grouping_id,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count]
                      FlushableHashAggregateExecTransformer [i_item_id,ca_country,ca_state,ca_county,spark_grouping_id,_pre_x,_pre_x,_pre_x,_pre_x,_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,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count,sum,count]
                        ProjectExecTransformer [i_item_id,ca_country,ca_state,ca_county,spark_grouping_id,cs_quantity,cs_list_price,cs_coupon_amt,cs_sales_price,cs_net_profit,c_birth_year,cd_dep_count]
                          ExpandExecTransformer [cs_quantity,cs_list_price,cs_sales_price,cs_coupon_amt,cs_net_profit,cd_dep_count,c_birth_year,i_item_id,ca_country,ca_state,ca_county]
                            ProjectExecTransformer [cs_quantity,cs_list_price,cs_sales_price,cs_coupon_amt,cs_net_profit,cd_dep_count,c_birth_year,i_item_id,ca_country,ca_state,ca_county]
                              ShuffledHashJoinExecTransformer [cs_bill_customer_sk,c_customer_sk]
                                InputIteratorTransformer
                                  InputAdapter
                                    ColumnarExchange [cs_bill_customer_sk,cs_quantity,cs_list_price,cs_sales_price,cs_coupon_amt,cs_net_profit,cd_dep_count,i_item_id] #2
                                      VeloxResizeBatches
                                        WholeStageCodegenTransformer (5)
                                          ProjectExecTransformer [cs_bill_customer_sk,cs_quantity,cs_list_price,cs_sales_price,cs_coupon_amt,cs_net_profit,cd_dep_count,i_item_id]
                                            BroadcastHashJoinExecTransformer [cs_item_sk,i_item_sk]
                                              ProjectExecTransformer [cs_bill_customer_sk,cs_item_sk,cs_quantity,cs_list_price,cs_sales_price,cs_coupon_amt,cs_net_profit,cd_dep_count]
                                                BroadcastHashJoinExecTransformer [cs_sold_date_sk,d_date_sk]
                                                  ProjectExecTransformer [cs_bill_customer_sk,cs_item_sk,cs_quantity,cs_list_price,cs_sales_price,cs_coupon_amt,cs_net_profit,cs_sold_date_sk,cd_dep_count]
                                                    BroadcastHashJoinExecTransformer [cs_bill_cdemo_sk,cd_demo_sk]
                                                      FilterExecTransformer [cs_bill_cdemo_sk,cs_bill_customer_sk,cs_item_sk]
                                                        FileSourceScanExecTransformer parquet spark_catalog.default.catalog_sales [cs_bill_customer_sk,cs_bill_cdemo_sk,cs_item_sk,cs_quantity,cs_list_price,cs_sales_price,cs_coupon_amt,cs_net_profit,cs_sold_date_sk]
                                                          ColumnarSubqueryBroadcast [d_date_sk] #1
                                                            ColumnarBroadcastExchange #3
                                                              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 #4
                                                            WholeStageCodegenTransformer (2)
                                                              ProjectExecTransformer [cd_demo_sk,cd_dep_count]
                                                                FilterExecTransformer [cd_gender,cd_education_status,cd_demo_sk]
                                                                  FileSourceScanExecTransformer parquet spark_catalog.default.customer_demographics [cd_demo_sk,cd_gender,cd_education_status,cd_dep_count]
                                                  InputIteratorTransformer
                                                    InputAdapter
                                                      ReusedExchange [d_date_sk] #3
                                              InputIteratorTransformer
                                                InputAdapter
                                                  ColumnarBroadcastExchange #5
                                                    WholeStageCodegenTransformer (4)
                                                      FilterExecTransformer [i_item_sk]
                                                        FileSourceScanExecTransformer parquet spark_catalog.default.item [i_item_sk,i_item_id]
                                InputIteratorTransformer
                                  InputAdapter
                                    ColumnarExchange [c_customer_sk,c_birth_year,ca_county,ca_state,ca_country] #6
                                      VeloxResizeBatches
                                        WholeStageCodegenTransformer (9)
                                          ProjectExecTransformer [c_customer_sk,c_birth_year,ca_county,ca_state,ca_country]
                                            ShuffledHashJoinExecTransformer [c_current_cdemo_sk,cd_demo_sk]
                                              InputIteratorTransformer
                                                InputAdapter
                                                  ColumnarExchange [c_current_cdemo_sk,c_customer_sk,c_birth_year,ca_county,ca_state,ca_country] #7
                                                    VeloxResizeBatches
                                                      WholeStageCodegenTransformer (7)
                                                        ProjectExecTransformer [c_current_cdemo_sk,c_customer_sk,c_birth_year,ca_county,ca_state,ca_country]
                                                          BroadcastHashJoinExecTransformer [c_current_addr_sk,ca_address_sk]
                                                            ProjectExecTransformer [c_customer_sk,c_current_cdemo_sk,c_current_addr_sk,c_birth_year]
                                                              FilterExecTransformer [c_birth_month,c_customer_sk,c_current_cdemo_sk,c_current_addr_sk]
                                                                FileSourceScanExecTransformer parquet spark_catalog.default.customer [c_customer_sk,c_current_cdemo_sk,c_current_addr_sk,c_birth_month,c_birth_year]
                                                            InputIteratorTransformer
                                                              InputAdapter
                                                                ColumnarBroadcastExchange #8
                                                                  WholeStageCodegenTransformer (6)
                                                                    FilterExecTransformer [ca_state,ca_address_sk]
                                                                      FileSourceScanExecTransformer parquet spark_catalog.default.customer_address [ca_address_sk,ca_county,ca_state,ca_country]
                                              InputIteratorTransformer
                                                InputAdapter
                                                  ColumnarExchange [cd_demo_sk] #9
                                                    VeloxResizeBatches
                                                      WholeStageCodegenTransformer (8)
                                                        ProjectExecTransformer [cd_demo_sk]
                                                          FilterExecTransformer [cd_demo_sk]
                                                            FileSourceScanExecTransformer parquet spark_catalog.default.customer_demographics [cd_demo_sk]
