-- SINK_WRITE  |PARTITIONED|
  -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
    -- STREAM_PROJECT  |PARTITIONED|
      -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
        -- UNION_ALL  |PARTITIONED|
          -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
            -- STREAM_PROJECT  |UNPARTITIONED|
              -- ASSIGN  |PARTITIONED|
                -- STREAM_SELECT  |LOCAL|
                  -- ASSIGN  |PARTITIONED|
                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                      -- BTREE_SEARCH  |PARTITIONED|
                        -- ONE_TO_ONE_EXCHANGE  |LOCAL|
                          -- STABLE_SORT [$$27(ASC)]  |LOCAL|
                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                              -- INVERTED_INDEX_SEARCH  |PARTITIONED|
                                -- BROADCAST_EXCHANGE  |PARTITIONED|
                                  -- STREAM_SELECT  |LOCAL|
                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                      -- SPLIT  |PARTITIONED|
                                        -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                                          -- ASSIGN  |UNPARTITIONED|
                                            -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                                              -- DATASOURCE_SCAN  |UNPARTITIONED|
                                                -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                                                  -- EMPTY_TUPLE_SOURCE  |UNPARTITIONED|
          -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
            -- STREAM_PROJECT  |UNPARTITIONED|
              -- ASSIGN  |PARTITIONED|
                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                  -- NESTED_LOOP  |PARTITIONED|
                    -- BROADCAST_EXCHANGE  |PARTITIONED|
                      -- ASSIGN  |UNPARTITIONED|
                        -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                          -- DATASOURCE_SCAN  |UNPARTITIONED|
                            -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                              -- EMPTY_TUPLE_SOURCE  |UNPARTITIONED|
                    -- ONE_TO_ONE_EXCHANGE  |LOCAL|
                      -- STREAM_SELECT  |LOCAL|
                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                          -- SPLIT  |PARTITIONED|
                            -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                              -- ASSIGN  |UNPARTITIONED|
                                -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                                  -- DATASOURCE_SCAN  |UNPARTITIONED|
                                    -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                                      -- EMPTY_TUPLE_SOURCE  |UNPARTITIONED|