| -- DISTRIBUTE_RESULT |UNPARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |UNPARTITIONED| | |
| -- STREAM_PROJECT |UNPARTITIONED| | |
| -- ASSIGN |UNPARTITIONED| | |
| -- STREAM_LIMIT |UNPARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- SORT_MERGE_EXCHANGE [$$26(DESC) ] |PARTITIONED| | |
| -- STREAM_LIMIT |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- STABLE_SORT [$$26(DESC)] |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- PRE_CLUSTERED_GROUP_BY[$$32] |PARTITIONED| | |
| { | |
| -- AGGREGATE |LOCAL| | |
| -- NESTED_TUPLE_SOURCE |LOCAL| | |
| } | |
| { | |
| -- AGGREGATE |LOCAL| | |
| -- MICRO_PRE_CLUSTERED_GROUP_BY[$$33] |LOCAL| | |
| { | |
| -- AGGREGATE |LOCAL| | |
| -- NESTED_TUPLE_SOURCE |LOCAL| | |
| } | |
| -- NESTED_TUPLE_SOURCE |LOCAL| | |
| } | |
| -- HASH_PARTITION_MERGE_EXCHANGE MERGE:[$$32(ASC), $$33(ASC)] HASH:[$$32] |PARTITIONED| | |
| -- SORT_GROUP_BY[$$23, $$24] |PARTITIONED| | |
| { | |
| -- AGGREGATE |LOCAL| | |
| -- NESTED_TUPLE_SOURCE |LOCAL| | |
| } | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- ASSIGN |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- UNNEST |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| |