http://git-wip-us.apache.org/repos/asf/hive/blob/09b6f9a3/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
new file mode 100644
index 0000000..5379e87
--- /dev/null
+++ b/ql/src/test/results/clientpositive/perf/query58.q.out
@@ -0,0 +1,602 @@
+PREHOOK: query: explain select ss_items.item_id
+ ,ss_item_rev
+ ,ss_item_rev/(ss_item_rev+cs_item_rev+ws_item_rev)/3 * 100 ss_dev
+ ,cs_item_rev
+ ,cs_item_rev/(ss_item_rev+cs_item_rev+ws_item_rev)/3 * 100 cs_dev
+ ,ws_item_rev
+ ,ws_item_rev/(ss_item_rev+cs_item_rev+ws_item_rev)/3 * 100 ws_dev
+ ,(ss_item_rev+cs_item_rev+ws_item_rev)/3 average
+FROM
+( select i_item_id item_id ,sum(ss_ext_sales_price) as ss_item_rev
+ from store_sales
+ JOIN item ON store_sales.ss_item_sk = item.i_item_sk
+ JOIN date_dim ON store_sales.ss_sold_date_sk = date_dim.d_date_sk
+ JOIN (select d1.d_date
+ from date_dim d1 JOIN date_dim d2 ON d1.d_week_seq =
d2.d_week_seq
+ where d2.d_date = '1998-08-04') sub ON date_dim.d_date =
sub.d_date
+ group by i_item_id ) ss_items
+JOIN
+( select i_item_id item_id ,sum(cs_ext_sales_price) as cs_item_rev
+ from catalog_sales
+ JOIN item ON catalog_sales.cs_item_sk = item.i_item_sk
+ JOIN date_dim ON catalog_sales.cs_sold_date_sk = date_dim.d_date_sk
+ JOIN (select d1.d_date
+ from date_dim d1 JOIN date_dim d2 ON d1.d_week_seq =
d2.d_week_seq
+ where d2.d_date = '1998-08-04') sub ON date_dim.d_date =
sub.d_date
+ group by i_item_id ) cs_items
+ON ss_items.item_id=cs_items.item_id
+JOIN
+( select i_item_id item_id ,sum(ws_ext_sales_price) as ws_item_rev
+ from web_sales
+ JOIN item ON web_sales.ws_item_sk = item.i_item_sk
+ JOIN date_dim ON web_sales.ws_sold_date_sk = date_dim.d_date_sk
+ JOIN (select d1.d_date
+ from date_dim d1 JOIN date_dim d2 ON d1.d_week_seq =
d2.d_week_seq
+ where d2.d_date = '1998-08-04') sub ON date_dim.d_date =
sub.d_date
+ group by i_item_id ) ws_items
+ON ss_items.item_id=ws_items.item_id
+ where
+ ss_item_rev between 0.9 * cs_item_rev and 1.1 * cs_item_rev
+ and ss_item_rev between 0.9 * ws_item_rev and 1.1 * ws_item_rev
+ and cs_item_rev between 0.9 * ss_item_rev and 1.1 * ss_item_rev
+ and cs_item_rev between 0.9 * ws_item_rev and 1.1 * ws_item_rev
+ and ws_item_rev between 0.9 * ss_item_rev and 1.1 * ss_item_rev
+ and ws_item_rev between 0.9 * cs_item_rev and 1.1 * cs_item_rev
+ order by item_id ,ss_item_rev
+ limit 100
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select ss_items.item_id
+ ,ss_item_rev
+ ,ss_item_rev/(ss_item_rev+cs_item_rev+ws_item_rev)/3 * 100 ss_dev
+ ,cs_item_rev
+ ,cs_item_rev/(ss_item_rev+cs_item_rev+ws_item_rev)/3 * 100 cs_dev
+ ,ws_item_rev
+ ,ws_item_rev/(ss_item_rev+cs_item_rev+ws_item_rev)/3 * 100 ws_dev
+ ,(ss_item_rev+cs_item_rev+ws_item_rev)/3 average
+FROM
+( select i_item_id item_id ,sum(ss_ext_sales_price) as ss_item_rev
+ from store_sales
+ JOIN item ON store_sales.ss_item_sk = item.i_item_sk
+ JOIN date_dim ON store_sales.ss_sold_date_sk = date_dim.d_date_sk
+ JOIN (select d1.d_date
+ from date_dim d1 JOIN date_dim d2 ON d1.d_week_seq =
d2.d_week_seq
+ where d2.d_date = '1998-08-04') sub ON date_dim.d_date =
sub.d_date
+ group by i_item_id ) ss_items
+JOIN
+( select i_item_id item_id ,sum(cs_ext_sales_price) as cs_item_rev
+ from catalog_sales
+ JOIN item ON catalog_sales.cs_item_sk = item.i_item_sk
+ JOIN date_dim ON catalog_sales.cs_sold_date_sk = date_dim.d_date_sk
+ JOIN (select d1.d_date
+ from date_dim d1 JOIN date_dim d2 ON d1.d_week_seq =
d2.d_week_seq
+ where d2.d_date = '1998-08-04') sub ON date_dim.d_date =
sub.d_date
+ group by i_item_id ) cs_items
+ON ss_items.item_id=cs_items.item_id
+JOIN
+( select i_item_id item_id ,sum(ws_ext_sales_price) as ws_item_rev
+ from web_sales
+ JOIN item ON web_sales.ws_item_sk = item.i_item_sk
+ JOIN date_dim ON web_sales.ws_sold_date_sk = date_dim.d_date_sk
+ JOIN (select d1.d_date
+ from date_dim d1 JOIN date_dim d2 ON d1.d_week_seq =
d2.d_week_seq
+ where d2.d_date = '1998-08-04') sub ON date_dim.d_date =
sub.d_date
+ group by i_item_id ) ws_items
+ON ss_items.item_id=ws_items.item_id
+ where
+ ss_item_rev between 0.9 * cs_item_rev and 1.1 * cs_item_rev
+ and ss_item_rev between 0.9 * ws_item_rev and 1.1 * ws_item_rev
+ and cs_item_rev between 0.9 * ss_item_rev and 1.1 * ss_item_rev
+ and cs_item_rev between 0.9 * ws_item_rev and 1.1 * ws_item_rev
+ and ws_item_rev between 0.9 * ss_item_rev and 1.1 * ss_item_rev
+ and ws_item_rev between 0.9 * cs_item_rev and 1.1 * cs_item_rev
+ order by item_id ,ss_item_rev
+ limit 100
+POSTHOOK: type: QUERY
+Plan optimized by CBO.
+
+Vertex dependency in root stage
+Reducer 12 <- Map 11 (SIMPLE_EDGE), Map 13 (SIMPLE_EDGE)
+Reducer 15 <- Map 14 (SIMPLE_EDGE), Map 19 (SIMPLE_EDGE)
+Reducer 16 <- Map 20 (SIMPLE_EDGE), Reducer 15 (SIMPLE_EDGE)
+Reducer 17 <- Reducer 16 (SIMPLE_EDGE), Reducer 22 (SIMPLE_EDGE)
+Reducer 18 <- Reducer 17 (SIMPLE_EDGE)
+Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 9 (SIMPLE_EDGE)
+Reducer 22 <- Map 21 (SIMPLE_EDGE), Map 23 (SIMPLE_EDGE)
+Reducer 25 <- Map 24 (SIMPLE_EDGE), Map 29 (SIMPLE_EDGE)
+Reducer 26 <- Map 30 (SIMPLE_EDGE), Reducer 25 (SIMPLE_EDGE)
+Reducer 27 <- Reducer 26 (SIMPLE_EDGE), Reducer 32 (SIMPLE_EDGE)
+Reducer 28 <- Reducer 27 (SIMPLE_EDGE)
+Reducer 3 <- Map 10 (SIMPLE_EDGE), Reducer 2 (SIMPLE_EDGE)
+Reducer 32 <- Map 31 (SIMPLE_EDGE), Map 33 (SIMPLE_EDGE)
+Reducer 4 <- Reducer 12 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
+Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
+Reducer 6 <- Reducer 18 (SIMPLE_EDGE), Reducer 5 (SIMPLE_EDGE)
+Reducer 7 <- Reducer 28 (SIMPLE_EDGE), Reducer 6 (SIMPLE_EDGE)
+Reducer 8 <- Reducer 7 (SIMPLE_EDGE)
+
+Stage-0
+ Fetch Operator
+ limit:100
+ Stage-1
+ Reducer 8
+ File Output Operator [FS_140]
+ 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]
+ Number of rows:100
+ Statistics:Num rows: 100 Data size: 143600 Basic stats:
COMPLETE Column stats: NONE
+ Select Operator [SEL_138]
+ |
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]
+ 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]
+
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)
+ Statistics:Num rows: 21137 Data size: 30358620
Basic stats: COMPLETE Column stats: NONE
+ Merge Join Operator [MERGEJOIN_232]
+ | 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]
+ | 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]
+ | | 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]
+ | 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]
+ | 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]
+ |
outputColumnNames:["_col4","_col2"]
+ | Statistics:Num rows: 614922 Data
size: 883199024 Basic stats: COMPLETE Column stats: NONE
+ | Merge Join Operator
[MERGEJOIN_230]
+ | | 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]
+ | | 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]
+ | | | 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]
+ | | | 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]
+ | | |
outputColumnNames:["_col0","_col1"]
+ | | | Statistics:Num
rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
+ | | | Filter Operator
[FIL_216]
+ | | |
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]
+ | | |
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]
+ | | 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]
+ | | | 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]
+ | | | 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]
+ | | |
outputColumnNames:["_col0","_col1","_col2"]
+ | | |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+ | | | Filter
Operator [FIL_214]
+ | | |
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]
+ | | |
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]
+ | | 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]
+ | |
outputColumnNames:["_col0","_col1"]
+ | |
Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column
stats: NONE
+ | | Filter
Operator [FIL_215]
+ | |
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]
+ | |
alias:item
+ | |
Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column
stats: NONE
+ | |<-Reducer 32 [SIMPLE_EDGE]
+ | Reduce Output Operator [RS_123]
+ | 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]
+ | | 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]
+ | | 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]
+ | |
outputColumnNames:["_col0","_col1"]
+ | | Statistics:Num
rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
+ | | Filter Operator
[FIL_217]
+ | |
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]
+ | |
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]
+ | 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]
+ |
outputColumnNames:["_col1"]
+ | Statistics:Num
rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
+ | Filter Operator
[FIL_218]
+ |
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]
+ |
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]
+ 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)
+ Statistics:Num rows: 84551 Data size:
121438791 Basic stats: COMPLETE Column stats: NONE
+ Merge Join Operator [MERGEJOIN_231]
+ | 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]
+ | 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]
+ | | 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]
+ | 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]
+ | 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]
+ |
outputColumnNames:["_col4","_col2"]
+ | Statistics:Num rows:
614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
+ | Merge Join Operator
[MERGEJOIN_229]
+ | | 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]
+ | | 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]
+ | | | 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]
+ | | | 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]
+ | | |
outputColumnNames:["_col0","_col1"]
+ | | |
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
+ | | | Filter
Operator [FIL_211]
+ | | |
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]
+ | | |
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]
+ | | 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]
+ | | | 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]
+ | | | 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]
+ | | |
outputColumnNames:["_col0","_col1","_col2"]
+ | | |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+ | | |
Filter Operator [FIL_209]
+ | | |
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]
+ | | |
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]
+ | | 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]
+ | |
outputColumnNames:["_col0","_col1"]
+ | |
Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column
stats: NONE
+ | |
Filter Operator [FIL_210]
+ | |
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]
+ | |
alias:item
+ | |
Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column
stats: NONE
+ | |<-Reducer 22
[SIMPLE_EDGE]
+ | Reduce Output
Operator [RS_75]
+ | 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]
+ | | 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]
+ | | 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]
+ | |
outputColumnNames:["_col0","_col1"]
+ | |
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
+ | | Filter
Operator [FIL_212]
+ | |
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]
+ | |
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]
+ | 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]
+ |
outputColumnNames:["_col1"]
+ |
Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column
stats: NONE
+ | Filter
Operator [FIL_213]
+ |
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]
+ |
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]
+ 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]
+ | 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]
+ 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]
+ 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]
+
outputColumnNames:["_col4","_col2"]
+ Statistics:Num rows:
614922 Data size: 883199024 Basic stats: COMPLETE Column stats: NONE
+ Merge Join Operator
[MERGEJOIN_228]
+ | 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]
+ | 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]
+ | | 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]
+ | | 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_11]
+ | |
outputColumnNames:["_col0","_col1"]
+ | |
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
+ | | Filter
Operator [FIL_207]
+ | |
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]
+ | 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_14]
+ |
outputColumnNames:["_col1"]
+ |
Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column
stats: NONE
+ | Filter
Operator [FIL_208]
+ |
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]
+ 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]
+ | 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]
+ | 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_8]
+ |
outputColumnNames:["_col0","_col1"]
+ |
Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column
stats: NONE
+ | Filter
Operator [FIL_206]
+ |
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]
+ 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]
+ | 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]
+ | 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_2]
+ |
outputColumnNames:["_col0","_col1","_col2"]
+ |
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
+ |
Filter Operator [FIL_204]
+ |
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]
+ 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_5]
+
outputColumnNames:["_col0","_col1"]
+
Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column
stats: NONE
+
Filter Operator [FIL_205]
+
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]
+
alias:item
+
Statistics:Num rows: 462000 Data size: 663560457 Basic stats: COMPLETE Column
stats: NONE
+