hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From prasan...@apache.org
Subject [1/6] hive git commit: Revert "HIVE-16330 : Improve plans for scalar subquery with aggregates (Vineet Garg via Ashutosh Chauhan)"
Date Wed, 10 May 2017 06:08:40 GMT
Repository: hive
Updated Branches:
  refs/heads/master a113ede99 -> cde41e9ea


http://git-wip-us.apache.org/repos/asf/hive/blob/cde41e9e/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
index 3c913e1..d714d41 100644
--- a/ql/src/test/results/clientpositive/perf/query9.q.out
+++ b/ql/src/test/results/clientpositive/perf/query9.q.out
@@ -1,18 +1,33 @@
-Warning: Shuffle Join MERGEJOIN[171][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
-Warning: Shuffle Join MERGEJOIN[172][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product
-Warning: Shuffle Join MERGEJOIN[173][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3]] in Stage 'Reducer 4' is a cross product
-Warning: Shuffle Join MERGEJOIN[174][tables = [$hdt$_0, $hdt$_1, $hdt$_2, $hdt$_3, $hdt$_4]] in Stage 'Reducer 5' is a cross product
-Warning: Shuffle Join MERGEJOIN[175][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[176][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[177][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[178][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[179][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[180][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[181][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[182][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[183][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[184][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[185][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[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
@@ -112,313 +127,703 @@ POSTHOOK: type: QUERY
 Plan optimized by CBO.
 
 Vertex dependency in root stage
-Reducer 10 <- Reducer 34 (CUSTOM_SIMPLE_EDGE), Reducer 9 (CUSTOM_SIMPLE_EDGE)
-Reducer 11 <- Reducer 10 (CUSTOM_SIMPLE_EDGE), Reducer 36 (CUSTOM_SIMPLE_EDGE)
-Reducer 12 <- Reducer 11 (CUSTOM_SIMPLE_EDGE), Reducer 38 (CUSTOM_SIMPLE_EDGE)
-Reducer 13 <- Reducer 12 (CUSTOM_SIMPLE_EDGE), Reducer 40 (CUSTOM_SIMPLE_EDGE)
-Reducer 14 <- Reducer 13 (CUSTOM_SIMPLE_EDGE), Reducer 42 (CUSTOM_SIMPLE_EDGE)
-Reducer 15 <- Reducer 14 (CUSTOM_SIMPLE_EDGE), Reducer 44 (CUSTOM_SIMPLE_EDGE)
-Reducer 16 <- Reducer 15 (CUSTOM_SIMPLE_EDGE), Reducer 46 (CUSTOM_SIMPLE_EDGE)
-Reducer 18 <- Map 17 (CUSTOM_SIMPLE_EDGE)
-Reducer 2 <- Map 1 (CUSTOM_SIMPLE_EDGE), Reducer 18 (CUSTOM_SIMPLE_EDGE)
-Reducer 20 <- Map 19 (CUSTOM_SIMPLE_EDGE)
-Reducer 22 <- Map 21 (CUSTOM_SIMPLE_EDGE)
-Reducer 24 <- Map 23 (CUSTOM_SIMPLE_EDGE)
-Reducer 26 <- Map 25 (CUSTOM_SIMPLE_EDGE)
-Reducer 28 <- Map 27 (CUSTOM_SIMPLE_EDGE)
-Reducer 3 <- Reducer 2 (CUSTOM_SIMPLE_EDGE), Reducer 20 (CUSTOM_SIMPLE_EDGE)
-Reducer 30 <- Map 29 (CUSTOM_SIMPLE_EDGE)
-Reducer 32 <- Map 31 (CUSTOM_SIMPLE_EDGE)
-Reducer 34 <- Map 33 (CUSTOM_SIMPLE_EDGE)
-Reducer 36 <- Map 35 (CUSTOM_SIMPLE_EDGE)
-Reducer 38 <- Map 37 (CUSTOM_SIMPLE_EDGE)
-Reducer 4 <- Reducer 22 (CUSTOM_SIMPLE_EDGE), Reducer 3 (CUSTOM_SIMPLE_EDGE)
-Reducer 40 <- Map 39 (CUSTOM_SIMPLE_EDGE)
-Reducer 42 <- Map 41 (CUSTOM_SIMPLE_EDGE)
-Reducer 44 <- Map 43 (CUSTOM_SIMPLE_EDGE)
-Reducer 46 <- Map 45 (CUSTOM_SIMPLE_EDGE)
-Reducer 5 <- Reducer 24 (CUSTOM_SIMPLE_EDGE), Reducer 4 (CUSTOM_SIMPLE_EDGE)
-Reducer 6 <- Reducer 26 (CUSTOM_SIMPLE_EDGE), Reducer 5 (CUSTOM_SIMPLE_EDGE)
-Reducer 7 <- Reducer 28 (CUSTOM_SIMPLE_EDGE), Reducer 6 (CUSTOM_SIMPLE_EDGE)
-Reducer 8 <- Reducer 30 (CUSTOM_SIMPLE_EDGE), Reducer 7 (CUSTOM_SIMPLE_EDGE)
-Reducer 9 <- Reducer 32 (CUSTOM_SIMPLE_EDGE), Reducer 8 (CUSTOM_SIMPLE_EDGE)
+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 16
-      File Output Operator [FS_154]
-        Select Operator [SEL_153] (rows=36 width=3135)
+      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_185] (rows=36 width=3135)
-            Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14","_col15"]
-          <-Reducer 15 [CUSTOM_SIMPLE_EDGE]
-            PARTITION_ONLY_SHUFFLE [RS_150]
-              Merge Join Operator [MERGEJOIN_184] (rows=36 width=2846)
-                Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13","_col14"]
-              <-Reducer 14 [CUSTOM_SIMPLE_EDGE]
-                PARTITION_ONLY_SHUFFLE [RS_147]
-                  Merge Join Operator [MERGEJOIN_183] (rows=36 width=2557)
-                    Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
-                  <-Reducer 13 [CUSTOM_SIMPLE_EDGE]
-                    PARTITION_ONLY_SHUFFLE [RS_144]
-                      Merge Join Operator [MERGEJOIN_182] (rows=36 width=2548)
-                        Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12"]
-                      <-Reducer 12 [CUSTOM_SIMPLE_EDGE]
-                        PARTITION_ONLY_SHUFFLE [RS_141]
-                          Merge Join Operator [MERGEJOIN_181] (rows=36 width=2259)
-                            Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11"]
-                          <-Reducer 11 [CUSTOM_SIMPLE_EDGE]
-                            PARTITION_ONLY_SHUFFLE [RS_138]
-                              Merge Join Operator [MERGEJOIN_180] (rows=36 width=1970)
-                                Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10"]
-                              <-Reducer 10 [CUSTOM_SIMPLE_EDGE]
-                                PARTITION_ONLY_SHUFFLE [RS_135]
-                                  Merge Join Operator [MERGEJOIN_179] (rows=36 width=1961)
-                                    Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9"]
-                                  <-Reducer 34 [CUSTOM_SIMPLE_EDGE]
-                                    PARTITION_ONLY_SHUFFLE [RS_133]
-                                      Group By Operator [GBY_64] (rows=1 width=288)
-                                        Output:["_col0"],aggregations:["avg(VALUE._col0)"]
-                                      <-Map 33 [CUSTOM_SIMPLE_EDGE]
-                                        PARTITION_ONLY_SHUFFLE [RS_63]
-                                          Group By Operator [GBY_62] (rows=1 width=288)
-                                            Output:["_col0"],aggregations:["avg(ss_net_paid_inc_tax)"]
-                                            Select Operator [SEL_61] (rows=63999515 width=88)
-                                              Output:["ss_net_paid_inc_tax"]
-                                              Filter Operator [FIL_164] (rows=63999515 width=88)
-                                                predicate:ss_quantity BETWEEN 41 AND 60
-                                                TableScan [TS_59] (rows=575995635 width=88)
-                                                  default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_net_paid_inc_tax"]
-                                  <-Reducer 9 [CUSTOM_SIMPLE_EDGE]
-                                    PARTITION_ONLY_SHUFFLE [RS_132]
-                                      Merge Join Operator [MERGEJOIN_178] (rows=36 width=1672)
-                                        Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8"]
-                                      <-Reducer 32 [CUSTOM_SIMPLE_EDGE]
-                                        PARTITION_ONLY_SHUFFLE [RS_130]
-                                          Group By Operator [GBY_57] (rows=1 width=288)
-                                            Output:["_col0"],aggregations:["avg(VALUE._col0)"]
-                                          <-Map 31 [CUSTOM_SIMPLE_EDGE]
-                                            PARTITION_ONLY_SHUFFLE [RS_56]
-                                              Group By Operator [GBY_55] (rows=1 width=288)
-                                                Output:["_col0"],aggregations:["avg(ss_ext_list_price)"]
-                                                Select Operator [SEL_54] (rows=63999515 width=88)
-                                                  Output:["ss_ext_list_price"]
-                                                  Filter Operator [FIL_163] (rows=63999515 width=88)
-                                                    predicate:ss_quantity BETWEEN 41 AND 60
-                                                    TableScan [TS_52] (rows=575995635 width=88)
-                                                      default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_ext_list_price"]
-                                      <-Reducer 8 [CUSTOM_SIMPLE_EDGE]
-                                        PARTITION_ONLY_SHUFFLE [RS_129]
-                                          Merge Join Operator [MERGEJOIN_177] (rows=36 width=1383)
-                                            Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
-                                          <-Reducer 30 [CUSTOM_SIMPLE_EDGE]
-                                            PARTITION_ONLY_SHUFFLE [RS_127]
-                                              Group By Operator [GBY_50] (rows=1 width=8)
-                                                Output:["_col0"],aggregations:["count(VALUE._col0)"]
-                                              <-Map 29 [CUSTOM_SIMPLE_EDGE]
-                                                PARTITION_ONLY_SHUFFLE [RS_49]
-                                                  Group By Operator [GBY_48] (rows=1 width=8)
-                                                    Output:["_col0"],aggregations:["count()"]
-                                                    Select Operator [SEL_47] (rows=63999515 width=88)
-                                                      Filter Operator [FIL_162] (rows=63999515 width=88)
-                                                        predicate:ss_quantity BETWEEN 41 AND 60
-                                                        TableScan [TS_45] (rows=575995635 width=88)
-                                                          default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity"]
-                                          <-Reducer 7 [CUSTOM_SIMPLE_EDGE]
-                                            PARTITION_ONLY_SHUFFLE [RS_126]
-                                              Merge Join Operator [MERGEJOIN_176] (rows=36 width=1374)
-                                                Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4","_col5","_col6"]
-                                              <-Reducer 28 [CUSTOM_SIMPLE_EDGE]
-                                                PARTITION_ONLY_SHUFFLE [RS_124]
-                                                  Group By Operator [GBY_43] (rows=1 width=288)
-                                                    Output:["_col0"],aggregations:["avg(VALUE._col0)"]
-                                                  <-Map 27 [CUSTOM_SIMPLE_EDGE]
-                                                    PARTITION_ONLY_SHUFFLE [RS_42]
-                                                      Group By Operator [GBY_41] (rows=1 width=288)
-                                                        Output:["_col0"],aggregations:["avg(ss_net_paid_inc_tax)"]
-                                                        Select Operator [SEL_40] (rows=63999515 width=88)
-                                                          Output:["ss_net_paid_inc_tax"]
-                                                          Filter Operator [FIL_161] (rows=63999515 width=88)
-                                                            predicate:ss_quantity BETWEEN 21 AND 40
-                                                            TableScan [TS_38] (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_123]
-                                                  Merge Join Operator [MERGEJOIN_175] (rows=36 width=1085)
-                                                    Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4","_col5"]
-                                                  <-Reducer 26 [CUSTOM_SIMPLE_EDGE]
-                                                    PARTITION_ONLY_SHUFFLE [RS_121]
-                                                      Group By Operator [GBY_36] (rows=1 width=288)
-                                                        Output:["_col0"],aggregations:["avg(VALUE._col0)"]
-                                                      <-Map 25 [CUSTOM_SIMPLE_EDGE]
-                                                        PARTITION_ONLY_SHUFFLE [RS_35]
-                                                          Group By Operator [GBY_34] (rows=1 width=288)
-                                                            Output:["_col0"],aggregations:["avg(ss_ext_list_price)"]
-                                                            Select Operator [SEL_33] (rows=63999515 width=88)
-                                                              Output:["ss_ext_list_price"]
-                                                              Filter Operator [FIL_160] (rows=63999515 width=88)
-                                                                predicate:ss_quantity BETWEEN 21 AND 40
-                                                                TableScan [TS_31] (rows=575995635 width=88)
-                                                                  default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity","ss_ext_list_price"]
-                                                  <-Reducer 5 [CUSTOM_SIMPLE_EDGE]
-                                                    PARTITION_ONLY_SHUFFLE [RS_120]
-                                                      Merge Join Operator [MERGEJOIN_174] (rows=36 width=796)
-                                                        Conds:(Left Outer),Output:["_col1","_col2","_col3","_col4"]
-                                                      <-Reducer 24 [CUSTOM_SIMPLE_EDGE]
-                                                        PARTITION_ONLY_SHUFFLE [RS_118]
-                                                          Group By Operator [GBY_29] (rows=1 width=8)
-                                                            Output:["_col0"],aggregations:["count(VALUE._col0)"]
-                                                          <-Map 23 [CUSTOM_SIMPLE_EDGE]
-                                                            PARTITION_ONLY_SHUFFLE [RS_28]
-                                                              Group By Operator [GBY_27] (rows=1 width=8)
-                                                                Output:["_col0"],aggregations:["count()"]
-                                                                Select Operator [SEL_26] (rows=63999515 width=88)
-                                                                  Filter Operator [FIL_159] (rows=63999515 width=88)
-                                                                    predicate:ss_quantity BETWEEN 21 AND 40
-                                                                    TableScan [TS_24] (rows=575995635 width=88)
-                                                                      default@store_sales,store_sales,Tbl:COMPLETE,Col:NONE,Output:["ss_quantity"]
-                                                      <-Reducer 4 [CUSTOM_SIMPLE_EDGE]
-                                                        PARTITION_ONLY_SHUFFLE [RS_117]
-                                                          Merge Join Operator [MERGEJOIN_173] (rows=36 width=787)
-                                                            Conds:(Left Outer),Output:["_col1","_col2","_col3"]
-                                                          <-Reducer 22 [CUSTOM_SIMPLE_EDGE]
-                                                            PARTITION_ONLY_SHUFFLE [RS_115]
-                                                              Group By Operator [GBY_22] (rows=1 width=288)
+          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 21 [CUSTOM_SIMPLE_EDGE]
-                                                                PARTITION_ONLY_SHUFFLE [RS_21]
-                                                                  Group By Operator [GBY_20] (rows=1 width=288)
+                                             

<TRUNCATED>

Mime
View raw message