hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject [1/3] hive git commit: HIVE-16228 : Support subqueries in complex expression in SELECT clause (Vineet Garg via Ashutosh Chauhan)
Date Thu, 30 Mar 2017 22:15:27 GMT
Repository: hive
Updated Branches:
  refs/heads/master db983d6c6 -> ac6735a38


http://git-wip-us.apache.org/repos/asf/hive/blob/ac6735a3/ql/src/test/results/clientpositive/perf/query9.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query9.q.out b/ql/src/test/results/clientpositive/perf/query9.q.out
new file mode 100644
index 0000000..d714d41
--- /dev/null
+++ b/ql/src/test/results/clientpositive/perf/query9.q.out
@@ -0,0 +1,829 @@
+Warning: Shuffle Join MERGEJOIN[456][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
+Warning: Shuffle Join MERGEJOIN[457][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
+Warning: Shuffle Join MERGEJOIN[458][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 4' is a cross product
+Warning: Shuffle Join MERGEJOIN[459][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4]] in Stage 'Reducer 5' is a cross product
+Warning: Shuffle Join MERGEJOIN[460][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5]] in Stage 'Reducer 6' is a cross product
+Warning: Shuffle Join MERGEJOIN[461][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6]] in Stage 'Reducer 7' is a cross product
+Warning: Shuffle Join MERGEJOIN[462][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7]] in Stage 'Reducer 8' is a cross product
+Warning: Shuffle Join MERGEJOIN[463][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8]] in Stage 'Reducer 9' is a cross product
+Warning: Shuffle Join MERGEJOIN[464][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9]] in Stage 'Reducer 10' is a cross product
+Warning: Shuffle Join MERGEJOIN[465][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10]] in Stage 'Reducer 11' is a cross product
+Warning: Shuffle Join MERGEJOIN[466][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11]] in Stage 'Reducer 12' is a cross product
+Warning: Shuffle Join MERGEJOIN[467][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12]] in Stage 'Reducer 13' is a cross product
+Warning: Shuffle Join MERGEJOIN[468][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13]] in Stage 'Reducer 14' is a cross product
+Warning: Shuffle Join MERGEJOIN[469][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14]] in Stage 'Reducer 15' is a cross product
+Warning: Shuffle Join MERGEJOIN[470][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15]] in Stage 'Reducer 16' is a cross product
+Warning: Shuffle Join MERGEJOIN[471][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16]] in Stage 'Reducer 17' is a cross product
+Warning: Shuffle Join MERGEJOIN[472][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17]] in Stage 'Reducer 18' is a cross product
+Warning: Shuffle Join MERGEJOIN[473][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18]] in Stage 'Reducer 19' is a cross product
+Warning: Shuffle Join MERGEJOIN[474][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19]] in Stage 'Reducer 20' is a cross product
+Warning: Shuffle Join MERGEJOIN[475][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19, $hdt$_20]] in Stage 'Reducer 21' is a cross product
+Warning: Shuffle Join MERGEJOIN[476][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19, $hdt$_20, $hdt$_21]] in Stage 'Reducer 22' is a cross product
+Warning: Shuffle Join MERGEJOIN[477][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19, $hdt$_20, $hdt$_21, $hdt$_22]] in Stage 'Reducer 23' is a cross product
+Warning: Shuffle Join MERGEJOIN[478][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19, $hdt$_20, $hdt$_21, $hdt$_22, $hdt$_23]] in Stage 'Reducer 24' is a cross product
+Warning: Shuffle Join MERGEJOIN[479][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19, $hdt$_20, $hdt$_21, $hdt$_22, $hdt$_23, $hdt$_24]] in Stage 'Reducer 25' is a cross product
+Warning: Shuffle Join MERGEJOIN[480][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19, $hdt$_20, $hdt$_21, $hdt$_22, $hdt$_23, $hdt$_24, $hdt$_25]] in Stage 'Reducer 26' is a cross product
+Warning: Shuffle Join MERGEJOIN[481][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19, $hdt$_20, $hdt$_21, $hdt$_22, $hdt$_23, $hdt$_24, $hdt$_25, $hdt$_26]] in Stage 'Reducer 27' is a cross product
+Warning: Shuffle Join MERGEJOIN[482][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19, $hdt$_20, $hdt$_21, $hdt$_22, $hdt$_23, $hdt$_24, $hdt$_25, $hdt$_26, $hdt$_27]] in Stage 'Reducer 28' is a cross product
+Warning: Shuffle Join MERGEJOIN[483][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19, $hdt$_20, $hdt$_21, $hdt$_22, $hdt$_23, $hdt$_24, $hdt$_25, $hdt$_26, $hdt$_27, $hdt$_28]] in Stage 'Reducer 29' is a cross product
+Warning: Shuffle Join MERGEJOIN[484][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19, $hdt$_20, $hdt$_21, $hdt$_22, $hdt$_23, $hdt$_24, $hdt$_25, $hdt$_26, $hdt$_27, $hdt$_28, $hdt$_29]] in Stage 'Reducer 30' is a cross product
+Warning: Shuffle Join MERGEJOIN[485][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4, $hdt$_5, $hdt$_6, $hdt$_7, $hdt$_8, $hdt$_9, $hdt$_10, $hdt$_11, $hdt$_12, $hdt$_13, $hdt$_14, $hdt$_15, $hdt$_16, $hdt$_17, $hdt$_18, $hdt$_19, $hdt$_20, $hdt$_21, $hdt$_22, $hdt$_23, $hdt$_24, $hdt$_25, $hdt$_26, $hdt$_27, $hdt$_28, $hdt$_29, $hdt$_30]] in Stage 'Reducer 31' is a cross product
+PREHOOK: query: explain select case when (select count(*)
+                  from store_sales
+                  where ss_quantity between 1 and 20) > 409437
+            then (select avg(ss_ext_list_price)
+                  from store_sales
+                  where ss_quantity between 1 and 20)
+            else (select avg(ss_net_paid_inc_tax)
+                  from store_sales
+                  where ss_quantity between 1 and 20) end bucket1 ,
+       case when (select count(*)
+                  from store_sales
+                  where ss_quantity between 21 and 40) > 4595804
+            then (select avg(ss_ext_list_price)
+                  from store_sales
+                  where ss_quantity between 21 and 40)
+            else (select avg(ss_net_paid_inc_tax)
+                  from store_sales
+                  where ss_quantity between 21 and 40) end bucket2,
+       case when (select count(*)
+                  from store_sales
+                  where ss_quantity between 41 and 60) > 7887297
+            then (select avg(ss_ext_list_price)
+                  from store_sales
+                  where ss_quantity between 41 and 60)
+            else (select avg(ss_net_paid_inc_tax)
+                  from store_sales
+                  where ss_quantity between 41 and 60) end bucket3,
+       case when (select count(*)
+                  from store_sales
+                  where ss_quantity between 61 and 80) > 10872978
+            then (select avg(ss_ext_list_price)
+                  from store_sales
+                  where ss_quantity between 61 and 80)
+            else (select avg(ss_net_paid_inc_tax)
+                  from store_sales
+                  where ss_quantity between 61 and 80) end bucket4,
+       case when (select count(*)
+                  from store_sales
+                  where ss_quantity between 81 and 100) > 43571537
+            then (select avg(ss_ext_list_price)
+                  from store_sales
+                  where ss_quantity between 81 and 100)
+            else (select avg(ss_net_paid_inc_tax)
+                  from store_sales
+                  where ss_quantity between 81 and 100) end bucket5
+from reason
+where r_reason_sk = 1
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select case when (select count(*)
+                  from store_sales
+                  where ss_quantity between 1 and 20) > 409437
+            then (select avg(ss_ext_list_price)
+                  from store_sales
+                  where ss_quantity between 1 and 20)
+            else (select avg(ss_net_paid_inc_tax)
+                  from store_sales
+                  where ss_quantity between 1 and 20) end bucket1 ,
+       case when (select count(*)
+                  from store_sales
+                  where ss_quantity between 21 and 40) > 4595804
+            then (select avg(ss_ext_list_price)
+                  from store_sales
+                  where ss_quantity between 21 and 40)
+            else (select avg(ss_net_paid_inc_tax)
+                  from store_sales
+                  where ss_quantity between 21 and 40) end bucket2,
+       case when (select count(*)
+                  from store_sales
+                  where ss_quantity between 41 and 60) > 7887297
+            then (select avg(ss_ext_list_price)
+                  from store_sales
+                  where ss_quantity between 41 and 60)
+            else (select avg(ss_net_paid_inc_tax)
+                  from store_sales
+                  where ss_quantity between 41 and 60) end bucket3,
+       case when (select count(*)
+                  from store_sales
+                  where ss_quantity between 61 and 80) > 10872978
+            then (select avg(ss_ext_list_price)
+                  from store_sales
+                  where ss_quantity between 61 and 80)
+            else (select avg(ss_net_paid_inc_tax)
+                  from store_sales
+                  where ss_quantity between 61 and 80) end bucket4,
+       case when (select count(*)
+                  from store_sales
+                  where ss_quantity between 81 and 100) > 43571537
+            then (select avg(ss_ext_list_price)
+                  from store_sales
+                  where ss_quantity between 81 and 100)
+            else (select avg(ss_net_paid_inc_tax)
+                  from store_sales
+                  where ss_quantity between 81 and 100) end bucket5
+from reason
+where r_reason_sk = 1
+POSTHOOK: type: QUERY
+Plan optimized by CBO.
+
+Vertex dependency in root stage
+Reducer 10 <- Reducer 49 (CUSTOM_SIMPLE_EDGE), Reducer 9 (CUSTOM_SIMPLE_EDGE)
+Reducer 11 <- Reducer 10 (CUSTOM_SIMPLE_EDGE), Reducer 51 (CUSTOM_SIMPLE_EDGE)
+Reducer 12 <- Reducer 11 (CUSTOM_SIMPLE_EDGE), Reducer 53 (CUSTOM_SIMPLE_EDGE)
+Reducer 13 <- Reducer 12 (CUSTOM_SIMPLE_EDGE), Reducer 55 (CUSTOM_SIMPLE_EDGE)
+Reducer 14 <- Reducer 13 (CUSTOM_SIMPLE_EDGE), Reducer 57 (CUSTOM_SIMPLE_EDGE)
+Reducer 15 <- Reducer 14 (CUSTOM_SIMPLE_EDGE), Reducer 59 (CUSTOM_SIMPLE_EDGE)
+Reducer 16 <- Reducer 15 (CUSTOM_SIMPLE_EDGE), Reducer 61 (CUSTOM_SIMPLE_EDGE)
+Reducer 17 <- Reducer 16 (CUSTOM_SIMPLE_EDGE), Reducer 63 (CUSTOM_SIMPLE_EDGE)
+Reducer 18 <- Reducer 17 (CUSTOM_SIMPLE_EDGE), Reducer 65 (CUSTOM_SIMPLE_EDGE)
+Reducer 19 <- Reducer 18 (CUSTOM_SIMPLE_EDGE), Reducer 67 (CUSTOM_SIMPLE_EDGE)
+Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE), Reducer 33 (CUSTOM_SIMPLE_EDGE)
+Reducer 20 <- Reducer 19 (CUSTOM_SIMPLE_EDGE), Reducer 69 (CUSTOM_SIMPLE_EDGE)
+Reducer 21 <- Reducer 20 (CUSTOM_SIMPLE_EDGE), Reducer 71 (CUSTOM_SIMPLE_EDGE)
+Reducer 22 <- Reducer 21 (CUSTOM_SIMPLE_EDGE), Reducer 73 (CUSTOM_SIMPLE_EDGE)
+Reducer 23 <- Reducer 22 (CUSTOM_SIMPLE_EDGE), Reducer 75 (CUSTOM_SIMPLE_EDGE)
+Reducer 24 <- Reducer 23 (CUSTOM_SIMPLE_EDGE), Reducer 77 (CUSTOM_SIMPLE_EDGE)
+Reducer 25 <- Reducer 24 (CUSTOM_SIMPLE_EDGE), Reducer 79 (CUSTOM_SIMPLE_EDGE)
+Reducer 26 <- Reducer 25 (CUSTOM_SIMPLE_EDGE), Reducer 81 (CUSTOM_SIMPLE_EDGE)
+Reducer 27 <- Reducer 26 (CUSTOM_SIMPLE_EDGE), Reducer 83 (CUSTOM_SIMPLE_EDGE)
+Reducer 28 <- Reducer 27 (CUSTOM_SIMPLE_EDGE), Reducer 85 (CUSTOM_SIMPLE_EDGE)
+Reducer 29 <- Reducer 28 (CUSTOM_SIMPLE_EDGE), Reducer 87 (CUSTOM_SIMPLE_EDGE)
+Reducer 3 <- Reducer 2 (CUSTOM_SIMPLE_EDGE), Reducer 35 (CUSTOM_SIMPLE_EDGE)
+Reducer 30 <- Reducer 29 (CUSTOM_SIMPLE_EDGE), Reducer 89 (CUSTOM_SIMPLE_EDGE)
+Reducer 31 <- Reducer 30 (CUSTOM_SIMPLE_EDGE), Reducer 91 (CUSTOM_SIMPLE_EDGE)
+Reducer 33 <- Map 32 (CUSTOM_SIMPLE_EDGE)
+Reducer 35 <- Map 34 (CUSTOM_SIMPLE_EDGE)
+Reducer 37 <- Map 36 (CUSTOM_SIMPLE_EDGE)
+Reducer 39 <- Map 38 (CUSTOM_SIMPLE_EDGE)
+Reducer 4 <- Reducer 3 (CUSTOM_SIMPLE_EDGE), Reducer 37 (CUSTOM_SIMPLE_EDGE)
+Reducer 41 <- Map 40 (CUSTOM_SIMPLE_EDGE)
+Reducer 43 <- Map 42 (CUSTOM_SIMPLE_EDGE)
+Reducer 45 <- Map 44 (CUSTOM_SIMPLE_EDGE)
+Reducer 47 <- Map 46 (CUSTOM_SIMPLE_EDGE)
+Reducer 49 <- Map 48 (CUSTOM_SIMPLE_EDGE)
+Reducer 5 <- Reducer 39 (CUSTOM_SIMPLE_EDGE), Reducer 4 (CUSTOM_SIMPLE_EDGE)
+Reducer 51 <- Map 50 (CUSTOM_SIMPLE_EDGE)
+Reducer 53 <- Map 52 (CUSTOM_SIMPLE_EDGE)
+Reducer 55 <- Map 54 (CUSTOM_SIMPLE_EDGE)
+Reducer 57 <- Map 56 (CUSTOM_SIMPLE_EDGE)
+Reducer 59 <- Map 58 (CUSTOM_SIMPLE_EDGE)
+Reducer 6 <- Reducer 41 (CUSTOM_SIMPLE_EDGE), Reducer 5 (CUSTOM_SIMPLE_EDGE)
+Reducer 61 <- Map 60 (CUSTOM_SIMPLE_EDGE)
+Reducer 63 <- Map 62 (CUSTOM_SIMPLE_EDGE)
+Reducer 65 <- Map 64 (CUSTOM_SIMPLE_EDGE)
+Reducer 67 <- Map 66 (CUSTOM_SIMPLE_EDGE)
+Reducer 69 <- Map 68 (CUSTOM_SIMPLE_EDGE)
+Reducer 7 <- Reducer 43 (CUSTOM_SIMPLE_EDGE), Reducer 6 (CUSTOM_SIMPLE_EDGE)
+Reducer 71 <- Map 70 (CUSTOM_SIMPLE_EDGE)
+Reducer 73 <- Map 72 (CUSTOM_SIMPLE_EDGE)
+Reducer 75 <- Map 74 (CUSTOM_SIMPLE_EDGE)
+Reducer 77 <- Map 76 (CUSTOM_SIMPLE_EDGE)
+Reducer 79 <- Map 78 (CUSTOM_SIMPLE_EDGE)
+Reducer 8 <- Reducer 45 (CUSTOM_SIMPLE_EDGE), Reducer 7 (CUSTOM_SIMPLE_EDGE)
+Reducer 81 <- Map 80 (CUSTOM_SIMPLE_EDGE)
+Reducer 83 <- Map 82 (CUSTOM_SIMPLE_EDGE)
+Reducer 85 <- Map 84 (CUSTOM_SIMPLE_EDGE)
+Reducer 87 <- Map 86 (CUSTOM_SIMPLE_EDGE)
+Reducer 89 <- Map 88 (CUSTOM_SIMPLE_EDGE)
+Reducer 9 <- Reducer 47 (CUSTOM_SIMPLE_EDGE), Reducer 8 (CUSTOM_SIMPLE_EDGE)
+Reducer 91 <- Map 90 (CUSTOM_SIMPLE_EDGE)
+
+Stage-0
+  Fetch Operator
+    limit:-1
+    Stage-1
+      Reducer 31
+      File Output Operator [FS_424]
+        Select Operator [SEL_423] (rows=36 width=3270)
+          Output:["_col0","_col1","_col2","_col3","_col4"]
+          Merge Join Operator [MERGEJOIN_485] (rows=36 width=3270)
+            Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18","_col20","_col22","_col24","_col26","_col28","_col30"]
+          <-Reducer 30 [CUSTOM_SIMPLE_EDGE]
+            PARTITION_ONLY_SHUFFLE [RS_420]
+              Merge Join Operator [MERGEJOIN_484] (rows=36 width=2981)
+                Conds:(Inner),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18","_col20","_col22","_col24","_col26","_col28"]
+              <-Reducer 29 [CUSTOM_SIMPLE_EDGE]
+                PARTITION_ONLY_SHUFFLE [RS_417]
+                  Merge Join Operator [MERGEJOIN_483] (rows=36 width=2972)
+                    Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18","_col20","_col22","_col24","_col26","_col28"]
+                  <-Reducer 28 [CUSTOM_SIMPLE_EDGE]
+                    PARTITION_ONLY_SHUFFLE [RS_414]
+                      Merge Join Operator [MERGEJOIN_482] (rows=36 width=2683)
+                        Conds:(Inner),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18","_col20","_col22","_col24","_col26"]
+                      <-Reducer 27 [CUSTOM_SIMPLE_EDGE]
+                        PARTITION_ONLY_SHUFFLE [RS_411]
+                          Merge Join Operator [MERGEJOIN_481] (rows=36 width=2674)
+                            Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18","_col20","_col22","_col24","_col26"]
+                          <-Reducer 26 [CUSTOM_SIMPLE_EDGE]
+                            PARTITION_ONLY_SHUFFLE [RS_408]
+                              Merge Join Operator [MERGEJOIN_480] (rows=36 width=2665)
+                                Conds:(Inner),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18","_col20","_col22","_col24"]
+                              <-Reducer 25 [CUSTOM_SIMPLE_EDGE]
+                                PARTITION_ONLY_SHUFFLE [RS_405]
+                                  Merge Join Operator [MERGEJOIN_479] (rows=36 width=2656)
+                                    Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18","_col20","_col22","_col24"]
+                                  <-Reducer 24 [CUSTOM_SIMPLE_EDGE]
+                                    PARTITION_ONLY_SHUFFLE [RS_402]
+                                      Merge Join Operator [MERGEJOIN_478] (rows=36 width=2367)
+                                        Conds:(Inner),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18","_col20","_col22"]
+                                      <-Reducer 23 [CUSTOM_SIMPLE_EDGE]
+                                        PARTITION_ONLY_SHUFFLE [RS_399]
+                                          Merge Join Operator [MERGEJOIN_477] (rows=36 width=2358)
+                                            Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18","_col20","_col22"]
+                                          <-Reducer 22 [CUSTOM_SIMPLE_EDGE]
+                                            PARTITION_ONLY_SHUFFLE [RS_396]
+                                              Merge Join Operator [MERGEJOIN_476] (rows=36 width=2069)
+                                                Conds:(Inner),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18","_col20"]
+                                              <-Reducer 21 [CUSTOM_SIMPLE_EDGE]
+                                                PARTITION_ONLY_SHUFFLE [RS_393]
+                                                  Merge Join Operator [MERGEJOIN_475] (rows=36 width=2060)
+                                                    Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18","_col20"]
+                                                  <-Reducer 20 [CUSTOM_SIMPLE_EDGE]
+                                                    PARTITION_ONLY_SHUFFLE [RS_390]
+                                                      Merge Join Operator [MERGEJOIN_474] (rows=36 width=2051)
+                                                        Conds:(Inner),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18"]
+                                                      <-Reducer 19 [CUSTOM_SIMPLE_EDGE]
+                                                        PARTITION_ONLY_SHUFFLE [RS_387]
+                                                          Merge Join Operator [MERGEJOIN_473] (rows=36 width=2042)
+                                                            Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16","_col18"]
+                                                          <-Reducer 18 [CUSTOM_SIMPLE_EDGE]
+                                                            PARTITION_ONLY_SHUFFLE [RS_384]
+                                                              Merge Join Operator [MERGEJOIN_472] (rows=36 width=1753)
+                                                                Conds:(Inner),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16"]
+                                                              <-Reducer 17 [CUSTOM_SIMPLE_EDGE]
+                                                                PARTITION_ONLY_SHUFFLE [RS_381]
+                                                                  Merge Join Operator [MERGEJOIN_471] (rows=36 width=1744)
+                                                                    Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14","_col16"]
+                                                                  <-Reducer 16 [CUSTOM_SIMPLE_EDGE]
+                                                                    PARTITION_ONLY_SHUFFLE [RS_378]
+                                                                      Merge Join Operator [MERGEJOIN_470] (rows=36 width=1455)
+                                                                        Conds:(Inner),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14"]
+                                                                      <-Reducer 15 [CUSTOM_SIMPLE_EDGE]
+                                                                        PARTITION_ONLY_SHUFFLE [RS_375]
+                                                                          Merge Join Operator [MERGEJOIN_469] (rows=36 width=1446)
+                                                                            Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8","_col10","_col12","_col14"]
+                                                                          <-Reducer 14 [CUSTOM_SIMPLE_EDGE]
+                                                                            PARTITION_ONLY_SHUFFLE [RS_372]
+                                                                              Merge Join Operator [MERGEJOIN_468] (rows=36 width=1437)
+                                                                                Conds:(Inner),Output:["_col2","_col4","_col6","_col8","_col10","_col12"]
+                                                                              <-Reducer 13 [CUSTOM_SIMPLE_EDGE]
+                                                                                PARTITION_ONLY_SHUFFLE [RS_369]
+                                                                                  Merge Join Operator [MERGEJOIN_467] (rows=36 width=1428)
+                                                                                    Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8","_col10","_col12"]
+                                                                                  <-Reducer 12 [CUSTOM_SIMPLE_EDGE]
+                                                                                    PARTITION_ONLY_SHUFFLE [RS_366]
+                                                                                      Merge Join Operator [MERGEJOIN_466] (rows=36 width=1139)
+                                                                                        Conds:(Inner),Output:["_col2","_col4","_col6","_col8","_col10"]
+                                                                                      <-Reducer 11 [CUSTOM_SIMPLE_EDGE]
+                                                                                        PARTITION_ONLY_SHUFFLE [RS_363]
+                                                                                          Merge Join Operator [MERGEJOIN_465] (rows=36 width=1130)
+                                                                                            Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8","_col10"]
+                                                                                          <-Reducer 10 [CUSTOM_SIMPLE_EDGE]
+                                                                                            PARTITION_ONLY_SHUFFLE [RS_360]
+                                                                                              Merge Join Operator [MERGEJOIN_464] (rows=36 width=841)
+                                                                                                Conds:(Inner),Output:["_col2","_col4","_col6","_col8"]
+                                                                                              <-Reducer 49 [CUSTOM_SIMPLE_EDGE]
+                                                                                                PARTITION_ONLY_SHUFFLE [RS_358]
+                                                                                                  Select Operator [SEL_105] (rows=1 width=8)
+                                                                                                    Filter Operator [FIL_104] (rows=1 width=8)
+                                                                                                      predicate:(sq_count_check(_col0) <= 1)
+                                                                                                      Group By Operator [GBY_102] (rows=1 width=8)
+                                                                                                        Output:["_col0"],aggregations:["count()"]
+                                                                                                        Select Operator [SEL_97] (rows=1 width=8)
+                                                                                                          Group By Operator [GBY_96] (rows=1 width=8)
+                                                                                                            Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                                                          <-Map 48 [CUSTOM_SIMPLE_EDGE]
+                                                                                                            PARTITION_ONLY_SHUFFLE [RS_95]
+                                                                                                              Group By Operator [GBY_94] (rows=1 width=8)
+                                                                                                                Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                                                                                Select Operator [SEL_93] (rows=63999515 width=88)
+                                                                                                                  Output:["ss_sold_date_sk"]
+                                                                                                                  Filter Operator [FIL_434] (rows=63999515 width=88)
+                                                                                                                    predicate:ss_quantity BETWEEN 21 AND 40
+                                                                                                                    TableScan [TS_91] (rows=575995635 width=88)
+                                                                                                                      default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                                                                              <-Reducer 9 [CUSTOM_SIMPLE_EDGE]
+                                                                                                PARTITION_ONLY_SHUFFLE [RS_357]
+                                                                                                  Merge Join Operator [MERGEJOIN_463] (rows=36 width=832)
+                                                                                                    Conds:(Left Outer),Output:["_col2","_col4","_col6","_col8"]
+                                                                                                  <-Reducer 47 [CUSTOM_SIMPLE_EDGE]
+                                                                                                    PARTITION_ONLY_SHUFFLE [RS_355]
+                                                                                                      Group By Operator [GBY_89] (rows=1 width=8)
+                                                                                                        Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                                                      <-Map 46 [CUSTOM_SIMPLE_EDGE]
+                                                                                                        PARTITION_ONLY_SHUFFLE [RS_88]
+                                                                                                          Group By Operator [GBY_87] (rows=1 width=8)
+                                                                                                            Output:["_col0"],aggregations:["count()"]
+                                                                                                            Select Operator [SEL_86] (rows=63999515 width=88)
+                                                                                                              Filter Operator [FIL_433] (rows=63999515 width=88)
+                                                                                                                predicate:ss_quantity BETWEEN 21 AND 40
+                                                                                                                TableScan [TS_84] (rows=575995635 width=88)
+                                                                                                                  default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity"]
+                                                                                                  <-Reducer 8 [CUSTOM_SIMPLE_EDGE]
+                                                                                                    PARTITION_ONLY_SHUFFLE [RS_354]
+                                                                                                      Merge Join Operator [MERGEJOIN_462] (rows=36 width=823)
+                                                                                                        Conds:(Inner),Output:["_col2","_col4","_col6"]
+                                                                                                      <-Reducer 45 [CUSTOM_SIMPLE_EDGE]
+                                                                                                        PARTITION_ONLY_SHUFFLE [RS_352]
+                                                                                                          Select Operator [SEL_83] (rows=1 width=8)
+                                                                                                            Filter Operator [FIL_82] (rows=1 width=8)
+                                                                                                              predicate:(sq_count_check(_col0) <= 1)
+                                                                                                              Group By Operator [GBY_80] (rows=1 width=8)
+                                                                                                                Output:["_col0"],aggregations:["count()"]
+                                                                                                                Select Operator [SEL_75] (rows=1 width=8)
+                                                                                                                  Group By Operator [GBY_74] (rows=1 width=8)
+                                                                                                                    Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                                                                  <-Map 44 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                    PARTITION_ONLY_SHUFFLE [RS_73]
+                                                                                                                      Group By Operator [GBY_72] (rows=1 width=8)
+                                                                                                                        Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                                                                                        Select Operator [SEL_71] (rows=63999515 width=88)
+                                                                                                                          Output:["ss_sold_date_sk"]
+                                                                                                                          Filter Operator [FIL_432] (rows=63999515 width=88)
+                                                                                                                            predicate:ss_quantity BETWEEN 21 AND 40
+                                                                                                                            TableScan [TS_69] (rows=575995635 width=88)
+                                                                                                                              default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                                                                                      <-Reducer 7 [CUSTOM_SIMPLE_EDGE]
+                                                                                                        PARTITION_ONLY_SHUFFLE [RS_351]
+                                                                                                          Merge Join Operator [MERGEJOIN_461] (rows=36 width=814)
+                                                                                                            Conds:(Left Outer),Output:["_col2","_col4","_col6"]
+                                                                                                          <-Reducer 43 [CUSTOM_SIMPLE_EDGE]
+                                                                                                            PARTITION_ONLY_SHUFFLE [RS_349]
+                                                                                                              Group By Operator [GBY_67] (rows=1 width=288)
+                                                                                                                Output:["_col0"],aggregations:["avg(VALUE._col0)"]
+                                                                                                              <-Map 42 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                PARTITION_ONLY_SHUFFLE [RS_66]
+                                                                                                                  Group By Operator [GBY_65] (rows=1 width=288)
+                                                                                                                    Output:["_col0"],aggregations:["avg(ss_net_paid_inc_tax)"]
+                                                                                                                    Select Operator [SEL_64] (rows=63999515 width=88)
+                                                                                                                      Output:["ss_net_paid_inc_tax"]
+                                                                                                                      Filter Operator [FIL_431] (rows=63999515 width=88)
+                                                                                                                        predicate:ss_quantity BETWEEN 1 AND 20
+                                                                                                                        TableScan [TS_62] (rows=575995635 width=88)
+                                                                                                                          default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_net_paid_inc_tax"]
+                                                                                                          <-Reducer 6 [CUSTOM_SIMPLE_EDGE]
+                                                                                                            PARTITION_ONLY_SHUFFLE [RS_348]
+                                                                                                              Merge Join Operator [MERGEJOIN_460] (rows=36 width=525)
+                                                                                                                Conds:(Inner),Output:["_col2","_col4"]
+                                                                                                              <-Reducer 41 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                PARTITION_ONLY_SHUFFLE [RS_346]
+                                                                                                                  Select Operator [SEL_61] (rows=1 width=8)
+                                                                                                                    Filter Operator [FIL_60] (rows=1 width=8)
+                                                                                                                      predicate:(sq_count_check(_col0) <= 1)
+                                                                                                                      Group By Operator [GBY_58] (rows=1 width=8)
+                                                                                                                        Output:["_col0"],aggregations:["count()"]
+                                                                                                                        Select Operator [SEL_53] (rows=1 width=8)
+                                                                                                                          Group By Operator [GBY_52] (rows=1 width=8)
+                                                                                                                            Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                                                                          <-Map 40 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                            PARTITION_ONLY_SHUFFLE [RS_51]
+                                                                                                                              Group By Operator [GBY_50] (rows=1 width=8)
+                                                                                                                                Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                                                                                                Select Operator [SEL_49] (rows=63999515 width=88)
+                                                                                                                                  Output:["ss_sold_date_sk"]
+                                                                                                                                  Filter Operator [FIL_430] (rows=63999515 width=88)
+                                                                                                                                    predicate:ss_quantity BETWEEN 1 AND 20
+                                                                                                                                    TableScan [TS_47] (rows=575995635 width=88)
+                                                                                                                                      default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                                                                                              <-Reducer 5 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                PARTITION_ONLY_SHUFFLE [RS_345]
+                                                                                                                  Merge Join Operator [MERGEJOIN_459] (rows=36 width=516)
+                                                                                                                    Conds:(Left Outer),Output:["_col2","_col4"]
+                                                                                                                  <-Reducer 39 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                    PARTITION_ONLY_SHUFFLE [RS_343]
+                                                                                                                      Group By Operator [GBY_45] (rows=1 width=288)
+                                                                                                                        Output:["_col0"],aggregations:["avg(VALUE._col0)"]
+                                                                                                                      <-Map 38 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                        PARTITION_ONLY_SHUFFLE [RS_44]
+                                                                                                                          Group By Operator [GBY_43] (rows=1 width=288)
+                                                                                                                            Output:["_col0"],aggregations:["avg(ss_ext_list_price)"]
+                                                                                                                            Select Operator [SEL_42] (rows=63999515 width=88)
+                                                                                                                              Output:["ss_ext_list_price"]
+                                                                                                                              Filter Operator [FIL_429] (rows=63999515 width=88)
+                                                                                                                                predicate:ss_quantity BETWEEN 1 AND 20
+                                                                                                                                TableScan [TS_40] (rows=575995635 width=88)
+                                                                                                                                  default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_ext_list_price"]
+                                                                                                                  <-Reducer 4 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                    PARTITION_ONLY_SHUFFLE [RS_342]
+                                                                                                                      Merge Join Operator [MERGEJOIN_458] (rows=36 width=227)
+                                                                                                                        Conds:(Inner),Output:["_col2"]
+                                                                                                                      <-Reducer 3 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                        PARTITION_ONLY_SHUFFLE [RS_339]
+                                                                                                                          Merge Join Operator [MERGEJOIN_457] (rows=36 width=218)
+                                                                                                                            Conds:(Left Outer),Output:["_col2"]
+                                                                                                                          <-Reducer 2 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                            PARTITION_ONLY_SHUFFLE [RS_336]
+                                                                                                                              Merge Join Operator [MERGEJOIN_456] (rows=36 width=209)
+                                                                                                                                Conds:(Inner)
+                                                                                                                              <-Map 1 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                                PARTITION_ONLY_SHUFFLE [RS_333]
+                                                                                                                                  Select Operator [SEL_2] (rows=36 width=200)
+                                                                                                                                    Filter Operator [FIL_425] (rows=36 width=200)
+                                                                                                                                      predicate:(r_reason_sk = 1)
+                                                                                                                                      TableScan [TS_0] (rows=72 width=200)
+                                                                                                                                        default@reason,reason,Tbl:COMPLETE,Col:NONE,Output:["r_reason_sk"]
+                                                                                                                              <-Reducer 33 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                                PARTITION_ONLY_SHUFFLE [RS_334]
+                                                                                                                                  Select Operator [SEL_17] (rows=1 width=8)
+                                                                                                                                    Filter Operator [FIL_16] (rows=1 width=8)
+                                                                                                                                      predicate:(sq_count_check(_col0) <= 1)
+                                                                                                                                      Group By Operator [GBY_14] (rows=1 width=8)
+                                                                                                                                        Output:["_col0"],aggregations:["count()"]
+                                                                                                                                        Select Operator [SEL_9] (rows=1 width=8)
+                                                                                                                                          Group By Operator [GBY_8] (rows=1 width=8)
+                                                                                                                                            Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                                                                                          <-Map 32 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                                            PARTITION_ONLY_SHUFFLE [RS_7]
+                                                                                                                                              Group By Operator [GBY_6] (rows=1 width=8)
+                                                                                                                                                Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                                                                                                                Select Operator [SEL_5] (rows=63999515 width=88)
+                                                                                                                                                  Output:["ss_sold_date_sk"]
+                                                                                                                                                  Filter Operator [FIL_426] (rows=63999515 width=88)
+                                                                                                                                                    predicate:ss_quantity BETWEEN 1 AND 20
+                                                                                                                                                    TableScan [TS_3] (rows=575995635 width=88)
+                                                                                                                                                      default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                                                                                                          <-Reducer 35 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                            PARTITION_ONLY_SHUFFLE [RS_337]
+                                                                                                                              Group By Operator [GBY_23] (rows=1 width=8)
+                                                                                                                                Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                                                                              <-Map 34 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                                PARTITION_ONLY_SHUFFLE [RS_22]
+                                                                                                                                  Group By Operator [GBY_21] (rows=1 width=8)
+                                                                                                                                    Output:["_col0"],aggregations:["count()"]
+                                                                                                                                    Select Operator [SEL_20] (rows=63999515 width=88)
+                                                                                                                                      Filter Operator [FIL_427] (rows=63999515 width=88)
+                                                                                                                                        predicate:ss_quantity BETWEEN 1 AND 20
+                                                                                                                                        TableScan [TS_18] (rows=575995635 width=88)
+                                                                                                                                          default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity"]
+                                                                                                                      <-Reducer 37 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                        PARTITION_ONLY_SHUFFLE [RS_340]
+                                                                                                                          Select Operator [SEL_39] (rows=1 width=8)
+                                                                                                                            Filter Operator [FIL_38] (rows=1 width=8)
+                                                                                                                              predicate:(sq_count_check(_col0) <= 1)
+                                                                                                                              Group By Operator [GBY_36] (rows=1 width=8)
+                                                                                                                                Output:["_col0"],aggregations:["count()"]
+                                                                                                                                Select Operator [SEL_31] (rows=1 width=8)
+                                                                                                                                  Group By Operator [GBY_30] (rows=1 width=8)
+                                                                                                                                    Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                                                                                  <-Map 36 [CUSTOM_SIMPLE_EDGE]
+                                                                                                                                    PARTITION_ONLY_SHUFFLE [RS_29]
+                                                                                                                                      Group By Operator [GBY_28] (rows=1 width=8)
+                                                                                                                                        Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                                                                                                        Select Operator [SEL_27] (rows=63999515 width=88)
+                                                                                                                                          Output:["ss_sold_date_sk"]
+                                                                                                                                          Filter Operator [FIL_428] (rows=63999515 width=88)
+                                                                                                                                            predicate:ss_quantity BETWEEN 1 AND 20
+                                                                                                                                            TableScan [TS_25] (rows=575995635 width=88)
+                                                                                                                                              default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                                                                          <-Reducer 51 [CUSTOM_SIMPLE_EDGE]
+                                                                                            PARTITION_ONLY_SHUFFLE [RS_361]
+                                                                                              Group By Operator [GBY_111] (rows=1 width=288)
+                                                                                                Output:["_col0"],aggregations:["avg(VALUE._col0)"]
+                                                                                              <-Map 50 [CUSTOM_SIMPLE_EDGE]
+                                                                                                PARTITION_ONLY_SHUFFLE [RS_110]
+                                                                                                  Group By Operator [GBY_109] (rows=1 width=288)
+                                                                                                    Output:["_col0"],aggregations:["avg(ss_ext_list_price)"]
+                                                                                                    Select Operator [SEL_108] (rows=63999515 width=88)
+                                                                                                      Output:["ss_ext_list_price"]
+                                                                                                      Filter Operator [FIL_435] (rows=63999515 width=88)
+                                                                                                        predicate:ss_quantity BETWEEN 21 AND 40
+                                                                                                        TableScan [TS_106] (rows=575995635 width=88)
+                                                                                                          default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_ext_list_price"]
+                                                                                      <-Reducer 53 [CUSTOM_SIMPLE_EDGE]
+                                                                                        PARTITION_ONLY_SHUFFLE [RS_364]
+                                                                                          Select Operator [SEL_127] (rows=1 width=8)
+                                                                                            Filter Operator [FIL_126] (rows=1 width=8)
+                                                                                              predicate:(sq_count_check(_col0) <= 1)
+                                                                                              Group By Operator [GBY_124] (rows=1 width=8)
+                                                                                                Output:["_col0"],aggregations:["count()"]
+                                                                                                Select Operator [SEL_119] (rows=1 width=8)
+                                                                                                  Group By Operator [GBY_118] (rows=1 width=8)
+                                                                                                    Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                                                  <-Map 52 [CUSTOM_SIMPLE_EDGE]
+                                                                                                    PARTITION_ONLY_SHUFFLE [RS_117]
+                                                                                                      Group By Operator [GBY_116] (rows=1 width=8)
+                                                                                                        Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                                                                        Select Operator [SEL_115] (rows=63999515 width=88)
+                                                                                                          Output:["ss_sold_date_sk"]
+                                                                                                          Filter Operator [FIL_436] (rows=63999515 width=88)
+                                                                                                            predicate:ss_quantity BETWEEN 21 AND 40
+                                                                                                            TableScan [TS_113] (rows=575995635 width=88)
+                                                                                                              default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                                                                  <-Reducer 55 [CUSTOM_SIMPLE_EDGE]
+                                                                                    PARTITION_ONLY_SHUFFLE [RS_367]
+                                                                                      Group By Operator [GBY_133] (rows=1 width=288)
+                                                                                        Output:["_col0"],aggregations:["avg(VALUE._col0)"]
+                                                                                      <-Map 54 [CUSTOM_SIMPLE_EDGE]
+                                                                                        PARTITION_ONLY_SHUFFLE [RS_132]
+                                                                                          Group By Operator [GBY_131] (rows=1 width=288)
+                                                                                            Output:["_col0"],aggregations:["avg(ss_net_paid_inc_tax)"]
+                                                                                            Select Operator [SEL_130] (rows=63999515 width=88)
+                                                                                              Output:["ss_net_paid_inc_tax"]
+                                                                                              Filter Operator [FIL_437] (rows=63999515 width=88)
+                                                                                                predicate:ss_quantity BETWEEN 21 AND 40
+                                                                                                TableScan [TS_128] (rows=575995635 width=88)
+                                                                                                  default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_net_paid_inc_tax"]
+                                                                              <-Reducer 57 [CUSTOM_SIMPLE_EDGE]
+                                                                                PARTITION_ONLY_SHUFFLE [RS_370]
+                                                                                  Select Operator [SEL_149] (rows=1 width=8)
+                                                                                    Filter Operator [FIL_148] (rows=1 width=8)
+                                                                                      predicate:(sq_count_check(_col0) <= 1)
+                                                                                      Group By Operator [GBY_146] (rows=1 width=8)
+                                                                                        Output:["_col0"],aggregations:["count()"]
+                                                                                        Select Operator [SEL_141] (rows=1 width=8)
+                                                                                          Group By Operator [GBY_140] (rows=1 width=8)
+                                                                                            Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                                          <-Map 56 [CUSTOM_SIMPLE_EDGE]
+                                                                                            PARTITION_ONLY_SHUFFLE [RS_139]
+                                                                                              Group By Operator [GBY_138] (rows=1 width=8)
+                                                                                                Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                                                                Select Operator [SEL_137] (rows=63999515 width=88)
+                                                                                                  Output:["ss_sold_date_sk"]
+                                                                                                  Filter Operator [FIL_438] (rows=63999515 width=88)
+                                                                                                    predicate:ss_quantity BETWEEN 41 AND 60
+                                                                                                    TableScan [TS_135] (rows=575995635 width=88)
+                                                                                                      default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                                                          <-Reducer 59 [CUSTOM_SIMPLE_EDGE]
+                                                                            PARTITION_ONLY_SHUFFLE [RS_373]
+                                                                              Group By Operator [GBY_155] (rows=1 width=8)
+                                                                                Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                              <-Map 58 [CUSTOM_SIMPLE_EDGE]
+                                                                                PARTITION_ONLY_SHUFFLE [RS_154]
+                                                                                  Group By Operator [GBY_153] (rows=1 width=8)
+                                                                                    Output:["_col0"],aggregations:["count()"]
+                                                                                    Select Operator [SEL_152] (rows=63999515 width=88)
+                                                                                      Filter Operator [FIL_439] (rows=63999515 width=88)
+                                                                                        predicate:ss_quantity BETWEEN 41 AND 60
+                                                                                        TableScan [TS_150] (rows=575995635 width=88)
+                                                                                          default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity"]
+                                                                      <-Reducer 61 [CUSTOM_SIMPLE_EDGE]
+                                                                        PARTITION_ONLY_SHUFFLE [RS_376]
+                                                                          Select Operator [SEL_171] (rows=1 width=8)
+                                                                            Filter Operator [FIL_170] (rows=1 width=8)
+                                                                              predicate:(sq_count_check(_col0) <= 1)
+                                                                              Group By Operator [GBY_168] (rows=1 width=8)
+                                                                                Output:["_col0"],aggregations:["count()"]
+                                                                                Select Operator [SEL_163] (rows=1 width=8)
+                                                                                  Group By Operator [GBY_162] (rows=1 width=8)
+                                                                                    Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                                  <-Map 60 [CUSTOM_SIMPLE_EDGE]
+                                                                                    PARTITION_ONLY_SHUFFLE [RS_161]
+                                                                                      Group By Operator [GBY_160] (rows=1 width=8)
+                                                                                        Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                                                        Select Operator [SEL_159] (rows=63999515 width=88)
+                                                                                          Output:["ss_sold_date_sk"]
+                                                                                          Filter Operator [FIL_440] (rows=63999515 width=88)
+                                                                                            predicate:ss_quantity BETWEEN 41 AND 60
+                                                                                            TableScan [TS_157] (rows=575995635 width=88)
+                                                                                              default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                                                  <-Reducer 63 [CUSTOM_SIMPLE_EDGE]
+                                                                    PARTITION_ONLY_SHUFFLE [RS_379]
+                                                                      Group By Operator [GBY_177] (rows=1 width=288)
+                                                                        Output:["_col0"],aggregations:["avg(VALUE._col0)"]
+                                                                      <-Map 62 [CUSTOM_SIMPLE_EDGE]
+                                                                        PARTITION_ONLY_SHUFFLE [RS_176]
+                                                                          Group By Operator [GBY_175] (rows=1 width=288)
+                                                                            Output:["_col0"],aggregations:["avg(ss_ext_list_price)"]
+                                                                            Select Operator [SEL_174] (rows=63999515 width=88)
+                                                                              Output:["ss_ext_list_price"]
+                                                                              Filter Operator [FIL_441] (rows=63999515 width=88)
+                                                                                predicate:ss_quantity BETWEEN 41 AND 60
+                                                                                TableScan [TS_172] (rows=575995635 width=88)
+                                                                                  default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_ext_list_price"]
+                                                              <-Reducer 65 [CUSTOM_SIMPLE_EDGE]
+                                                                PARTITION_ONLY_SHUFFLE [RS_382]
+                                                                  Select Operator [SEL_193] (rows=1 width=8)
+                                                                    Filter Operator [FIL_192] (rows=1 width=8)
+                                                                      predicate:(sq_count_check(_col0) <= 1)
+                                                                      Group By Operator [GBY_190] (rows=1 width=8)
+                                                                        Output:["_col0"],aggregations:["count()"]
+                                                                        Select Operator [SEL_185] (rows=1 width=8)
+                                                                          Group By Operator [GBY_184] (rows=1 width=8)
+                                                                            Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                          <-Map 64 [CUSTOM_SIMPLE_EDGE]
+                                                                            PARTITION_ONLY_SHUFFLE [RS_183]
+                                                                              Group By Operator [GBY_182] (rows=1 width=8)
+                                                                                Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                                                Select Operator [SEL_181] (rows=63999515 width=88)
+                                                                                  Output:["ss_sold_date_sk"]
+                                                                                  Filter Operator [FIL_442] (rows=63999515 width=88)
+                                                                                    predicate:ss_quantity BETWEEN 41 AND 60
+                                                                                    TableScan [TS_179] (rows=575995635 width=88)
+                                                                                      default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                                          <-Reducer 67 [CUSTOM_SIMPLE_EDGE]
+                                                            PARTITION_ONLY_SHUFFLE [RS_385]
+                                                              Group By Operator [GBY_199] (rows=1 width=288)
+                                                                Output:["_col0"],aggregations:["avg(VALUE._col0)"]
+                                                              <-Map 66 [CUSTOM_SIMPLE_EDGE]
+                                                                PARTITION_ONLY_SHUFFLE [RS_198]
+                                                                  Group By Operator [GBY_197] (rows=1 width=288)
+                                                                    Output:["_col0"],aggregations:["avg(ss_net_paid_inc_tax)"]
+                                                                    Select Operator [SEL_196] (rows=63999515 width=88)
+                                                                      Output:["ss_net_paid_inc_tax"]
+                                                                      Filter Operator [FIL_443] (rows=63999515 width=88)
+                                                                        predicate:ss_quantity BETWEEN 41 AND 60
+                                                                        TableScan [TS_194] (rows=575995635 width=88)
+                                                                          default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_net_paid_inc_tax"]
+                                                      <-Reducer 69 [CUSTOM_SIMPLE_EDGE]
+                                                        PARTITION_ONLY_SHUFFLE [RS_388]
+                                                          Select Operator [SEL_215] (rows=1 width=8)
+                                                            Filter Operator [FIL_214] (rows=1 width=8)
+                                                              predicate:(sq_count_check(_col0) <= 1)
+                                                              Group By Operator [GBY_212] (rows=1 width=8)
+                                                                Output:["_col0"],aggregations:["count()"]
+                                                                Select Operator [SEL_207] (rows=1 width=8)
+                                                                  Group By Operator [GBY_206] (rows=1 width=8)
+                                                                    Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                                  <-Map 68 [CUSTOM_SIMPLE_EDGE]
+                                                                    PARTITION_ONLY_SHUFFLE [RS_205]
+                                                                      Group By Operator [GBY_204] (rows=1 width=8)
+                                                                        Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                                        Select Operator [SEL_203] (rows=63999515 width=88)
+                                                                          Output:["ss_sold_date_sk"]
+                                                                          Filter Operator [FIL_444] (rows=63999515 width=88)
+                                                                            predicate:ss_quantity BETWEEN 61 AND 80
+                                                                            TableScan [TS_201] (rows=575995635 width=88)
+                                                                              default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                                  <-Reducer 71 [CUSTOM_SIMPLE_EDGE]
+                                                    PARTITION_ONLY_SHUFFLE [RS_391]
+                                                      Group By Operator [GBY_221] (rows=1 width=8)
+                                                        Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                      <-Map 70 [CUSTOM_SIMPLE_EDGE]
+                                                        PARTITION_ONLY_SHUFFLE [RS_220]
+                                                          Group By Operator [GBY_219] (rows=1 width=8)
+                                                            Output:["_col0"],aggregations:["count()"]
+                                                            Select Operator [SEL_218] (rows=63999515 width=88)
+                                                              Filter Operator [FIL_445] (rows=63999515 width=88)
+                                                                predicate:ss_quantity BETWEEN 61 AND 80
+                                                                TableScan [TS_216] (rows=575995635 width=88)
+                                                                  default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity"]
+                                              <-Reducer 73 [CUSTOM_SIMPLE_EDGE]
+                                                PARTITION_ONLY_SHUFFLE [RS_394]
+                                                  Select Operator [SEL_237] (rows=1 width=8)
+                                                    Filter Operator [FIL_236] (rows=1 width=8)
+                                                      predicate:(sq_count_check(_col0) <= 1)
+                                                      Group By Operator [GBY_234] (rows=1 width=8)
+                                                        Output:["_col0"],aggregations:["count()"]
+                                                        Select Operator [SEL_229] (rows=1 width=8)
+                                                          Group By Operator [GBY_228] (rows=1 width=8)
+                                                            Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                          <-Map 72 [CUSTOM_SIMPLE_EDGE]
+                                                            PARTITION_ONLY_SHUFFLE [RS_227]
+                                                              Group By Operator [GBY_226] (rows=1 width=8)
+                                                                Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                                Select Operator [SEL_225] (rows=63999515 width=88)
+                                                                  Output:["ss_sold_date_sk"]
+                                                                  Filter Operator [FIL_446] (rows=63999515 width=88)
+                                                                    predicate:ss_quantity BETWEEN 61 AND 80
+                                                                    TableScan [TS_223] (rows=575995635 width=88)
+                                                                      default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                          <-Reducer 75 [CUSTOM_SIMPLE_EDGE]
+                                            PARTITION_ONLY_SHUFFLE [RS_397]
+                                              Group By Operator [GBY_243] (rows=1 width=288)
+                                                Output:["_col0"],aggregations:["avg(VALUE._col0)"]
+                                              <-Map 74 [CUSTOM_SIMPLE_EDGE]
+                                                PARTITION_ONLY_SHUFFLE [RS_242]
+                                                  Group By Operator [GBY_241] (rows=1 width=288)
+                                                    Output:["_col0"],aggregations:["avg(ss_ext_list_price)"]
+                                                    Select Operator [SEL_240] (rows=63999515 width=88)
+                                                      Output:["ss_ext_list_price"]
+                                                      Filter Operator [FIL_447] (rows=63999515 width=88)
+                                                        predicate:ss_quantity BETWEEN 61 AND 80
+                                                        TableScan [TS_238] (rows=575995635 width=88)
+                                                          default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_ext_list_price"]
+                                      <-Reducer 77 [CUSTOM_SIMPLE_EDGE]
+                                        PARTITION_ONLY_SHUFFLE [RS_400]
+                                          Select Operator [SEL_259] (rows=1 width=8)
+                                            Filter Operator [FIL_258] (rows=1 width=8)
+                                              predicate:(sq_count_check(_col0) <= 1)
+                                              Group By Operator [GBY_256] (rows=1 width=8)
+                                                Output:["_col0"],aggregations:["count()"]
+                                                Select Operator [SEL_251] (rows=1 width=8)
+                                                  Group By Operator [GBY_250] (rows=1 width=8)
+                                                    Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                                  <-Map 76 [CUSTOM_SIMPLE_EDGE]
+                                                    PARTITION_ONLY_SHUFFLE [RS_249]
+                                                      Group By Operator [GBY_248] (rows=1 width=8)
+                                                        Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                        Select Operator [SEL_247] (rows=63999515 width=88)
+                                                          Output:["ss_sold_date_sk"]
+                                                          Filter Operator [FIL_448] (rows=63999515 width=88)
+                                                            predicate:ss_quantity BETWEEN 61 AND 80
+                                                            TableScan [TS_245] (rows=575995635 width=88)
+                                                              default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                                  <-Reducer 79 [CUSTOM_SIMPLE_EDGE]
+                                    PARTITION_ONLY_SHUFFLE [RS_403]
+                                      Group By Operator [GBY_265] (rows=1 width=288)
+                                        Output:["_col0"],aggregations:["avg(VALUE._col0)"]
+                                      <-Map 78 [CUSTOM_SIMPLE_EDGE]
+                                        PARTITION_ONLY_SHUFFLE [RS_264]
+                                          Group By Operator [GBY_263] (rows=1 width=288)
+                                            Output:["_col0"],aggregations:["avg(ss_net_paid_inc_tax)"]
+                                            Select Operator [SEL_262] (rows=63999515 width=88)
+                                              Output:["ss_net_paid_inc_tax"]
+                                              Filter Operator [FIL_449] (rows=63999515 width=88)
+                                                predicate:ss_quantity BETWEEN 61 AND 80
+                                                TableScan [TS_260] (rows=575995635 width=88)
+                                                  default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_net_paid_inc_tax"]
+                              <-Reducer 81 [CUSTOM_SIMPLE_EDGE]
+                                PARTITION_ONLY_SHUFFLE [RS_406]
+                                  Select Operator [SEL_281] (rows=1 width=8)
+                                    Filter Operator [FIL_280] (rows=1 width=8)
+                                      predicate:(sq_count_check(_col0) <= 1)
+                                      Group By Operator [GBY_278] (rows=1 width=8)
+                                        Output:["_col0"],aggregations:["count()"]
+                                        Select Operator [SEL_273] (rows=1 width=8)
+                                          Group By Operator [GBY_272] (rows=1 width=8)
+                                            Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                                          <-Map 80 [CUSTOM_SIMPLE_EDGE]
+                                            PARTITION_ONLY_SHUFFLE [RS_271]
+                                              Group By Operator [GBY_270] (rows=1 width=8)
+                                                Output:["_col0"],aggregations:["count(ss_sold_date_sk)"]
+                                                Select Operator [SEL_269] (rows=63999515 width=88)
+                                                  Output:["ss_sold_date_sk"]
+                                                  Filter Operator [FIL_450] (rows=63999515 width=88)
+                                                    predicate:ss_quantity BETWEEN 81 AND 100
+                                                    TableScan [TS_267] (rows=575995635 width=88)
+                                                      default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_sold_date_sk","ss_quantity"]
+                          <-Reducer 83 [CUSTOM_SIMPLE_EDGE]
+                            PARTITION_ONLY_SHUFFLE [RS_409]
+                              Group By Operator [GBY_287] (rows=1 width=8)
+                                Output:["_col0"],aggregations:["count(VALUE._col0)"]
+                              <-Map 82 [CUSTOM_SIMPLE_EDGE]
+              

<TRUNCATED>

Mime
View raw message