Gitiles
Code Review Sign In
asterix-gerrit.ics.uci.edu / asterixdb / 1e7760c307a8be58f3e770401252b0d1cb9ef82a / . / asterix-app / src / test / resources / optimizerts / results / query-issue562.plan
blob: 28625aa57b0d8e7fe5a394f7ecec3fa49d8327d7 [file] [log] [blame]
buyingyia9a02022015-01-15 10:40:15 -0800[diff] [blame]1-- DISTRIBUTE_RESULT |PARTITIONED|
2 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
3 -- STREAM_PROJECT |PARTITIONED|
4 -- ASSIGN |PARTITIONED|
5 -- SORT_MERGE_EXCHANGE [$$7(ASC) ] |PARTITIONED|
Yingyi Bu1e7760c2016-02-22 16:25:42 -0800[diff] [blame^]6 -- PRE_CLUSTERED_GROUP_BY[$$86] |PARTITIONED|
buyingyia9a02022015-01-15 10:40:15 -0800[diff] [blame]7 {
8 -- AGGREGATE |LOCAL|
9 -- NESTED_TUPLE_SOURCE |LOCAL|
10 }
Yingyi Bu1e7760c2016-02-22 16:25:42 -0800[diff] [blame^]11 -- HASH_PARTITION_MERGE_EXCHANGE MERGE:[$$86(ASC)] HASH:[$$86] |PARTITIONED|
buyingyia9a02022015-01-15 10:40:15 -0800[diff] [blame]12 -- SORT_GROUP_BY[$$59] |PARTITIONED|
13 {
14 -- AGGREGATE |LOCAL|
15 -- NESTED_TUPLE_SOURCE |LOCAL|
16 }
17 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
18 -- STREAM_PROJECT |PARTITIONED|
Yingyi Bu947fc3c2016-01-27 20:14:47 -0800[diff] [blame]19 -- ASSIGN |PARTITIONED|
buyingyia9a02022015-01-15 10:40:15 -0800[diff] [blame]20 -- STREAM_PROJECT |PARTITIONED|
Yingyi Bu947fc3c2016-01-27 20:14:47 -0800[diff] [blame]21 -- STREAM_SELECT |PARTITIONED|
22 -- STREAM_PROJECT |PARTITIONED|
23 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Yingyi Bu1e7760c2016-02-22 16:25:42 -0800[diff] [blame^]24 -- SORT_GROUP_BY[$$83] |PARTITIONED|
buyingyia9a02022015-01-15 10:40:15 -0800[diff] [blame]25 {
26 -- AGGREGATE |LOCAL|
Yingyi Bu947fc3c2016-01-27 20:14:47 -0800[diff] [blame]27 -- NESTED_TUPLE_SOURCE |LOCAL|
buyingyia9a02022015-01-15 10:40:15 -0800[diff] [blame]28 }
Yingyi Bu1e7760c2016-02-22 16:25:42 -0800[diff] [blame^]29 -- HASH_PARTITION_EXCHANGE [$$83] |PARTITIONED|
30 -- STREAM_PROJECT |PARTITIONED|
buyingyia9a02022015-01-15 10:40:15 -0800[diff] [blame]31 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Yingyi Bu1e7760c2016-02-22 16:25:42 -0800[diff] [blame^]32 -- PRE_CLUSTERED_GROUP_BY[$$65, $$11, $$62] |PARTITIONED|
33 {
34 -- AGGREGATE |LOCAL|
35 -- STREAM_SELECT |LOCAL|
36 -- NESTED_TUPLE_SOURCE |LOCAL|
37 }
buyingyia9a02022015-01-15 10:40:15 -0800[diff] [blame]38 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Yingyi Bu1e7760c2016-02-22 16:25:42 -0800[diff] [blame^]39 -- STABLE_SORT [$$65(ASC), $$65(ASC), $$62(ASC)] |PARTITIONED|
Yingyi Bu947fc3c2016-01-27 20:14:47 -0800[diff] [blame]40 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Yingyi Bu1e7760c2016-02-22 16:25:42 -0800[diff] [blame^]41 -- STABLE_SORT [$$65(ASC), $$65(ASC), $$62(ASC)] |PARTITIONED|
42 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
43 -- STREAM_PROJECT |PARTITIONED|
44 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
45 -- HYBRID_HASH_JOIN [$$68][$$69] |PARTITIONED|
46 -- HASH_PARTITION_EXCHANGE [$$68] |PARTITIONED|
47 -- ASSIGN |PARTITIONED|
48 -- ASSIGN |PARTITIONED|
49 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
50 -- HYBRID_HASH_JOIN [$$65][$$11] |PARTITIONED|
51 -- HASH_PARTITION_EXCHANGE [$$65] |PARTITIONED|
52 -- UNNEST |UNPARTITIONED|
53 -- EMPTY_TUPLE_SOURCE |UNPARTITIONED|
54 -- HASH_PARTITION_EXCHANGE [$$11] |PARTITIONED|
Yingyi Bu947fc3c2016-01-27 20:14:47 -0800[diff] [blame]55 -- ASSIGN |PARTITIONED|
Yingyi Bu1e7760c2016-02-22 16:25:42 -0800[diff] [blame^]56 -- STREAM_PROJECT |PARTITIONED|
57 -- ASSIGN |PARTITIONED|
Yingyi Bu947fc3c2016-01-27 20:14:47 -0800[diff] [blame]58 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Yingyi Bu1e7760c2016-02-22 16:25:42 -0800[diff] [blame^]59 -- DATASOURCE_SCAN |PARTITIONED|
60 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
61 -- EMPTY_TUPLE_SOURCE |PARTITIONED|
62 -- HASH_PARTITION_EXCHANGE [$$69] |PARTITIONED|
63 -- ASSIGN |PARTITIONED|
64 -- STREAM_PROJECT |PARTITIONED|
65 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
66 -- DATASOURCE_SCAN |PARTITIONED|
67 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
68 -- EMPTY_TUPLE_SOURCE |PARTITIONED|