VeloxColumnarToRow
  TakeOrderedAndProjectExecTransformer [c_last_name,c_first_name,_pre_x,s_city,profit,substr(s_city, 1, 30),ss_ticket_number,amt]
    WholeStageCodegenTransformer (8)
      ProjectExecTransformer [c_last_name,c_first_name,s_city,ss_ticket_number,amt,profit]
        ShuffledHashJoinExecTransformer [ss_customer_sk,c_customer_sk]
          InputIteratorTransformer
            InputAdapter
              ColumnarExchange [ss_customer_sk,ss_ticket_number,s_city,amt,profit] #1
                VeloxResizeBatches
                  WholeStageCodegenTransformer (6)
                    ProjectExecTransformer [ss_customer_sk,ss_ticket_number,s_city,sum(UnscaledValue(ss_coupon_amt)),sum(UnscaledValue(ss_net_profit))]
                      RegularHashAggregateExecTransformer [ss_ticket_number,ss_customer_sk,ss_addr_sk,s_city,sum,sum] [sum(UnscaledValue(ss_coupon_amt)),sum(UnscaledValue(ss_net_profit)),sum,sum]
                        InputIteratorTransformer
                          InputAdapter
                            ColumnarExchange [ss_ticket_number,ss_customer_sk,ss_addr_sk,s_city,sum,sum] #2
                              VeloxResizeBatches
                                WholeStageCodegenTransformer (5)
                                  ProjectExecTransformer [ss_ticket_number,ss_customer_sk,ss_addr_sk,s_city,sum,sum]
                                    FlushableHashAggregateExecTransformer [ss_ticket_number,ss_customer_sk,ss_addr_sk,s_city,_pre_x,_pre_x] [sum,sum,sum,sum,sum,sum]
                                      ProjectExecTransformer [ss_customer_sk,ss_addr_sk,ss_ticket_number,s_city,ss_coupon_amt,ss_net_profit]
                                        BroadcastHashJoinExecTransformer [ss_store_sk,s_store_sk]
                                          ProjectExecTransformer [ss_customer_sk,ss_addr_sk,ss_store_sk,ss_ticket_number,ss_coupon_amt,ss_net_profit]
                                            BroadcastHashJoinExecTransformer [ss_hdemo_sk,hd_demo_sk]
                                              ProjectExecTransformer [ss_customer_sk,ss_hdemo_sk,ss_addr_sk,ss_store_sk,ss_ticket_number,ss_coupon_amt,ss_net_profit]
                                                BroadcastHashJoinExecTransformer [ss_sold_date_sk,d_date_sk]
                                                  FilterExecTransformer [ss_store_sk,ss_hdemo_sk,ss_customer_sk]
                                                    FileSourceScanExecTransformer parquet spark_catalog.default.store_sales [ss_customer_sk,ss_hdemo_sk,ss_addr_sk,ss_store_sk,ss_ticket_number,ss_coupon_amt,ss_net_profit,ss_sold_date_sk]
                                                      ColumnarSubqueryBroadcast [d_date_sk] #1
                                                        ColumnarBroadcastExchange #3
                                                          WholeStageCodegenTransformer (1)
                                                            ProjectExecTransformer [d_date_sk]
                                                              FilterExecTransformer [d_dow,d_year,d_date_sk]
                                                                FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_date_sk,d_year,d_dow]
                                                  InputIteratorTransformer
                                                    InputAdapter
                                                      ReusedExchange [d_date_sk] #3
                                              InputIteratorTransformer
                                                InputAdapter
                                                  ColumnarBroadcastExchange #4
                                                    WholeStageCodegenTransformer (3)
                                                      ProjectExecTransformer [hd_demo_sk]
                                                        FilterExecTransformer [hd_dep_count,hd_vehicle_count,hd_demo_sk]
                                                          FileSourceScanExecTransformer parquet spark_catalog.default.household_demographics [hd_demo_sk,hd_dep_count,hd_vehicle_count]
                                          InputIteratorTransformer
                                            InputAdapter
                                              ColumnarBroadcastExchange #5
                                                WholeStageCodegenTransformer (4)
                                                  ProjectExecTransformer [s_store_sk,s_city]
                                                    FilterExecTransformer [s_number_employees,s_store_sk]
                                                      FileSourceScanExecTransformer parquet spark_catalog.default.store [s_store_sk,s_number_employees,s_city]
          InputIteratorTransformer
            InputAdapter
              ColumnarExchange [c_customer_sk,c_first_name,c_last_name] #6
                VeloxResizeBatches
                  WholeStageCodegenTransformer (7)
                    ProjectExecTransformer [c_customer_sk,c_first_name,c_last_name]
                      FilterExecTransformer [c_customer_sk]
                        FileSourceScanExecTransformer parquet spark_catalog.default.customer [c_customer_sk,c_first_name,c_last_name]
