VeloxColumnarToRow
  TakeOrderedAndProjectExecTransformer [total_cnt,i_item_desc,w_warehouse_name,d_week_seq,no_promo,promo]
    WholeStageCodegenTransformer (17)
      ProjectExecTransformer [i_item_desc,w_warehouse_name,d_week_seq,count(1)]
        RegularHashAggregateExecTransformer [i_item_desc,w_warehouse_name,d_week_seq,count] [count(1),count]
          InputIteratorTransformer
            InputAdapter
              ColumnarExchange [i_item_desc,w_warehouse_name,d_week_seq,count] #1
                VeloxResizeBatches
                  WholeStageCodegenTransformer (16)
                    ProjectExecTransformer [i_item_desc,w_warehouse_name,d_week_seq,count]
                      FlushableHashAggregateExecTransformer [i_item_desc,w_warehouse_name,d_week_seq] [count,count]
                        ProjectExecTransformer [w_warehouse_name,i_item_desc,d_week_seq]
                          ShuffledHashJoinExecTransformer [cs_item_sk,cs_order_number,cr_item_sk,cr_order_number]
                            InputIteratorTransformer
                              InputAdapter
                                ColumnarExchange [cs_item_sk,cs_order_number,w_warehouse_name,i_item_desc,d_week_seq] #2
                                  VeloxResizeBatches
                                    WholeStageCodegenTransformer (14)
                                      ProjectExecTransformer [cs_item_sk,cs_order_number,w_warehouse_name,i_item_desc,d_week_seq]
                                        BroadcastHashJoinExecTransformer [cs_promo_sk,p_promo_sk]
                                          ProjectExecTransformer [cs_item_sk,cs_promo_sk,cs_order_number,w_warehouse_name,i_item_desc,d_week_seq]
                                            ShuffledHashJoinExecTransformer [cs_item_sk,d_date_sk,inv_item_sk,inv_date_sk,inv_quantity_on_hand,cs_quantity]
                                              InputIteratorTransformer
                                                InputAdapter
                                                  ColumnarExchange [cs_item_sk,d_date_sk,cs_promo_sk,cs_order_number,cs_quantity,i_item_desc,d_week_seq] #3
                                                    VeloxResizeBatches
                                                      WholeStageCodegenTransformer (10)
                                                        ProjectExecTransformer [cs_item_sk,d_date_sk,cs_promo_sk,cs_order_number,cs_quantity,i_item_desc,d_week_seq]
                                                          BroadcastHashJoinExecTransformer [cs_sold_date_sk,d_date_sk,d_date,d_date]
                                                            ProjectExecTransformer [cs_item_sk,cs_promo_sk,cs_order_number,cs_quantity,cs_sold_date_sk,d_date,i_item_desc]
                                                              ShuffledHashJoinExecTransformer [cs_item_sk,i_item_sk]
                                                                InputIteratorTransformer
                                                                  InputAdapter
                                                                    ColumnarExchange [cs_item_sk,cs_promo_sk,cs_order_number,cs_quantity,cs_sold_date_sk,d_date] #4
                                                                      VeloxResizeBatches
                                                                        WholeStageCodegenTransformer (6)
                                                                          ProjectExecTransformer [cs_item_sk,cs_promo_sk,cs_order_number,cs_quantity,cs_sold_date_sk,d_date]
                                                                            BroadcastHashJoinExecTransformer [cs_ship_date_sk,d_date_sk]
                                                                              ProjectExecTransformer [cs_ship_date_sk,cs_item_sk,cs_promo_sk,cs_order_number,cs_quantity,cs_sold_date_sk]
                                                                                BroadcastHashJoinExecTransformer [cs_bill_cdemo_sk,cd_demo_sk]
                                                                                  ProjectExecTransformer [cs_ship_date_sk,cs_bill_cdemo_sk,cs_item_sk,cs_promo_sk,cs_order_number,cs_quantity,cs_sold_date_sk]
                                                                                    BroadcastHashJoinExecTransformer [cs_bill_hdemo_sk,hd_demo_sk]
                                                                                      FilterExecTransformer [cs_quantity,cs_item_sk,cs_bill_cdemo_sk,cs_bill_hdemo_sk,cs_ship_date_sk]
                                                                                        FileSourceScanExecTransformer parquet spark_catalog.default.catalog_sales [cs_ship_date_sk,cs_bill_cdemo_sk,cs_bill_hdemo_sk,cs_item_sk,cs_promo_sk,cs_order_number,cs_quantity,cs_sold_date_sk]
                                                                                          ColumnarSubqueryBroadcast [d_date_sk] #1
                                                                                            ColumnarBroadcastExchange #5
                                                                                              WholeStageCodegenTransformer (2)
                                                                                                ProjectExecTransformer [d_date_sk,d_date,d_week_seq,d_date_sk]
                                                                                                  BroadcastHashJoinExecTransformer [d_week_seq,d_week_seq]
                                                                                                    InputIteratorTransformer
                                                                                                      InputAdapter
                                                                                                        ColumnarBroadcastExchange #6
                                                                                                          WholeStageCodegenTransformer (1)
                                                                                                            ProjectExecTransformer [d_date_sk,d_date,d_week_seq]
                                                                                                              FilterExecTransformer [d_year,d_date_sk,d_week_seq,d_date]
                                                                                                                FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_date_sk,d_date,d_week_seq,d_year]
                                                                                                    FilterExecTransformer [d_week_seq,d_date_sk]
                                                                                                      FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_date_sk,d_week_seq]
                                                                                      InputIteratorTransformer
                                                                                        InputAdapter
                                                                                          ColumnarBroadcastExchange #7
                                                                                            WholeStageCodegenTransformer (3)
                                                                                              ProjectExecTransformer [hd_demo_sk]
                                                                                                FilterExecTransformer [hd_buy_potential,hd_demo_sk]
                                                                                                  FileSourceScanExecTransformer parquet spark_catalog.default.household_demographics [hd_demo_sk,hd_buy_potential]
                                                                                  InputIteratorTransformer
                                                                                    InputAdapter
                                                                                      ColumnarBroadcastExchange #8
                                                                                        WholeStageCodegenTransformer (4)
                                                                                          ProjectExecTransformer [cd_demo_sk]
                                                                                            FilterExecTransformer [cd_marital_status,cd_demo_sk]
                                                                                              FileSourceScanExecTransformer parquet spark_catalog.default.customer_demographics [cd_demo_sk,cd_marital_status]
                                                                              InputIteratorTransformer
                                                                                InputAdapter
                                                                                  ColumnarBroadcastExchange #9
                                                                                    WholeStageCodegenTransformer (5)
                                                                                      FilterExecTransformer [d_date,d_date_sk]
                                                                                        FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_date_sk,d_date]
                                                                InputIteratorTransformer
                                                                  InputAdapter
                                                                    ColumnarExchange [i_item_sk,i_item_desc] #10
                                                                      VeloxResizeBatches
                                                                        WholeStageCodegenTransformer (7)
                                                                          ProjectExecTransformer [i_item_sk,i_item_desc]
                                                                            FilterExecTransformer [i_item_sk]
                                                                              FileSourceScanExecTransformer parquet spark_catalog.default.item [i_item_sk,i_item_desc]
                                                            InputIteratorTransformer
                                                              InputAdapter
                                                                ReusedExchange [d_date_sk,d_date,d_week_seq,d_date_sk] #5
                                              InputIteratorTransformer
                                                InputAdapter
                                                  ColumnarExchange [inv_item_sk,inv_date_sk,inv_quantity_on_hand,w_warehouse_name] #11
                                                    VeloxResizeBatches
                                                      WholeStageCodegenTransformer (12)
                                                        ProjectExecTransformer [inv_item_sk,inv_date_sk,inv_quantity_on_hand,w_warehouse_name]
                                                          BroadcastHashJoinExecTransformer [inv_warehouse_sk,w_warehouse_sk]
                                                            FilterExecTransformer [inv_quantity_on_hand,inv_item_sk,inv_warehouse_sk]
                                                              FileSourceScanExecTransformer parquet spark_catalog.default.inventory [inv_item_sk,inv_warehouse_sk,inv_quantity_on_hand,inv_date_sk]
                                                            InputIteratorTransformer
                                                              InputAdapter
                                                                ColumnarBroadcastExchange #12
                                                                  WholeStageCodegenTransformer (11)
                                                                    FilterExecTransformer [w_warehouse_sk]
                                                                      FileSourceScanExecTransformer parquet spark_catalog.default.warehouse [w_warehouse_sk,w_warehouse_name]
                                          InputIteratorTransformer
                                            InputAdapter
                                              ColumnarBroadcastExchange #13
                                                WholeStageCodegenTransformer (13)
                                                  FilterExecTransformer [p_promo_sk]
                                                    FileSourceScanExecTransformer parquet spark_catalog.default.promotion [p_promo_sk]
                            InputIteratorTransformer
                              InputAdapter
                                ColumnarExchange [cr_item_sk,cr_order_number] #14
                                  VeloxResizeBatches
                                    WholeStageCodegenTransformer (15)
                                      ProjectExecTransformer [cr_item_sk,cr_order_number]
                                        FilterExecTransformer [cr_item_sk,cr_order_number]
                                          FileSourceScanExecTransformer parquet spark_catalog.default.catalog_returns [cr_item_sk,cr_order_number,cr_returned_date_sk]
