| vinayakb | 38b7ca4 | 2012-03-05 05:44:15 +0000 | [diff] [blame^] | 1 | -- SINK_WRITE |UNPARTITIONED| |
| 2 | -- STREAM_PROJECT |UNPARTITIONED| |
| 3 | -- ASSIGN |UNPARTITIONED| |
| 4 | -- STREAM_LIMIT |UNPARTITIONED| |
| 5 | -- SORT_MERGE_EXCHANGE [$$26(DESC) ] |PARTITIONED| |
| 6 | -- STREAM_LIMIT |LOCAL| |
| 7 | -- ONE_TO_ONE_EXCHANGE |LOCAL| |
| 8 | -- STABLE_SORT [$$26(DESC)] |LOCAL| |
| 9 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 10 | -- PRE_CLUSTERED_GROUP_BY[$$31] |PARTITIONED| |
| 11 | { |
| 12 | -- AGGREGATE |LOCAL| |
| 13 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 14 | } |
| 15 | { |
| 16 | -- AGGREGATE |LOCAL| |
| 17 | -- MICRO_PRE_CLUSTERED_GROUP_BY[$$32] |LOCAL| |
| 18 | { |
| 19 | -- AGGREGATE |LOCAL| |
| 20 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 21 | } |
| 22 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 23 | } |
| 24 | -- HASH_PARTITION_MERGE_EXCHANGE MERGE:[$$31(ASC), $$32(ASC)] HASH:[$$31] |PARTITIONED| |
| 25 | -- PRE_CLUSTERED_GROUP_BY[$$23, $$24] |LOCAL| |
| 26 | { |
| 27 | -- AGGREGATE |LOCAL| |
| 28 | -- NESTED_TUPLE_SOURCE |LOCAL| |
| 29 | } |
| 30 | -- ONE_TO_ONE_EXCHANGE |LOCAL| |
| 31 | -- STABLE_SORT [$$23(ASC), $$24(ASC)] |LOCAL| |
| 32 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 33 | -- STREAM_PROJECT |PARTITIONED| |
| 34 | -- ASSIGN |PARTITIONED| |
| 35 | -- UNNEST |PARTITIONED| |
| 36 | -- ASSIGN |PARTITIONED| |
| 37 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 38 | -- DATASOURCE_SCAN |PARTITIONED| |
| 39 | -- ONE_TO_ONE_EXCHANGE |PARTITIONED| |
| 40 | -- EMPTY_TUPLE_SOURCE |PARTITIONED| |