Gitiles
Code Review Sign In
asterix-gerrit.ics.uci.edu / asterixdb / 91da9477d12f295af888514f4228152b2d5b2d14 / . / asterixdb / asterix-app / src / test / resources / optimizerts / results / query-ASTERIXDB-159-3.plan
blob: 6c713c463dd2774dace9346373a8fbcc73cfd7be [file] [log] [blame]
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]1-- DISTRIBUTE_RESULT |UNPARTITIONED|
2 -- ONE_TO_ONE_EXCHANGE |UNPARTITIONED|
3 -- STREAM_LIMIT |UNPARTITIONED|
4 -- STREAM_PROJECT |PARTITIONED|
5 -- ASSIGN |PARTITIONED|
Dmitry Lychaginee1b3b02020-11-24 18:22:26 -0800[diff] [blame]6 -- SORT_MERGE_EXCHANGE [$$45(DESC), $$46(DESC) ] |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]7 -- STREAM_LIMIT |PARTITIONED|
8 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Dmitry Lychaginee1b3b02020-11-24 18:22:26 -0800[diff] [blame]9 -- STABLE_SORT [topK: 5] [$$45(DESC), $$46(DESC)] |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]10 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
11 -- STREAM_PROJECT |PARTITIONED|
12 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Dmitry Lychaginee1b3b02020-11-24 18:22:26 -0800[diff] [blame]13 -- HYBRID_HASH_JOIN [$$45][$$54] |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]14 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
15 -- STREAM_PROJECT |PARTITIONED|
16 -- ASSIGN |PARTITIONED|
17 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Taewoo Kima79db2a2016-09-27 16:55:48 -0700[diff] [blame]18 -- REPLICATE |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]19 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
20 -- STREAM_PROJECT |PARTITIONED|
21 -- ASSIGN |PARTITIONED|
22 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Taewoo Kima79db2a2016-09-27 16:55:48 -0700[diff] [blame]23 -- REPLICATE |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]24 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
25 -- STREAM_PROJECT |PARTITIONED|
26 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Dmitry Lychaginee1b3b02020-11-24 18:22:26 -0800[diff] [blame]27 -- DATASOURCE_SCAN (TinySocial.FacebookUsers) |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]28 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
29 -- EMPTY_TUPLE_SOURCE |PARTITIONED|
Ali Alsuliman59ea0052022-08-19 21:49:34 -0700[diff] [blame]30 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]31 -- STREAM_PROJECT |PARTITIONED|
32 -- STREAM_SELECT |PARTITIONED|
Yingyi Bu834e1732016-09-09 20:25:49 -0700[diff] [blame]33 -- SUBPLAN |PARTITIONED|
34 {
35 -- AGGREGATE |LOCAL|
36 -- UNNEST |LOCAL|
37 -- NESTED_TUPLE_SOURCE |LOCAL|
38 }
39 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
40 -- NESTED_LOOP |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]41 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Taewoo Kima79db2a2016-09-27 16:55:48 -0700[diff] [blame]42 -- REPLICATE |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]43 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Yingyi Bu834e1732016-09-09 20:25:49 -0700[diff] [blame]44 -- STREAM_PROJECT |PARTITIONED|
45 -- ASSIGN |PARTITIONED|
46 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Taewoo Kima79db2a2016-09-27 16:55:48 -0700[diff] [blame]47 -- REPLICATE |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]48 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Yingyi Bu834e1732016-09-09 20:25:49 -0700[diff] [blame]49 -- STREAM_PROJECT |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]50 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Dmitry Lychaginee1b3b02020-11-24 18:22:26 -0800[diff] [blame]51 -- DATASOURCE_SCAN (TinySocial.FacebookUsers) |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]52 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Yingyi Bu834e1732016-09-09 20:25:49 -0700[diff] [blame]53 -- EMPTY_TUPLE_SOURCE |PARTITIONED|
54 -- BROADCAST_EXCHANGE |PARTITIONED|
Taewoo Kima79db2a2016-09-27 16:55:48 -0700[diff] [blame]55 -- REPLICATE |PARTITIONED|
Yingyi Bu834e1732016-09-09 20:25:49 -0700[diff] [blame]56 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
57 -- STREAM_PROJECT |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]58 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Dmitry Lychaginee1b3b02020-11-24 18:22:26 -0800[diff] [blame]59 -- DATASOURCE_SCAN (TinySocial.FacebookUsers) |PARTITIONED|
Yingyi Bu8fec3312016-08-27 19:54:47 -0700[diff] [blame]60 -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
Yingyi Bu834e1732016-09-09 20:25:49 -0700[diff] [blame]61 -- EMPTY_TUPLE_SOURCE |PARTITIONED|