You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2015/12/21 02:07:02 UTC
[21/32] hive git commit: HIVE-11865: Disable Hive PPD optimizer when
CBO has optimized the plan (Jesus Camacho Rodriguez,
reviewed by Laljo John Pullokkaran)
http://git-wip-us.apache.org/repos/asf/hive/blob/6f44fc81/ql/src/test/results/clientpositive/perf/query58.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query58.q.out b/ql/src/test/results/clientpositive/perf/query58.q.out
index 5379e87..c2f7189 100644
--- a/ql/src/test/results/clientpositive/perf/query58.q.out
+++ b/ql/src/test/results/clientpositive/perf/query58.q.out
@@ -119,385 +119,385 @@ Stage-0
limit:100
Stage-1
Reducer 8
- File Output Operator [FS_140]
+ File Output Operator [FS_112]
compressed:false
Statistics:Num rows: 100 Data size: 143600 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"}
- Limit [LIM_139]
+ Limit [LIM_111]
Number of rows:100
Statistics:Num rows: 100 Data size: 143600 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_138]
+ Select Operator [SEL_110]
| outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
| Statistics:Num rows: 21137 Data size: 30358620 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 7 [SIMPLE_EDGE]
- Reduce Output Operator [RS_137]
+ Reduce Output Operator [RS_109]
key expressions:_col0 (type: string), _col1 (type: decimal(17,2))
sort order:++
Statistics:Num rows: 21137 Data size: 30358620 Basic stats: COMPLETE Column stats: NONE
value expressions:_col2 (type: decimal(38,21)), _col3 (type: decimal(17,2)), _col4 (type: decimal(38,21)), _col5 (type: decimal(17,2)), _col6 (type: decimal(38,21)), _col7 (type: decimal(23,6))
- Select Operator [SEL_136]
+ Select Operator [SEL_108]
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
Statistics:Num rows: 21137 Data size: 30358620 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_202]
- predicate:(((_col1 BETWEEN (0.9 * UDFToDouble(_col5)) AND (1.1 * UDFToDouble(_col5)) and _col3 BETWEEN (0.9 * UDFToDouble(_col5)) AND (1.1 * UDFToDouble(_col5))) and _col5 BETWEEN (0.9 * UDFToDouble(_col1)) AND (1.1 * UDFToDouble(_col1))) and _col5 BETWEEN (0.9 * UDFToDouble(_col3)) AND (1.1 * UDFToDouble(_col3))) (type: boolean)
+ Filter Operator [FIL_107]
+ predicate:(_col1 BETWEEN (0.9 * UDFToDouble(_col5)) AND (1.1 * UDFToDouble(_col5)) and _col3 BETWEEN (0.9 * UDFToDouble(_col5)) AND (1.1 * UDFToDouble(_col5)) and _col5 BETWEEN (0.9 * UDFToDouble(_col1)) AND (1.1 * UDFToDouble(_col1)) and _col5 BETWEEN (0.9 * UDFToDouble(_col3)) AND (1.1 * UDFToDouble(_col3))) (type: boolean)
Statistics:Num rows: 21137 Data size: 30358620 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_232]
+ Merge Join Operator [MERGEJOIN_202]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col0 (type: string)","1":"_col0 (type: string)"}
| outputColumnNames:["_col0","_col1","_col3","_col5"]
| Statistics:Num rows: 338207 Data size: 485759473 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 28 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_133]
+ | Reduce Output Operator [RS_105]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
| Statistics:Num rows: 307461 Data size: 441599512 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col1 (type: decimal(17,2))
- | Group By Operator [GBY_128]
+ | Group By Operator [GBY_102]
| | aggregations:["sum(VALUE._col0)"]
| | keys:KEY._col0 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 307461 Data size: 441599512 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 27 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_127]
+ | Reduce Output Operator [RS_101]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
| Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col1 (type: decimal(17,2))
- | Group By Operator [GBY_126]
+ | Group By Operator [GBY_100]
| aggregations:["sum(_col2)"]
| keys:_col4 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_125]
+ | Select Operator [SEL_99]
| outputColumnNames:["_col4","_col2"]
| Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_230]
+ | Merge Join Operator [MERGEJOIN_200]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col6 (type: string)","1":"_col0 (type: string)"}
| | outputColumnNames:["_col2","_col4"]
| | Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 26 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_121]
+ | | Reduce Output Operator [RS_96]
| | key expressions:_col6 (type: string)
| | Map-reduce partition columns:_col6 (type: string)
| | sort order:+
| | Statistics:Num rows: 559020 Data size: 802908187 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col2 (type: decimal(7,2)), _col4 (type: string)
- | | Merge Join Operator [MERGEJOIN_226]
+ | | Merge Join Operator [MERGEJOIN_196]
| | | condition map:[{"":"Inner Join 0 to 1"}]
| | | keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
| | | outputColumnNames:["_col2","_col4","_col6"]
| | | Statistics:Num rows: 559020 Data size: 802908187 Basic stats: COMPLETE Column stats: NONE
| | |<-Map 30 [SIMPLE_EDGE]
- | | | Reduce Output Operator [RS_118]
+ | | | Reduce Output Operator [RS_94]
| | | key expressions:_col0 (type: int)
| | | Map-reduce partition columns:_col0 (type: int)
| | | sort order:+
| | | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
| | | value expressions:_col1 (type: string)
- | | | Select Operator [SEL_97]
+ | | | Select Operator [SEL_79]
| | | outputColumnNames:["_col0","_col1"]
| | | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
- | | | Filter Operator [FIL_216]
+ | | | Filter Operator [FIL_186]
| | | predicate:(d_date_sk is not null and d_date is not null) (type: boolean)
| | | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
- | | | TableScan [TS_95]
+ | | | TableScan [TS_77]
| | | alias:date_dim
| | | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
| | |<-Reducer 25 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_116]
+ | | Reduce Output Operator [RS_93]
| | key expressions:_col0 (type: int)
| | Map-reduce partition columns:_col0 (type: int)
| | sort order:+
| | Statistics:Num rows: 508200 Data size: 729916518 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col2 (type: decimal(7,2)), _col4 (type: string)
- | | Merge Join Operator [MERGEJOIN_225]
+ | | Merge Join Operator [MERGEJOIN_195]
| | | condition map:[{"":"Inner Join 0 to 1"}]
| | | keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
| | | outputColumnNames:["_col0","_col2","_col4"]
| | | Statistics:Num rows: 508200 Data size: 729916518 Basic stats: COMPLETE Column stats: NONE
| | |<-Map 24 [SIMPLE_EDGE]
- | | | Reduce Output Operator [RS_111]
+ | | | Reduce Output Operator [RS_90]
| | | 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: decimal(7,2))
- | | | Select Operator [SEL_91]
+ | | | Select Operator [SEL_73]
| | | outputColumnNames:["_col0","_col1","_col2"]
| | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | | Filter Operator [FIL_214]
+ | | | Filter Operator [FIL_184]
| | | 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_89]
+ | | | TableScan [TS_71]
| | | alias:web_sales
| | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| | |<-Map 29 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_113]
+ | | Reduce Output Operator [RS_91]
| | key expressions:_col0 (type: int)
| | Map-reduce partition columns:_col0 (type: int)
| | sort order:+
| | Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col1 (type: string)
- | | Select Operator [SEL_94]
+ | | Select Operator [SEL_76]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_215]
+ | | Filter Operator [FIL_185]
| | predicate:(i_item_sk is not null and i_item_id is not null) (type: boolean)
| | Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_92]
+ | | TableScan [TS_74]
| | alias:item
| | Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 32 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_123]
+ | Reduce Output Operator [RS_97]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
| Statistics:Num rows: 80353 Data size: 89916016 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_227]
+ | Merge Join Operator [MERGEJOIN_197]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col1 (type: int)","1":"_col1 (type: int)"}
| | outputColumnNames:["_col0"]
| | Statistics:Num rows: 80353 Data size: 89916016 Basic stats: COMPLETE Column stats: NONE
| |<-Map 31 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_105]
+ | | Reduce Output Operator [RS_86]
| | key expressions:_col1 (type: int)
| | Map-reduce partition columns:_col1 (type: int)
| | sort order:+
| | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col0 (type: string)
- | | Select Operator [SEL_100]
+ | | Select Operator [SEL_82]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_217]
+ | | Filter Operator [FIL_187]
| | predicate:(d_week_seq is not null and d_date is not null) (type: boolean)
| | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_98]
+ | | TableScan [TS_80]
| | alias:date_dim
| | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
| |<-Map 33 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_107]
+ | Reduce Output Operator [RS_87]
| key expressions:_col1 (type: int)
| Map-reduce partition columns:_col1 (type: int)
| sort order:+
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_103]
+ | Select Operator [SEL_85]
| outputColumnNames:["_col1"]
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_218]
+ | Filter Operator [FIL_188]
| predicate:((d_date = '1998-08-04') and d_week_seq is not null) (type: boolean)
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_101]
+ | TableScan [TS_83]
| alias:date_dim
| Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 6 [SIMPLE_EDGE]
- Reduce Output Operator [RS_131]
+ Reduce Output Operator [RS_104]
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
Statistics:Num rows: 84551 Data size: 121438791 Basic stats: COMPLETE Column stats: NONE
value expressions:_col1 (type: decimal(17,2)), _col3 (type: decimal(17,2))
- Filter Operator [FIL_203]
- predicate:(_col1 BETWEEN (0.9 * UDFToDouble(_col3)) AND (1.1 * UDFToDouble(_col3)) and _col3 BETWEEN (0.9 * UDFToDouble(_col1)) AND (1.1 * UDFToDouble(_col1))) (type: boolean)
+ Filter Operator [FIL_69]
+ predicate:(_col3 BETWEEN (0.9 * UDFToDouble(_col1)) AND (1.1 * UDFToDouble(_col1)) and _col1 BETWEEN (0.9 * UDFToDouble(_col3)) AND (1.1 * UDFToDouble(_col3))) (type: boolean)
Statistics:Num rows: 84551 Data size: 121438791 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_231]
+ Merge Join Operator [MERGEJOIN_201]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col0 (type: string)","1":"_col0 (type: string)"}
| outputColumnNames:["_col0","_col1","_col3"]
| Statistics:Num rows: 338207 Data size: 485759473 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 18 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_85]
+ | Reduce Output Operator [RS_67]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
| Statistics:Num rows: 307461 Data size: 441599512 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col1 (type: decimal(17,2))
- | Group By Operator [GBY_80]
+ | Group By Operator [GBY_64]
| | aggregations:["sum(VALUE._col0)"]
| | keys:KEY._col0 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 307461 Data size: 441599512 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 17 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_79]
+ | Reduce Output Operator [RS_63]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
| Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col1 (type: decimal(17,2))
- | Group By Operator [GBY_78]
+ | Group By Operator [GBY_62]
| aggregations:["sum(_col2)"]
| keys:_col4 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_77]
+ | Select Operator [SEL_61]
| outputColumnNames:["_col4","_col2"]
| Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_229]
+ | Merge Join Operator [MERGEJOIN_199]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col6 (type: string)","1":"_col0 (type: string)"}
| | outputColumnNames:["_col2","_col4"]
| | Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 16 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_73]
+ | | Reduce Output Operator [RS_58]
| | key expressions:_col6 (type: string)
| | Map-reduce partition columns:_col6 (type: string)
| | sort order:+
| | Statistics:Num rows: 559020 Data size: 802908187 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col2 (type: decimal(7,2)), _col4 (type: string)
- | | Merge Join Operator [MERGEJOIN_223]
+ | | Merge Join Operator [MERGEJOIN_193]
| | | condition map:[{"":"Inner Join 0 to 1"}]
| | | keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
| | | outputColumnNames:["_col2","_col4","_col6"]
| | | Statistics:Num rows: 559020 Data size: 802908187 Basic stats: COMPLETE Column stats: NONE
| | |<-Map 20 [SIMPLE_EDGE]
- | | | Reduce Output Operator [RS_70]
+ | | | Reduce Output Operator [RS_56]
| | | key expressions:_col0 (type: int)
| | | Map-reduce partition columns:_col0 (type: int)
| | | sort order:+
| | | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
| | | value expressions:_col1 (type: string)
- | | | Select Operator [SEL_49]
+ | | | Select Operator [SEL_41]
| | | outputColumnNames:["_col0","_col1"]
| | | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
- | | | Filter Operator [FIL_211]
+ | | | Filter Operator [FIL_181]
| | | predicate:(d_date_sk is not null and d_date is not null) (type: boolean)
| | | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
- | | | TableScan [TS_47]
+ | | | TableScan [TS_39]
| | | alias:date_dim
| | | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
| | |<-Reducer 15 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_68]
+ | | Reduce Output Operator [RS_55]
| | key expressions:_col0 (type: int)
| | Map-reduce partition columns:_col0 (type: int)
| | sort order:+
| | Statistics:Num rows: 508200 Data size: 729916518 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col2 (type: decimal(7,2)), _col4 (type: string)
- | | Merge Join Operator [MERGEJOIN_222]
+ | | Merge Join Operator [MERGEJOIN_192]
| | | condition map:[{"":"Inner Join 0 to 1"}]
| | | keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
| | | outputColumnNames:["_col0","_col2","_col4"]
| | | Statistics:Num rows: 508200 Data size: 729916518 Basic stats: COMPLETE Column stats: NONE
| | |<-Map 14 [SIMPLE_EDGE]
- | | | Reduce Output Operator [RS_63]
+ | | | Reduce Output Operator [RS_52]
| | | 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: decimal(7,2))
- | | | Select Operator [SEL_43]
+ | | | Select Operator [SEL_35]
| | | outputColumnNames:["_col0","_col1","_col2"]
| | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | | Filter Operator [FIL_209]
+ | | | Filter Operator [FIL_179]
| | | 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_41]
+ | | | TableScan [TS_33]
| | | alias:catalog_sales
| | | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| | |<-Map 19 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_65]
+ | | Reduce Output Operator [RS_53]
| | key expressions:_col0 (type: int)
| | Map-reduce partition columns:_col0 (type: int)
| | sort order:+
| | Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col1 (type: string)
- | | Select Operator [SEL_46]
+ | | Select Operator [SEL_38]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_210]
+ | | Filter Operator [FIL_180]
| | predicate:(i_item_sk is not null and i_item_id is not null) (type: boolean)
| | Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_44]
+ | | TableScan [TS_36]
| | alias:item
| | Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 22 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_75]
+ | Reduce Output Operator [RS_59]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
| Statistics:Num rows: 80353 Data size: 89916016 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_224]
+ | Merge Join Operator [MERGEJOIN_194]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col1 (type: int)","1":"_col1 (type: int)"}
| | outputColumnNames:["_col0"]
| | Statistics:Num rows: 80353 Data size: 89916016 Basic stats: COMPLETE Column stats: NONE
| |<-Map 21 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_57]
+ | | Reduce Output Operator [RS_48]
| | key expressions:_col1 (type: int)
| | Map-reduce partition columns:_col1 (type: int)
| | sort order:+
| | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col0 (type: string)
- | | Select Operator [SEL_52]
+ | | Select Operator [SEL_44]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_212]
+ | | Filter Operator [FIL_182]
| | predicate:(d_week_seq is not null and d_date is not null) (type: boolean)
| | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_50]
+ | | TableScan [TS_42]
| | alias:date_dim
| | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
| |<-Map 23 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_59]
+ | Reduce Output Operator [RS_49]
| key expressions:_col1 (type: int)
| Map-reduce partition columns:_col1 (type: int)
| sort order:+
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_55]
+ | Select Operator [SEL_47]
| outputColumnNames:["_col1"]
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_213]
+ | Filter Operator [FIL_183]
| predicate:((d_date = '1998-08-04') and d_week_seq is not null) (type: boolean)
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_53]
+ | TableScan [TS_45]
| alias:date_dim
| Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 5 [SIMPLE_EDGE]
- Reduce Output Operator [RS_83]
+ Reduce Output Operator [RS_66]
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
Statistics:Num rows: 307461 Data size: 441599512 Basic stats: COMPLETE Column stats: NONE
value expressions:_col1 (type: decimal(17,2))
- Group By Operator [GBY_39]
+ Group By Operator [GBY_31]
| aggregations:["sum(VALUE._col0)"]
| keys:KEY._col0 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 307461 Data size: 441599512 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_38]
+ Reduce Output Operator [RS_30]
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
value expressions:_col1 (type: decimal(17,2))
- Group By Operator [GBY_37]
+ Group By Operator [GBY_29]
aggregations:["sum(_col2)"]
keys:_col4 (type: string)
outputColumnNames:["_col0","_col1"]
Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_36]
+ Select Operator [SEL_28]
outputColumnNames:["_col4","_col2"]
Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_228]
+ Merge Join Operator [MERGEJOIN_198]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col6 (type: string)","1":"_col0 (type: string)"}
| outputColumnNames:["_col2","_col4"]
| Statistics:Num rows: 614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 12 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_34]
+ | Reduce Output Operator [RS_26]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
| Statistics:Num rows: 80353 Data size: 89916016 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_221]
+ | Merge Join Operator [MERGEJOIN_191]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col1 (type: int)","1":"_col1 (type: int)"}
| | outputColumnNames:["_col0"]
| | Statistics:Num rows: 80353 Data size: 89916016 Basic stats: COMPLETE Column stats: NONE
| |<-Map 11 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_16]
+ | | Reduce Output Operator [RS_15]
| | key expressions:_col1 (type: int)
| | Map-reduce partition columns:_col1 (type: int)
| | sort order:+
@@ -506,14 +506,14 @@ Stage-0
| | Select Operator [SEL_11]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_207]
+ | | Filter Operator [FIL_177]
| | predicate:(d_week_seq is not null and d_date is not null) (type: boolean)
| | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
| | TableScan [TS_9]
| | alias:date_dim
| | Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
| |<-Map 13 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_18]
+ | Reduce Output Operator [RS_16]
| key expressions:_col1 (type: int)
| Map-reduce partition columns:_col1 (type: int)
| sort order:+
@@ -521,26 +521,26 @@ Stage-0
| Select Operator [SEL_14]
| outputColumnNames:["_col1"]
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_208]
+ | Filter Operator [FIL_178]
| predicate:((d_date = '1998-08-04') and d_week_seq is not null) (type: boolean)
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_12]
| alias:date_dim
| Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 3 [SIMPLE_EDGE]
- Reduce Output Operator [RS_32]
+ Reduce Output Operator [RS_25]
key expressions:_col6 (type: string)
Map-reduce partition columns:_col6 (type: string)
sort order:+
Statistics:Num rows: 559020 Data size: 802908187 Basic stats: COMPLETE Column stats: NONE
value expressions:_col2 (type: decimal(7,2)), _col4 (type: string)
- Merge Join Operator [MERGEJOIN_220]
+ Merge Join Operator [MERGEJOIN_190]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col2","_col4","_col6"]
| Statistics:Num rows: 559020 Data size: 802908187 Basic stats: COMPLETE Column stats: NONE
|<-Map 10 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_29]
+ | Reduce Output Operator [RS_23]
| key expressions:_col0 (type: int)
| Map-reduce partition columns:_col0 (type: int)
| sort order:+
@@ -549,26 +549,26 @@ Stage-0
| Select Operator [SEL_8]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_206]
+ | Filter Operator [FIL_176]
| predicate:(d_date_sk is not null and d_date is not null) (type: boolean)
| Statistics:Num rows: 73049 Data size: 81741831 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_27]
+ Reduce Output Operator [RS_22]
key expressions:_col0 (type: int)
Map-reduce partition columns:_col0 (type: int)
sort order:+
Statistics:Num rows: 508200 Data size: 729916518 Basic stats: COMPLETE Column stats: NONE
value expressions:_col2 (type: decimal(7,2)), _col4 (type: string)
- Merge Join Operator [MERGEJOIN_219]
+ Merge Join Operator [MERGEJOIN_189]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col0","_col2","_col4"]
| Statistics:Num rows: 508200 Data size: 729916518 Basic stats: COMPLETE Column stats: NONE
|<-Map 1 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_22]
+ | Reduce Output Operator [RS_19]
| key expressions:_col1 (type: int)
| Map-reduce partition columns:_col1 (type: int)
| sort order:+
@@ -577,14 +577,14 @@ 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_204]
+ | Filter Operator [FIL_174]
| 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_0]
| alias:store_sales
| Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
|<-Map 9 [SIMPLE_EDGE]
- Reduce Output Operator [RS_24]
+ Reduce Output Operator [RS_20]
key expressions:_col0 (type: int)
Map-reduce partition columns:_col0 (type: int)
sort order:+
@@ -593,7 +593,7 @@ Stage-0
Select Operator [SEL_5]
outputColumnNames:["_col0","_col1"]
Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_205]
+ Filter Operator [FIL_175]
predicate:(i_item_sk is not null and i_item_id is not null) (type: boolean)
Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column stats: NONE
TableScan [TS_3]