| -- SINK_WRITE |PARTITIONED| | |
| -- RANDOM_MERGE_EXCHANGE |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- ASSIGN |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- PRE_CLUSTERED_GROUP_BY[$$23] |PARTITIONED| | |
| { | |
| -- AGGREGATE |LOCAL| | |
| -- STREAM_SELECT |LOCAL| | |
| -- NESTED_TUPLE_SOURCE |LOCAL| | |
| } | |
| -- ONE_TO_ONE_EXCHANGE |LOCAL| | |
| -- STABLE_SORT [$$23(ASC), $$7(ASC)] |LOCAL| | |
| -- HASH_PARTITION_EXCHANGE [$$23] |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- HYBRID_HASH_JOIN [$$2][$$7] |PARTITIONED| | |
| -- HASH_PARTITION_EXCHANGE [$$2] |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- UNNEST |PARTITIONED| | |
| -- ASSIGN |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- DATASOURCE_SCAN |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- EMPTY_TUPLE_SOURCE |PARTITIONED| | |
| -- HASH_PARTITION_EXCHANGE [$$7] |PARTITIONED| | |
| -- RUNNING_AGGREGATE |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- SORT_MERGE_EXCHANGE [$$24(DESC) ] |PARTITIONED| | |
| -- STABLE_SORT [$$24(DESC)] |LOCAL| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- PRE_CLUSTERED_GROUP_BY[$$30] |PARTITIONED| | |
| { | |
| -- AGGREGATE |LOCAL| | |
| -- NESTED_TUPLE_SOURCE |LOCAL| | |
| } | |
| -- HASH_PARTITION_MERGE_EXCHANGE MERGE:[$$30(ASC)] HASH:[$$30] |PARTITIONED| | |
| -- PRE_CLUSTERED_GROUP_BY[$$6] |LOCAL| | |
| { | |
| -- AGGREGATE |LOCAL| | |
| -- NESTED_TUPLE_SOURCE |LOCAL| | |
| } | |
| -- ONE_TO_ONE_EXCHANGE |LOCAL| | |
| -- STABLE_SORT [$$6(ASC)] |LOCAL| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- UNNEST |PARTITIONED| | |
| -- ASSIGN |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- DATASOURCE_SCAN |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- EMPTY_TUPLE_SOURCE |PARTITIONED| |