distribute result [$$75] [cardinality: 1000000.0, op-cost: 0.0, total-cost: 1000000.0]
-- DISTRIBUTE_RESULT  |UNPARTITIONED|
  exchange [cardinality: 1000000.0, op-cost: 0.0, total-cost: 1000000.0]
  -- ONE_TO_ONE_EXCHANGE  |UNPARTITIONED|
    limit 5 offset 5 [cardinality: 1000000.0, op-cost: 0.0, total-cost: 1000000.0]
    -- STREAM_LIMIT  |UNPARTITIONED|
      project ([$$75]) [cardinality: 1000000.0, op-cost: 0.0, total-cost: 1000000.0]
      -- STREAM_PROJECT  |PARTITIONED|
        assign [$$75] <- [get-item($$73, 0)] [cardinality: 1000000.0, op-cost: 0.0, total-cost: 1000000.0]
        -- ASSIGN  |PARTITIONED|
          project ([$$73]) [cardinality: 1000000.0, op-cost: 0.0, total-cost: 1000000.0]
          -- STREAM_PROJECT  |PARTITIONED|
            exchange [cardinality: 1000000.0, op-cost: 0.0, total-cost: 1000000.0]
            -- SORT_MERGE_EXCHANGE [$$77(ASC) ]  |PARTITIONED|
              project ([$$73, $$77]) [cardinality: 1000000.0, op-cost: 0.0, total-cost: 1000000.0]
              -- STREAM_PROJECT  |PARTITIONED|
                subplan {
                          aggregate [$$73] <- [listify($$72)] [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
                          -- AGGREGATE  |LOCAL|
                            assign [$$72] <- [object-remove(object-remove(object-remove($$t0, "title"), "authors"), "misc")] [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
                            -- ASSIGN  |LOCAL|
                              unnest $$t0 <- scan-collection(to-array($$paper)) [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
                              -- UNNEST  |LOCAL|
                                nested tuple source [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
                                -- NESTED_TUPLE_SOURCE  |LOCAL|
                       } [cardinality: 1000000.0, op-cost: 0.0, total-cost: 1000000.0]
                -- SUBPLAN  |PARTITIONED|
                  limit 10 [cardinality: 1000000.0, op-cost: 0.0, total-cost: 1000000.0]
                  -- STREAM_LIMIT  |PARTITIONED|
                    exchange [cardinality: 1000000.0, op-cost: 0.0, total-cost: 1000000.0]
                    -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                      data-scan []<-[$$77, $$paper] <- test.DBLP1 limit 10 [cardinality: 1000000.0, op-cost: 1000000.0, total-cost: 1000000.0]
                      -- DATASOURCE_SCAN  |PARTITIONED|
                        exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
                        -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
                          empty-tuple-source [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
                          -- EMPTY_TUPLE_SOURCE  |PARTITIONED|