VeloxColumnarToRow
  TakeOrderedAndProjectExecTransformer [c_last_name,ss_ticket_number,c_first_name,ca_city,bought_city,extended_price,extended_tax,list_price]
    WholeStageCodegenTransformer (10)
      ProjectExecTransformer [c_last_name,c_first_name,ca_city,bought_city,ss_ticket_number,extended_price,extended_tax,list_price]
        ShuffledHashJoinExecTransformer [c_current_addr_sk,ca_address_sk,ca_city,bought_city]
          InputIteratorTransformer
            InputAdapter
              ColumnarExchange [c_current_addr_sk,ss_ticket_number,bought_city,extended_price,list_price,extended_tax,c_first_name,c_last_name] #1
                VeloxResizeBatches
                  WholeStageCodegenTransformer (8)
                    ProjectExecTransformer [c_current_addr_sk,ss_ticket_number,bought_city,extended_price,list_price,extended_tax,c_first_name,c_last_name]
                      BroadcastHashJoinExecTransformer [ss_customer_sk,c_customer_sk]
                        InputIteratorTransformer
                          InputAdapter
                            ColumnarBroadcastExchange #2
                              WholeStageCodegenTransformer (7)
                                ProjectExecTransformer [ss_ticket_number,ss_customer_sk,ca_city,sum(UnscaledValue(ss_ext_sales_price)),sum(UnscaledValue(ss_ext_list_price)),sum(UnscaledValue(ss_ext_tax))]
                                  RegularHashAggregateExecTransformer [ss_ticket_number,ss_customer_sk,ss_addr_sk,ca_city,sum,sum,sum] [sum(UnscaledValue(ss_ext_sales_price)),sum(UnscaledValue(ss_ext_list_price)),sum(UnscaledValue(ss_ext_tax)),sum,sum,sum]
                                    InputIteratorTransformer
                                      InputAdapter
                                        ColumnarExchange [ss_ticket_number,ss_customer_sk,ss_addr_sk,ca_city,sum,sum,sum] #3
                                          VeloxResizeBatches
                                            WholeStageCodegenTransformer (6)
                                              ProjectExecTransformer [ss_ticket_number,ss_customer_sk,ss_addr_sk,ca_city,sum,sum,sum]
                                                FlushableHashAggregateExecTransformer [ss_ticket_number,ss_customer_sk,ss_addr_sk,ca_city,_pre_x,_pre_x,_pre_x] [sum,sum,sum,sum,sum,sum,sum,sum,sum]
                                                  ProjectExecTransformer [ss_customer_sk,ss_addr_sk,ss_ticket_number,ca_city,ss_ext_sales_price,ss_ext_list_price,ss_ext_tax]
                                                    BroadcastHashJoinExecTransformer [ss_addr_sk,ca_address_sk]
                                                      InputIteratorTransformer
                                                        InputAdapter
                                                          ColumnarBroadcastExchange #4
                                                            WholeStageCodegenTransformer (5)
                                                              ProjectExecTransformer [ss_customer_sk,ss_addr_sk,ss_ticket_number,ss_ext_sales_price,ss_ext_list_price,ss_ext_tax]
                                                                BroadcastHashJoinExecTransformer [ss_hdemo_sk,hd_demo_sk]
                                                                  ProjectExecTransformer [ss_customer_sk,ss_hdemo_sk,ss_addr_sk,ss_ticket_number,ss_ext_sales_price,ss_ext_list_price,ss_ext_tax]
                                                                    BroadcastHashJoinExecTransformer [ss_store_sk,s_store_sk]
                                                                      ProjectExecTransformer [ss_customer_sk,ss_hdemo_sk,ss_addr_sk,ss_store_sk,ss_ticket_number,ss_ext_sales_price,ss_ext_list_price,ss_ext_tax]
                                                                        BroadcastHashJoinExecTransformer [ss_sold_date_sk,d_date_sk]
                                                                          FilterExecTransformer [ss_store_sk,ss_hdemo_sk,ss_addr_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_ext_sales_price,ss_ext_list_price,ss_ext_tax,ss_sold_date_sk]
                                                                              ColumnarSubqueryBroadcast [d_date_sk] #1
                                                                                ColumnarBroadcastExchange #5
                                                                                  WholeStageCodegenTransformer (1)
                                                                                    ProjectExecTransformer [d_date_sk]
                                                                                      FilterExecTransformer [d_dom,d_year,d_date_sk]
                                                                                        FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_date_sk,d_year,d_dom]
                                                                          InputIteratorTransformer
                                                                            InputAdapter
                                                                              ReusedExchange [d_date_sk] #5
                                                                      InputIteratorTransformer
                                                                        InputAdapter
                                                                          ColumnarBroadcastExchange #6
                                                                            WholeStageCodegenTransformer (3)
                                                                              ProjectExecTransformer [s_store_sk]
                                                                                FilterExecTransformer [s_city,s_store_sk]
                                                                                  FileSourceScanExecTransformer parquet spark_catalog.default.store [s_store_sk,s_city]
                                                                  InputIteratorTransformer
                                                                    InputAdapter
                                                                      ColumnarBroadcastExchange #7
                                                                        WholeStageCodegenTransformer (4)
                                                                          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]
                                                      FilterExecTransformer [ca_address_sk,ca_city]
                                                        FileSourceScanExecTransformer parquet spark_catalog.default.customer_address [ca_address_sk,ca_city]
                        FilterExecTransformer [c_customer_sk,c_current_addr_sk]
                          FileSourceScanExecTransformer parquet spark_catalog.default.customer [c_customer_sk,c_current_addr_sk,c_first_name,c_last_name]
          InputIteratorTransformer
            InputAdapter
              ColumnarExchange [ca_address_sk,ca_city] #8
                VeloxResizeBatches
                  WholeStageCodegenTransformer (9)
                    ProjectExecTransformer [ca_address_sk,ca_city]
                      FilterExecTransformer [ca_address_sk,ca_city]
                        FileSourceScanExecTransformer parquet spark_catalog.default.customer_address [ca_address_sk,ca_city]
