You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by px...@apache.org on 2015/12/23 06:06:50 UTC
[7/9] hive git commit: HIVE-11927: Implement/Enable constant related
optimization rules in Calcite: enable HiveReduceExpressionsRule to fold
constants (Pengcheng Xiong, reviewed by Laljo John Pullokkaran)
http://git-wip-us.apache.org/repos/asf/hive/blob/b340ecb5/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out b/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
index b322ef1..7c5be6d 100644
--- a/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
+++ b/ql/src/test/results/clientpositive/parquet_predicate_pushdown.q.out
@@ -756,23 +756,23 @@ STAGE PLANS:
alias: tbl_pred
Statistics: Num rows: 1049 Data size: 11539 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (not (s like '%car%'))) and (t > 0)) and si BETWEEN 300 AND 400) (type: boolean)
- Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (t > 0)) and si BETWEEN 300 AND 400) and (not (s like '%car%'))) (type: boolean)
+ Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: t (type: tinyint), si (type: smallint), d (type: double), s (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: string)
sort order: -
- Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col2 (type: double)
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: smallint), VALUE._col2 (type: double), KEY.reducesinkkey0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 3
Statistics: Num rows: 3 Data size: 33 Basic stats: COMPLETE Column stats: NONE
@@ -822,26 +822,26 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: tbl_pred
- filterExpr: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (not (s like '%car%'))) and (t > 0)) and si BETWEEN 300 AND 400) (type: boolean)
+ filterExpr: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (t > 0)) and si BETWEEN 300 AND 400) and (not (s like '%car%'))) (type: boolean)
Statistics: Num rows: 1049 Data size: 11539 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (not (s like '%car%'))) and (t > 0)) and si BETWEEN 300 AND 400) (type: boolean)
- Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+ predicate: ((((((d >= 10.0) and (d < 12.0)) and (s like '%son')) and (t > 0)) and si BETWEEN 300 AND 400) and (not (s like '%car%'))) (type: boolean)
+ Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: t (type: tinyint), si (type: smallint), d (type: double), s (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col3 (type: string)
sort order: -
- Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
TopN Hash Memory Usage: 0.1
value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col2 (type: double)
Reduce Operator Tree:
Select Operator
expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: smallint), VALUE._col2 (type: double), KEY.reducesinkkey0 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3
- Statistics: Num rows: 4 Data size: 44 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 5 Data size: 55 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 3
Statistics: Num rows: 3 Data size: 33 Basic stats: COMPLETE Column stats: NONE
http://git-wip-us.apache.org/repos/asf/hive/blob/b340ecb5/ql/src/test/results/clientpositive/partition_multilevels.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/partition_multilevels.q.out b/ql/src/test/results/clientpositive/partition_multilevels.q.out
index c1c8778..0fe7f82 100644
--- a/ql/src/test/results/clientpositive/partition_multilevels.q.out
+++ b/ql/src/test/results/clientpositive/partition_multilevels.q.out
@@ -990,12 +990,12 @@ STAGE PLANS:
alias: partition_test_multilevel
Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: '2222' (type: string), level2 (type: string), level3 (type: string)
- outputColumnNames: level1, level2, level3
+ expressions: level2 (type: string), level3 (type: string)
+ outputColumnNames: _col1, _col2
Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
- keys: level1 (type: string), level2 (type: string), level3 (type: string)
+ keys: '2222' (type: string), _col1 (type: string), _col2 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
@@ -1012,13 +1012,17 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 54 Data size: 573 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Select Operator
+ expressions: '2222' (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: bigint)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 54 Data size: 573 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
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 54 Data size: 573 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
Stage: Stage-0
Fetch Operator
@@ -1578,12 +1582,12 @@ STAGE PLANS:
alias: partition_test_multilevel
Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: '2222' (type: string), level2 (type: string), level3 (type: string)
- outputColumnNames: level1, level2, level3
+ expressions: level2 (type: string), level3 (type: string)
+ outputColumnNames: _col1, _col2
Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
Group By Operator
aggregations: count()
- keys: level1 (type: string), level2 (type: string), level3 (type: string)
+ keys: '2222' (type: string), _col1 (type: string), _col2 (type: string)
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 108 Data size: 1146 Basic stats: COMPLETE Column stats: NONE
@@ -1600,13 +1604,17 @@ STAGE PLANS:
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 54 Data size: 573 Basic stats: COMPLETE Column stats: NONE
- File Output Operator
- compressed: false
+ Select Operator
+ expressions: '2222' (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: bigint)
+ outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 54 Data size: 573 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
+ File Output Operator
+ compressed: false
+ Statistics: Num rows: 54 Data size: 573 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
Stage: Stage-0
Fetch Operator
http://git-wip-us.apache.org/repos/asf/hive/blob/b340ecb5/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 52cbdf4..8c370c4 100644
--- a/ql/src/test/results/clientpositive/perf/query31.q.out
+++ b/ql/src/test/results/clientpositive/perf/query31.q.out
@@ -32,549 +32,549 @@ Stage-0
limit:-1
Stage-1
Reducer 7
- File Output Operator [FS_135]
+ File Output Operator [FS_141]
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_134]
+ Select Operator [SEL_140]
| 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_133]
+ Reduce Output Operator [RS_139]
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_132]
- outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
+ value expressions:_col0 (type: string), _col3 (type: decimal(37,20)), _col4 (type: decimal(37,20)), _col5 (type: decimal(37,20))
+ Select Operator [SEL_138]
+ outputColumnNames:["_col0","_col2","_col3","_col4","_col5"]
Statistics:Num rows: 11831111 Data size: 12007156967 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_131]
+ Filter Operator [FIL_137]
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_275]
+ Merge Join Operator [MERGEJOIN_281]
| 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"]
+ | outputColumnNames:["_col0","_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_129]
+ | Reduce Output Operator [RS_135]
| 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_127]
+ | Select Operator [SEL_133]
| outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_126]
+ | Group By Operator [GBY_132]
| | aggregations:["sum(VALUE._col0)"]
- | | keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+ | | keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
| | 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_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)
+ | Reduce Output Operator [RS_131]
+ | key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+ | Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
| 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_124]
- | aggregations:["sum(_col2)"]
- | keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+ | Group By Operator [GBY_130]
+ | aggregations:["sum(_col3)"]
+ | keys:_col0 (type: string), 3 (type: int), 1998 (type: int)
| outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_123]
- | outputColumnNames:["_col4","_col5","_col7","_col2"]
+ | Select Operator [SEL_128]
+ | outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_273]
+ | Merge Join Operator [MERGEJOIN_279]
| | 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_121]
+ | | Reduce Output Operator [RS_126]
| | 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_116]
+ | | Select Operator [SEL_121]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_261]
+ | | Filter Operator [FIL_267]
| | 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_114]
+ | | TableScan [TS_119]
| | alias:customer_address
| | Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 35 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_120]
+ | Reduce Output Operator [RS_125]
| 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_272]
+ | Merge Join Operator [MERGEJOIN_278]
| | 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_117]
+ | | Reduce Output Operator [RS_122]
| | 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_110]
+ | | Select Operator [SEL_115]
| | outputColumnNames:["_col0","_col1","_col2"]
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter Operator [FIL_259]
+ | | Filter Operator [FIL_265]
| | 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_108]
+ | | TableScan [TS_113]
| | alias:web_sales
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| |<-Map 38 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_118]
+ | Reduce Output Operator [RS_123]
| 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_113]
+ | Select Operator [SEL_118]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_260]
+ | Filter Operator [FIL_266]
| 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_111]
+ | TableScan [TS_116]
| alias:date_dim
| Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 5 [SIMPLE_EDGE]
- Reduce Output Operator [RS_128]
+ Reduce Output Operator [RS_134]
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_107]
- outputColumnNames:["_col0","_col11","_col12","_col15","_col19","_col2","_col3","_col7"]
+ value expressions:_col0 (type: string), _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_112]
+ outputColumnNames:["_col0","_col11","_col12","_col15","_col19","_col3","_col7"]
Statistics:Num rows: 32266667 Data size: 32746791943 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_106]
+ Filter Operator [FIL_111]
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_274]
+ Merge Join Operator [MERGEJOIN_280]
| 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"]
+ | outputColumnNames:["_col0","_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_101]
+ | Reduce Output Operator [RS_106]
| 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_39]
+ | Select Operator [SEL_41]
| outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_38]
+ | Group By Operator [GBY_40]
| | aggregations:["sum(VALUE._col0)"]
- | | keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+ | | keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
| | 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_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)
+ | Reduce Output Operator [RS_39]
+ | key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+ | Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
| 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_36]
- | aggregations:["sum(_col2)"]
- | keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+ | Group By Operator [GBY_38]
+ | aggregations:["sum(_col3)"]
+ | keys:_col0 (type: string), 2 (type: int), 1998 (type: int)
| outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_35]
- | outputColumnNames:["_col4","_col5","_col7","_col2"]
+ | Select Operator [SEL_36]
+ | outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_265]
+ | 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 15 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_33]
+ | | Reduce Output Operator [RS_34]
| | 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_28]
+ | | Select Operator [SEL_29]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_249]
+ | | 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_26]
+ | | TableScan [TS_27]
| | alias:customer_address
| | Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 11 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_32]
+ | Reduce Output Operator [RS_33]
| 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_264]
+ | 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 10 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_29]
+ | | Reduce Output Operator [RS_30]
| | 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_22]
+ | | Select Operator [SEL_23]
| | outputColumnNames:["_col0","_col1","_col2"]
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter Operator [FIL_247]
+ | | Filter Operator [FIL_253]
| | 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_20]
+ | | TableScan [TS_21]
| | alias:store_sales
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| |<-Map 14 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_30]
+ | Reduce Output Operator [RS_31]
| 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_25]
+ | Select Operator [SEL_26]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_248]
+ | Filter Operator [FIL_254]
| 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_23]
+ | TableScan [TS_24]
| alias:date_dim
| Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 19 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_102]
+ | Reduce Output Operator [RS_107]
| 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_59]
+ | Select Operator [SEL_62]
| outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_58]
+ | Group By Operator [GBY_61]
| | aggregations:["sum(VALUE._col0)"]
- | | keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+ | | keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
| | 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_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)
+ | Reduce Output Operator [RS_60]
+ | key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+ | Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
| 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_56]
- | aggregations:["sum(_col2)"]
- | keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+ | Group By Operator [GBY_59]
+ | aggregations:["sum(_col3)"]
+ | keys:_col0 (type: string), 3 (type: int), 1998 (type: int)
| outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_55]
- | outputColumnNames:["_col4","_col5","_col7","_col2"]
+ | Select Operator [SEL_57]
+ | outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_267]
+ | 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 21 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_53]
+ | | Reduce Output Operator [RS_55]
| | 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_48]
+ | | Select Operator [SEL_50]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_252]
+ | | 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_46]
+ | | TableScan [TS_48]
| | alias:customer_address
| | Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 17 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_52]
+ | Reduce Output Operator [RS_54]
| 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_266]
+ | 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 16 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_49]
+ | | Reduce Output Operator [RS_51]
| | 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_42]
+ | | Select Operator [SEL_44]
| | outputColumnNames:["_col0","_col1","_col2"]
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter Operator [FIL_250]
+ | | Filter Operator [FIL_256]
| | 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_40]
+ | | TableScan [TS_42]
| | alias:store_sales
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| |<-Map 20 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_50]
+ | Reduce Output Operator [RS_52]
| 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_45]
+ | Select Operator [SEL_47]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_251]
+ | Filter Operator [FIL_257]
| 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_43]
+ | TableScan [TS_45]
| alias:date_dim
| Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 25 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_103]
+ | Reduce Output Operator [RS_108]
| 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_79]
+ | Select Operator [SEL_83]
| outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_78]
+ | Group By Operator [GBY_82]
| | aggregations:["sum(VALUE._col0)"]
- | | keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+ | | keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
| | 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_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)
+ | Reduce Output Operator [RS_81]
+ | key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+ | Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
| 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_76]
- | aggregations:["sum(_col2)"]
- | keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+ | Group By Operator [GBY_80]
+ | aggregations:["sum(_col3)"]
+ | keys:_col0 (type: string), 1 (type: int), 1998 (type: int)
| outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_75]
- | outputColumnNames:["_col4","_col5","_col7","_col2"]
+ | Select Operator [SEL_78]
+ | outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_269]
+ | Merge Join Operator [MERGEJOIN_275]
| | 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_73]
+ | | Reduce Output Operator [RS_76]
| | 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_68]
+ | | Select Operator [SEL_71]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_255]
+ | | 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_66]
+ | | TableScan [TS_69]
| | alias:customer_address
| | Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 23 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_72]
+ | Reduce Output Operator [RS_75]
| 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_268]
+ | Merge Join Operator [MERGEJOIN_274]
| | 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_69]
+ | | Reduce Output Operator [RS_72]
| | 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_62]
+ | | Select Operator [SEL_65]
| | outputColumnNames:["_col0","_col1","_col2"]
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter Operator [FIL_253]
+ | | 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_60]
+ | | TableScan [TS_63]
| | alias:web_sales
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| |<-Map 26 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_70]
+ | Reduce Output Operator [RS_73]
| 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_65]
+ | Select Operator [SEL_68]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_254]
+ | Filter Operator [FIL_260]
| 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_63]
+ | TableScan [TS_66]
| alias:date_dim
| Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 31 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_104]
+ | Reduce Output Operator [RS_109]
| 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_99]
+ | Select Operator [SEL_104]
| outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_98]
+ | Group By Operator [GBY_103]
| | aggregations:["sum(VALUE._col0)"]
- | | keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+ | | keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
| | 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_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)
+ | Reduce Output Operator [RS_102]
+ | key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+ | Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
| 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_96]
- | aggregations:["sum(_col2)"]
- | keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+ | Group By Operator [GBY_101]
+ | aggregations:["sum(_col3)"]
+ | keys:_col0 (type: string), 2 (type: int), 1998 (type: int)
| outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_95]
- | outputColumnNames:["_col4","_col5","_col7","_col2"]
+ | Select Operator [SEL_99]
+ | outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_271]
+ | Merge Join Operator [MERGEJOIN_277]
| | 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_93]
+ | | Reduce Output Operator [RS_97]
| | 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_88]
+ | | Select Operator [SEL_92]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_258]
+ | | Filter Operator [FIL_264]
| | 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_86]
+ | | TableScan [TS_90]
| | alias:customer_address
| | Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 29 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_92]
+ | Reduce Output Operator [RS_96]
| 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_270]
+ | Merge Join Operator [MERGEJOIN_276]
| | 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_89]
+ | | Reduce Output Operator [RS_93]
| | 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_82]
+ | | Select Operator [SEL_86]
| | outputColumnNames:["_col0","_col1","_col2"]
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter Operator [FIL_256]
+ | | Filter Operator [FIL_262]
| | 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_80]
+ | | TableScan [TS_84]
| | alias:web_sales
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| |<-Map 32 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_90]
+ | Reduce Output Operator [RS_94]
| 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_85]
+ | Select Operator [SEL_89]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 18262 Data size: 20435178 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_257]
+ | Filter Operator [FIL_263]
| 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_83]
+ | TableScan [TS_87]
| alias:date_dim
| Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_100]
+ Reduce Output Operator [RS_105]
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_19]
- outputColumnNames:["_col0","_col2","_col3"]
+ value expressions:_col3 (type: decimal(17,2))
+ Select Operator [SEL_20]
+ outputColumnNames:["_col0","_col3"]
Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
- Group By Operator [GBY_18]
+ Group By Operator [GBY_19]
| aggregations:["sum(VALUE._col0)"]
- | keys:KEY._col0 (type: int), KEY._col1 (type: int), KEY._col2 (type: string)
+ | keys:KEY._col0 (type: string), KEY._col1 (type: int), KEY._col2 (type: int)
| 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_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)
+ Reduce Output Operator [RS_18]
+ key expressions:_col0 (type: string), _col1 (type: int), _col2 (type: int)
+ Map-reduce partition columns:_col0 (type: string), _col1 (type: int), _col2 (type: int)
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_16]
- aggregations:["sum(_col2)"]
- keys:_col4 (type: int), _col5 (type: int), _col7 (type: string)
+ Group By Operator [GBY_17]
+ aggregations:["sum(_col3)"]
+ keys:_col0 (type: string), 1 (type: int), 1998 (type: int)
outputColumnNames:["_col0","_col1","_col2","_col3"]
Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
Select Operator [SEL_15]
- outputColumnNames:["_col4","_col5","_col7","_col2"]
+ outputColumnNames:["_col0","_col3"]
Statistics:Num rows: 44000000 Data size: 44654715780 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_263]
+ Merge Join Operator [MERGEJOIN_269]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col2","_col7"]
@@ -589,7 +589,7 @@ 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_246]
+ | 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_6]
@@ -602,7 +602,7 @@ Stage-0
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_262]
+ Merge Join Operator [MERGEJOIN_268]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col1","_col2"]
@@ -617,7 +617,7 @@ 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_244]
+ | 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_0]
@@ -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_245]
+ Filter Operator [FIL_251]
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]