-- SINK_WRITE  |PARTITIONED|
  -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
    -- STREAM_PROJECT  |PARTITIONED|
      -- ASSIGN  |PARTITIONED|
        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
          -- PRE_CLUSTERED_GROUP_BY[$$25]  |PARTITIONED|
                  {
                    -- AGGREGATE  |LOCAL|
                      -- MICRO_PRE_CLUSTERED_GROUP_BY[$$23]  |LOCAL|
                              {
                                -- AGGREGATE  |LOCAL|
                                  -- STREAM_SELECT  |LOCAL|
                                    -- NESTED_TUPLE_SOURCE  |LOCAL|
                              }
                        -- STREAM_SELECT  |LOCAL|
                          -- NESTED_TUPLE_SOURCE  |LOCAL|
                  }
            -- ONE_TO_ONE_EXCHANGE  |LOCAL|
              -- STABLE_SORT [$$25(ASC), $$23(ASC)]  |LOCAL|
                -- HASH_PARTITION_EXCHANGE [$$25]  |PARTITIONED|
                  -- STREAM_PROJECT  |PARTITIONED|
                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                      -- HYBRID_HASH_JOIN [$$23][$$20]  |PARTITIONED|
                        -- HASH_PARTITION_EXCHANGE [$$23]  |PARTITIONED|
                          -- STREAM_PROJECT  |PARTITIONED|
                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                              -- HYBRID_HASH_JOIN [$$25][$$26]  |PARTITIONED|
                                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                  -- DATASOURCE_SCAN  |PARTITIONED|
                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                      -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                                -- HASH_PARTITION_EXCHANGE [$$26]  |PARTITIONED|
                                  -- ASSIGN  |PARTITIONED|
                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                      -- DATASOURCE_SCAN  |PARTITIONED|
                                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                          -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                        -- HASH_PARTITION_EXCHANGE [$$20]  |PARTITIONED|
                          -- STREAM_PROJECT  |PARTITIONED|
                            -- ASSIGN  |PARTITIONED|
                              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                -- DATASOURCE_SCAN  |PARTITIONED|
                                  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                    -- EMPTY_TUPLE_SOURCE  |PARTITIONED|