-- SINK_WRITE  |PARTITIONED|
  -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
    -- STREAM_PROJECT  |PARTITIONED|
      -- ASSIGN  |PARTITIONED|
        -- STREAM_PROJECT  |PARTITIONED|
          -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
            -- PRE_CLUSTERED_GROUP_BY[$$23]  |PARTITIONED|
                    {
                      -- AGGREGATE  |LOCAL|
                        -- STREAM_SELECT  |LOCAL|
                          -- NESTED_TUPLE_SOURCE  |LOCAL|
                    }
              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                -- STABLE_SORT [$$23(ASC), $$6(ASC)]  |PARTITIONED|
                  -- HASH_PARTITION_EXCHANGE [$$23]  |PARTITIONED|
                    -- STREAM_PROJECT  |PARTITIONED|
                      -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                        -- HYBRID_HASH_JOIN [$$1][$$6]  |PARTITIONED|
                          -- HASH_PARTITION_EXCHANGE [$$1]  |PARTITIONED|
                            -- STREAM_PROJECT  |PARTITIONED|
                              -- UNNEST  |PARTITIONED|
                                -- STREAM_PROJECT  |PARTITIONED|
                                  -- ASSIGN  |PARTITIONED|
                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                      -- DATASOURCE_SCAN  |PARTITIONED|
                                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                          -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                          -- HASH_PARTITION_EXCHANGE [$$6]  |PARTITIONED|
                            -- RUNNING_AGGREGATE  |PARTITIONED|
                              -- STREAM_PROJECT  |PARTITIONED|
                                -- SORT_MERGE_EXCHANGE [$$24(DESC) ]  |PARTITIONED|
                                  -- STABLE_SORT [$$24(DESC)]  |PARTITIONED|
                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                      -- PRE_CLUSTERED_GROUP_BY[$$30]  |PARTITIONED|
                                              {
                                                -- AGGREGATE  |LOCAL|
                                                  -- NESTED_TUPLE_SOURCE  |LOCAL|
                                              }
                                        -- HASH_PARTITION_MERGE_EXCHANGE MERGE:[$$30(ASC)] HASH:[$$30]  |PARTITIONED|
                                          -- PRE_CLUSTERED_GROUP_BY[$$5]  |PARTITIONED|
                                                  {
                                                    -- AGGREGATE  |LOCAL|
                                                      -- NESTED_TUPLE_SOURCE  |LOCAL|
                                                  }
                                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                              -- STABLE_SORT [$$5(ASC)]  |PARTITIONED|
                                                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                  -- STREAM_PROJECT  |PARTITIONED|
                                                    -- UNNEST  |PARTITIONED|
                                                      -- STREAM_PROJECT  |PARTITIONED|
                                                        -- ASSIGN  |PARTITIONED|
                                                          -- STREAM_PROJECT  |PARTITIONED|
                                                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                              -- DATASOURCE_SCAN  |PARTITIONED|
                                                                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                  -- EMPTY_TUPLE_SOURCE  |PARTITIONED|