asterix-app/src/test/resources/optimizerts/results/query-ASTERIXDB-1263.plan

-- DISTRIBUTE_RESULT  |PARTITIONED|
  -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
    -- STREAM_PROJECT  |PARTITIONED|
      -- ASSIGN  |PARTITIONED|
        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
          -- PRE_CLUSTERED_GROUP_BY[$$27]  |PARTITIONED|
                  {
                    -- AGGREGATE  |LOCAL|
                      -- NESTED_TUPLE_SOURCE  |LOCAL|
                  }
                  {
                    -- AGGREGATE  |LOCAL|
                      -- MICRO_PRE_CLUSTERED_GROUP_BY[$$19]  |LOCAL|
                              {
                                -- AGGREGATE  |LOCAL|
                                  -- NESTED_TUPLE_SOURCE  |LOCAL|
                              }
                        -- IN_MEMORY_STABLE_SORT [$$19(ASC)]  |LOCAL|
                          -- ASSIGN  |LOCAL|
                            -- NESTED_TUPLE_SOURCE  |LOCAL|
                  }
            -- HASH_PARTITION_MERGE_EXCHANGE MERGE:[$$27(ASC), $$28(ASC)] HASH:[$$27]  |PARTITIONED|
              -- SORT_GROUP_BY[$$18, $$24]  |PARTITIONED|
                      {
                        -- AGGREGATE  |LOCAL|
                          -- NESTED_TUPLE_SOURCE  |LOCAL|
                      }
                -- ONE_TO_ONE_EXCHANGE  |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|