VeloxColumnarToRow
  TakeOrderedAndProjectExecTransformer [segment,num_customers,segment_base]
    WholeStageCodegenTransformer (32)
      ProjectExecTransformer [segment,count(1)]
        RegularHashAggregateExecTransformer [segment,count] [count(1),count]
          InputIteratorTransformer
            InputAdapter
              ColumnarExchange [segment,count] #1
                VeloxResizeBatches
                  WholeStageCodegenTransformer (31)
                    ProjectExecTransformer [segment,count]
                      FlushableHashAggregateExecTransformer [segment] [count,count]
                        ProjectExecTransformer [sum(UnscaledValue(ss_ext_sales_price))]
                          RegularHashAggregateExecTransformer [c_customer_sk,sum] [sum(UnscaledValue(ss_ext_sales_price)),sum]
                            InputIteratorTransformer
                              InputAdapter
                                ColumnarExchange [c_customer_sk,sum] #2
                                  VeloxResizeBatches
                                    WholeStageCodegenTransformer (30)
                                      ProjectExecTransformer [c_customer_sk,sum]
                                        FlushableHashAggregateExecTransformer [c_customer_sk,_pre_x] [sum,sum,sum]
                                          ProjectExecTransformer [c_customer_sk,ss_ext_sales_price]
                                            BroadcastHashJoinExecTransformer [ss_sold_date_sk,d_date_sk]
                                              ProjectExecTransformer [c_customer_sk,ss_ext_sales_price,ss_sold_date_sk]
                                                BroadcastHashJoinExecTransformer [ca_county,ca_state,s_county,s_state]
                                                  ProjectExecTransformer [c_customer_sk,ss_ext_sales_price,ss_sold_date_sk,ca_county,ca_state]
                                                    BroadcastHashJoinExecTransformer [c_current_addr_sk,ca_address_sk]
                                                      ProjectExecTransformer [c_customer_sk,c_current_addr_sk,ss_ext_sales_price,ss_sold_date_sk]
                                                        BroadcastHashJoinExecTransformer [c_customer_sk,ss_customer_sk]
                                                          RegularHashAggregateExecTransformer [c_customer_sk,c_current_addr_sk]
                                                            InputIteratorTransformer
                                                              InputAdapter
                                                                ColumnarExchange [c_customer_sk,c_current_addr_sk] #3
                                                                  VeloxResizeBatches
                                                                    WholeStageCodegenTransformer (8)
                                                                      ProjectExecTransformer [c_customer_sk,c_current_addr_sk]
                                                                        FlushableHashAggregateExecTransformer [c_customer_sk,c_current_addr_sk]
                                                                          ProjectExecTransformer [c_customer_sk,c_current_addr_sk]
                                                                            BroadcastHashJoinExecTransformer [customer_sk,c_customer_sk]
                                                                              ProjectExecTransformer [customer_sk]
                                                                                BroadcastHashJoinExecTransformer [sold_date_sk,d_date_sk]
                                                                                  ProjectExecTransformer [sold_date_sk,customer_sk]
                                                                                    BroadcastHashJoinExecTransformer [item_sk,i_item_sk]
                                                                                      InputIteratorTransformer
                                                                                        InputAdapter
                                                                                          ColumnarUnion
                                                                                            WholeStageCodegenTransformer (2)
                                                                                              ProjectExecTransformer [cs_sold_date_sk,cs_bill_customer_sk,cs_item_sk]
                                                                                                FilterExecTransformer [cs_item_sk,cs_bill_customer_sk]
                                                                                                  FileSourceScanExecTransformer parquet spark_catalog.default.catalog_sales [cs_bill_customer_sk,cs_item_sk,cs_sold_date_sk]
                                                                                                    ColumnarSubqueryBroadcast [d_date_sk] #1
                                                                                                      ColumnarBroadcastExchange #4
                                                                                                        WholeStageCodegenTransformer (1)
                                                                                                          ProjectExecTransformer [d_date_sk]
                                                                                                            FilterExecTransformer [d_moy,d_year,d_date_sk]
                                                                                                              FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_date_sk,d_year,d_moy]
                                                                                            WholeStageCodegenTransformer (4)
                                                                                              ProjectExecTransformer [ws_sold_date_sk,ws_bill_customer_sk,ws_item_sk]
                                                                                                FilterExecTransformer [ws_item_sk,ws_bill_customer_sk]
                                                                                                  FileSourceScanExecTransformer parquet spark_catalog.default.web_sales [ws_item_sk,ws_bill_customer_sk,ws_sold_date_sk]
                                                                                                    ReusedSubquery [d_date_sk] #1
                                                                                      InputIteratorTransformer
                                                                                        InputAdapter
                                                                                          ColumnarBroadcastExchange #5
                                                                                            WholeStageCodegenTransformer (5)
                                                                                              ProjectExecTransformer [i_item_sk]
                                                                                                FilterExecTransformer [i_category,i_class,i_item_sk]
                                                                                                  FileSourceScanExecTransformer parquet spark_catalog.default.item [i_item_sk,i_class,i_category]
                                                                                  InputIteratorTransformer
                                                                                    InputAdapter
                                                                                      ReusedExchange [d_date_sk] #4
                                                                              InputIteratorTransformer
                                                                                InputAdapter
                                                                                  ColumnarBroadcastExchange #6
                                                                                    WholeStageCodegenTransformer (7)
                                                                                      FilterExecTransformer [c_customer_sk,c_current_addr_sk]
                                                                                        FileSourceScanExecTransformer parquet spark_catalog.default.customer [c_customer_sk,c_current_addr_sk]
                                                          InputIteratorTransformer
                                                            InputAdapter
                                                              ColumnarBroadcastExchange #7
                                                                WholeStageCodegenTransformer (18)
                                                                  FilterExecTransformer [ss_customer_sk]
                                                                    FileSourceScanExecTransformer parquet spark_catalog.default.store_sales [ss_customer_sk,ss_ext_sales_price,ss_sold_date_sk]
                                                                      ColumnarSubqueryBroadcast [d_date_sk] #2
                                                                        ColumnarBroadcastExchange #8
                                                                          WholeStageCodegenTransformer (17)
                                                                            ProjectExecTransformer [d_date_sk]
                                                                              FilterExecTransformer [d_month_seq,d_date_sk]
                                                                                ReusedSubquery [(d_month_seq + 1)] #3
                                                                                ReusedSubquery [(d_month_seq + 3)] #4
                                                                                FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_date_sk,d_month_seq]
                                                                                  Subquery #3
                                                                                    VeloxColumnarToRow
                                                                                      WholeStageCodegenTransformer (14)
                                                                                        RegularHashAggregateExecTransformer [(d_month_seq + 1)]
                                                                                          InputIteratorTransformer
                                                                                            InputAdapter
                                                                                              ColumnarExchange [(d_month_seq + 1)] #9
                                                                                                VeloxResizeBatches
                                                                                                  WholeStageCodegenTransformer (13)
                                                                                                    ProjectExecTransformer [(d_month_seq + 1)]
                                                                                                      FlushableHashAggregateExecTransformer [(d_month_seq + 1)]
                                                                                                        ProjectExecTransformer [d_month_seq]
                                                                                                          FilterExecTransformer [d_year,d_moy]
                                                                                                            FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_month_seq,d_year,d_moy]
                                                                                  Subquery #4
                                                                                    VeloxColumnarToRow
                                                                                      WholeStageCodegenTransformer (16)
                                                                                        RegularHashAggregateExecTransformer [(d_month_seq + 3)]
                                                                                          InputIteratorTransformer
                                                                                            InputAdapter
                                                                                              ColumnarExchange [(d_month_seq + 3)] #10
                                                                                                VeloxResizeBatches
                                                                                                  WholeStageCodegenTransformer (15)
                                                                                                    ProjectExecTransformer [(d_month_seq + 3)]
                                                                                                      FlushableHashAggregateExecTransformer [(d_month_seq + 3)]
                                                                                                        ProjectExecTransformer [d_month_seq]
                                                                                                          FilterExecTransformer [d_year,d_moy]
                                                                                                            FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_month_seq,d_year,d_moy]
                                                                                  ReusedSubquery [(d_month_seq + 1)] #3
                                                                                  ReusedSubquery [(d_month_seq + 3)] #4
                                                      InputIteratorTransformer
                                                        InputAdapter
                                                          ColumnarBroadcastExchange #11
                                                            WholeStageCodegenTransformer (19)
                                                              FilterExecTransformer [ca_address_sk,ca_county,ca_state]
                                                                FileSourceScanExecTransformer parquet spark_catalog.default.customer_address [ca_address_sk,ca_county,ca_state]
                                                  InputIteratorTransformer
                                                    InputAdapter
                                                      ColumnarBroadcastExchange #12
                                                        WholeStageCodegenTransformer (20)
                                                          FilterExecTransformer [s_county,s_state]
                                                            FileSourceScanExecTransformer parquet spark_catalog.default.store [s_county,s_state]
                                              InputIteratorTransformer
                                                InputAdapter
                                                  ReusedExchange [d_date_sk] #8
