VeloxColumnarToRow
  TakeOrderedAndProjectExecTransformer [cd_gender,cd_marital_status,cd_education_status,cd_purchase_estimate,cd_credit_rating,cnt1,cnt2,cnt3]
    WholeStageCodegenTransformer (16)
      ProjectExecTransformer [cd_gender,cd_marital_status,cd_education_status,count(1),cd_purchase_estimate,cd_credit_rating]
        RegularHashAggregateExecTransformer [cd_gender,cd_marital_status,cd_education_status,cd_purchase_estimate,cd_credit_rating,count] [count(1),count]
          InputIteratorTransformer
            InputAdapter
              ColumnarExchange [cd_gender,cd_marital_status,cd_education_status,cd_purchase_estimate,cd_credit_rating,count] #1
                VeloxResizeBatches
                  WholeStageCodegenTransformer (15)
                    ProjectExecTransformer [cd_gender,cd_marital_status,cd_education_status,cd_purchase_estimate,cd_credit_rating,count]
                      FlushableHashAggregateExecTransformer [cd_gender,cd_marital_status,cd_education_status,cd_purchase_estimate,cd_credit_rating] [count,count]
                        ProjectExecTransformer [cd_gender,cd_marital_status,cd_education_status,cd_purchase_estimate,cd_credit_rating]
                          BroadcastHashJoinExecTransformer [c_current_cdemo_sk,cd_demo_sk]
                            InputIteratorTransformer
                              InputAdapter
                                ColumnarBroadcastExchange #2
                                  WholeStageCodegenTransformer (14)
                                    ProjectExecTransformer [c_current_cdemo_sk]
                                      BroadcastHashJoinExecTransformer [c_current_addr_sk,ca_address_sk]
                                        ProjectExecTransformer [c_current_cdemo_sk,c_current_addr_sk]
                                          ShuffledHashJoinExecTransformer [c_customer_sk,cs_ship_customer_sk]
                                            ShuffledHashJoinExecTransformer [c_customer_sk,ws_bill_customer_sk]
                                              ShuffledHashJoinExecTransformer [c_customer_sk,ss_customer_sk]
                                                InputIteratorTransformer
                                                  InputAdapter
                                                    ColumnarExchange [c_customer_sk,c_current_cdemo_sk,c_current_addr_sk] #3
                                                      VeloxResizeBatches
                                                        WholeStageCodegenTransformer (3)
                                                          ProjectExecTransformer [c_customer_sk,c_current_cdemo_sk,c_current_addr_sk]
                                                            FilterExecTransformer [c_current_addr_sk,c_current_cdemo_sk]
                                                              Subquery #1
                                                                VeloxColumnarToRow
                                                                  WholeStageCodegenTransformer (2)
                                                                    RegularHashAggregateExecTransformer [bloom_filter_agg(xxhash64(ca_address_sk, 42), 55556, 899992, 0, 0),bloomFilter,buf,buf]
                                                                      InputIteratorTransformer
                                                                        InputAdapter
                                                                          ColumnarExchange #4
                                                                            VeloxResizeBatches
                                                                              WholeStageCodegenTransformer (1)
                                                                                FlushableHashAggregateExecTransformer [_pre_x] [buf,buf,buf]
                                                                                  ProjectExecTransformer [ca_address_sk]
                                                                                    FilterExecTransformer [ca_state,ca_address_sk]
                                                                                      FileSourceScanExecTransformer parquet spark_catalog.default.customer_address [ca_address_sk,ca_state]
                                                              FileSourceScanExecTransformer parquet spark_catalog.default.customer [c_customer_sk,c_current_cdemo_sk,c_current_addr_sk]
                                                                Subquery #1
                                                                  VeloxColumnarToRow
                                                                    WholeStageCodegenTransformer (2)
                                                                      RegularHashAggregateExecTransformer [bloom_filter_agg(xxhash64(ca_address_sk, 42), 55556, 899992, 0, 0),bloomFilter,buf,buf]
                                                                        InputIteratorTransformer
                                                                          InputAdapter
                                                                            ColumnarExchange #4
                                                                              VeloxResizeBatches
                                                                                WholeStageCodegenTransformer (1)
                                                                                  FlushableHashAggregateExecTransformer [_pre_x] [buf,buf,buf]
                                                                                    ProjectExecTransformer [ca_address_sk]
                                                                                      FilterExecTransformer [ca_state,ca_address_sk]
                                                                                        FileSourceScanExecTransformer parquet spark_catalog.default.customer_address [ca_address_sk,ca_state]
                                                InputIteratorTransformer
                                                  InputAdapter
                                                    ColumnarExchange [ss_customer_sk] #5
                                                      VeloxResizeBatches
                                                        WholeStageCodegenTransformer (6)
                                                          ProjectExecTransformer [ss_customer_sk]
                                                            BroadcastHashJoinExecTransformer [ss_sold_date_sk,d_date_sk]
                                                              FileSourceScanExecTransformer parquet spark_catalog.default.store_sales [ss_customer_sk,ss_sold_date_sk]
                                                                ColumnarSubqueryBroadcast [d_date_sk] #2
                                                                  ColumnarBroadcastExchange #6
                                                                    WholeStageCodegenTransformer (4)
                                                                      ProjectExecTransformer [d_date_sk]
                                                                        FilterExecTransformer [d_year,d_moy,d_date_sk]
                                                                          FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_date_sk,d_year,d_moy]
                                                              InputIteratorTransformer
                                                                InputAdapter
                                                                  ReusedExchange [d_date_sk] #6
                                              InputIteratorTransformer
                                                InputAdapter
                                                  ColumnarExchange [ws_bill_customer_sk] #7
                                                    VeloxResizeBatches
                                                      WholeStageCodegenTransformer (9)
                                                        ProjectExecTransformer [ws_bill_customer_sk]
                                                          BroadcastHashJoinExecTransformer [ws_sold_date_sk,d_date_sk]
                                                            FileSourceScanExecTransformer parquet spark_catalog.default.web_sales [ws_bill_customer_sk,ws_sold_date_sk]
                                                              ReusedSubquery [d_date_sk] #2
                                                            InputIteratorTransformer
                                                              InputAdapter
                                                                ReusedExchange [d_date_sk] #6
                                            InputIteratorTransformer
                                              InputAdapter
                                                ColumnarExchange [cs_ship_customer_sk] #8
                                                  VeloxResizeBatches
                                                    WholeStageCodegenTransformer (12)
                                                      ProjectExecTransformer [cs_ship_customer_sk]
                                                        BroadcastHashJoinExecTransformer [cs_sold_date_sk,d_date_sk]
                                                          FileSourceScanExecTransformer parquet spark_catalog.default.catalog_sales [cs_ship_customer_sk,cs_sold_date_sk]
                                                            ReusedSubquery [d_date_sk] #2
                                                          InputIteratorTransformer
                                                            InputAdapter
                                                              ReusedExchange [d_date_sk] #6
                                        InputIteratorTransformer
                                          InputAdapter
                                            ColumnarBroadcastExchange #9
                                              WholeStageCodegenTransformer (13)
                                                ProjectExecTransformer [ca_address_sk]
                                                  FilterExecTransformer [ca_state,ca_address_sk]
                                                    FileSourceScanExecTransformer parquet spark_catalog.default.customer_address [ca_address_sk,ca_state]
                            FilterExecTransformer [cd_demo_sk]
                              FileSourceScanExecTransformer parquet spark_catalog.default.customer_demographics [cd_demo_sk,cd_gender,cd_marital_status,cd_education_status,cd_purchase_estimate,cd_credit_rating]
