asterix-app/src/test/resources/optimizerts/results/query-issue827-2.plan

-- DISTRIBUTE_RESULT  |PARTITIONED|
  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
    -- STREAM_PROJECT  |PARTITIONED|
      -- ASSIGN  |PARTITIONED|
        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
          -- NESTED_LOOP  |PARTITIONED|
            -- BROADCAST_EXCHANGE  |PARTITIONED|
              -- NESTED_LOOP  |PARTITIONED|
                -- BROADCAST_EXCHANGE  |PARTITIONED|
                  -- NESTED_LOOP  |PARTITIONED|
                    -- BROADCAST_EXCHANGE  |PARTITIONED|
                      -- NESTED_LOOP  |PARTITIONED|
                        -- BROADCAST_EXCHANGE  |PARTITIONED|
                          -- NESTED_LOOP  |PARTITIONED|
                            -- BROADCAST_EXCHANGE  |PARTITIONED|
                              -- NESTED_LOOP  |PARTITIONED|
                                -- BROADCAST_EXCHANGE  |PARTITIONED|
                                  -- AGGREGATE  |UNPARTITIONED|
                                    -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
                                      -- AGGREGATE  |PARTITIONED|
                                        -- STREAM_PROJECT  |PARTITIONED|
                                          -- STREAM_SELECT  |PARTITIONED|
                                            -- ASSIGN  |PARTITIONED|
                                              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                -- SPLIT  |PARTITIONED|
                                                  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                    -- STREAM_PROJECT  |PARTITIONED|
                                                      -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                        -- DATASOURCE_SCAN  |PARTITIONED|
                                                          -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                            -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                                -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                                  -- AGGREGATE  |UNPARTITIONED|
                                    -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
                                      -- AGGREGATE  |PARTITIONED|
                                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                          -- SPLIT  |PARTITIONED|
                                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                              -- STREAM_PROJECT  |PARTITIONED|
                                                -- ASSIGN  |PARTITIONED|
                                                  -- STREAM_PROJECT  |PARTITIONED|
                                                    -- ASSIGN  |PARTITIONED|
                                                      -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                        -- SPLIT  |PARTITIONED|
                                                          -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                            -- STREAM_PROJECT  |PARTITIONED|
                                                              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                -- DATASOURCE_SCAN  |PARTITIONED|
                                                                  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                                    -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                            -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                              -- AGGREGATE  |UNPARTITIONED|
                                -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
                                  -- AGGREGATE  |PARTITIONED|
                                    -- STREAM_PROJECT  |PARTITIONED|
                                      -- ASSIGN  |PARTITIONED|
                                        -- STREAM_PROJECT  |PARTITIONED|
                                          -- ASSIGN  |PARTITIONED|
                                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                              -- SPLIT  |PARTITIONED|
                                                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                  -- STREAM_PROJECT  |PARTITIONED|
                                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                      -- DATASOURCE_SCAN  |PARTITIONED|
                                                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                          -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                        -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                          -- AGGREGATE  |UNPARTITIONED|
                            -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
                              -- AGGREGATE  |PARTITIONED|
                                -- STREAM_PROJECT  |PARTITIONED|
                                  -- ASSIGN  |PARTITIONED|
                                    -- STREAM_PROJECT  |PARTITIONED|
                                      -- ASSIGN  |PARTITIONED|
                                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                          -- SPLIT  |PARTITIONED|
                                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                              -- STREAM_PROJECT  |PARTITIONED|
                                                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                  -- DATASOURCE_SCAN  |PARTITIONED|
                                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                      -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                    -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                      -- AGGREGATE  |UNPARTITIONED|
                        -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
                          -- AGGREGATE  |PARTITIONED|
                            -- STREAM_PROJECT  |PARTITIONED|
                              -- ASSIGN  |PARTITIONED|
                                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                  -- SPLIT  |PARTITIONED|
                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                      -- STREAM_PROJECT  |PARTITIONED|
                                        -- ASSIGN  |PARTITIONED|
                                          -- STREAM_PROJECT  |PARTITIONED|
                                            -- ASSIGN  |PARTITIONED|
                                              -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                -- SPLIT  |PARTITIONED|
                                                  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                    -- STREAM_PROJECT  |PARTITIONED|
                                                      -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                        -- DATASOURCE_SCAN  |PARTITIONED|
                                                          -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                                            -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
                -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
                  -- AGGREGATE  |UNPARTITIONED|
                    -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
                      -- AGGREGATE  |PARTITIONED|
                        -- STREAM_PROJECT  |PARTITIONED|
                          -- ASSIGN  |PARTITIONED|
                            -- STREAM_PROJECT  |PARTITIONED|
                              -- ASSIGN  |PARTITIONED|
                                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                  -- SPLIT  |PARTITIONED|
                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                      -- STREAM_PROJECT  |PARTITIONED|
                                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                          -- DATASOURCE_SCAN  |PARTITIONED|
                                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                              -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
            -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
              -- AGGREGATE  |UNPARTITIONED|
                -- RANDOM_MERGE_EXCHANGE  |PARTITIONED|
                  -- AGGREGATE  |PARTITIONED|
                    -- STREAM_PROJECT  |PARTITIONED|
                      -- ASSIGN  |PARTITIONED|
                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                          -- SPLIT  |PARTITIONED|
                            -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                              -- STREAM_PROJECT  |PARTITIONED|
                                -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                  -- DATASOURCE_SCAN  |PARTITIONED|
                                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                                      -- EMPTY_TUPLE_SOURCE  |PARTITIONED|