| -- SINK_WRITE |UNPARTITIONED| | |
| -- STREAM_PROJECT |UNPARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |UNPARTITIONED| | |
| -- PRE_CLUSTERED_GROUP_BY[$$8] |UNPARTITIONED| | |
| { | |
| -- AGGREGATE |UNPARTITIONED| | |
| -- NESTED_TUPLE_SOURCE |UNPARTITIONED| | |
| } | |
| -- ONE_TO_ONE_EXCHANGE |LOCAL| | |
| -- STABLE_SORT [$$8(ASC)] |LOCAL| | |
| -- ONE_TO_ONE_EXCHANGE |UNPARTITIONED| | |
| -- STREAM_PROJECT |UNPARTITIONED| | |
| -- ASSIGN |UNPARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |UNPARTITIONED| | |
| -- HYBRID_HASH_JOIN [$$0][$$1] |UNPARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |UNPARTITIONED| | |
| -- UNNEST |UNPARTITIONED| | |
| -- EMPTY_TUPLE_SOURCE |UNPARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |UNPARTITIONED| | |
| -- UNNEST |UNPARTITIONED| | |
| -- EMPTY_TUPLE_SOURCE |UNPARTITIONED| |