hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pxi...@apache.org
Subject [7/9] hive git commit: HIVE-11927: Implement/Enable constant related optimization rules in Calcite: enable HiveReduceExpressionsRule to fold constants (Pengcheng Xiong, reviewed by Laljo John Pullokkaran)
Date Wed, 23 Dec 2015 05:06:50 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/b340ecb5/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out b/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
index b322ef1..7c5be6d 100644
--- a/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
+++ b/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
@@ -756,23 +756,23 @@ STAGE PLANS:
             alias: tbl_pred
             Statistics: Num rows: 1049 Data size: 11539 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (not (s like '%car%'))) and (t > 0)) and si BETWEEN 300 AND 400) (type: boolean)
-              Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+              predicate: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (t > 0)) and si BETWEEN 300 AND 400) and (not (s like '%car%'))) (type: boolean)
+              Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
               Select Operator
                 expressions: t (type: tinyint), si (type: smallint), d (type: double), s (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3
-                Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col3 (type: string)
                   sort order: -
-                  Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
                   TopN Hash Memory Usage: 0.1
                   value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col2 (type: double)
       Reduce Operator Tree:
         Select Operator
           expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: smallint), VALUE._col2 (type: double), KEY.reducesinkkey0 (type: string)
           outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
           Limit
             Number of rows: 3
             Statistics: Num rows: 3 Data size: 33 Basic stats: COMPLETE Column stats: NONE
@@ -822,26 +822,26 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: tbl_pred
-            filterExpr: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (not (s like '%car%'))) and (t > 0)) and si BETWEEN 300 AND 400) (type: boolean)
+            filterExpr: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (t > 0)) and si BETWEEN 300 AND 400) and (not (s like '%car%'))) (type: boolean)
             Statistics: Num rows: 1049 Data size: 11539 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
-              predicate: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (not (s like '%car%'))) and (t > 0)) and si BETWEEN 300 AND 400) (type: boolean)
-              Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+              predicate: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (t > 0)) and si BETWEEN 300 AND 400) and (not (s like '%car%'))) (type: boolean)
+              Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
               Select Operator
                 expressions: t (type: tinyint), si (type: smallint), d (type: double), s (type: string)
                 outputColumnNames: _col0, _col1, _col2, _col3
-                Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col3 (type: string)
                   sort order: -
-                  Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
                   TopN Hash Memory Usage: 0.1
                   value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col2 (type: double)
       Reduce Operator Tree:
         Select Operator
           expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: smallint), VALUE._col2 (type: double), KEY.reducesinkkey0 (type: string)
           outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
           Limit
             Number of rows: 3
             Statistics: Num rows: 3 Data size: 33 Basic stats: COMPLETE Column stats: NONE

http://git-wip-us.apache.org/repos/asf/hive/blob/b340ecb5/ql/src/test/results/clientpositive/partition_multilevels.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/partition_multilevels.q.out b/ql/src/test/results/clientpositive/partition_multilevels.q.out
index c1c8778..0fe7f82 100644
--- a/ql/src/test/results/clientpositive/partition_multilevels.q.out
+++ b/ql/src/test/results/clientpositive/partition_multilevels.q.out
@@ -990,12 +990,12 @@ STAGE PLANS:
             alias: partition_test_multilevel
             Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: '2222' (type: string), level2 (type: string), level3 (type: string)
-              outputColumnNames: level1, level2, level3
+              expressions: level2 (type: string), level3 (type: string)
+              outputColumnNames: _col1, _col2
               Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
                 aggregations: count()
-                keys: level1 (type: string), level2 (type: string), level3 (type: string)
+                keys: '2222' (type: string), _col1 (type: string), _col2 (type: string)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
@@ -1012,13 +1012,17 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics: Num rows: 54 Data size: 573 Basic stats: COMPLETE Column stats: NONE
-          File Output Operator
-            compressed: false
+          Select Operator
+            expressions: '2222' (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: bigint)
+            outputColumnNames: _col0, _col1, _col2, _col3
             Statistics: Num rows: 54 Data size: 573 Basic stats: COMPLETE Column stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.TextInputFormat
-                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+            File Output Operator
+              compressed: false
+              Statistics: Num rows: 54 Data size: 573 Basic stats: COMPLETE Column stats: NONE
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator
@@ -1578,12 +1582,12 @@ STAGE PLANS:
             alias: partition_test_multilevel
             Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
             Select Operator
-              expressions: '2222' (type: string), level2 (type: string), level3 (type: string)
-              outputColumnNames: level1, level2, level3
+              expressions: level2 (type: string), level3 (type: string)
+              outputColumnNames: _col1, _col2
               Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
               Group By Operator
                 aggregations: count()
-                keys: level1 (type: string), level2 (type: string), level3 (type: string)
+                keys: '2222' (type: string), _col1 (type: string), _col2 (type: string)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
@@ -1600,13 +1604,17 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics: Num rows: 54 Data size: 573 Basic stats: COMPLETE Column stats: NONE
-          File Output Operator
-            compressed: false
+          Select Operator
+            expressions: '2222' (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: bigint)
+            outputColumnNames: _col0, _col1, _col2, _col3
             Statistics: Num rows: 54 Data size: 573 Basic stats: COMPLETE Column stats: NONE
-            table:
-                input format: org.apache.hadoop.mapred.TextInputFormat
-                output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+            File Output Operator
+              compressed: false
+              Statistics: Num rows: 54 Data size: 573 Basic stats: COMPLETE Column stats: NONE
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
   Stage: Stage-0
     Fetch Operator

http://git-wip-us.apache.org/repos/asf/hive/blob/b340ecb5/ql/src/test/results/clientpositive/perf/query31.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query31.q.out b/ql/src/test/results/clientpositive/perf/query31.q.out
index 52cbdf4..8c370c4 100644
--- a/ql/src/test/results/clientpositive/perf/query31.q.out
+++ b/ql/src/test/results/clientpositive/perf/query31.q.out
@@ -32,549 +32,549 @@ Stage-0
       limit:-1
       Stage-1
          Reducer 7
-         File Output Operator [FS_135]
+         File Output Operator [FS_141]
             compressed:false
             Statistics:Num rows: 11831111 Data size: 12007156967 Basic stats: COMPLETE Column stats: NONE
             table:{"input format:":"org.apache.hadoop.mapred.TextInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}
-            Select Operator [SEL_134]
+            Select Operator [SEL_140]
             |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
             |  Statistics:Num rows: 11831111 Data size: 12007156967 Basic stats: COMPLETE Column stats: NONE
             |<-Reducer 6 [SIMPLE_EDGE]
-               Reduce Output Operator [RS_133]
+               Reduce Output Operator [RS_139]
                   key expressions:_col2 (type: decimal(37,20))
                   sort order:+
                   Statistics:Num rows: 11831111 Data size: 12007156967 Basic stats: COMPLETE Column stats: NONE
-                  value expressions:_col0 (type: string), _col1 (type: int), _col3 (type: decimal(37,20)), _col4 (type: decimal(37,20)), _col5 (type: decimal(37,20))
-                  Select Operator [SEL_132]
-                     outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
+                  value expressions:_col0 (type: string), _col3 (type: decimal(37,20)), _col4 (type: decimal(37,20)), _col5 (type: decimal(37,20))
+                  Select Operator [SEL_138]
+                     outputColumnNames:["_col0","_col2","_col3","_col4","_col5"]
                      Statistics:Num rows: 11831111 Data size: 12007156967 Basic stats: COMPLETE Column stats: NONE
-                     Filter Operator [FIL_131]
+                     Filter Operator [FIL_137]
                         predicate:(CASE WHEN ((_col19 > 0)) THEN ((_col23 / _col19)) ELSE (null) END > CASE WHEN ((_col7 > 0)) THEN ((_col11 / _col7)) ELSE (null) END) (type: boolean)
                         Statistics:Num rows: 11831111 Data size: 12007156967 Basic stats: COMPLETE Column stats: NONE
-                        Merge Join Operator [MERGEJOIN_275]
+                        Merge Join Operator [MERGEJOIN_281]
                         |  condition map:[{"":"Inner Join 0 to 1"}]
                         |  keys:{"0":"_col12 (type: string)","1":"_col0 (type: string)"}
-                        |  outputColumnNames:["_col0","_col2","_col3","_col7","_col11","_col15","_col19","_col23"]
+                        |  outputColumnNames:["_col0","_col3","_col7","_col11","_col15","_col19","_col23"]
                         |  Statistics:Num rows: 35493334 Data size: 36021471918 Basic stats: COMPLETE Column stats: NONE
                         |<-Reducer 37 [SIMPLE_EDGE]
-                        |  Reduce Output Operator [RS_129]
+                        |  Reduce Output Operator [RS_135]
                         |     key expressions:_col0 (type: string)
                         |     Map-reduce partition columns:_col0 (type: string)
                         |     sort order:+
                         |     Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
                         |     value expressions:_col3 (type: decimal(17,2))
-                        |     Select Operator [SEL_127]
+                        |     Select Operator [SEL_133]
                         |        outputColumnNames:["_col0","_col3"]
                         |        Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
-                        |        Group By Operator [GBY_126]
+                        |        Group By Operator [GBY_132]
                         |        |  aggregations:["sum(VALUE._col0)"]
-                        |        |  keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+                        |        |  keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
                         |        |  outputColumnNames:["_col0","_col1","_col2","_col3"]
                         |        |  Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
                         |        |<-Reducer 36 [SIMPLE_EDGE]
-                        |           Reduce Output Operator [RS_125]
-                        |              key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: string)
-                        |              Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: string)
+                        |           Reduce Output Operator [RS_131]
+                        |              key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+                        |              Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
                         |              sort order:+++
                         |              Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                         |              value expressions:_col3 (type: decimal(17,2))
-                        |              Group By Operator [GBY_124]
-                        |                 aggregations:["sum(_col2)"]
-                        |                 keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+                        |              Group By Operator [GBY_130]
+                        |                 aggregations:["sum(_col3)"]
+                        |                 keys:_col0 (type: string), 3 (type: int), 1998 (type: int)
                         |                 outputColumnNames:["_col0","_col1","_col2","_col3"]
                         |                 Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
-                        |                 Select Operator [SEL_123]
-                        |                    outputColumnNames:["_col4","_col5","_col7","_col2"]
+                        |                 Select Operator [SEL_128]
+                        |                    outputColumnNames:["_col0","_col3"]
                         |                    Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
-                        |                    Merge Join Operator [MERGEJOIN_273]
+                        |                    Merge Join Operator [MERGEJOIN_279]
                         |                    |  condition map:[{"":"Inner Join 0 to 1"}]
                         |                    |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
                         |                    |  outputColumnNames:["_col2","_col7"]
                         |                    |  Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                         |                    |<-Map 39 [SIMPLE_EDGE]
-                        |                    |  Reduce Output Operator [RS_121]
+                        |                    |  Reduce Output Operator [RS_126]
                         |                    |     key expressions:_col0 (type: int)
                         |                    |     Map-reduce partition columns:_col0 (type: int)
                         |                    |     sort order:+
                         |                    |     Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
                         |                    |     value expressions:_col1 (type: string)
-                        |                    |     Select Operator [SEL_116]
+                        |                    |     Select Operator [SEL_121]
                         |                    |        outputColumnNames:["_col0","_col1"]
                         |                    |        Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
-                        |                    |        Filter Operator [FIL_261]
+                        |                    |        Filter Operator [FIL_267]
                         |                    |           predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
                         |                    |           Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
-                        |                    |           TableScan [TS_114]
+                        |                    |           TableScan [TS_119]
                         |                    |              alias:customer_address
                         |                    |              Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
                         |                    |<-Reducer 35 [SIMPLE_EDGE]
-                        |                       Reduce Output Operator [RS_120]
+                        |                       Reduce Output Operator [RS_125]
                         |                          key expressions:_col1 (type: int)
                         |                          Map-reduce partition columns:_col1 (type: int)
                         |                          sort order:+
                         |                          Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
                         |                          value expressions:_col2 (type: decimal(7,2))
-                        |                          Merge Join Operator [MERGEJOIN_272]
+                        |                          Merge Join Operator [MERGEJOIN_278]
                         |                          |  condition map:[{"":"Inner Join 0 to 1"}]
                         |                          |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
                         |                          |  outputColumnNames:["_col1","_col2"]
                         |                          |  Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
                         |                          |<-Map 34 [SIMPLE_EDGE]
-                        |                          |  Reduce Output Operator [RS_117]
+                        |                          |  Reduce Output Operator [RS_122]
                         |                          |     key expressions:_col0 (type: int)
                         |                          |     Map-reduce partition columns:_col0 (type: int)
                         |                          |     sort order:+
                         |                          |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                         |                          |     value expressions:_col1 (type: int), _col2 (type: decimal(7,2))
-                        |                          |     Select Operator [SEL_110]
+                        |                          |     Select Operator [SEL_115]
                         |                          |        outputColumnNames:["_col0","_col1","_col2"]
                         |                          |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                        |                          |        Filter Operator [FIL_259]
+                        |                          |        Filter Operator [FIL_265]
                         |                          |           predicate:(ws_sold_date_sk is not null and ws_bill_addr_sk is not null) (type: boolean)
                         |                          |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                        |                          |           TableScan [TS_108]
+                        |                          |           TableScan [TS_113]
                         |                          |              alias:web_sales
                         |                          |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                         |                          |<-Map 38 [SIMPLE_EDGE]
-                        |                             Reduce Output Operator [RS_118]
+                        |                             Reduce Output Operator [RS_123]
                         |                                key expressions:_col0 (type: int)
                         |                                Map-reduce partition columns:_col0 (type: int)
                         |                                sort order:+
                         |                                Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                        |                                Select Operator [SEL_113]
+                        |                                Select Operator [SEL_118]
                         |                                   outputColumnNames:["_col0"]
                         |                                   Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                        |                                   Filter Operator [FIL_260]
+                        |                                   Filter Operator [FIL_266]
                         |                                      predicate:(((d_qoy = 3) and (d_year = 1998)) and d_date_sk is not null) (type: boolean)
                         |                                      Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                        |                                      TableScan [TS_111]
+                        |                                      TableScan [TS_116]
                         |                                         alias:date_dim
                         |                                         Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
                         |<-Reducer 5 [SIMPLE_EDGE]
-                           Reduce Output Operator [RS_128]
+                           Reduce Output Operator [RS_134]
                               key expressions:_col12 (type: string)
                               Map-reduce partition columns:_col12 (type: string)
                               sort order:+
                               Statistics:Num rows: 32266667 Data size: 32746791943 Basic stats: COMPLETE Column stats: NONE
-                              value expressions:_col0 (type: string), _col2 (type: int), _col3 (type: decimal(17,2)), _col7 (type: decimal(17,2)), _col11 (type: decimal(17,2)), _col15 (type: decimal(17,2)), _col19 (type: decimal(17,2))
-                              Select Operator [SEL_107]
-                                 outputColumnNames:["_col0","_col11","_col12","_col15","_col19","_col2","_col3","_col7"]
+                              value expressions:_col0 (type: string), _col3 (type: decimal(17,2)), _col7 (type: decimal(17,2)), _col11 (type: decimal(17,2)), _col15 (type: decimal(17,2)), _col19 (type: decimal(17,2))
+                              Select Operator [SEL_112]
+                                 outputColumnNames:["_col0","_col11","_col12","_col15","_col19","_col3","_col7"]
                                  Statistics:Num rows: 32266667 Data size: 32746791943 Basic stats: COMPLETE Column stats: NONE
-                                 Filter Operator [FIL_106]
+                                 Filter Operator [FIL_111]
                                     predicate:(CASE WHEN ((_col15 > 0)) THEN ((_col19 / _col15)) ELSE (null) END > CASE WHEN ((_col3 > 0)) THEN ((_col7 / _col3)) ELSE (null) END) (type: boolean)
                                     Statistics:Num rows: 32266667 Data size: 32746791943 Basic stats: COMPLETE Column stats: NONE
-                                    Merge Join Operator [MERGEJOIN_274]
+                                    Merge Join Operator [MERGEJOIN_280]
                                     |  condition map:[{"":"Inner Join 0 to 1"},{"":"Inner Join 1 to 2"},{"":"Inner Join 0 to 3"},{"":"Inner Join 3 to 4"}]
                                     |  keys:{"0":"_col0 (type: string)","1":"_col0 (type: string)","2":"_col0 (type: string)","3":"_col0 (type: string)","4":"_col0 (type: string)"}
-                                    |  outputColumnNames:["_col0","_col2","_col3","_col7","_col11","_col12","_col15","_col19"]
+                                    |  outputColumnNames:["_col0","_col3","_col7","_col11","_col12","_col15","_col19"]
                                     |  Statistics:Num rows: 96800002 Data size: 98240376845 Basic stats: COMPLETE Column stats: NONE
                                     |<-Reducer 13 [SIMPLE_EDGE]
-                                    |  Reduce Output Operator [RS_101]
+                                    |  Reduce Output Operator [RS_106]
                                     |     key expressions:_col0 (type: string)
                                     |     Map-reduce partition columns:_col0 (type: string)
                                     |     sort order:+
                                     |     Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
                                     |     value expressions:_col3 (type: decimal(17,2))
-                                    |     Select Operator [SEL_39]
+                                    |     Select Operator [SEL_41]
                                     |        outputColumnNames:["_col0","_col3"]
                                     |        Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
-                                    |        Group By Operator [GBY_38]
+                                    |        Group By Operator [GBY_40]
                                     |        |  aggregations:["sum(VALUE._col0)"]
-                                    |        |  keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+                                    |        |  keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
                                     |        |  outputColumnNames:["_col0","_col1","_col2","_col3"]
                                     |        |  Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
                                     |        |<-Reducer 12 [SIMPLE_EDGE]
-                                    |           Reduce Output Operator [RS_37]
-                                    |              key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: string)
-                                    |              Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: string)
+                                    |           Reduce Output Operator [RS_39]
+                                    |              key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+                                    |              Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
                                     |              sort order:+++
                                     |              Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                                     |              value expressions:_col3 (type: decimal(17,2))
-                                    |              Group By Operator [GBY_36]
-                                    |                 aggregations:["sum(_col2)"]
-                                    |                 keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+                                    |              Group By Operator [GBY_38]
+                                    |                 aggregations:["sum(_col3)"]
+                                    |                 keys:_col0 (type: string), 2 (type: int), 1998 (type: int)
                                     |                 outputColumnNames:["_col0","_col1","_col2","_col3"]
                                     |                 Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
-                                    |                 Select Operator [SEL_35]
-                                    |                    outputColumnNames:["_col4","_col5","_col7","_col2"]
+                                    |                 Select Operator [SEL_36]
+                                    |                    outputColumnNames:["_col0","_col3"]
                                     |                    Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
-                                    |                    Merge Join Operator [MERGEJOIN_265]
+                                    |                    Merge Join Operator [MERGEJOIN_271]
                                     |                    |  condition map:[{"":"Inner Join 0 to 1"}]
                                     |                    |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
                                     |                    |  outputColumnNames:["_col2","_col7"]
                                     |                    |  Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                                     |                    |<-Map 15 [SIMPLE_EDGE]
-                                    |                    |  Reduce Output Operator [RS_33]
+                                    |                    |  Reduce Output Operator [RS_34]
                                     |                    |     key expressions:_col0 (type: int)
                                     |                    |     Map-reduce partition columns:_col0 (type: int)
                                     |                    |     sort order:+
                                     |                    |     Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
                                     |                    |     value expressions:_col1 (type: string)
-                                    |                    |     Select Operator [SEL_28]
+                                    |                    |     Select Operator [SEL_29]
                                     |                    |        outputColumnNames:["_col0","_col1"]
                                     |                    |        Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
-                                    |                    |        Filter Operator [FIL_249]
+                                    |                    |        Filter Operator [FIL_255]
                                     |                    |           predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
                                     |                    |           Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
-                                    |                    |           TableScan [TS_26]
+                                    |                    |           TableScan [TS_27]
                                     |                    |              alias:customer_address
                                     |                    |              Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
                                     |                    |<-Reducer 11 [SIMPLE_EDGE]
-                                    |                       Reduce Output Operator [RS_32]
+                                    |                       Reduce Output Operator [RS_33]
                                     |                          key expressions:_col1 (type: int)
                                     |                          Map-reduce partition columns:_col1 (type: int)
                                     |                          sort order:+
                                     |                          Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
                                     |                          value expressions:_col2 (type: decimal(7,2))
-                                    |                          Merge Join Operator [MERGEJOIN_264]
+                                    |                          Merge Join Operator [MERGEJOIN_270]
                                     |                          |  condition map:[{"":"Inner Join 0 to 1"}]
                                     |                          |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
                                     |                          |  outputColumnNames:["_col1","_col2"]
                                     |                          |  Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
                                     |                          |<-Map 10 [SIMPLE_EDGE]
-                                    |                          |  Reduce Output Operator [RS_29]
+                                    |                          |  Reduce Output Operator [RS_30]
                                     |                          |     key expressions:_col0 (type: int)
                                     |                          |     Map-reduce partition columns:_col0 (type: int)
                                     |                          |     sort order:+
                                     |                          |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                     |                          |     value expressions:_col1 (type: int), _col2 (type: decimal(7,2))
-                                    |                          |     Select Operator [SEL_22]
+                                    |                          |     Select Operator [SEL_23]
                                     |                          |        outputColumnNames:["_col0","_col1","_col2"]
                                     |                          |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                          |        Filter Operator [FIL_247]
+                                    |                          |        Filter Operator [FIL_253]
                                     |                          |           predicate:(ss_sold_date_sk is not null and ss_addr_sk is not null) (type: boolean)
                                     |                          |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                          |           TableScan [TS_20]
+                                    |                          |           TableScan [TS_21]
                                     |                          |              alias:store_sales
                                     |                          |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                     |                          |<-Map 14 [SIMPLE_EDGE]
-                                    |                             Reduce Output Operator [RS_30]
+                                    |                             Reduce Output Operator [RS_31]
                                     |                                key expressions:_col0 (type: int)
                                     |                                Map-reduce partition columns:_col0 (type: int)
                                     |                                sort order:+
                                     |                                Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                Select Operator [SEL_25]
+                                    |                                Select Operator [SEL_26]
                                     |                                   outputColumnNames:["_col0"]
                                     |                                   Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                   Filter Operator [FIL_248]
+                                    |                                   Filter Operator [FIL_254]
                                     |                                      predicate:(((d_qoy = 2) and (d_year = 1998)) and d_date_sk is not null) (type: boolean)
                                     |                                      Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                      TableScan [TS_23]
+                                    |                                      TableScan [TS_24]
                                     |                                         alias:date_dim
                                     |                                         Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
                                     |<-Reducer 19 [SIMPLE_EDGE]
-                                    |  Reduce Output Operator [RS_102]
+                                    |  Reduce Output Operator [RS_107]
                                     |     key expressions:_col0 (type: string)
                                     |     Map-reduce partition columns:_col0 (type: string)
                                     |     sort order:+
                                     |     Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
                                     |     value expressions:_col3 (type: decimal(17,2))
-                                    |     Select Operator [SEL_59]
+                                    |     Select Operator [SEL_62]
                                     |        outputColumnNames:["_col0","_col3"]
                                     |        Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
-                                    |        Group By Operator [GBY_58]
+                                    |        Group By Operator [GBY_61]
                                     |        |  aggregations:["sum(VALUE._col0)"]
-                                    |        |  keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+                                    |        |  keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
                                     |        |  outputColumnNames:["_col0","_col1","_col2","_col3"]
                                     |        |  Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
                                     |        |<-Reducer 18 [SIMPLE_EDGE]
-                                    |           Reduce Output Operator [RS_57]
-                                    |              key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: string)
-                                    |              Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: string)
+                                    |           Reduce Output Operator [RS_60]
+                                    |              key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+                                    |              Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
                                     |              sort order:+++
                                     |              Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                                     |              value expressions:_col3 (type: decimal(17,2))
-                                    |              Group By Operator [GBY_56]
-                                    |                 aggregations:["sum(_col2)"]
-                                    |                 keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+                                    |              Group By Operator [GBY_59]
+                                    |                 aggregations:["sum(_col3)"]
+                                    |                 keys:_col0 (type: string), 3 (type: int), 1998 (type: int)
                                     |                 outputColumnNames:["_col0","_col1","_col2","_col3"]
                                     |                 Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
-                                    |                 Select Operator [SEL_55]
-                                    |                    outputColumnNames:["_col4","_col5","_col7","_col2"]
+                                    |                 Select Operator [SEL_57]
+                                    |                    outputColumnNames:["_col0","_col3"]
                                     |                    Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
-                                    |                    Merge Join Operator [MERGEJOIN_267]
+                                    |                    Merge Join Operator [MERGEJOIN_273]
                                     |                    |  condition map:[{"":"Inner Join 0 to 1"}]
                                     |                    |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
                                     |                    |  outputColumnNames:["_col2","_col7"]
                                     |                    |  Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                                     |                    |<-Map 21 [SIMPLE_EDGE]
-                                    |                    |  Reduce Output Operator [RS_53]
+                                    |                    |  Reduce Output Operator [RS_55]
                                     |                    |     key expressions:_col0 (type: int)
                                     |                    |     Map-reduce partition columns:_col0 (type: int)
                                     |                    |     sort order:+
                                     |                    |     Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
                                     |                    |     value expressions:_col1 (type: string)
-                                    |                    |     Select Operator [SEL_48]
+                                    |                    |     Select Operator [SEL_50]
                                     |                    |        outputColumnNames:["_col0","_col1"]
                                     |                    |        Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
-                                    |                    |        Filter Operator [FIL_252]
+                                    |                    |        Filter Operator [FIL_258]
                                     |                    |           predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
                                     |                    |           Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
-                                    |                    |           TableScan [TS_46]
+                                    |                    |           TableScan [TS_48]
                                     |                    |              alias:customer_address
                                     |                    |              Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
                                     |                    |<-Reducer 17 [SIMPLE_EDGE]
-                                    |                       Reduce Output Operator [RS_52]
+                                    |                       Reduce Output Operator [RS_54]
                                     |                          key expressions:_col1 (type: int)
                                     |                          Map-reduce partition columns:_col1 (type: int)
                                     |                          sort order:+
                                     |                          Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
                                     |                          value expressions:_col2 (type: decimal(7,2))
-                                    |                          Merge Join Operator [MERGEJOIN_266]
+                                    |                          Merge Join Operator [MERGEJOIN_272]
                                     |                          |  condition map:[{"":"Inner Join 0 to 1"}]
                                     |                          |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
                                     |                          |  outputColumnNames:["_col1","_col2"]
                                     |                          |  Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
                                     |                          |<-Map 16 [SIMPLE_EDGE]
-                                    |                          |  Reduce Output Operator [RS_49]
+                                    |                          |  Reduce Output Operator [RS_51]
                                     |                          |     key expressions:_col0 (type: int)
                                     |                          |     Map-reduce partition columns:_col0 (type: int)
                                     |                          |     sort order:+
                                     |                          |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                     |                          |     value expressions:_col1 (type: int), _col2 (type: decimal(7,2))
-                                    |                          |     Select Operator [SEL_42]
+                                    |                          |     Select Operator [SEL_44]
                                     |                          |        outputColumnNames:["_col0","_col1","_col2"]
                                     |                          |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                          |        Filter Operator [FIL_250]
+                                    |                          |        Filter Operator [FIL_256]
                                     |                          |           predicate:(ss_sold_date_sk is not null and ss_addr_sk is not null) (type: boolean)
                                     |                          |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                          |           TableScan [TS_40]
+                                    |                          |           TableScan [TS_42]
                                     |                          |              alias:store_sales
                                     |                          |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                     |                          |<-Map 20 [SIMPLE_EDGE]
-                                    |                             Reduce Output Operator [RS_50]
+                                    |                             Reduce Output Operator [RS_52]
                                     |                                key expressions:_col0 (type: int)
                                     |                                Map-reduce partition columns:_col0 (type: int)
                                     |                                sort order:+
                                     |                                Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                Select Operator [SEL_45]
+                                    |                                Select Operator [SEL_47]
                                     |                                   outputColumnNames:["_col0"]
                                     |                                   Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                   Filter Operator [FIL_251]
+                                    |                                   Filter Operator [FIL_257]
                                     |                                      predicate:(((d_qoy = 3) and (d_year = 1998)) and d_date_sk is not null) (type: boolean)
                                     |                                      Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                      TableScan [TS_43]
+                                    |                                      TableScan [TS_45]
                                     |                                         alias:date_dim
                                     |                                         Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
                                     |<-Reducer 25 [SIMPLE_EDGE]
-                                    |  Reduce Output Operator [RS_103]
+                                    |  Reduce Output Operator [RS_108]
                                     |     key expressions:_col0 (type: string)
                                     |     Map-reduce partition columns:_col0 (type: string)
                                     |     sort order:+
                                     |     Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
                                     |     value expressions:_col3 (type: decimal(17,2))
-                                    |     Select Operator [SEL_79]
+                                    |     Select Operator [SEL_83]
                                     |        outputColumnNames:["_col0","_col3"]
                                     |        Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
-                                    |        Group By Operator [GBY_78]
+                                    |        Group By Operator [GBY_82]
                                     |        |  aggregations:["sum(VALUE._col0)"]
-                                    |        |  keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+                                    |        |  keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
                                     |        |  outputColumnNames:["_col0","_col1","_col2","_col3"]
                                     |        |  Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
                                     |        |<-Reducer 24 [SIMPLE_EDGE]
-                                    |           Reduce Output Operator [RS_77]
-                                    |              key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: string)
-                                    |              Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: string)
+                                    |           Reduce Output Operator [RS_81]
+                                    |              key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+                                    |              Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
                                     |              sort order:+++
                                     |              Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                                     |              value expressions:_col3 (type: decimal(17,2))
-                                    |              Group By Operator [GBY_76]
-                                    |                 aggregations:["sum(_col2)"]
-                                    |                 keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+                                    |              Group By Operator [GBY_80]
+                                    |                 aggregations:["sum(_col3)"]
+                                    |                 keys:_col0 (type: string), 1 (type: int), 1998 (type: int)
                                     |                 outputColumnNames:["_col0","_col1","_col2","_col3"]
                                     |                 Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
-                                    |                 Select Operator [SEL_75]
-                                    |                    outputColumnNames:["_col4","_col5","_col7","_col2"]
+                                    |                 Select Operator [SEL_78]
+                                    |                    outputColumnNames:["_col0","_col3"]
                                     |                    Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
-                                    |                    Merge Join Operator [MERGEJOIN_269]
+                                    |                    Merge Join Operator [MERGEJOIN_275]
                                     |                    |  condition map:[{"":"Inner Join 0 to 1"}]
                                     |                    |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
                                     |                    |  outputColumnNames:["_col2","_col7"]
                                     |                    |  Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                                     |                    |<-Map 27 [SIMPLE_EDGE]
-                                    |                    |  Reduce Output Operator [RS_73]
+                                    |                    |  Reduce Output Operator [RS_76]
                                     |                    |     key expressions:_col0 (type: int)
                                     |                    |     Map-reduce partition columns:_col0 (type: int)
                                     |                    |     sort order:+
                                     |                    |     Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
                                     |                    |     value expressions:_col1 (type: string)
-                                    |                    |     Select Operator [SEL_68]
+                                    |                    |     Select Operator [SEL_71]
                                     |                    |        outputColumnNames:["_col0","_col1"]
                                     |                    |        Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
-                                    |                    |        Filter Operator [FIL_255]
+                                    |                    |        Filter Operator [FIL_261]
                                     |                    |           predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
                                     |                    |           Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
-                                    |                    |           TableScan [TS_66]
+                                    |                    |           TableScan [TS_69]
                                     |                    |              alias:customer_address
                                     |                    |              Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
                                     |                    |<-Reducer 23 [SIMPLE_EDGE]
-                                    |                       Reduce Output Operator [RS_72]
+                                    |                       Reduce Output Operator [RS_75]
                                     |                          key expressions:_col1 (type: int)
                                     |                          Map-reduce partition columns:_col1 (type: int)
                                     |                          sort order:+
                                     |                          Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
                                     |                          value expressions:_col2 (type: decimal(7,2))
-                                    |                          Merge Join Operator [MERGEJOIN_268]
+                                    |                          Merge Join Operator [MERGEJOIN_274]
                                     |                          |  condition map:[{"":"Inner Join 0 to 1"}]
                                     |                          |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
                                     |                          |  outputColumnNames:["_col1","_col2"]
                                     |                          |  Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
                                     |                          |<-Map 22 [SIMPLE_EDGE]
-                                    |                          |  Reduce Output Operator [RS_69]
+                                    |                          |  Reduce Output Operator [RS_72]
                                     |                          |     key expressions:_col0 (type: int)
                                     |                          |     Map-reduce partition columns:_col0 (type: int)
                                     |                          |     sort order:+
                                     |                          |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                     |                          |     value expressions:_col1 (type: int), _col2 (type: decimal(7,2))
-                                    |                          |     Select Operator [SEL_62]
+                                    |                          |     Select Operator [SEL_65]
                                     |                          |        outputColumnNames:["_col0","_col1","_col2"]
                                     |                          |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                          |        Filter Operator [FIL_253]
+                                    |                          |        Filter Operator [FIL_259]
                                     |                          |           predicate:(ws_sold_date_sk is not null and ws_bill_addr_sk is not null) (type: boolean)
                                     |                          |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                          |           TableScan [TS_60]
+                                    |                          |           TableScan [TS_63]
                                     |                          |              alias:web_sales
                                     |                          |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                     |                          |<-Map 26 [SIMPLE_EDGE]
-                                    |                             Reduce Output Operator [RS_70]
+                                    |                             Reduce Output Operator [RS_73]
                                     |                                key expressions:_col0 (type: int)
                                     |                                Map-reduce partition columns:_col0 (type: int)
                                     |                                sort order:+
                                     |                                Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                Select Operator [SEL_65]
+                                    |                                Select Operator [SEL_68]
                                     |                                   outputColumnNames:["_col0"]
                                     |                                   Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                   Filter Operator [FIL_254]
+                                    |                                   Filter Operator [FIL_260]
                                     |                                      predicate:(((d_year = 1998) and (d_qoy = 1)) and d_date_sk is not null) (type: boolean)
                                     |                                      Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                      TableScan [TS_63]
+                                    |                                      TableScan [TS_66]
                                     |                                         alias:date_dim
                                     |                                         Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
                                     |<-Reducer 31 [SIMPLE_EDGE]
-                                    |  Reduce Output Operator [RS_104]
+                                    |  Reduce Output Operator [RS_109]
                                     |     key expressions:_col0 (type: string)
                                     |     Map-reduce partition columns:_col0 (type: string)
                                     |     sort order:+
                                     |     Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
                                     |     value expressions:_col3 (type: decimal(17,2))
-                                    |     Select Operator [SEL_99]
+                                    |     Select Operator [SEL_104]
                                     |        outputColumnNames:["_col0","_col3"]
                                     |        Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
-                                    |        Group By Operator [GBY_98]
+                                    |        Group By Operator [GBY_103]
                                     |        |  aggregations:["sum(VALUE._col0)"]
-                                    |        |  keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+                                    |        |  keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
                                     |        |  outputColumnNames:["_col0","_col1","_col2","_col3"]
                                     |        |  Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
                                     |        |<-Reducer 30 [SIMPLE_EDGE]
-                                    |           Reduce Output Operator [RS_97]
-                                    |              key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: string)
-                                    |              Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: string)
+                                    |           Reduce Output Operator [RS_102]
+                                    |              key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+                                    |              Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
                                     |              sort order:+++
                                     |              Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                                     |              value expressions:_col3 (type: decimal(17,2))
-                                    |              Group By Operator [GBY_96]
-                                    |                 aggregations:["sum(_col2)"]
-                                    |                 keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+                                    |              Group By Operator [GBY_101]
+                                    |                 aggregations:["sum(_col3)"]
+                                    |                 keys:_col0 (type: string), 2 (type: int), 1998 (type: int)
                                     |                 outputColumnNames:["_col0","_col1","_col2","_col3"]
                                     |                 Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
-                                    |                 Select Operator [SEL_95]
-                                    |                    outputColumnNames:["_col4","_col5","_col7","_col2"]
+                                    |                 Select Operator [SEL_99]
+                                    |                    outputColumnNames:["_col0","_col3"]
                                     |                    Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
-                                    |                    Merge Join Operator [MERGEJOIN_271]
+                                    |                    Merge Join Operator [MERGEJOIN_277]
                                     |                    |  condition map:[{"":"Inner Join 0 to 1"}]
                                     |                    |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
                                     |                    |  outputColumnNames:["_col2","_col7"]
                                     |                    |  Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                                     |                    |<-Map 33 [SIMPLE_EDGE]
-                                    |                    |  Reduce Output Operator [RS_93]
+                                    |                    |  Reduce Output Operator [RS_97]
                                     |                    |     key expressions:_col0 (type: int)
                                     |                    |     Map-reduce partition columns:_col0 (type: int)
                                     |                    |     sort order:+
                                     |                    |     Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
                                     |                    |     value expressions:_col1 (type: string)
-                                    |                    |     Select Operator [SEL_88]
+                                    |                    |     Select Operator [SEL_92]
                                     |                    |        outputColumnNames:["_col0","_col1"]
                                     |                    |        Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
-                                    |                    |        Filter Operator [FIL_258]
+                                    |                    |        Filter Operator [FIL_264]
                                     |                    |           predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
                                     |                    |           Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
-                                    |                    |           TableScan [TS_86]
+                                    |                    |           TableScan [TS_90]
                                     |                    |              alias:customer_address
                                     |                    |              Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
                                     |                    |<-Reducer 29 [SIMPLE_EDGE]
-                                    |                       Reduce Output Operator [RS_92]
+                                    |                       Reduce Output Operator [RS_96]
                                     |                          key expressions:_col1 (type: int)
                                     |                          Map-reduce partition columns:_col1 (type: int)
                                     |                          sort order:+
                                     |                          Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
                                     |                          value expressions:_col2 (type: decimal(7,2))
-                                    |                          Merge Join Operator [MERGEJOIN_270]
+                                    |                          Merge Join Operator [MERGEJOIN_276]
                                     |                          |  condition map:[{"":"Inner Join 0 to 1"}]
                                     |                          |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
                                     |                          |  outputColumnNames:["_col1","_col2"]
                                     |                          |  Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
                                     |                          |<-Map 28 [SIMPLE_EDGE]
-                                    |                          |  Reduce Output Operator [RS_89]
+                                    |                          |  Reduce Output Operator [RS_93]
                                     |                          |     key expressions:_col0 (type: int)
                                     |                          |     Map-reduce partition columns:_col0 (type: int)
                                     |                          |     sort order:+
                                     |                          |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                     |                          |     value expressions:_col1 (type: int), _col2 (type: decimal(7,2))
-                                    |                          |     Select Operator [SEL_82]
+                                    |                          |     Select Operator [SEL_86]
                                     |                          |        outputColumnNames:["_col0","_col1","_col2"]
                                     |                          |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                          |        Filter Operator [FIL_256]
+                                    |                          |        Filter Operator [FIL_262]
                                     |                          |           predicate:(ws_sold_date_sk is not null and ws_bill_addr_sk is not null) (type: boolean)
                                     |                          |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                          |           TableScan [TS_80]
+                                    |                          |           TableScan [TS_84]
                                     |                          |              alias:web_sales
                                     |                          |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                     |                          |<-Map 32 [SIMPLE_EDGE]
-                                    |                             Reduce Output Operator [RS_90]
+                                    |                             Reduce Output Operator [RS_94]
                                     |                                key expressions:_col0 (type: int)
                                     |                                Map-reduce partition columns:_col0 (type: int)
                                     |                                sort order:+
                                     |                                Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                Select Operator [SEL_85]
+                                    |                                Select Operator [SEL_89]
                                     |                                   outputColumnNames:["_col0"]
                                     |                                   Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                   Filter Operator [FIL_257]
+                                    |                                   Filter Operator [FIL_263]
                                     |                                      predicate:(((d_qoy = 2) and (d_year = 1998)) and d_date_sk is not null) (type: boolean)
                                     |                                      Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                    |                                      TableScan [TS_83]
+                                    |                                      TableScan [TS_87]
                                     |                                         alias:date_dim
                                     |                                         Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
                                     |<-Reducer 4 [SIMPLE_EDGE]
-                                       Reduce Output Operator [RS_100]
+                                       Reduce Output Operator [RS_105]
                                           key expressions:_col0 (type: string)
                                           Map-reduce partition columns:_col0 (type: string)
                                           sort order:+
                                           Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
-                                          value expressions:_col2 (type: int), _col3 (type: decimal(17,2))
-                                          Select Operator [SEL_19]
-                                             outputColumnNames:["_col0","_col2","_col3"]
+                                          value expressions:_col3 (type: decimal(17,2))
+                                          Select Operator [SEL_20]
+                                             outputColumnNames:["_col0","_col3"]
                                              Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
-                                             Group By Operator [GBY_18]
+                                             Group By Operator [GBY_19]
                                              |  aggregations:["sum(VALUE._col0)"]
-                                             |  keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+                                             |  keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
                                              |  outputColumnNames:["_col0","_col1","_col2","_col3"]
                                              |  Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
                                              |<-Reducer 3 [SIMPLE_EDGE]
-                                                Reduce Output Operator [RS_17]
-                                                   key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: string)
-                                                   Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: string)
+                                                Reduce Output Operator [RS_18]
+                                                   key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+                                                   Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
                                                    sort order:+++
                                                    Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                                                    value expressions:_col3 (type: decimal(17,2))
-                                                   Group By Operator [GBY_16]
-                                                      aggregations:["sum(_col2)"]
-                                                      keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+                                                   Group By Operator [GBY_17]
+                                                      aggregations:["sum(_col3)"]
+                                                      keys:_col0 (type: string), 1 (type: int), 1998 (type: int)
                                                       outputColumnNames:["_col0","_col1","_col2","_col3"]
                                                       Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
                                                       Select Operator [SEL_15]
-                                                         outputColumnNames:["_col4","_col5","_col7","_col2"]
+                                                         outputColumnNames:["_col0","_col3"]
                                                          Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
-                                                         Merge Join Operator [MERGEJOIN_263]
+                                                         Merge Join Operator [MERGEJOIN_269]
                                                          |  condition map:[{"":"Inner Join 0 to 1"}]
                                                          |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
                                                          |  outputColumnNames:["_col2","_col7"]
@@ -589,7 +589,7 @@ Stage-0
                                                          |     Select Operator [SEL_8]
                                                          |        outputColumnNames:["_col0","_col1"]
                                                          |        Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
-                                                         |        Filter Operator [FIL_246]
+                                                         |        Filter Operator [FIL_252]
                                                          |           predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
                                                          |           Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
                                                          |           TableScan [TS_6]
@@ -602,7 +602,7 @@ Stage-0
                                                                sort order:+
                                                                Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
                                                                value expressions:_col2 (type: decimal(7,2))
-                                                               Merge Join Operator [MERGEJOIN_262]
+                                                               Merge Join Operator [MERGEJOIN_268]
                                                                |  condition map:[{"":"Inner Join 0 to 1"}]
                                                                |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
                                                                |  outputColumnNames:["_col1","_col2"]
@@ -617,7 +617,7 @@ Stage-0
                                                                |     Select Operator [SEL_2]
                                                                |        outputColumnNames:["_col0","_col1","_col2"]
                                                                |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                                               |        Filter Operator [FIL_244]
+                                                               |        Filter Operator [FIL_250]
                                                                |           predicate:(ss_sold_date_sk is not null and ss_addr_sk is not null) (type: boolean)
                                                                |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                                                                |           TableScan [TS_0]
@@ -632,7 +632,7 @@ Stage-0
                                                                      Select Operator [SEL_5]
                                                                         outputColumnNames:["_col0"]
                                                                         Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
-                                                                        Filter Operator [FIL_245]
+                                                                        Filter Operator [FIL_251]
                                                                            predicate:(((d_year = 1998) and (d_qoy = 1)) and d_date_sk is not null) (type: boolean)
                                                                            Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
                                                                            TableScan [TS_3]


Mime
View raw message