-- DISTRIBUTE_RESULT  |UNPARTITIONED|
  -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
    -- STREAM_PROJECT  |UNPARTITIONED|
      -- ASSIGN  |UNPARTITIONED|
        -- AGGREGATE  |UNPARTITIONED|
          -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
            -- AGGREGATE  |PARTITIONED|
              -- STREAM_SELECT  |PARTITIONED|
                -- STREAM_PROJECT  |PARTITIONED|
                  -- ASSIGN  |PARTITIONED|
                    -- STREAM_PROJECT  |PARTITIONED|
                      -- UNNEST  |PARTITIONED|
                        -- STREAM_PROJECT  |PARTITIONED|
                          -- ASSIGN  |PARTITIONED|
                            -- STREAM_PROJECT  |PARTITIONED|
                              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                -- BTREE_SEARCH (test.orders.orders)  |PARTITIONED|
                                  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                    -- PRE_SORTED_DISTINCT_BY  |PARTITIONED|
                                      -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                        -- STABLE_SORT [$$56(ASC)]  |PARTITIONED|
                                          -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                            -- STREAM_PROJECT  |PARTITIONED|
                                              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                -- BTREE_SEARCH (test.orders.orderline_delivery_d)  |PARTITIONED|
                                                  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                    -- ASSIGN  |PARTITIONED|
                                                      -- EMPTY_TUPLE_SOURCE  |PARTITIONED|