VeloxColumnarToRow
  TakeOrderedAndProjectExecTransformer [lochierarchy,_pre_x,i_category,rank_within_parent,total_sum,i_class]
    WholeStageCodegenTransformer (19)
      ProjectExecTransformer [total_sum,i_category,i_class,lochierarchy,rank_within_parent]
        WindowExecTransformer [total_sum,lochierarchy,_w0]
          SortExecTransformer [lochierarchy,_w0,total_sum]
            InputIteratorTransformer
              InputAdapter
                ColumnarExchange [lochierarchy,_w0,total_sum,i_category,i_class] #1
                  VeloxResizeBatches
                    WholeStageCodegenTransformer (18)
                      ProjectExecTransformer [lochierarchy,_w0,total_sum,i_category,i_class]
                        ProjectExecTransformer [total_sum,i_category,i_class,lochierarchy,g_class]
                          FlushableHashAggregateExecTransformer [total_sum,i_category,i_class,g_category,g_class,lochierarchy]
                            InputIteratorTransformer
                              InputAdapter
                                ColumnarExchange [total_sum,i_category,i_class,g_category,g_class,lochierarchy] #2
                                  VeloxResizeBatches
                                    WholeStageCodegenTransformer (17)
                                      ProjectExecTransformer [total_sum,i_category,i_class,g_category,g_class,lochierarchy]
                                        FlushableHashAggregateExecTransformer [total_sum,i_category,i_class,g_category,g_class,lochierarchy]
                                          InputIteratorTransformer
                                            InputAdapter
                                              ColumnarUnion
                                                WholeStageCodegenTransformer (5)
                                                  ProjectExecTransformer [sum(UnscaledValue(ws_net_paid)),i_category,i_class]
                                                    RegularHashAggregateExecTransformer [i_category,i_class,sum] [sum(UnscaledValue(ws_net_paid)),sum]
                                                      InputIteratorTransformer
                                                        InputAdapter
                                                          ColumnarExchange [i_category,i_class,sum] #3
                                                            VeloxResizeBatches
                                                              WholeStageCodegenTransformer (4)
                                                                ProjectExecTransformer [i_category,i_class,sum]
                                                                  FlushableHashAggregateExecTransformer [i_category,i_class,_pre_x] [sum,sum,sum]
                                                                    ProjectExecTransformer [i_class,i_category,ws_net_paid]
                                                                      BroadcastHashJoinExecTransformer [ws_item_sk,i_item_sk]
                                                                        ProjectExecTransformer [ws_item_sk,ws_net_paid]
                                                                          BroadcastHashJoinExecTransformer [ws_sold_date_sk,d_date_sk]
                                                                            FilterExecTransformer [ws_item_sk]
                                                                              FileSourceScanExecTransformer parquet spark_catalog.default.web_sales [ws_item_sk,ws_net_paid,ws_sold_date_sk]
                                                                                ColumnarSubqueryBroadcast [d_date_sk] #1
                                                                                  ColumnarBroadcastExchange #4
                                                                                    WholeStageCodegenTransformer (1)
                                                                                      ProjectExecTransformer [d_date_sk]
                                                                                        FilterExecTransformer [d_month_seq,d_date_sk]
                                                                                          FileSourceScanExecTransformer parquet spark_catalog.default.date_dim [d_date_sk,d_month_seq]
                                                                            InputIteratorTransformer
                                                                              InputAdapter
                                                                                ReusedExchange [d_date_sk] #4
                                                                        InputIteratorTransformer
                                                                          InputAdapter
                                                                            ColumnarBroadcastExchange #5
                                                                              WholeStageCodegenTransformer (3)
                                                                                FilterExecTransformer [i_item_sk]
                                                                                  FileSourceScanExecTransformer parquet spark_catalog.default.item [i_item_sk,i_class,i_category]
                                                WholeStageCodegenTransformer (11)
                                                  ProjectExecTransformer [sum(total_sum),i_category]
                                                    RegularHashAggregateExecTransformer [i_category,sum,isEmpty] [sum(total_sum),sum,isEmpty]
                                                      InputIteratorTransformer
                                                        InputAdapter
                                                          ColumnarExchange [i_category,sum,isEmpty] #6
                                                            VeloxResizeBatches
                                                              WholeStageCodegenTransformer (10)
                                                                ProjectExecTransformer [i_category,sum,isEmpty]
                                                                  FlushableHashAggregateExecTransformer [i_category,total_sum] [sum,isEmpty,sum,isEmpty]
                                                                    ProjectExecTransformer [sum(UnscaledValue(ws_net_paid)),i_category]
                                                                      RegularHashAggregateExecTransformer [i_category,i_class,sum] [sum(UnscaledValue(ws_net_paid)),sum]
                                                                        InputIteratorTransformer
                                                                          InputAdapter
                                                                            ReusedExchange [i_category,i_class,sum] #3
                                                WholeStageCodegenTransformer (16)
                                                  ProjectExecTransformer [sum(total_sum)]
                                                    RegularHashAggregateExecTransformer [total_sum] [sum(total_sum),sum,isEmpty]
                                                      ProjectExecTransformer [sum(UnscaledValue(ws_net_paid))]
                                                        RegularHashAggregateExecTransformer [i_category,i_class,sum] [sum(UnscaledValue(ws_net_paid)),sum]
                                                          InputIteratorTransformer
                                                            InputAdapter
                                                              ReusedExchange [i_category,i_class,sum] #3
