Gitiles
Code Review Sign In
asterix-gerrit.ics.uci.edu / asterixdb-bad / f9c3014475ba15c9537c3e6a2f2beb28ce0b8ddc / . / asterix-bad / src / test / resources / optimizerts / results / channel / channel-advanced.plan
blob: 59805cce839585ea553f0d529b45802024417210 [file] [log] [blame]
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]1-- NOTIFY_BROKERS |PARTITIONED|
2 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]3 -- PRE_CLUSTERED_GROUP_BY[$$141, $$channelExecutionTime] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]4 {
5 -- AGGREGATE |LOCAL|
6 -- NESTED_TUPLE_SOURCE |LOCAL|
7 }
8 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]9 -- STABLE_SORT [$$141(ASC), $$channelExecutionTime(ASC)] |PARTITIONED|
10 -- HASH_PARTITION_EXCHANGE [$$141, $$channelExecutionTime] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]11 -- PRE_SORTED_DISTINCT_BY |PARTITIONED|
12 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]13 -- STABLE_SORT [$$116(ASC)] |PARTITIONED|
14 -- HASH_PARTITION_EXCHANGE [$$116] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]15 -- STREAM_PROJECT |PARTITIONED|
16 -- COMMIT |PARTITIONED|
17 -- STREAM_PROJECT |PARTITIONED|
18 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
19 -- INDEX_INSERT_DELETE |PARTITIONED|
20 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
21 -- STREAM_PROJECT |PARTITIONED|
22 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
23 -- INSERT_DELETE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]24 -- HASH_PARTITION_EXCHANGE [$$111] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]25 -- ASSIGN |PARTITIONED|
26 -- STREAM_PROJECT |PARTITIONED|
27 -- ASSIGN |PARTITIONED|
28 -- STREAM_PROJECT |PARTITIONED|
29 -- ASSIGN |PARTITIONED|
30 -- STREAM_PROJECT |PARTITIONED|
31 -- ASSIGN |PARTITIONED|
32 -- STREAM_PROJECT |PARTITIONED|
33 -- STREAM_SELECT |PARTITIONED|
34 -- STREAM_PROJECT |PARTITIONED|
35 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]36 -- HYBRID_HASH_JOIN [$$126][$$125] |PARTITIONED|
37 -- HASH_PARTITION_EXCHANGE [$$126] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]38 -- STREAM_PROJECT |PARTITIONED|
39 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]40 -- HYBRID_HASH_JOIN [$$124, $$122][$$117, $$118] |PARTITIONED|
41 -- HASH_PARTITION_EXCHANGE [$$124, $$122] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]42 -- STREAM_PROJECT |PARTITIONED|
43 -- ASSIGN |PARTITIONED|
44 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
45 -- DATASOURCE_SCAN |PARTITIONED|
46 -- BROADCAST_EXCHANGE |PARTITIONED|
47 -- ASSIGN |UNPARTITIONED|
48 -- EMPTY_TUPLE_SOURCE |UNPARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]49 -- HASH_PARTITION_EXCHANGE [$$117, $$118] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]50 -- STREAM_PROJECT |PARTITIONED|
51 -- ASSIGN |PARTITIONED|
52 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
53 -- DATASOURCE_SCAN |PARTITIONED|
54 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
55 -- EMPTY_TUPLE_SOURCE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]56 -- HASH_PARTITION_EXCHANGE [$$125] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]57 -- STREAM_PROJECT |PARTITIONED|
58 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]59 -- HYBRID_HASH_JOIN [$$119][$$135] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]60 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
61 -- STREAM_SELECT |PARTITIONED|
62 -- ASSIGN |PARTITIONED|
63 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
64 -- BTREE_SEARCH |PARTITIONED|
65 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]66 -- STABLE_SORT [$$145(ASC)] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]67 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
68 -- STREAM_PROJECT |PARTITIONED|
69 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
70 -- BTREE_SEARCH |PARTITIONED|
71 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
72 -- ASSIGN |PARTITIONED|
73 -- EMPTY_TUPLE_SOURCE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]74 -- HASH_PARTITION_EXCHANGE [$$135] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]75 -- NESTED_LOOP |PARTITIONED|
76 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
77 -- STREAM_PROJECT |PARTITIONED|
78 -- STREAM_SELECT |PARTITIONED|
79 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
80 -- BTREE_SEARCH |PARTITIONED|
81 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]82 -- STABLE_SORT [$$149(ASC)] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]83 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
84 -- STREAM_PROJECT |PARTITIONED|
85 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
86 -- BTREE_SEARCH |PARTITIONED|
87 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
88 -- ASSIGN |PARTITIONED|
89 -- EMPTY_TUPLE_SOURCE |PARTITIONED|
90 -- BROADCAST_EXCHANGE |PARTITIONED|
91 -- STREAM_PROJECT |PARTITIONED|
92 -- STREAM_SELECT |PARTITIONED|
93 -- STREAM_PROJECT |PARTITIONED|
94 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
95 -- BTREE_SEARCH |PARTITIONED|
96 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]97 -- STABLE_SORT [$$152(ASC)] |PARTITIONED|
Steven Glenn Jacobs8b53ce52017-11-14 10:21:43 -0800[diff] [blame]98 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
99 -- STREAM_PROJECT |PARTITIONED|
100 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
101 -- BTREE_SEARCH |PARTITIONED|
102 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
103 -- ASSIGN |PARTITIONED|
Xikui Wang4e2e7a52018-06-06 11:45:24 -0700[diff] [blame]104 -- EMPTY_TUPLE_SOURCE |PARTITIONED|