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]
