| -- DISTRIBUTE_RESULT |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- ASSIGN |PARTITIONED| | |
| -- SORT_MERGE_EXCHANGE [$$7(ASC) ] |PARTITIONED| | |
| -- PRE_CLUSTERED_GROUP_BY[$$86] |PARTITIONED| | |
| { | |
| -- AGGREGATE |LOCAL| | |
| -- NESTED_TUPLE_SOURCE |LOCAL| | |
| } | |
| -- HASH_PARTITION_MERGE_EXCHANGE MERGE:[$$86(ASC)] HASH:[$$86] |PARTITIONED| | |
| -- SORT_GROUP_BY[$$59] |PARTITIONED| | |
| { | |
| -- AGGREGATE |LOCAL| | |
| -- NESTED_TUPLE_SOURCE |LOCAL| | |
| } | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- ASSIGN |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- STREAM_SELECT |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- SORT_GROUP_BY[$$83] |PARTITIONED| | |
| { | |
| -- AGGREGATE |LOCAL| | |
| -- NESTED_TUPLE_SOURCE |LOCAL| | |
| } | |
| -- HASH_PARTITION_EXCHANGE [$$83] |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- PRE_CLUSTERED_GROUP_BY[$$65, $$11, $$62] |PARTITIONED| | |
| { | |
| -- AGGREGATE |LOCAL| | |
| -- STREAM_SELECT |LOCAL| | |
| -- NESTED_TUPLE_SOURCE |LOCAL| | |
| } | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- STABLE_SORT [$$65(ASC), $$65(ASC), $$62(ASC)] |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- STABLE_SORT [$$65(ASC), $$65(ASC), $$62(ASC)] |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- HYBRID_HASH_JOIN [$$68][$$69] |PARTITIONED| | |
| -- HASH_PARTITION_EXCHANGE [$$68] |PARTITIONED| | |
| -- ASSIGN |PARTITIONED| | |
| -- ASSIGN |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- HYBRID_HASH_JOIN [$$65][$$11] |PARTITIONED| | |
| -- HASH_PARTITION_EXCHANGE [$$65] |PARTITIONED| | |
| -- UNNEST |UNPARTITIONED| | |
| -- EMPTY_TUPLE_SOURCE |UNPARTITIONED| | |
| -- HASH_PARTITION_EXCHANGE [$$11] |PARTITIONED| | |
| -- ASSIGN |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- ASSIGN |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- DATASOURCE_SCAN |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- EMPTY_TUPLE_SOURCE |PARTITIONED| | |
| -- HASH_PARTITION_EXCHANGE [$$69] |PARTITIONED| | |
| -- ASSIGN |PARTITIONED| | |
| -- STREAM_PROJECT |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- DATASOURCE_SCAN |PARTITIONED| | |
| -- ONE_TO_ONE_EXCHANGE |PARTITIONED| | |
| -- EMPTY_TUPLE_SOURCE |PARTITIONED| |