http://git-wip-us.apache.org/repos/asf/hive/blob/6f44fc81/ql/src/test/results/clientpositive/perf/query31.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query31.q.out
b/ql/src/test/results/clientpositive/perf/query31.q.out
index c479d91..52cbdf4 100644
--- a/ql/src/test/results/clientpositive/perf/query31.q.out
+++ b/ql/src/test/results/clientpositive/perf/query31.q.out
@@ -32,555 +32,555 @@ Stage-0
limit:-1
Stage-1
Reducer 7
- File Output Operator [FS_166]
+ File Output Operator [FS_135]
compressed:false
Statistics:Num rows: 11831111 Data size: 12007156967 Basic stats:
COMPLETE Column stats: NONE
table:{"input
format:":"org.apache.hadoop.mapred.TextInputFormat","output
format:":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}
- Select Operator [SEL_165]
+ Select Operator [SEL_134]
|
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
| Statistics:Num rows: 11831111 Data size: 12007156967 Basic
stats: COMPLETE Column stats: NONE
|<-Reducer 6 [SIMPLE_EDGE]
- Reduce Output Operator [RS_164]
+ Reduce Output Operator [RS_133]
key expressions:_col2 (type: decimal(37,20))
sort order:+
Statistics:Num rows: 11831111 Data size: 12007156967 Basic
stats: COMPLETE Column stats: NONE
value expressions:_col0 (type: string), _col1 (type: int),
_col3 (type: decimal(37,20)), _col4 (type: decimal(37,20)), _col5 (type:
decimal(37,20))
- Select Operator [SEL_163]
+ Select Operator [SEL_132]
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
Statistics:Num rows: 11831111 Data size: 12007156967
Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_275]
+ Filter Operator [FIL_131]
predicate:(CASE WHEN ((_col19 > 0)) THEN ((_col23 /
_col19)) ELSE (null) END > CASE WHEN ((_col7 > 0)) THEN ((_col11 / _col7)) ELSE
(null) END) (type: boolean)
Statistics:Num rows: 11831111 Data size: 12007156967
Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_308]
+ Merge Join Operator [MERGEJOIN_275]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col12 (type: string)","1":"_col0 (type:
string)"}
|
outputColumnNames:["_col0","_col2","_col3","_col7","_col11","_col15","_col19","_col23"]
| Statistics:Num rows: 35493334 Data size:
36021471918 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 37 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_160]
+ | Reduce Output Operator [RS_129]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
| Statistics:Num rows: 22000000 Data size:
22327357890 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col3 (type: decimal(17,2))
- | Select Operator [SEL_156]
+ | Select Operator [SEL_127]
| outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 22000000 Data size:
22327357890 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_155]
+ | Group By Operator [GBY_126]
| | aggregations:["sum(VALUE._col0)"]
| | keys:KEY._col0 (type: int), KEY._col1
(type: int), KEY._col2 (type: string)
| |
outputColumnNames:["_col0","_col1","_col2","_col3"]
| | Statistics:Num rows: 22000000 Data size:
22327357890 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 36 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_154]
+ | Reduce Output Operator [RS_125]
| key expressions:_col0 (type: int),
_col1 (type: int), _col2 (type: string)
| Map-reduce partition columns:_col0
(type: int), _col1 (type: int), _col2 (type: string)
| sort order:+++
| Statistics:Num rows: 44000000 Data
size: 44654715780 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col3 (type:
decimal(17,2))
- | Group By Operator [GBY_153]
+ | Group By Operator [GBY_124]
| aggregations:["sum(_col2)"]
| keys:_col4 (type: int), _col5 (type:
int), _col7 (type: string)
|
outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows: 44000000 Data
size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_152]
+ | Select Operator [SEL_123]
|
outputColumnNames:["_col4","_col5","_col7","_col2"]
| Statistics:Num rows: 44000000
Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator
[MERGEJOIN_306]
+ | Merge Join Operator
[MERGEJOIN_273]
| | condition map:[{"":"Inner Join
0 to 1"}]
| | keys:{"0":"_col1 (type:
int)","1":"_col0 (type: int)"}
| |
outputColumnNames:["_col2","_col7"]
| | Statistics:Num rows: 44000000
Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
| |<-Map 39 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_150]
+ | | Reduce Output Operator [RS_121]
| | key expressions:_col0
(type: int)
| | Map-reduce partition
columns:_col0 (type: int)
| | sort order:+
| | Statistics:Num rows:
40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col1
(type: string)
- | | Select Operator [SEL_141]
+ | | Select Operator [SEL_116]
| |
outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows:
40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_294]
+ | | Filter Operator [FIL_261]
| |
predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
| | Statistics:Num rows:
40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_139]
+ | | TableScan [TS_114]
| |
alias:customer_address
| | Statistics:Num
rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 35 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_148]
+ | Reduce Output Operator [RS_120]
| key expressions:_col1
(type: int)
| Map-reduce partition
columns:_col1 (type: int)
| sort order:+
| Statistics:Num rows: 20088
Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col2
(type: decimal(7,2))
- | Merge Join Operator
[MERGEJOIN_305]
+ | Merge Join Operator
[MERGEJOIN_272]
| | condition
map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col0 (type:
int)","1":"_col0 (type: int)"}
| |
outputColumnNames:["_col1","_col2"]
| | Statistics:Num rows:
20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
| |<-Map 34 [SIMPLE_EDGE]
- | | Reduce Output Operator
[RS_143]
+ | | Reduce Output Operator
[RS_117]
| | key expressions:_col0
(type: int)
| | Map-reduce partition
columns:_col0 (type: int)
| | sort order:+
| | Statistics:Num rows:
1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| | value
expressions:_col1 (type: int), _col2 (type: decimal(7,2))
- | | Select Operator
[SEL_135]
+ | | Select Operator
[SEL_110]
| |
outputColumnNames:["_col0","_col1","_col2"]
| | Statistics:Num
rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter Operator
[FIL_292]
+ | | Filter Operator
[FIL_259]
| |
predicate:(ws_sold_date_sk is not null and ws_bill_addr_sk is not null) (type:
boolean)
| | Statistics:Num
rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | TableScan
[TS_133]
+ | | TableScan
[TS_108]
| |
alias:web_sales
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| |<-Map 38 [SIMPLE_EDGE]
- | Reduce Output Operator
[RS_145]
+ | Reduce Output Operator
[RS_118]
| key expressions:_col0
(type: int)
| Map-reduce partition
columns:_col0 (type: int)
| sort order:+
| Statistics:Num rows:
18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
- | Select Operator
[SEL_138]
+ | Select Operator
[SEL_113]
|
outputColumnNames:["_col0"]
| Statistics:Num
rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator
[FIL_293]
+ | Filter Operator
[FIL_260]
|
predicate:(((d_qoy = 3) and (d_year = 1998)) and d_date_sk is not null) (type:
boolean)
| Statistics:Num
rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
- | TableScan
[TS_136]
+ | TableScan
[TS_111]
|
alias:date_dim
|
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
|<-Reducer 5 [SIMPLE_EDGE]
- Reduce Output Operator [RS_158]
+ Reduce Output Operator [RS_128]
key expressions:_col12 (type: string)
Map-reduce partition columns:_col12 (type:
string)
sort order:+
Statistics:Num rows: 32266667 Data size:
32746791943 Basic stats: COMPLETE Column stats: NONE
value expressions:_col0 (type: string), _col2
(type: int), _col3 (type: decimal(17,2)), _col7 (type: decimal(17,2)), _col11
(type: decimal(17,2)), _col15 (type: decimal(17,2)), _col19 (type:
decimal(17,2))
- Select Operator [SEL_132]
+ Select Operator [SEL_107]
outputColumnNames:["_col0","_col11","_col12","_col15","_col19","_col2","_col3","_col7"]
Statistics:Num rows: 32266667 Data size:
32746791943 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_276]
+ Filter Operator [FIL_106]
predicate:(CASE WHEN ((_col15 > 0)) THEN
((_col19 / _col15)) ELSE (null) END > CASE WHEN ((_col3 > 0)) THEN ((_col7 /
_col3)) ELSE (null) END) (type: boolean)
Statistics:Num rows: 32266667 Data size:
32746791943 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_307]
+ Merge Join Operator [MERGEJOIN_274]
| condition map:[{"":"Inner Join 0 to
1"},{"":"Inner Join 1 to 2"},{"":"Inner Join 0 to 3"},{"":"Inner Join 3 to 4"}]
| keys:{"0":"_col0 (type:
string)","1":"_col0 (type: string)","2":"_col0 (type: string)","3":"_col0
(type: string)","4":"_col0 (type: string)"}
|
outputColumnNames:["_col0","_col2","_col3","_col7","_col11","_col12","_col15","_col19"]
| Statistics:Num rows: 96800002 Data
size: 98240376845 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 13 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_123]
+ | Reduce Output Operator [RS_101]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0
(type: string)
| sort order:+
| Statistics:Num rows: 22000000 Data
size: 22327357890 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col3 (type:
decimal(17,2))
- | Select Operator [SEL_47]
+ | Select Operator [SEL_39]
|
outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 22000000
Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_46]
+ | Group By Operator [GBY_38]
| |
aggregations:["sum(VALUE._col0)"]
| | keys:KEY._col0 (type: int),
KEY._col1 (type: int), KEY._col2 (type: string)
| |
outputColumnNames:["_col0","_col1","_col2","_col3"]
| | Statistics:Num rows: 22000000
Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 12 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_45]
+ | Reduce Output Operator [RS_37]
| key expressions:_col0
(type: int), _col1 (type: int), _col2 (type: string)
| Map-reduce partition
columns:_col0 (type: int), _col1 (type: int), _col2 (type: string)
| sort order:+++
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col3
(type: decimal(17,2))
- | Group By Operator [GBY_44]
+ | Group By Operator [GBY_36]
|
aggregations:["sum(_col2)"]
| keys:_col4 (type: int),
_col5 (type: int), _col7 (type: string)
|
outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_43]
+ | Select Operator [SEL_35]
|
outputColumnNames:["_col4","_col5","_col7","_col2"]
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator
[MERGEJOIN_298]
+ | Merge Join Operator
[MERGEJOIN_265]
| | condition
map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col1
(type: int)","1":"_col0 (type: int)"}
| |
outputColumnNames:["_col2","_col7"]
| | Statistics:Num
rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
| |<-Map 15
[SIMPLE_EDGE]
- | | Reduce Output
Operator [RS_41]
+ | | Reduce Output
Operator [RS_33]
| | key
expressions:_col0 (type: int)
| | Map-reduce
partition columns:_col0 (type: int)
| | sort order:+
| | Statistics:Num
rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
| | value
expressions:_col1 (type: string)
- | | Select Operator
[SEL_32]
+ | | Select Operator
[SEL_28]
| |
outputColumnNames:["_col0","_col1"]
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
- | | Filter
Operator [FIL_282]
+ | | Filter
Operator [FIL_249]
| |
predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
- | | TableScan
[TS_30]
+ | | TableScan
[TS_26]
| |
alias:customer_address
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
| |<-Reducer 11
[SIMPLE_EDGE]
- | Reduce Output
Operator [RS_39]
+ | Reduce Output
Operator [RS_32]
| key
expressions:_col1 (type: int)
| Map-reduce
partition columns:_col1 (type: int)
| sort order:+
| Statistics:Num
rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
| value
expressions:_col2 (type: decimal(7,2))
- | Merge Join
Operator [MERGEJOIN_297]
+ | Merge Join
Operator [MERGEJOIN_264]
| | condition
map:[{"":"Inner Join 0 to 1"}]
| |
keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
| |
outputColumnNames:["_col1","_col2"]
| |
Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column
stats: NONE
| |<-Map 10
[SIMPLE_EDGE]
- | | Reduce
Output Operator [RS_34]
+ | | Reduce
Output Operator [RS_29]
| | key
expressions:_col0 (type: int)
| |
Map-reduce partition columns:_col0 (type: int)
| | sort
order:+
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| | value
expressions:_col1 (type: int), _col2 (type: decimal(7,2))
- | | Select
Operator [SEL_26]
+ | | Select
Operator [SEL_22]
| |
outputColumnNames:["_col0","_col1","_col2"]
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter
Operator [FIL_280]
+ | | Filter
Operator [FIL_247]
| |
predicate:(ss_sold_date_sk is not null and ss_addr_sk is not null) (type:
boolean)
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | |
TableScan [TS_24]
+ | |
TableScan [TS_20]
| |
alias:store_sales
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| |<-Map 14
[SIMPLE_EDGE]
- | Reduce
Output Operator [RS_36]
+ | Reduce
Output Operator [RS_30]
| key
expressions:_col0 (type: int)
|
Map-reduce partition columns:_col0 (type: int)
| sort
order:+
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- | Select
Operator [SEL_29]
+ | Select
Operator [SEL_25]
|
outputColumnNames:["_col0"]
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- | Filter
Operator [FIL_281]
+ | Filter
Operator [FIL_248]
|
predicate:(((d_qoy = 2) and (d_year = 1998)) and d_date_sk is not null) (type:
boolean)
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- |
TableScan [TS_27]
+ |
TableScan [TS_23]
|
alias:date_dim
|
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
|<-Reducer 19 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_125]
+ | Reduce Output Operator [RS_102]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0
(type: string)
| sort order:+
| Statistics:Num rows: 22000000 Data
size: 22327357890 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col3 (type:
decimal(17,2))
- | Select Operator [SEL_71]
+ | Select Operator [SEL_59]
|
outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 22000000
Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_70]
+ | Group By Operator [GBY_58]
| |
aggregations:["sum(VALUE._col0)"]
| | keys:KEY._col0 (type: int),
KEY._col1 (type: int), KEY._col2 (type: string)
| |
outputColumnNames:["_col0","_col1","_col2","_col3"]
| | Statistics:Num rows: 22000000
Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 18 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_69]
+ | Reduce Output Operator [RS_57]
| key expressions:_col0
(type: int), _col1 (type: int), _col2 (type: string)
| Map-reduce partition
columns:_col0 (type: int), _col1 (type: int), _col2 (type: string)
| sort order:+++
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col3
(type: decimal(17,2))
- | Group By Operator [GBY_68]
+ | Group By Operator [GBY_56]
|
aggregations:["sum(_col2)"]
| keys:_col4 (type: int),
_col5 (type: int), _col7 (type: string)
|
outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_67]
+ | Select Operator [SEL_55]
|
outputColumnNames:["_col4","_col5","_col7","_col2"]
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator
[MERGEJOIN_300]
+ | Merge Join Operator
[MERGEJOIN_267]
| | condition
map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col1
(type: int)","1":"_col0 (type: int)"}
| |
outputColumnNames:["_col2","_col7"]
| | Statistics:Num
rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
| |<-Map 21
[SIMPLE_EDGE]
- | | Reduce Output
Operator [RS_65]
+ | | Reduce Output
Operator [RS_53]
| | key
expressions:_col0 (type: int)
| | Map-reduce
partition columns:_col0 (type: int)
| | sort order:+
| | Statistics:Num
rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
| | value
expressions:_col1 (type: string)
- | | Select Operator
[SEL_56]
+ | | Select Operator
[SEL_48]
| |
outputColumnNames:["_col0","_col1"]
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
- | | Filter
Operator [FIL_285]
+ | | Filter
Operator [FIL_252]
| |
predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
- | | TableScan
[TS_54]
+ | | TableScan
[TS_46]
| |
alias:customer_address
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
| |<-Reducer 17
[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: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
| value
expressions:_col2 (type: decimal(7,2))
- | Merge Join
Operator [MERGEJOIN_299]
+ | Merge Join
Operator [MERGEJOIN_266]
| | condition
map:[{"":"Inner Join 0 to 1"}]
| |
keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
| |
outputColumnNames:["_col1","_col2"]
| |
Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column
stats: NONE
| |<-Map 16
[SIMPLE_EDGE]
- | | Reduce
Output Operator [RS_58]
+ | | Reduce
Output Operator [RS_49]
| | key
expressions:_col0 (type: int)
| |
Map-reduce partition columns:_col0 (type: int)
| | sort
order:+
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| | value
expressions:_col1 (type: int), _col2 (type: decimal(7,2))
- | | Select
Operator [SEL_50]
+ | | Select
Operator [SEL_42]
| |
outputColumnNames:["_col0","_col1","_col2"]
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter
Operator [FIL_283]
+ | | Filter
Operator [FIL_250]
| |
predicate:(ss_sold_date_sk is not null and ss_addr_sk is not null) (type:
boolean)
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | |
TableScan [TS_48]
+ | |
TableScan [TS_40]
| |
alias:store_sales
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| |<-Map 20
[SIMPLE_EDGE]
- | Reduce
Output Operator [RS_60]
+ | Reduce
Output Operator [RS_50]
| key
expressions:_col0 (type: int)
|
Map-reduce partition columns:_col0 (type: int)
| sort
order:+
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- | Select
Operator [SEL_53]
+ | Select
Operator [SEL_45]
|
outputColumnNames:["_col0"]
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- | Filter
Operator [FIL_284]
+ | Filter
Operator [FIL_251]
|
predicate:(((d_qoy = 3) and (d_year = 1998)) and d_date_sk is not null) (type:
boolean)
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- |
TableScan [TS_51]
+ |
TableScan [TS_43]
|
alias:date_dim
|
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
|<-Reducer 25 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_127]
+ | Reduce Output Operator [RS_103]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0
(type: string)
| sort order:+
| Statistics:Num rows: 22000000 Data
size: 22327357890 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col3 (type:
decimal(17,2))
- | Select Operator [SEL_95]
+ | Select Operator [SEL_79]
|
outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 22000000
Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_94]
+ | Group By Operator [GBY_78]
| |
aggregations:["sum(VALUE._col0)"]
| | keys:KEY._col0 (type: int),
KEY._col1 (type: int), KEY._col2 (type: string)
| |
outputColumnNames:["_col0","_col1","_col2","_col3"]
| | Statistics:Num rows: 22000000
Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 24 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_93]
+ | Reduce Output Operator [RS_77]
| key expressions:_col0
(type: int), _col1 (type: int), _col2 (type: string)
| Map-reduce partition
columns:_col0 (type: int), _col1 (type: int), _col2 (type: string)
| sort order:+++
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col3
(type: decimal(17,2))
- | Group By Operator [GBY_92]
+ | Group By Operator [GBY_76]
|
aggregations:["sum(_col2)"]
| keys:_col4 (type: int),
_col5 (type: int), _col7 (type: string)
|
outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_91]
+ | Select Operator [SEL_75]
|
outputColumnNames:["_col4","_col5","_col7","_col2"]
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator
[MERGEJOIN_302]
+ | Merge Join Operator
[MERGEJOIN_269]
| | condition
map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col1
(type: int)","1":"_col0 (type: int)"}
| |
outputColumnNames:["_col2","_col7"]
| | Statistics:Num
rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
| |<-Map 27
[SIMPLE_EDGE]
- | | Reduce Output
Operator [RS_89]
+ | | Reduce Output
Operator [RS_73]
| | key
expressions:_col0 (type: int)
| | Map-reduce
partition columns:_col0 (type: int)
| | sort order:+
| | Statistics:Num
rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
| | value
expressions:_col1 (type: string)
- | | Select Operator
[SEL_80]
+ | | Select Operator
[SEL_68]
| |
outputColumnNames:["_col0","_col1"]
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
- | | Filter
Operator [FIL_288]
+ | | Filter
Operator [FIL_255]
| |
predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
- | | TableScan
[TS_78]
+ | | TableScan
[TS_66]
| |
alias:customer_address
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
| |<-Reducer 23
[SIMPLE_EDGE]
- | Reduce Output
Operator [RS_87]
+ | Reduce Output
Operator [RS_72]
| key
expressions:_col1 (type: int)
| Map-reduce
partition columns:_col1 (type: int)
| sort order:+
| Statistics:Num
rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
| value
expressions:_col2 (type: decimal(7,2))
- | Merge Join
Operator [MERGEJOIN_301]
+ | Merge Join
Operator [MERGEJOIN_268]
| | condition
map:[{"":"Inner Join 0 to 1"}]
| |
keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
| |
outputColumnNames:["_col1","_col2"]
| |
Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column
stats: NONE
| |<-Map 22
[SIMPLE_EDGE]
- | | Reduce
Output Operator [RS_82]
+ | | Reduce
Output Operator [RS_69]
| | key
expressions:_col0 (type: int)
| |
Map-reduce partition columns:_col0 (type: int)
| | sort
order:+
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| | value
expressions:_col1 (type: int), _col2 (type: decimal(7,2))
- | | Select
Operator [SEL_74]
+ | | Select
Operator [SEL_62]
| |
outputColumnNames:["_col0","_col1","_col2"]
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter
Operator [FIL_286]
+ | | Filter
Operator [FIL_253]
| |
predicate:(ws_sold_date_sk is not null and ws_bill_addr_sk is not null) (type:
boolean)
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | |
TableScan [TS_72]
+ | |
TableScan [TS_60]
| |
alias:web_sales
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| |<-Map 26
[SIMPLE_EDGE]
- | Reduce
Output Operator [RS_84]
+ | Reduce
Output Operator [RS_70]
| key
expressions:_col0 (type: int)
|
Map-reduce partition columns:_col0 (type: int)
| sort
order:+
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- | Select
Operator [SEL_77]
+ | Select
Operator [SEL_65]
|
outputColumnNames:["_col0"]
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- | Filter
Operator [FIL_287]
+ | Filter
Operator [FIL_254]
|
predicate:(((d_year = 1998) and (d_qoy = 1)) and d_date_sk is not null) (type:
boolean)
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- |
TableScan [TS_75]
+ |
TableScan [TS_63]
|
alias:date_dim
|
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
|<-Reducer 31 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_129]
+ | Reduce Output Operator [RS_104]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0
(type: string)
| sort order:+
| Statistics:Num rows: 22000000 Data
size: 22327357890 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col3 (type:
decimal(17,2))
- | Select Operator [SEL_119]
+ | Select Operator [SEL_99]
|
outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 22000000
Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_118]
+ | Group By Operator [GBY_98]
| |
aggregations:["sum(VALUE._col0)"]
| | keys:KEY._col0 (type: int),
KEY._col1 (type: int), KEY._col2 (type: string)
| |
outputColumnNames:["_col0","_col1","_col2","_col3"]
| | Statistics:Num rows: 22000000
Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 30 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_117]
+ | Reduce Output Operator [RS_97]
| key expressions:_col0
(type: int), _col1 (type: int), _col2 (type: string)
| Map-reduce partition
columns:_col0 (type: int), _col1 (type: int), _col2 (type: string)
| sort order:+++
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col3
(type: decimal(17,2))
- | Group By Operator [GBY_116]
+ | Group By Operator [GBY_96]
|
aggregations:["sum(_col2)"]
| keys:_col4 (type: int),
_col5 (type: int), _col7 (type: string)
|
outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_115]
+ | Select Operator [SEL_95]
|
outputColumnNames:["_col4","_col5","_col7","_col2"]
| Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator
[MERGEJOIN_304]
+ | Merge Join Operator
[MERGEJOIN_271]
| | condition
map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col1
(type: int)","1":"_col0 (type: int)"}
| |
outputColumnNames:["_col2","_col7"]
| | Statistics:Num
rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
| |<-Map 33
[SIMPLE_EDGE]
- | | Reduce Output
Operator [RS_113]
+ | | Reduce Output
Operator [RS_93]
| | key
expressions:_col0 (type: int)
| | Map-reduce
partition columns:_col0 (type: int)
| | sort order:+
| | Statistics:Num
rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
| | value
expressions:_col1 (type: string)
- | | Select Operator
[SEL_104]
+ | | Select Operator
[SEL_88]
| |
outputColumnNames:["_col0","_col1"]
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
- | | Filter
Operator [FIL_291]
+ | | Filter
Operator [FIL_258]
| |
predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
- | | TableScan
[TS_102]
+ | | TableScan
[TS_86]
| |
alias:customer_address
| |
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
| |<-Reducer 29
[SIMPLE_EDGE]
- | Reduce Output
Operator [RS_111]
+ | Reduce Output
Operator [RS_92]
| key
expressions:_col1 (type: int)
| Map-reduce
partition columns:_col1 (type: int)
| sort order:+
| Statistics:Num
rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
| value
expressions:_col2 (type: decimal(7,2))
- | Merge Join
Operator [MERGEJOIN_303]
+ | Merge Join
Operator [MERGEJOIN_270]
| | condition
map:[{"":"Inner Join 0 to 1"}]
| |
keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
| |
outputColumnNames:["_col1","_col2"]
| |
Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column
stats: NONE
| |<-Map 28
[SIMPLE_EDGE]
- | | Reduce
Output Operator [RS_106]
+ | | Reduce
Output Operator [RS_89]
| | key
expressions:_col0 (type: int)
| |
Map-reduce partition columns:_col0 (type: int)
| | sort
order:+
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| | value
expressions:_col1 (type: int), _col2 (type: decimal(7,2))
- | | Select
Operator [SEL_98]
+ | | Select
Operator [SEL_82]
| |
outputColumnNames:["_col0","_col1","_col2"]
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter
Operator [FIL_289]
+ | | Filter
Operator [FIL_256]
| |
predicate:(ws_sold_date_sk is not null and ws_bill_addr_sk is not null) (type:
boolean)
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | |
TableScan [TS_96]
+ | |
TableScan [TS_80]
| |
alias:web_sales
| |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| |<-Map 32
[SIMPLE_EDGE]
- | Reduce
Output Operator [RS_108]
+ | Reduce
Output Operator [RS_90]
| key
expressions:_col0 (type: int)
|
Map-reduce partition columns:_col0 (type: int)
| sort
order:+
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- | Select
Operator [SEL_101]
+ | Select
Operator [SEL_85]
|
outputColumnNames:["_col0"]
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- | Filter
Operator [FIL_290]
+ | Filter
Operator [FIL_257]
|
predicate:(((d_qoy = 2) and (d_year = 1998)) and d_date_sk is not null) (type:
boolean)
|
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- |
TableScan [TS_99]
+ |
TableScan [TS_83]
|
alias:date_dim
|
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
|<-Reducer 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_121]
+ Reduce Output Operator [RS_100]
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0
(type: string)
sort order:+
Statistics:Num rows: 22000000 Data
size: 22327357890 Basic stats: COMPLETE Column stats: NONE
value expressions:_col2 (type: int),
_col3 (type: decimal(17,2))
- Select Operator [SEL_23]
+ Select Operator [SEL_19]
outputColumnNames:["_col0","_col2","_col3"]
Statistics:Num rows: 22000000
Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
- Group By Operator [GBY_22]
+ Group By Operator [GBY_18]
|
aggregations:["sum(VALUE._col0)"]
| keys:KEY._col0 (type: int),
KEY._col1 (type: int), KEY._col2 (type: string)
|
outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows: 22000000
Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 3 [SIMPLE_EDGE]
- Reduce Output Operator [RS_21]
+ Reduce Output Operator [RS_17]
key expressions:_col0
(type: int), _col1 (type: int), _col2 (type: string)
Map-reduce partition
columns:_col0 (type: int), _col1 (type: int), _col2 (type: string)
sort order:+++
Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
value expressions:_col3
(type: decimal(17,2))
- Group By Operator [GBY_20]
+ Group By Operator [GBY_16]
aggregations:["sum(_col2)"]
keys:_col4 (type: int),
_col5 (type: int), _col7 (type: string)
outputColumnNames:["_col0","_col1","_col2","_col3"]
Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_19]
+ Select Operator [SEL_15]
outputColumnNames:["_col4","_col5","_col7","_col2"]
Statistics:Num rows:
44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator
[MERGEJOIN_296]
+ Merge Join Operator
[MERGEJOIN_263]
| condition
map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col1
(type: int)","1":"_col0 (type: int)"}
|
outputColumnNames:["_col2","_col7"]
| Statistics:Num
rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
|<-Map 9 [SIMPLE_EDGE]
- | Reduce Output
Operator [RS_17]
+ | Reduce Output
Operator [RS_13]
| key
expressions:_col0 (type: int)
| Map-reduce
partition columns:_col0 (type: int)
| sort order:+
@@ -589,26 +589,26 @@ Stage-0
| Select Operator
[SEL_8]
|
outputColumnNames:["_col0","_col1"]
|
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
- | Filter
Operator [FIL_279]
+ | Filter
Operator [FIL_246]
|
predicate:(ca_address_sk is not null and ca_county is not null) (type: boolean)
|
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
| TableScan
[TS_6]
|
alias:customer_address
|
Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE
Column stats: NONE
|<-Reducer 2
[SIMPLE_EDGE]
- Reduce Output
Operator [RS_15]
+ Reduce Output
Operator [RS_12]
key
expressions:_col1 (type: int)
Map-reduce
partition columns:_col1 (type: int)
sort order:+
Statistics:Num
rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column stats: NONE
value
expressions:_col2 (type: decimal(7,2))
- Merge Join
Operator [MERGEJOIN_295]
+ Merge Join
Operator [MERGEJOIN_262]
| condition
map:[{"":"Inner Join 0 to 1"}]
|
keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
|
outputColumnNames:["_col1","_col2"]
|
Statistics:Num rows: 20088 Data size: 22478696 Basic stats: COMPLETE Column
stats: NONE
|<-Map 1
[SIMPLE_EDGE]
- | Reduce
Output Operator [RS_10]
+ | Reduce
Output Operator [RS_9]
| key
expressions:_col0 (type: int)
|
Map-reduce partition columns:_col0 (type: int)
| sort
order:+
@@ -617,14 +617,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_277]
+ | Filter
Operator [FIL_244]
|
predicate:(ss_sold_date_sk is not null and ss_addr_sk is not null) (type:
boolean)
|
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
|
TableScan [TS_0]
|
alias:store_sales
|
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
|<-Map 8
[SIMPLE_EDGE]
- Reduce
Output Operator [RS_12]
+ Reduce
Output Operator [RS_10]
key
expressions:_col0 (type: int)
Map-reduce partition columns:_col0 (type: int)
sort
order:+
@@ -632,7 +632,7 @@ Stage-0
Select
Operator [SEL_5]
outputColumnNames:["_col0"]
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
- Filter
Operator [FIL_278]
+ Filter
Operator [FIL_245]
predicate:(((d_year = 1998) and (d_qoy = 1)) and d_date_sk is not null) (type:
boolean)
Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column
stats: NONE
TableScan [TS_3]
