hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pxi...@apache.org
Subject [3/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:46 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/b340ecb5/ql/src/test/results/clientpositive/perf/query75.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query75.q.out b/ql/src/test/results/clientpositive/perf/query75.q.out
index d54000b..f3f9827 100644
--- a/ql/src/test/results/clientpositive/perf/query75.q.out
+++ b/ql/src/test/results/clientpositive/perf/query75.q.out
@@ -48,9 +48,9 @@ Stage-0
                      key expressions:_col8 (type: bigint)
                      sort order:+
                      Statistics:Num rows: 169103 Data size: 242878993 Basic stats: COMPLETE Column stats: NONE
-                     value expressions:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: bigint), _col7 (type: bigint), _col9 (type: double)
+                     value expressions:_col0 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: bigint), _col7 (type: bigint), _col9 (type: double)
                      Select Operator [SEL_146]
-                        outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9"]
+                        outputColumnNames:["_col0","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9"]
                         Statistics:Num rows: 169103 Data size: 242878993 Basic stats: COMPLETE Column stats: NONE
                         Filter Operator [FIL_145]
                            predicate:((CAST( _col5 AS decimal(17,2)) / CAST( _col12 AS decimal(17,2))) < 0.9) (type: boolean)
@@ -58,7 +58,7 @@ Stage-0
                            Merge Join Operator [MERGEJOIN_253]
                            |  condition map:[{"":"Inner Join 0 to 1"}]
                            |  keys:{"0":"_col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)","1":"_col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)"}
-                           |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col12","_col13"]
+                           |  outputColumnNames:["_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col12","_col13"]
                            |  Statistics:Num rows: 507310 Data size: 728638416 Basic stats: COMPLETE Column stats: NONE
                            |<-Reducer 31 [SIMPLE_EDGE]
                            |  Reduce Output Operator [RS_143]
@@ -394,326 +394,335 @@ Stage-0
                                  Map-reduce partition columns:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
                                  sort order:++++
                                  Statistics:Num rows: 461191 Data size: 662398546 Basic stats: COMPLETE Column stats: NONE
-                                 value expressions:_col0 (type: int), _col5 (type: bigint), _col6 (type: double)
-                                 Group By Operator [GBY_69]
-                                 |  aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"]
-                                 |  keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: int), KEY._col3 (type: int), KEY._col4 (type: int)
-                                 |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
-                                 |  Statistics:Num rows: 461191 Data size: 662398546 Basic stats: COMPLETE Column stats: NONE
-                                 |<-Union 5 [SIMPLE_EDGE]
-                                    |<-Reducer 15 [CONTAINS]
-                                    |  Reduce Output Operator [RS_68]
-                                    |     key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
-                                    |     Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
-                                    |     sort order:+++++
-                                    |     Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
-                                    |     value expressions:_col5 (type: bigint), _col6 (type: double)
-                                    |     Group By Operator [GBY_67]
-                                    |        aggregations:["sum(_col5)","sum(_col6)"]
-                                    |        keys:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
-                                    |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
-                                    |        Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
-                                    |        Select Operator [SEL_41]
-                                    |           outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
-                                    |           Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
-                                    |           Merge Join Operator [MERGEJOIN_240]
-                                    |           |  condition map:[{"":"Left Outer Join0 to 1"}]
-                                    |           |  keys:{"0":"_col2 (type: int), _col1 (type: int)","1":"_col1 (type: int), _col0 (type: int)"}
-                                    |           |  outputColumnNames:["_col3","_col4","_col6","_col7","_col8","_col10","_col12","_col15","_col16"]
-                                    |           |  Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
-                                    |           |<-Map 18 [SIMPLE_EDGE]
-                                    |           |  Reduce Output Operator [RS_39]
-                                    |           |     key expressions:_col1 (type: int), _col0 (type: int)
-                                    |           |     Map-reduce partition columns:_col1 (type: int), _col0 (type: int)
-                                    |           |     sort order:++
-                                    |           |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |           |     value expressions:_col2 (type: int), _col3 (type: decimal(7,2))
-                                    |           |     Select Operator [SEL_31]
-                                    |           |        outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                    |           |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |           |        TableScan [TS_30]
-                                    |           |           alias:store_returns
-                                    |           |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |           |<-Reducer 14 [SIMPLE_EDGE]
-                                    |              Reduce Output Operator [RS_38]
-                                    |                 key expressions:_col2 (type: int), _col1 (type: int)
-                                    |                 Map-reduce partition columns:_col2 (type: int), _col1 (type: int)
-                                    |                 sort order:++
-                                    |                 Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
-                                    |                 value expressions:_col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int), _col12 (type: int)
-                                    |                 Merge Join Operator [MERGEJOIN_239]
-                                    |                 |  condition map:[{"":"Inner Join 0 to 1"}]
-                                    |                 |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
-                                    |                 |  outputColumnNames:["_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10","_col12"]
-                                    |                 |  Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
-                                    |                 |<-Map 17 [SIMPLE_EDGE]
-                                    |                 |  Reduce Output Operator [RS_36]
-                                    |                 |     key expressions:_col0 (type: int)
-                                    |                 |     Map-reduce partition columns:_col0 (type: int)
-                                    |                 |     sort order:+
-                                    |                 |     Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                                    |                 |     value expressions:2002 (type: int)
-                                    |                 |     Select Operator [SEL_29]
-                                    |                 |        outputColumnNames:["_col0"]
-                                    |                 |        Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                                    |                 |        Filter Operator [FIL_217]
-                                    |                 |           predicate:((d_year = 2002) and d_date_sk is not null) (type: boolean)
-                                    |                 |           Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                                    |                 |           TableScan [TS_27]
-                                    |                 |              alias:date_dim
-                                    |                 |              Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
-                                    |                 |<-Reducer 13 [SIMPLE_EDGE]
-                                    |                    Reduce Output Operator [RS_35]
-                                    |                       key expressions:_col0 (type: int)
-                                    |                       Map-reduce partition columns:_col0 (type: int)
-                                    |                       sort order:+
-                                    |                       Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
-                                    |                       value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int)
-                                    |                       Merge Join Operator [MERGEJOIN_238]
-                                    |                       |  condition map:[{"":"Inner Join 0 to 1"}]
-                                    |                       |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
-                                    |                       |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10"]
-                                    |                       |  Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
-                                    |                       |<-Map 12 [SIMPLE_EDGE]
-                                    |                       |  Reduce Output Operator [RS_32]
-                                    |                       |     key expressions:_col1 (type: int)
-                                    |                       |     Map-reduce partition columns:_col1 (type: int)
-                                    |                       |     sort order:+
-                                    |                       |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                       |     value expressions:_col0 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2))
-                                    |                       |     Select Operator [SEL_23]
-                                    |                       |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
-                                    |                       |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                       |        Filter Operator [FIL_215]
-                                    |                       |           predicate:(ss_item_sk is not null and ss_sold_date_sk is not null) (type: boolean)
-                                    |                       |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                       |           TableScan [TS_21]
-                                    |                       |              alias:store_sales
-                                    |                       |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                       |<-Map 16 [SIMPLE_EDGE]
-                                    |                          Reduce Output Operator [RS_33]
-                                    |                             key expressions:_col0 (type: int)
-                                    |                             Map-reduce partition columns:_col0 (type: int)
-                                    |                             sort order:+
-                                    |                             Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
-                                    |                             value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col5 (type: int)
-                                    |                             Select Operator [SEL_26]
-                                    |                                outputColumnNames:["_col0","_col1","_col2","_col3","_col5"]
-                                    |                                Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
-                                    |                                Filter Operator [FIL_216]
-                                    |                                   predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_category_id is not null) and i_manufact_id is not null) and i_class_id is not null) and i_brand_id is not null) (type: boolean)
-                                    |                                   Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
-                                    |                                   TableScan [TS_24]
-                                    |                                      alias:item
-                                    |                                      Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
-                                    |<-Reducer 22 [CONTAINS]
-                                    |  Reduce Output Operator [RS_68]
-                                    |     key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
-                                    |     Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
-                                    |     sort order:+++++
-                                    |     Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
-                                    |     value expressions:_col5 (type: bigint), _col6 (type: double)
-                                    |     Group By Operator [GBY_67]
-                                    |        aggregations:["sum(_col5)","sum(_col6)"]
-                                    |        keys:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
-                                    |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
-                                    |        Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
-                                    |        Select Operator [SEL_64]
-                                    |           outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
-                                    |           Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
-                                    |           Merge Join Operator [MERGEJOIN_243]
-                                    |           |  condition map:[{"":"Left Outer Join0 to 1"}]
-                                    |           |  keys:{"0":"_col2 (type: int), _col1 (type: int)","1":"_col1 (type: int), _col0 (type: int)"}
-                                    |           |  outputColumnNames:["_col3","_col4","_col6","_col7","_col8","_col10","_col12","_col15","_col16"]
-                                    |           |  Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
-                                    |           |<-Map 25 [SIMPLE_EDGE]
-                                    |           |  Reduce Output Operator [RS_62]
-                                    |           |     key expressions:_col1 (type: int), _col0 (type: int)
-                                    |           |     Map-reduce partition columns:_col1 (type: int), _col0 (type: int)
-                                    |           |     sort order:++
-                                    |           |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |           |     value expressions:_col2 (type: int), _col3 (type: decimal(7,2))
-                                    |           |     Select Operator [SEL_54]
-                                    |           |        outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                    |           |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |           |        TableScan [TS_53]
-                                    |           |           alias:web_returns
-                                    |           |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |           |<-Reducer 21 [SIMPLE_EDGE]
-                                    |              Reduce Output Operator [RS_61]
-                                    |                 key expressions:_col2 (type: int), _col1 (type: int)
-                                    |                 Map-reduce partition columns:_col2 (type: int), _col1 (type: int)
-                                    |                 sort order:++
-                                    |                 Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
-                                    |                 value expressions:_col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int), _col12 (type: int)
-                                    |                 Merge Join Operator [MERGEJOIN_242]
-                                    |                 |  condition map:[{"":"Inner Join 0 to 1"}]
-                                    |                 |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
-                                    |                 |  outputColumnNames:["_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10","_col12"]
-                                    |                 |  Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
-                                    |                 |<-Map 24 [SIMPLE_EDGE]
-                                    |                 |  Reduce Output Operator [RS_59]
-                                    |                 |     key expressions:_col0 (type: int)
-                                    |                 |     Map-reduce partition columns:_col0 (type: int)
-                                    |                 |     sort order:+
-                                    |                 |     Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                                    |                 |     value expressions:2002 (type: int)
-                                    |                 |     Select Operator [SEL_52]
-                                    |                 |        outputColumnNames:["_col0"]
-                                    |                 |        Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                                    |                 |        Filter Operator [FIL_221]
-                                    |                 |           predicate:((d_year = 2002) and d_date_sk is not null) (type: boolean)
-                                    |                 |           Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                                    |                 |           TableScan [TS_50]
-                                    |                 |              alias:date_dim
-                                    |                 |              Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
-                                    |                 |<-Reducer 20 [SIMPLE_EDGE]
-                                    |                    Reduce Output Operator [RS_58]
-                                    |                       key expressions:_col0 (type: int)
-                                    |                       Map-reduce partition columns:_col0 (type: int)
-                                    |                       sort order:+
-                                    |                       Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
-                                    |                       value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int)
-                                    |                       Merge Join Operator [MERGEJOIN_241]
-                                    |                       |  condition map:[{"":"Inner Join 0 to 1"}]
-                                    |                       |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
-                                    |                       |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10"]
-                                    |                       |  Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
-                                    |                       |<-Map 19 [SIMPLE_EDGE]
-                                    |                       |  Reduce Output Operator [RS_55]
-                                    |                       |     key expressions:_col1 (type: int)
-                                    |                       |     Map-reduce partition columns:_col1 (type: int)
-                                    |                       |     sort order:+
-                                    |                       |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                       |     value expressions:_col0 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2))
-                                    |                       |     Select Operator [SEL_46]
-                                    |                       |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
-                                    |                       |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                       |        Filter Operator [FIL_219]
-                                    |                       |           predicate:(ws_item_sk is not null and ws_sold_date_sk is not null) (type: boolean)
-                                    |                       |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                       |           TableScan [TS_44]
-                                    |                       |              alias:web_sales
-                                    |                       |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                    |                       |<-Map 23 [SIMPLE_EDGE]
-                                    |                          Reduce Output Operator [RS_56]
-                                    |                             key expressions:_col0 (type: int)
-                                    |                             Map-reduce partition columns:_col0 (type: int)
-                                    |                             sort order:+
-                                    |                             Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
-                                    |                             value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col5 (type: int)
-                                    |                             Select Operator [SEL_49]
-                                    |                                outputColumnNames:["_col0","_col1","_col2","_col3","_col5"]
-                                    |                                Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
-                                    |                                Filter Operator [FIL_220]
-                                    |                                   predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_category_id is not null) and i_manufact_id is not null) and i_class_id is not null) and i_brand_id is not null) (type: boolean)
-                                    |                                   Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
-                                    |                                   TableScan [TS_47]
-                                    |                                      alias:item
-                                    |                                      Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
-                                    |<-Reducer 4 [CONTAINS]
-                                       Reduce Output Operator [RS_68]
-                                          key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
-                                          Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
-                                          sort order:+++++
-                                          Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
-                                          value expressions:_col5 (type: bigint), _col6 (type: double)
-                                          Group By Operator [GBY_67]
-                                             aggregations:["sum(_col5)","sum(_col6)"]
-                                             keys:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
-                                             outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
+                                 value expressions:_col5 (type: bigint), _col6 (type: double)
+                                 Select Operator [SEL_70]
+                                    outputColumnNames:["_col1","_col2","_col3","_col4","_col5","_col6"]
+                                    Statistics:Num rows: 461191 Data size: 662398546 Basic stats: COMPLETE Column stats: NONE
+                                    Group By Operator [GBY_69]
+                                    |  aggregations:["sum(VALUE._col0)","sum(VALUE._col1)"]
+                                    |  keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: int), KEY._col3 (type: int), KEY._col4 (type: int)
+                                    |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
+                                    |  Statistics:Num rows: 461191 Data size: 662398546 Basic stats: COMPLETE Column stats: NONE
+                                    |<-Union 5 [SIMPLE_EDGE]
+                                       |<-Reducer 15 [CONTAINS]
+                                       |  Reduce Output Operator [RS_68]
+                                       |     key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
+                                       |     Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
+                                       |     sort order:+++++
+                                       |     Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
+                                       |     value expressions:_col5 (type: bigint), _col6 (type: double)
+                                       |     Group By Operator [GBY_67]
+                                       |        aggregations:["sum(_col5)","sum(_col6)"]
+                                       |        keys:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
+                                       |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
+                                       |        Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
+                                       |        Select Operator [SEL_65]
+                                       |           outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
+                                       |           Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
+                                       |           Select Operator [SEL_41]
+                                       |              outputColumnNames:["_col1","_col2","_col3","_col4","_col5","_col6"]
+                                       |              Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
+                                       |              Merge Join Operator [MERGEJOIN_240]
+                                       |              |  condition map:[{"":"Left Outer Join0 to 1"}]
+                                       |              |  keys:{"0":"_col2 (type: int), _col1 (type: int)","1":"_col1 (type: int), _col0 (type: int)"}
+                                       |              |  outputColumnNames:["_col3","_col4","_col6","_col7","_col8","_col10","_col15","_col16"]
+                                       |              |  Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
+                                       |              |<-Map 18 [SIMPLE_EDGE]
+                                       |              |  Reduce Output Operator [RS_39]
+                                       |              |     key expressions:_col1 (type: int), _col0 (type: int)
+                                       |              |     Map-reduce partition columns:_col1 (type: int), _col0 (type: int)
+                                       |              |     sort order:++
+                                       |              |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |              |     value expressions:_col2 (type: int), _col3 (type: decimal(7,2))
+                                       |              |     Select Operator [SEL_31]
+                                       |              |        outputColumnNames:["_col0","_col1","_col2","_col3"]
+                                       |              |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |              |        TableScan [TS_30]
+                                       |              |           alias:store_returns
+                                       |              |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |              |<-Reducer 14 [SIMPLE_EDGE]
+                                       |                 Reduce Output Operator [RS_38]
+                                       |                    key expressions:_col2 (type: int), _col1 (type: int)
+                                       |                    Map-reduce partition columns:_col2 (type: int), _col1 (type: int)
+                                       |                    sort order:++
+                                       |                    Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
+                                       |                    value expressions:_col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int)
+                                       |                    Merge Join Operator [MERGEJOIN_239]
+                                       |                    |  condition map:[{"":"Inner Join 0 to 1"}]
+                                       |                    |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
+                                       |                    |  outputColumnNames:["_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10"]
+                                       |                    |  Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
+                                       |                    |<-Map 17 [SIMPLE_EDGE]
+                                       |                    |  Reduce Output Operator [RS_36]
+                                       |                    |     key expressions:_col0 (type: int)
+                                       |                    |     Map-reduce partition columns:_col0 (type: int)
+                                       |                    |     sort order:+
+                                       |                    |     Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
+                                       |                    |     Select Operator [SEL_29]
+                                       |                    |        outputColumnNames:["_col0"]
+                                       |                    |        Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
+                                       |                    |        Filter Operator [FIL_217]
+                                       |                    |           predicate:((d_year = 2002) and d_date_sk is not null) (type: boolean)
+                                       |                    |           Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
+                                       |                    |           TableScan [TS_27]
+                                       |                    |              alias:date_dim
+                                       |                    |              Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
+                                       |                    |<-Reducer 13 [SIMPLE_EDGE]
+                                       |                       Reduce Output Operator [RS_35]
+                                       |                          key expressions:_col0 (type: int)
+                                       |                          Map-reduce partition columns:_col0 (type: int)
+                                       |                          sort order:+
+                                       |                          Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
+                                       |                          value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int)
+                                       |                          Merge Join Operator [MERGEJOIN_238]
+                                       |                          |  condition map:[{"":"Inner Join 0 to 1"}]
+                                       |                          |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
+                                       |                          |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10"]
+                                       |                          |  Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
+                                       |                          |<-Map 12 [SIMPLE_EDGE]
+                                       |                          |  Reduce Output Operator [RS_32]
+                                       |                          |     key expressions:_col1 (type: int)
+                                       |                          |     Map-reduce partition columns:_col1 (type: int)
+                                       |                          |     sort order:+
+                                       |                          |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |                          |     value expressions:_col0 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2))
+                                       |                          |     Select Operator [SEL_23]
+                                       |                          |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
+                                       |                          |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |                          |        Filter Operator [FIL_215]
+                                       |                          |           predicate:(ss_item_sk is not null and ss_sold_date_sk is not null) (type: boolean)
+                                       |                          |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |                          |           TableScan [TS_21]
+                                       |                          |              alias:store_sales
+                                       |                          |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |                          |<-Map 16 [SIMPLE_EDGE]
+                                       |                             Reduce Output Operator [RS_33]
+                                       |                                key expressions:_col0 (type: int)
+                                       |                                Map-reduce partition columns:_col0 (type: int)
+                                       |                                sort order:+
+                                       |                                Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
+                                       |                                value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col5 (type: int)
+                                       |                                Select Operator [SEL_26]
+                                       |                                   outputColumnNames:["_col0","_col1","_col2","_col3","_col5"]
+                                       |                                   Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
+                                       |                                   Filter Operator [FIL_216]
+                                       |                                      predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_category_id is not null) and i_manufact_id is not null) and i_class_id is not null) and i_brand_id is not null) (type: boolean)
+                                       |                                      Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
+                                       |                                      TableScan [TS_24]
+                                       |                                         alias:item
+                                       |                                         Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
+                                       |<-Reducer 22 [CONTAINS]
+                                       |  Reduce Output Operator [RS_68]
+                                       |     key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
+                                       |     Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
+                                       |     sort order:+++++
+                                       |     Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
+                                       |     value expressions:_col5 (type: bigint), _col6 (type: double)
+                                       |     Group By Operator [GBY_67]
+                                       |        aggregations:["sum(_col5)","sum(_col6)"]
+                                       |        keys:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
+                                       |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
+                                       |        Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
+                                       |        Select Operator [SEL_65]
+                                       |           outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
+                                       |           Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
+                                       |           Select Operator [SEL_64]
+                                       |              outputColumnNames:["_col1","_col2","_col3","_col4","_col5","_col6"]
+                                       |              Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
+                                       |              Merge Join Operator [MERGEJOIN_243]
+                                       |              |  condition map:[{"":"Left Outer Join0 to 1"}]
+                                       |              |  keys:{"0":"_col2 (type: int), _col1 (type: int)","1":"_col1 (type: int), _col0 (type: int)"}
+                                       |              |  outputColumnNames:["_col3","_col4","_col6","_col7","_col8","_col10","_col15","_col16"]
+                                       |              |  Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
+                                       |              |<-Map 25 [SIMPLE_EDGE]
+                                       |              |  Reduce Output Operator [RS_62]
+                                       |              |     key expressions:_col1 (type: int), _col0 (type: int)
+                                       |              |     Map-reduce partition columns:_col1 (type: int), _col0 (type: int)
+                                       |              |     sort order:++
+                                       |              |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |              |     value expressions:_col2 (type: int), _col3 (type: decimal(7,2))
+                                       |              |     Select Operator [SEL_54]
+                                       |              |        outputColumnNames:["_col0","_col1","_col2","_col3"]
+                                       |              |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |              |        TableScan [TS_53]
+                                       |              |           alias:web_returns
+                                       |              |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |              |<-Reducer 21 [SIMPLE_EDGE]
+                                       |                 Reduce Output Operator [RS_61]
+                                       |                    key expressions:_col2 (type: int), _col1 (type: int)
+                                       |                    Map-reduce partition columns:_col2 (type: int), _col1 (type: int)
+                                       |                    sort order:++
+                                       |                    Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
+                                       |                    value expressions:_col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int)
+                                       |                    Merge Join Operator [MERGEJOIN_242]
+                                       |                    |  condition map:[{"":"Inner Join 0 to 1"}]
+                                       |                    |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
+                                       |                    |  outputColumnNames:["_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10"]
+                                       |                    |  Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
+                                       |                    |<-Map 24 [SIMPLE_EDGE]
+                                       |                    |  Reduce Output Operator [RS_59]
+                                       |                    |     key expressions:_col0 (type: int)
+                                       |                    |     Map-reduce partition columns:_col0 (type: int)
+                                       |                    |     sort order:+
+                                       |                    |     Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
+                                       |                    |     Select Operator [SEL_52]
+                                       |                    |        outputColumnNames:["_col0"]
+                                       |                    |        Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
+                                       |                    |        Filter Operator [FIL_221]
+                                       |                    |           predicate:((d_year = 2002) and d_date_sk is not null) (type: boolean)
+                                       |                    |           Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
+                                       |                    |           TableScan [TS_50]
+                                       |                    |              alias:date_dim
+                                       |                    |              Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
+                                       |                    |<-Reducer 20 [SIMPLE_EDGE]
+                                       |                       Reduce Output Operator [RS_58]
+                                       |                          key expressions:_col0 (type: int)
+                                       |                          Map-reduce partition columns:_col0 (type: int)
+                                       |                          sort order:+
+                                       |                          Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
+                                       |                          value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int)
+                                       |                          Merge Join Operator [MERGEJOIN_241]
+                                       |                          |  condition map:[{"":"Inner Join 0 to 1"}]
+                                       |                          |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
+                                       |                          |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10"]
+                                       |                          |  Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
+                                       |                          |<-Map 19 [SIMPLE_EDGE]
+                                       |                          |  Reduce Output Operator [RS_55]
+                                       |                          |     key expressions:_col1 (type: int)
+                                       |                          |     Map-reduce partition columns:_col1 (type: int)
+                                       |                          |     sort order:+
+                                       |                          |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |                          |     value expressions:_col0 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2))
+                                       |                          |     Select Operator [SEL_46]
+                                       |                          |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
+                                       |                          |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |                          |        Filter Operator [FIL_219]
+                                       |                          |           predicate:(ws_item_sk is not null and ws_sold_date_sk is not null) (type: boolean)
+                                       |                          |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |                          |           TableScan [TS_44]
+                                       |                          |              alias:web_sales
+                                       |                          |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                       |                          |<-Map 23 [SIMPLE_EDGE]
+                                       |                             Reduce Output Operator [RS_56]
+                                       |                                key expressions:_col0 (type: int)
+                                       |                                Map-reduce partition columns:_col0 (type: int)
+                                       |                                sort order:+
+                                       |                                Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
+                                       |                                value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col5 (type: int)
+                                       |                                Select Operator [SEL_49]
+                                       |                                   outputColumnNames:["_col0","_col1","_col2","_col3","_col5"]
+                                       |                                   Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
+                                       |                                   Filter Operator [FIL_220]
+                                       |                                      predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_category_id is not null) and i_manufact_id is not null) and i_class_id is not null) and i_brand_id is not null) (type: boolean)
+                                       |                                      Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
+                                       |                                      TableScan [TS_47]
+                                       |                                         alias:item
+                                       |                                         Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
+                                       |<-Reducer 4 [CONTAINS]
+                                          Reduce Output Operator [RS_68]
+                                             key expressions:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
+                                             Map-reduce partition columns:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
+                                             sort order:+++++
                                              Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
-                                             Select Operator [SEL_20]
+                                             value expressions:_col5 (type: bigint), _col6 (type: double)
+                                             Group By Operator [GBY_67]
+                                                aggregations:["sum(_col5)","sum(_col6)"]
+                                                keys:_col0 (type: int), _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int)
                                                 outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
-                                                Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
-                                                Merge Join Operator [MERGEJOIN_237]
-                                                |  condition map:[{"":"Left Outer Join0 to 1"}]
-                                                |  keys:{"0":"_col2 (type: int), _col1 (type: int)","1":"_col1 (type: int), _col0 (type: int)"}
-                                                |  outputColumnNames:["_col3","_col4","_col6","_col7","_col8","_col10","_col12","_col15","_col16"]
-                                                |  Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
-                                                |<-Map 11 [SIMPLE_EDGE]
-                                                |  Reduce Output Operator [RS_18]
-                                                |     key expressions:_col1 (type: int), _col0 (type: int)
-                                                |     Map-reduce partition columns:_col1 (type: int), _col0 (type: int)
-                                                |     sort order:++
-                                                |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                                |     value expressions:_col2 (type: int), _col3 (type: decimal(7,2))
-                                                |     Select Operator [SEL_10]
-                                                |        outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                                |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                                |        TableScan [TS_9]
-                                                |           alias:catalog_returns
-                                                |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                                |<-Reducer 3 [SIMPLE_EDGE]
-                                                   Reduce Output Operator [RS_17]
-                                                      key expressions:_col2 (type: int), _col1 (type: int)
-                                                      Map-reduce partition columns:_col2 (type: int), _col1 (type: int)
-                                                      sort order:++
-                                                      Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
-                                                      value expressions:_col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int), _col12 (type: int)
-                                                      Merge Join Operator [MERGEJOIN_236]
-                                                      |  condition map:[{"":"Inner Join 0 to 1"}]
-                                                      |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
-                                                      |  outputColumnNames:["_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10","_col12"]
-                                                      |  Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
-                                                      |<-Map 10 [SIMPLE_EDGE]
-                                                      |  Reduce Output Operator [RS_15]
-                                                      |     key expressions:_col0 (type: int)
-                                                      |     Map-reduce partition columns:_col0 (type: int)
-                                                      |     sort order:+
-                                                      |     Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                                                      |     value expressions:2002 (type: int)
-                                                      |     Select Operator [SEL_8]
-                                                      |        outputColumnNames:["_col0"]
-                                                      |        Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                                                      |        Filter Operator [FIL_213]
-                                                      |           predicate:((d_year = 2002) and d_date_sk is not null) (type: boolean)
-                                                      |           Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
-                                                      |           TableScan [TS_6]
-                                                      |              alias:date_dim
-                                                      |              Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
-                                                      |<-Reducer 2 [SIMPLE_EDGE]
-                                                         Reduce Output Operator [RS_14]
-                                                            key expressions:_col0 (type: int)
-                                                            Map-reduce partition columns:_col0 (type: int)
-                                                            sort order:+
-                                                            Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
-                                                            value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int)
-                                                            Merge Join Operator [MERGEJOIN_235]
+                                                Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
+                                                Select Operator [SEL_65]
+                                                   outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
+                                                   Statistics:Num rows: 922383 Data size: 1324798530 Basic stats: COMPLETE Column stats: NONE
+                                                   Select Operator [SEL_20]
+                                                      outputColumnNames:["_col1","_col2","_col3","_col4","_col5","_col6"]
+                                                      Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
+                                                      Merge Join Operator [MERGEJOIN_237]
+                                                      |  condition map:[{"":"Left Outer Join0 to 1"}]
+                                                      |  keys:{"0":"_col2 (type: int), _col1 (type: int)","1":"_col1 (type: int), _col0 (type: int)"}
+                                                      |  outputColumnNames:["_col3","_col4","_col6","_col7","_col8","_col10","_col15","_col16"]
+                                                      |  Statistics:Num rows: 307461 Data size: 441599510 Basic stats: COMPLETE Column stats: NONE
+                                                      |<-Map 11 [SIMPLE_EDGE]
+                                                      |  Reduce Output Operator [RS_18]
+                                                      |     key expressions:_col1 (type: int), _col0 (type: int)
+                                                      |     Map-reduce partition columns:_col1 (type: int), _col0 (type: int)
+                                                      |     sort order:++
+                                                      |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                                      |     value expressions:_col2 (type: int), _col3 (type: decimal(7,2))
+                                                      |     Select Operator [SEL_10]
+                                                      |        outputColumnNames:["_col0","_col1","_col2","_col3"]
+                                                      |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                                      |        TableScan [TS_9]
+                                                      |           alias:catalog_returns
+                                                      |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                                      |<-Reducer 3 [SIMPLE_EDGE]
+                                                         Reduce Output Operator [RS_17]
+                                                            key expressions:_col2 (type: int), _col1 (type: int)
+                                                            Map-reduce partition columns:_col2 (type: int), _col1 (type: int)
+                                                            sort order:++
+                                                            Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
+                                                            value expressions:_col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int)
+                                                            Merge Join Operator [MERGEJOIN_236]
                                                             |  condition map:[{"":"Inner Join 0 to 1"}]
-                                                            |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
-                                                            |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10"]
-                                                            |  Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
-                                                            |<-Map 1 [SIMPLE_EDGE]
-                                                            |  Reduce Output Operator [RS_11]
-                                                            |     key expressions:_col1 (type: int)
-                                                            |     Map-reduce partition columns:_col1 (type: int)
+                                                            |  keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
+                                                            |  outputColumnNames:["_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10"]
+                                                            |  Statistics:Num rows: 279510 Data size: 401454092 Basic stats: COMPLETE Column stats: NONE
+                                                            |<-Map 10 [SIMPLE_EDGE]
+                                                            |  Reduce Output Operator [RS_15]
+                                                            |     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:_col0 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2))
-                                                            |     Select Operator [SEL_2]
-                                                            |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
-                                                            |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                                            |        Filter Operator [FIL_211]
-                                                            |           predicate:(cs_item_sk is not null and cs_sold_date_sk is not null) (type: boolean)
-                                                            |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                                            |           TableScan [TS_0]
-                                                            |              alias:catalog_sales
-                                                            |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-                                                            |<-Map 9 [SIMPLE_EDGE]
-                                                               Reduce Output Operator [RS_12]
+                                                            |     Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
+                                                            |     Select Operator [SEL_8]
+                                                            |        outputColumnNames:["_col0"]
+                                                            |        Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
+                                                            |        Filter Operator [FIL_213]
+                                                            |           predicate:((d_year = 2002) and d_date_sk is not null) (type: boolean)
+                                                            |           Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
+                                                            |           TableScan [TS_6]
+                                                            |              alias:date_dim
+                                                            |              Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
+                                                            |<-Reducer 2 [SIMPLE_EDGE]
+                                                               Reduce Output Operator [RS_14]
                                                                   key expressions:_col0 (type: int)
                                                                   Map-reduce partition columns:_col0 (type: int)
                                                                   sort order:+
-                                                                  Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
-                                                                  value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col5 (type: int)
-                                                                  Select Operator [SEL_5]
-                                                                     outputColumnNames:["_col0","_col1","_col2","_col3","_col5"]
-                                                                     Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
-                                                                     Filter Operator [FIL_212]
-                                                                        predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_category_id is not null) and i_manufact_id is not null) and i_class_id is not null) and i_brand_id is not null) (type: boolean)
+                                                                  Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
+                                                                  value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2)), _col6 (type: int), _col7 (type: int), _col8 (type: int), _col10 (type: int)
+                                                                  Merge Join Operator [MERGEJOIN_235]
+                                                                  |  condition map:[{"":"Inner Join 0 to 1"}]
+                                                                  |  keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
+                                                                  |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col6","_col7","_col8","_col10"]
+                                                                  |  Statistics:Num rows: 254100 Data size: 364958258 Basic stats: COMPLETE Column stats: NONE
+                                                                  |<-Map 1 [SIMPLE_EDGE]
+                                                                  |  Reduce Output Operator [RS_11]
+                                                                  |     key expressions:_col1 (type: int)
+                                                                  |     Map-reduce partition columns:_col1 (type: int)
+                                                                  |     sort order:+
+                                                                  |     Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                                                  |     value expressions:_col0 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: decimal(7,2))
+                                                                  |     Select Operator [SEL_2]
+                                                                  |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
+                                                                  |        Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                                                  |        Filter Operator [FIL_211]
+                                                                  |           predicate:(cs_item_sk is not null and cs_sold_date_sk is not null) (type: boolean)
+                                                                  |           Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                                                  |           TableScan [TS_0]
+                                                                  |              alias:catalog_sales
+                                                                  |              Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+                                                                  |<-Map 9 [SIMPLE_EDGE]
+                                                                     Reduce Output Operator [RS_12]
+                                                                        key expressions:_col0 (type: int)
+                                                                        Map-reduce partition columns:_col0 (type: int)
+                                                                        sort order:+
                                                                         Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
-                                                                        TableScan [TS_3]
-                                                                           alias:item
-                                                                           Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
+                                                                        value expressions:_col1 (type: int), _col2 (type: int), _col3 (type: int), _col5 (type: int)
+                                                                        Select Operator [SEL_5]
+                                                                           outputColumnNames:["_col0","_col1","_col2","_col3","_col5"]
+                                                                           Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
+                                                                           Filter Operator [FIL_212]
+                                                                              predicate:((((((i_category = 'Sports') and i_item_sk is not null) and i_category_id is not null) and i_manufact_id is not null) and i_class_id is not null) and i_brand_id is not null) (type: boolean)
+                                                                              Statistics:Num rows: 231000 Data size: 331780228 Basic stats: COMPLETE Column stats: NONE
+                                                                              TableScan [TS_3]
+                                                                                 alias:item
+                                                                                 Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
 

http://git-wip-us.apache.org/repos/asf/hive/blob/b340ecb5/ql/src/test/results/clientpositive/pointlookup2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/pointlookup2.q.out b/ql/src/test/results/clientpositive/pointlookup2.q.out
index a442425..1d7efe8 100644
--- a/ql/src/test/results/clientpositive/pointlookup2.q.out
+++ b/ql/src/test/results/clientpositive/pointlookup2.q.out
@@ -68,7 +68,7 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Output: default@pcr_t2
-POSTHOOK: Lineage: pcr_t2.ds SIMPLE [(pcr_t1)pcr_t1.FieldSchema(name:ds, type:string, comment:null), ]
+POSTHOOK: Lineage: pcr_t2.ds SIMPLE []
 POSTHOOK: Lineage: pcr_t2.key SIMPLE [(pcr_t1)pcr_t1.FieldSchema(name:key, type:int, comment:null), ]
 POSTHOOK: Lineage: pcr_t2.value SIMPLE [(pcr_t1)pcr_t1.FieldSchema(name:value, type:string, comment:null), ]
 PREHOOK: query: from pcr_t1
@@ -83,8 +83,8 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@pcr_t1
 POSTHOOK: Input: default@pcr_t1@ds=2000-04-08
 POSTHOOK: Output: default@pcr_t2
-POSTHOOK: Lineage: pcr_t2.ds SIMPLE [(pcr_t1)pcr_t1.FieldSchema(name:ds, type:string, comment:null), ]
-POSTHOOK: Lineage: pcr_t2.key SIMPLE [(pcr_t1)pcr_t1.FieldSchema(name:key, type:int, comment:null), ]
+POSTHOOK: Lineage: pcr_t2.ds SIMPLE []
+POSTHOOK: Lineage: pcr_t2.key SIMPLE []
 POSTHOOK: Lineage: pcr_t2.value SIMPLE [(pcr_t1)pcr_t1.FieldSchema(name:value, type:string, comment:null), ]
 PREHOOK: query: explain extended
 select key, value, ds

http://git-wip-us.apache.org/repos/asf/hive/blob/b340ecb5/ql/src/test/results/clientpositive/quotedid_basic.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/quotedid_basic.q.out b/ql/src/test/results/clientpositive/quotedid_basic.q.out
index 519f647..29736af 100644
--- a/ql/src/test/results/clientpositive/quotedid_basic.q.out
+++ b/ql/src/test/results/clientpositive/quotedid_basic.q.out
@@ -101,11 +101,11 @@ STAGE PLANS:
               predicate: (!@#$%^&*()_q = '1') (type: boolean)
               Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
               Select Operator
-                expressions: x+1 (type: string), y&y (type: string), '1' (type: string)
-                outputColumnNames: x+1, y&y, !@#$%^&*()_q
+                expressions: x+1 (type: string), y&y (type: string)
+                outputColumnNames: _col0, _col1
                 Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                 Group By Operator
-                  keys: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+                  keys: _col0 (type: string), _col1 (type: string), '1' (type: string)
                   mode: hash
                   outputColumnNames: _col0, _col1, _col2
                   Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
@@ -120,13 +120,17 @@ STAGE PLANS:
           mode: mergepartial
           outputColumnNames: _col0, _col1, _col2
           Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
-          File Output Operator
-            compressed: false
+          Select Operator
+            expressions: _col0 (type: string), _col1 (type: string), '1' (type: string)
+            outputColumnNames: _col0, _col1, _col2
             Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL 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: 1 Data size: 0 Basic stats: PARTIAL 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
@@ -156,11 +160,11 @@ STAGE PLANS:
               predicate: (!@#$%^&*()_q = '1') (type: boolean)
               Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
               Select Operator
-                expressions: x+1 (type: string), y&y (type: string), '1' (type: string)
-                outputColumnNames: x+1, y&y, !@#$%^&*()_q
+                expressions: x+1 (type: string), y&y (type: string)
+                outputColumnNames: _col0, _col1
                 Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                 Group By Operator
-                  keys: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+                  keys: _col0 (type: string), _col1 (type: string), '1' (type: string)
                   mode: hash
                   outputColumnNames: _col0, _col1, _col2
                   Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
@@ -187,27 +191,27 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             Reduce Output Operator
-              key expressions: _col2 (type: string), _col1 (type: string)
+              key expressions: '1' (type: string), _col1 (type: string)
               sort order: ++
-              Map-reduce partition columns: _col2 (type: string)
+              Map-reduce partition columns: '1' (type: string)
               Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
               value expressions: _col0 (type: string)
       Reduce Operator Tree:
         Select Operator
-          expressions: VALUE._col0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey0 (type: string)
-          outputColumnNames: _col0, _col1, _col2
+          expressions: VALUE._col0 (type: string), KEY.reducesinkkey1 (type: string)
+          outputColumnNames: _col0, _col1
           Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
           PTF Operator
             Function definitions:
                 Input definition
                   input alias: ptf_0
-                  output shape: _col0: string, _col1: string, _col2: string
+                  output shape: _col0: string, _col1: string
                   type: WINDOWING
                 Windowing table definition
                   input alias: ptf_1
                   name: windowingtablefunction
                   order by: _col1
-                  partition by: _col2
+                  partition by: '1'
                   raw input shape:
                   window functions:
                       window function definition
@@ -219,7 +223,7 @@ STAGE PLANS:
                         isPivotResult: true
             Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
             Select Operator
-              expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), rank_window_0 (type: int)
+              expressions: _col0 (type: string), _col1 (type: string), '1' (type: string), rank_window_0 (type: int)
               outputColumnNames: _col0, _col1, _col2, _col3
               Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
               File Output Operator
@@ -260,11 +264,11 @@ STAGE PLANS:
               predicate: (!@#$%^&*()_q = '1') (type: boolean)
               Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
               Select Operator
-                expressions: x+1 (type: string), y&y (type: string), '1' (type: string)
-                outputColumnNames: x+1, y&y, !@#$%^&*()_q
+                expressions: x+1 (type: string), y&y (type: string)
+                outputColumnNames: _col0, _col1
                 Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
                 Group By Operator
-                  keys: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string)
+                  keys: _col0 (type: string), _col1 (type: string), '1' (type: string)
                   mode: hash
                   outputColumnNames: _col0, _col1, _col2
                   Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
@@ -291,27 +295,27 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             Reduce Output Operator
-              key expressions: _col2 (type: string), _col1 (type: string)
+              key expressions: '1' (type: string), _col1 (type: string)
               sort order: ++
-              Map-reduce partition columns: _col2 (type: string)
+              Map-reduce partition columns: '1' (type: string)
               Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
               value expressions: _col0 (type: string)
       Reduce Operator Tree:
         Select Operator
-          expressions: VALUE._col0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey0 (type: string)
-          outputColumnNames: _col0, _col1, _col2
+          expressions: VALUE._col0 (type: string), KEY.reducesinkkey1 (type: string)
+          outputColumnNames: _col0, _col1
           Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
           PTF Operator
             Function definitions:
                 Input definition
                   input alias: ptf_0
-                  output shape: _col0: string, _col1: string, _col2: string
+                  output shape: _col0: string, _col1: string
                   type: WINDOWING
                 Windowing table definition
                   input alias: ptf_1
                   name: windowingtablefunction
                   order by: _col1
-                  partition by: _col2
+                  partition by: '1'
                   raw input shape:
                   window functions:
                       window function definition
@@ -323,7 +327,7 @@ STAGE PLANS:
                         isPivotResult: true
             Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
             Select Operator
-              expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), rank_window_0 (type: int)
+              expressions: _col0 (type: string), _col1 (type: string), '1' (type: string), rank_window_0 (type: int)
               outputColumnNames: _col0, _col1, _col2, _col3
               Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
               File Output Operator


Mime
View raw message