http://git-wip-us.apache.org/repos/asf/hive/blob/be9735e1/ql/src/test/results/clientpositive/perf/query87.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query87.q.out
b/ql/src/test/results/clientpositive/perf/query87.q.out
index 8e7b634..734b334 100644
--- a/ql/src/test/results/clientpositive/perf/query87.q.out
+++ b/ql/src/test/results/clientpositive/perf/query87.q.out
@@ -19,316 +19,167 @@ Reducer 6 <- Reducer 19 (SIMPLE_EDGE), Reducer 5
(SIMPLE_EDGE)
Reducer 7 <- Reducer 6 (SIMPLE_EDGE)
Stage-0
- Fetch Operator
- limit:-1
- Stage-1
- Reducer 7
- File Output Operator [FS_74]
- compressed:false
- Statistics:Num rows: 1 Data size: 8 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"}
- Group By Operator [GBY_72]
- | aggregations:["count(VALUE._col0)"]
- | outputColumnNames:["_col0"]
- | Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE
Column stats: NONE
- |<-Reducer 6 [SIMPLE_EDGE]
- Reduce Output Operator [RS_71]
- sort order:
- Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE
Column stats: NONE
- value expressions:_col0 (type: bigint)
- Group By Operator [GBY_70]
- aggregations:["count()"]
- outputColumnNames:["_col0"]
- Statistics:Num rows: 1 Data size: 8 Basic stats: COMPLETE
Column stats: NONE
- Select Operator [SEL_69]
- Statistics:Num rows: 24200000 Data size: 20812489029
Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_68]
- predicate:_col6 is null (type: boolean)
- Statistics:Num rows: 24200000 Data size:
20812489029 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_112]
- | condition map:[{"":"Left Outer Join0 to 1"}]
- | keys:{"0":"_col0 (type: string), _col1 (type:
string), _col2 (type: string)","1":"_col0 (type: string), _col1 (type: string),
_col2 (type: string)"}
- | outputColumnNames:["_col6"]
- | Statistics:Num rows: 48400001 Data size:
41624978920 Basic stats: COMPLETE Column stats: NONE
- |<-Reducer 19 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_66]
- | key expressions:_col0 (type: string), _col1
(type: string), _col2 (type: string)
- | Map-reduce partition columns:_col0 (type:
string), _col1 (type: string), _col2 (type: string)
- | sort order:+++
- | Statistics:Num rows: 44000000 Data size:
37840889108 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_64]
- | outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 44000000 Data size:
37840889108 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_63]
- | | keys:KEY._col0 (type: string),
KEY._col1 (type: string), KEY._col2 (type: string)
- | |
outputColumnNames:["_col0","_col1","_col2"]
- | | Statistics:Num rows: 44000000 Data
size: 37840889108 Basic stats: COMPLETE Column stats: NONE
- | |<-Reducer 18 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_62]
- | key expressions:_col0 (type:
string), _col1 (type: string), _col2 (type: string)
- | Map-reduce partition columns:_col0
(type: string), _col1 (type: string), _col2 (type: string)
- | sort order:+++
- | Statistics:Num rows: 88000001 Data
size: 75681779077 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_61]
- | keys:_col3 (type: string), _col6
(type: string), _col7 (type: string)
- |
outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 88000001
Data size: 75681779077 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator
[MERGEJOIN_110]
- | | condition map:[{"":"Inner Join
0 to 1"}]
- | | keys:{"0":"_col1 (type:
int)","1":"_col0 (type: int)"}
- | |
outputColumnNames:["_col3","_col6","_col7"]
- | | Statistics:Num rows: 88000001
Data size: 75681779077 Basic stats: COMPLETE Column stats: NONE
- | |<-Map 21 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_58]
- | | key expressions:_col0
(type: int)
- | | Map-reduce partition
columns:_col0 (type: int)
- | | sort order:+
- | | Statistics:Num rows:
80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
- | | value expressions:_col1
(type: string), _col2 (type: string)
- | | Select Operator [SEL_53]
- | |
outputColumnNames:["_col0","_col1","_col2"]
- | | Statistics:Num rows:
80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_104]
- | |
predicate:c_customer_sk is not null (type: boolean)
- | | Statistics:Num rows:
80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_51]
- | | alias:customer
- | | Statistics:Num
rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
- | |<-Reducer 17 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_57]
- | key expressions:_col1
(type: int)
- | Map-reduce partition
columns:_col1 (type: int)
- | sort order:+
- | Statistics:Num rows: 40176
Data size: 44957392 Basic stats: COMPLETE Column stats: NONE
- | value expressions:_col3
(type: string)
- | Merge Join Operator
[MERGEJOIN_109]
- | | condition
map:[{"":"Inner Join 0 to 1"}]
- | | keys:{"0":"_col0 (type:
int)","1":"_col0 (type: int)"}
- | |
outputColumnNames:["_col1","_col3"]
- | | Statistics:Num rows:
40176 Data size: 44957392 Basic stats: COMPLETE Column stats: NONE
- | |<-Map 16 [SIMPLE_EDGE]
- | | Reduce Output Operator
[RS_54]
- | | 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)
- | | Select Operator
[SEL_47]
- | |
outputColumnNames:["_col0","_col1"]
- | | Statistics:Num
rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter Operator
[FIL_102]
- | |
predicate:(ws_sold_date_sk is not null and ws_bill_customer_sk is not null)
(type: boolean)
- | | Statistics:Num
rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | TableScan
[TS_45]
- | |
alias:web_sales
- | |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | |<-Map 20 [SIMPLE_EDGE]
- | Reduce Output Operator
[RS_55]
- | key expressions:_col0
(type: int)
- | Map-reduce partition
columns:_col0 (type: int)
- | sort order:+
- | Statistics:Num rows:
36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | value
expressions:_col1 (type: string)
- | Select Operator
[SEL_50]
- |
outputColumnNames:["_col0","_col1"]
- | Statistics:Num
rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator
[FIL_103]
- |
predicate:(d_date_sk is not null and d_month_seq BETWEEN 1193 AND 1204) (type:
boolean)
- | Statistics:Num
rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | TableScan
[TS_48]
- |
alias:date_dim
- |
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
- |<-Reducer 5 [SIMPLE_EDGE]
- Reduce Output Operator [RS_65]
- key expressions:_col0 (type: string), _col1
(type: string), _col2 (type: string)
- Map-reduce partition columns:_col0 (type:
string), _col1 (type: string), _col2 (type: string)
- sort order:+++
- Statistics:Num rows: 24200000 Data size:
20812489029 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_44]
- outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 24200000 Data size:
20812489029 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_43]
- predicate:_col3 is null (type: boolean)
- Statistics:Num rows: 24200000 Data
size: 20812489029 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_111]
- | condition map:[{"":"Left Outer Join0
to 1"}]
- | keys:{"0":"_col0 (type: string),
_col1 (type: string), _col2 (type: string)","1":"_col0 (type: string), _col1
(type: string), _col2 (type: string)"}
- |
outputColumnNames:["_col0","_col1","_col2","_col3"]
- | Statistics:Num rows: 48400001 Data
size: 41624978920 Basic stats: COMPLETE Column stats: NONE
- |<-Reducer 13 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_41]
- | key expressions:_col0 (type:
string), _col1 (type: string), _col2 (type: string)
- | Map-reduce partition
columns:_col0 (type: string), _col1 (type: string), _col2 (type: string)
- | sort order:+++
- | Statistics:Num rows: 44000000
Data size: 37840889108 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_39]
- |
outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows: 44000000
Data size: 37840889108 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_38]
- | | keys:KEY._col0 (type:
string), KEY._col1 (type: string), KEY._col2 (type: string)
- | |
outputColumnNames:["_col0","_col1","_col2"]
- | | Statistics:Num rows:
44000000 Data size: 37840889108 Basic stats: COMPLETE Column stats: NONE
- | |<-Reducer 12 [SIMPLE_EDGE]
- | Reduce Output Operator
[RS_37]
- | key expressions:_col0
(type: string), _col1 (type: string), _col2 (type: string)
- | Map-reduce partition
columns:_col0 (type: string), _col1 (type: string), _col2 (type: string)
- | sort order:+++
- | Statistics:Num rows:
88000001 Data size: 75681779077 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator
[GBY_36]
- | keys:_col3 (type:
string), _col6 (type: string), _col7 (type: string)
- |
outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows:
88000001 Data size: 75681779077 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator
[MERGEJOIN_108]
- | | condition
map:[{"":"Inner Join 0 to 1"}]
- | | keys:{"0":"_col1
(type: int)","1":"_col0 (type: int)"}
- | |
outputColumnNames:["_col3","_col6","_col7"]
- | | Statistics:Num
rows: 88000001 Data size: 75681779077 Basic stats: COMPLETE Column stats: NONE
- | |<-Map 15
[SIMPLE_EDGE]
- | | Reduce Output
Operator [RS_33]
- | | key
expressions:_col0 (type: int)
- | | Map-reduce
partition columns:_col0 (type: int)
- | | sort order:+
- | | Statistics:Num
rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
- | | value
expressions:_col1 (type: string), _col2 (type: string)
- | | Select Operator
[SEL_28]
- | |
outputColumnNames:["_col0","_col1","_col2"]
- | |
Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE
Column stats: NONE
- | | Filter
Operator [FIL_101]
- | |
predicate:c_customer_sk is not null (type: boolean)
- | |
Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE
Column stats: NONE
- | | TableScan
[TS_26]
- | |
alias:customer
- | |
Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE
Column stats: NONE
- | |<-Reducer 11
[SIMPLE_EDGE]
- | Reduce Output
Operator [RS_32]
- | key
expressions:_col1 (type: int)
- | Map-reduce
partition columns:_col1 (type: int)
- | sort order:+
- | Statistics:Num
rows: 40176 Data size: 44957392 Basic stats: COMPLETE Column stats: NONE
- | value
expressions:_col3 (type: string)
- | Merge Join
Operator [MERGEJOIN_107]
- | | condition
map:[{"":"Inner Join 0 to 1"}]
- | |
keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
- | |
outputColumnNames:["_col1","_col3"]
- | |
Statistics:Num rows: 40176 Data size: 44957392 Basic stats: COMPLETE Column
stats: NONE
- | |<-Map 10
[SIMPLE_EDGE]
- | | 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)
- | | Select
Operator [SEL_22]
- | |
outputColumnNames:["_col0","_col1"]
- | |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter
Operator [FIL_99]
- | |
predicate:(cs_sold_date_sk is not null and cs_bill_customer_sk is not null)
(type: boolean)
- | |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | |
TableScan [TS_20]
- | |
alias:catalog_sales
- | |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | |<-Map 14
[SIMPLE_EDGE]
- | Reduce
Output Operator [RS_30]
- | key
expressions:_col0 (type: int)
- |
Map-reduce partition columns:_col0 (type: int)
- | sort
order:+
- |
Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column
stats: NONE
- | value
expressions:_col1 (type: string)
- | Select
Operator [SEL_25]
- |
outputColumnNames:["_col0","_col1"]
- |
Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column
stats: NONE
- | Filter
Operator [FIL_100]
- |
predicate:(d_date_sk is not null and d_month_seq BETWEEN 1193 AND 1204) (type:
boolean)
- |
Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column
stats: NONE
- |
TableScan [TS_23]
- |
alias:date_dim
- |
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
- |<-Reducer 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_40]
- key expressions:_col0 (type:
string), _col1 (type: string), _col2 (type: string)
- Map-reduce partition
columns:_col0 (type: string), _col1 (type: string), _col2 (type: string)
- sort order:+++
- Statistics:Num rows: 44000000
Data size: 37840889108 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_19]
-
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows: 44000000
Data size: 37840889108 Basic stats: COMPLETE Column stats: NONE
- Group By Operator [GBY_18]
- | keys:KEY._col0 (type:
string), KEY._col1 (type: string), KEY._col2 (type: string)
- |
outputColumnNames:["_col0","_col1","_col2"]
- | Statistics:Num rows:
44000000 Data size: 37840889108 Basic stats: COMPLETE Column stats: NONE
- |<-Reducer 3 [SIMPLE_EDGE]
- Reduce Output Operator
[RS_17]
- key expressions:_col0
(type: string), _col1 (type: string), _col2 (type: string)
- Map-reduce partition
columns:_col0 (type: string), _col1 (type: string), _col2 (type: string)
- sort order:+++
- Statistics:Num rows:
88000001 Data size: 75681779077 Basic stats: COMPLETE Column stats: NONE
- Group By Operator
[GBY_16]
- keys:_col3 (type:
string), _col6 (type: string), _col7 (type: string)
-
outputColumnNames:["_col0","_col1","_col2"]
- Statistics:Num rows:
88000001 Data size: 75681779077 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator
[MERGEJOIN_106]
- | condition
map:[{"":"Inner Join 0 to 1"}]
- | keys:{"0":"_col1
(type: int)","1":"_col0 (type: int)"}
- |
outputColumnNames:["_col3","_col6","_col7"]
- | Statistics:Num
rows: 88000001 Data size: 75681779077 Basic stats: COMPLETE Column stats: NONE
- |<-Map 9 [SIMPLE_EDGE]
- | Reduce Output
Operator [RS_13]
- | key
expressions:_col0 (type: int)
- | Map-reduce
partition columns:_col0 (type: int)
- | sort order:+
- | Statistics:Num
rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
- | value
expressions:_col1 (type: string), _col2 (type: string)
- | Select Operator
[SEL_8]
- |
outputColumnNames:["_col0","_col1","_col2"]
- |
Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE
Column stats: NONE
- | Filter
Operator [FIL_98]
- |
predicate:c_customer_sk is not null (type: boolean)
- |
Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE
Column stats: NONE
- | TableScan
[TS_6]
- |
alias:customer
- |
Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE
Column stats: NONE
- |<-Reducer 2
[SIMPLE_EDGE]
- Reduce Output
Operator [RS_12]
- key
expressions:_col1 (type: int)
- Map-reduce
partition columns:_col1 (type: int)
- sort order:+
- Statistics:Num
rows: 40176 Data size: 44957392 Basic stats: COMPLETE Column stats: NONE
- value
expressions:_col3 (type: string)
- Merge Join
Operator [MERGEJOIN_105]
- | condition
map:[{"":"Inner Join 0 to 1"}]
- |
keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
- |
outputColumnNames:["_col1","_col3"]
- |
Statistics:Num rows: 40176 Data size: 44957392 Basic stats: COMPLETE Column
stats: NONE
- |<-Map 1
[SIMPLE_EDGE]
- | Reduce
Output Operator [RS_9]
- | 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)
- | Select
Operator [SEL_2]
- |
outputColumnNames:["_col0","_col1"]
- |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | Filter
Operator [FIL_96]
- |
predicate:(ss_sold_date_sk is not null and ss_customer_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_10]
- key
expressions:_col0 (type: int)
-
Map-reduce partition columns:_col0 (type: int)
- sort
order:+
-
Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column
stats: NONE
- value
expressions:_col1 (type: string)
- Select
Operator [SEL_5]
-
outputColumnNames:["_col0","_col1"]
-
Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column
stats: NONE
- Filter
Operator [FIL_97]
-
predicate:(d_date_sk is not null and d_month_seq BETWEEN 1193 AND 1204) (type:
boolean)
-
Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column
stats: NONE
-
TableScan [TS_3]
-
alias:date_dim
-
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
+ Fetch Operator
+ limit:-1
+ Stage-1
+ Reducer 7
+ File Output Operator [FS_74]
+ Group By Operator [GBY_72] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count(VALUE._col0)"]
+ <-Reducer 6 [SIMPLE_EDGE]
+ SHUFFLE [RS_71]
+ Group By Operator [GBY_70] (rows=1 width=8)
+ Output:["_col0"],aggregations:["count()"]
+ Select Operator [SEL_69] (rows=24200000 width=860)
+ Filter Operator [FIL_68] (rows=24200000 width=860)
+ predicate:_col6 is null
+ Merge Join Operator [MERGEJOIN_112] (rows=48400001 width=860)
+ Conds:RS_65._col0, _col1, _col2=RS_66._col0, _col1,
_col2(Left Outer),Output:["_col6"]
+ <-Reducer 19 [SIMPLE_EDGE]
+ SHUFFLE [RS_66]
+ PartitionCols:_col0, _col1, _col2
+ Select Operator [SEL_64] (rows=44000000 width=860)
+ Output:["_col0","_col1","_col2"]
+ Group By Operator [GBY_63] (rows=44000000 width=860)
+ Output:["_col0","_col1","_col2"],keys:KEY._col0,
KEY._col1, KEY._col2
+ <-Reducer 18 [SIMPLE_EDGE]
+ SHUFFLE [RS_62]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_61] (rows=88000001
width=860)
+ Output:["_col0","_col1","_col2"],keys:_col3,
_col6, _col7
+ Merge Join Operator [MERGEJOIN_110]
(rows=88000001 width=860)
+
Conds:RS_57._col1=RS_58._col0(Inner),Output:["_col3","_col6","_col7"]
+ <-Map 21 [SIMPLE_EDGE]
+ SHUFFLE [RS_58]
+ PartitionCols:_col0
+ Select Operator [SEL_53] (rows=80000000
width=860)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_104] (rows=80000000
width=860)
+ predicate:c_customer_sk is not null
+ TableScan [TS_51] (rows=80000000
width=860)
+
default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_first_name","c_last_name"]
+ <-Reducer 17 [SIMPLE_EDGE]
+ SHUFFLE [RS_57]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_109]
(rows=40176 width=1119)
+
Conds:RS_54._col0=RS_55._col0(Inner),Output:["_col1","_col3"]
+ <-Map 16 [SIMPLE_EDGE]
+ SHUFFLE [RS_54]
+ PartitionCols:_col0
+ Select Operator [SEL_47] (rows=1 width=0)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_102] (rows=1
width=0)
+ predicate:(ws_sold_date_sk is not
null and ws_bill_customer_sk is not null)
+ TableScan [TS_45] (rows=1 width=0)
+
default@web_sales,web_sales,Tbl:PARTIAL,Col:NONE,Output:["ws_sold_date_sk","ws_bill_customer_sk"]
+ <-Map 20 [SIMPLE_EDGE]
+ SHUFFLE [RS_55]
+ PartitionCols:_col0
+ Select Operator [SEL_50] (rows=36524
width=1119)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_103] (rows=36524
width=1119)
+ predicate:(d_date_sk is not null and
d_month_seq BETWEEN 1193 AND 1204)
+ TableScan [TS_48] (rows=73049
width=1119)
+
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date","d_month_seq"]
+ <-Reducer 5 [SIMPLE_EDGE]
+ SHUFFLE [RS_65]
+ PartitionCols:_col0, _col1, _col2
+ Select Operator [SEL_44] (rows=24200000 width=860)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_43] (rows=24200000 width=860)
+ predicate:_col3 is null
+ Merge Join Operator [MERGEJOIN_111] (rows=48400001
width=860)
+ Conds:RS_40._col0, _col1, _col2=RS_41._col0,
_col1, _col2(Left Outer),Output:["_col0","_col1","_col2","_col3"]
+ <-Reducer 13 [SIMPLE_EDGE]
+ SHUFFLE [RS_41]
+ PartitionCols:_col0, _col1, _col2
+ Select Operator [SEL_39] (rows=44000000
width=860)
+ Output:["_col0","_col1","_col2"]
+ Group By Operator [GBY_38] (rows=44000000
width=860)
+
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Reducer 12 [SIMPLE_EDGE]
+ SHUFFLE [RS_37]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_36] (rows=88000001
width=860)
+
Output:["_col0","_col1","_col2"],keys:_col3, _col6, _col7
+ Merge Join Operator [MERGEJOIN_108]
(rows=88000001 width=860)
+
Conds:RS_32._col1=RS_33._col0(Inner),Output:["_col3","_col6","_col7"]
+ <-Map 15 [SIMPLE_EDGE]
+ SHUFFLE [RS_33]
+ PartitionCols:_col0
+ Select Operator [SEL_28]
(rows=80000000 width=860)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_101]
(rows=80000000 width=860)
+ predicate:c_customer_sk is not
null
+ TableScan [TS_26] (rows=80000000
width=860)
+
default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_first_name","c_last_name"]
+ <-Reducer 11 [SIMPLE_EDGE]
+ SHUFFLE [RS_32]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_107]
(rows=40176 width=1119)
+
Conds:RS_29._col0=RS_30._col0(Inner),Output:["_col1","_col3"]
+ <-Map 10 [SIMPLE_EDGE]
+ SHUFFLE [RS_29]
+ PartitionCols:_col0
+ Select Operator [SEL_22] (rows=1
width=0)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_99]
(rows=1 width=0)
+ predicate:(cs_sold_date_sk
is not null and cs_bill_customer_sk is not null)
+ TableScan [TS_20] (rows=1
width=0)
+
default@catalog_sales,catalog_sales,Tbl:PARTIAL,Col:NONE,Output:["cs_sold_date_sk","cs_bill_customer_sk"]
+ <-Map 14 [SIMPLE_EDGE]
+ SHUFFLE [RS_30]
+ PartitionCols:_col0
+ Select Operator [SEL_25]
(rows=36524 width=1119)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_100]
(rows=36524 width=1119)
+ predicate:(d_date_sk is not
null and d_month_seq BETWEEN 1193 AND 1204)
+ TableScan [TS_23]
(rows=73049 width=1119)
+
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date","d_month_seq"]
+ <-Reducer 4 [SIMPLE_EDGE]
+ SHUFFLE [RS_40]
+ PartitionCols:_col0, _col1, _col2
+ Select Operator [SEL_19] (rows=44000000
width=860)
+ Output:["_col0","_col1","_col2"]
+ Group By Operator [GBY_18] (rows=44000000
width=860)
+
Output:["_col0","_col1","_col2"],keys:KEY._col0, KEY._col1, KEY._col2
+ <-Reducer 3 [SIMPLE_EDGE]
+ SHUFFLE [RS_17]
+ PartitionCols:_col0, _col1, _col2
+ Group By Operator [GBY_16] (rows=88000001
width=860)
+
Output:["_col0","_col1","_col2"],keys:_col3, _col6, _col7
+ Merge Join Operator [MERGEJOIN_106]
(rows=88000001 width=860)
+
Conds:RS_12._col1=RS_13._col0(Inner),Output:["_col3","_col6","_col7"]
+ <-Map 9 [SIMPLE_EDGE]
+ SHUFFLE [RS_13]
+ PartitionCols:_col0
+ Select Operator [SEL_8]
(rows=80000000 width=860)
+ Output:["_col0","_col1","_col2"]
+ Filter Operator [FIL_98]
(rows=80000000 width=860)
+ predicate:c_customer_sk is not
null
+ TableScan [TS_6] (rows=80000000
width=860)
+
default@customer,customer,Tbl:COMPLETE,Col:NONE,Output:["c_customer_sk","c_first_name","c_last_name"]
+ <-Reducer 2 [SIMPLE_EDGE]
+ SHUFFLE [RS_12]
+ PartitionCols:_col1
+ Merge Join Operator [MERGEJOIN_105]
(rows=40176 width=1119)
+
Conds:RS_9._col0=RS_10._col0(Inner),Output:["_col1","_col3"]
+ <-Map 1 [SIMPLE_EDGE]
+ SHUFFLE [RS_9]
+ PartitionCols:_col0
+ Select Operator [SEL_2] (rows=1
width=0)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_96]
(rows=1 width=0)
+ predicate:(ss_sold_date_sk
is not null and ss_customer_sk is not null)
+ TableScan [TS_0] (rows=1
width=0)
+
default@store_sales,store_sales,Tbl:PARTIAL,Col:NONE,Output:["ss_sold_date_sk","ss_customer_sk"]
+ <-Map 8 [SIMPLE_EDGE]
+ SHUFFLE [RS_10]
+ PartitionCols:_col0
+ Select Operator [SEL_5]
(rows=36524 width=1119)
+ Output:["_col0","_col1"]
+ Filter Operator [FIL_97]
(rows=36524 width=1119)
+ predicate:(d_date_sk is not
null and d_month_seq BETWEEN 1193 AND 1204)
+ TableScan [TS_3] (rows=73049
width=1119)
+
default@date_dim,date_dim,Tbl:COMPLETE,Col:NONE,Output:["d_date_sk","d_date","d_month_seq"]
