You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2015/12/21 02:06:53 UTC
[12/32] hive git commit: HIVE-11865: Disable Hive PPD optimizer when
CBO has optimized the plan (Jesus Camacho Rodriguez,
reviewed by Laljo John Pullokkaran)
http://git-wip-us.apache.org/repos/asf/hive/blob/6f44fc81/ql/src/test/results/clientpositive/perf/query84.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query84.q.out b/ql/src/test/results/clientpositive/perf/query84.q.out
index 8e15aee..e522f23 100644
--- a/ql/src/test/results/clientpositive/perf/query84.q.out
+++ b/ql/src/test/results/clientpositive/perf/query84.q.out
@@ -16,32 +16,32 @@ Stage-0
limit:100
Stage-1
Reducer 6
- File Output Operator [FS_44]
+ File Output Operator [FS_35]
compressed:false
Statistics:Num rows: 100 Data size: 86000 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_43]
+ Limit [LIM_34]
Number of rows:100
Statistics:Num rows: 100 Data size: 86000 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_42]
+ Select Operator [SEL_33]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 234256017 Data size: 201464909002 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 5 [SIMPLE_EDGE]
- Reduce Output Operator [RS_41]
+ Reduce Output Operator [RS_32]
key expressions:_col0 (type: string)
sort order:+
Statistics:Num rows: 234256017 Data size: 201464909002 Basic stats: COMPLETE Column stats: NONE
value expressions:_col1 (type: string)
- Select Operator [SEL_40]
+ Select Operator [SEL_31]
outputColumnNames:["_col0","_col1"]
Statistics:Num rows: 234256017 Data size: 201464909002 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_75]
+ Merge Join Operator [MERGEJOIN_66]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col11 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col0","_col4","_col5"]
| Statistics:Num rows: 234256017 Data size: 201464909002 Basic stats: COMPLETE Column stats: NONE
|<-Map 10 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_38]
+ | Reduce Output Operator [RS_29]
| key expressions:_col0 (type: int)
| Map-reduce partition columns:_col0 (type: int)
| sort order:+
@@ -49,26 +49,26 @@ Stage-0
| Select Operator [SEL_14]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_70]
+ | Filter Operator [FIL_61]
| predicate:(((ib_upper_bound <= 82287) and (ib_lower_bound >= 32287)) and ib_income_band_sk is not null) (type: boolean)
| Statistics:Num rows: 2 Data size: 24 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_12]
| alias:income_band
| Statistics:Num rows: 20 Data size: 240 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_36]
+ Reduce Output Operator [RS_28]
key expressions:_col11 (type: int)
Map-reduce partition columns:_col11 (type: int)
sort order:+
Statistics:Num rows: 212960011 Data size: 183149913305 Basic stats: COMPLETE Column stats: NONE
value expressions:_col0 (type: string), _col4 (type: string), _col5 (type: string)
- Merge Join Operator [MERGEJOIN_74]
+ Merge Join Operator [MERGEJOIN_65]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col2 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col0","_col4","_col5","_col11"]
| Statistics:Num rows: 212960011 Data size: 183149913305 Basic stats: COMPLETE Column stats: NONE
|<-Map 9 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_33]
+ | Reduce Output Operator [RS_26]
| key expressions:_col0 (type: int)
| Map-reduce partition columns:_col0 (type: int)
| sort order:+
@@ -77,26 +77,26 @@ Stage-0
| Select Operator [SEL_11]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_69]
+ | Filter Operator [FIL_60]
| predicate:(hd_demo_sk is not null and hd_income_band_sk is not null) (type: boolean)
| Statistics:Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_9]
| alias:household_demographics
| Statistics:Num rows: 7200 Data size: 770400 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 3 [SIMPLE_EDGE]
- Reduce Output Operator [RS_31]
+ Reduce Output Operator [RS_25]
key expressions:_col2 (type: int)
Map-reduce partition columns:_col2 (type: int)
sort order:+
Statistics:Num rows: 193600006 Data size: 166499917578 Basic stats: COMPLETE Column stats: NONE
value expressions:_col0 (type: string), _col4 (type: string), _col5 (type: string)
- Merge Join Operator [MERGEJOIN_73]
+ Merge Join Operator [MERGEJOIN_64]
| condition map:[{"":"Inner Join 0 to 1"},{"":"Inner Join 1 to 2"}]
| keys:{"0":"_col1 (type: int)","1":"_col0 (type: int)","2":"_col0 (type: int)"}
| outputColumnNames:["_col0","_col2","_col4","_col5"]
| Statistics:Num rows: 193600006 Data size: 166499917578 Basic stats: COMPLETE Column stats: NONE
|<-Map 11 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_28]
+ | Reduce Output Operator [RS_23]
| key expressions:_col0 (type: int)
| Map-reduce partition columns:_col0 (type: int)
| sort order:+
@@ -104,14 +104,14 @@ Stage-0
| Select Operator [SEL_17]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | Filter Operator [FIL_71]
+ | Filter Operator [FIL_62]
| predicate:sr_cdemo_sk is not null (type: boolean)
| Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| TableScan [TS_15]
| alias:store_returns
| Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
|<-Map 8 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_26]
+ | Reduce Output Operator [RS_22]
| key expressions:_col0 (type: int)
| Map-reduce partition columns:_col0 (type: int)
| sort order:+
@@ -119,26 +119,26 @@ Stage-0
| Select Operator [SEL_8]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 19800 Data size: 7171059 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_68]
+ | Filter Operator [FIL_59]
| predicate:cd_demo_sk is not null (type: boolean)
| Statistics:Num rows: 19800 Data size: 7171059 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_6]
| alias:customer_demographics
| Statistics:Num rows: 19800 Data size: 7171059 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 2 [SIMPLE_EDGE]
- Reduce Output Operator [RS_24]
+ Reduce Output Operator [RS_21]
key expressions:_col1 (type: int)
Map-reduce partition columns:_col1 (type: int)
sort order:+
Statistics:Num rows: 88000001 Data size: 75681779077 Basic stats: COMPLETE Column stats: NONE
value expressions:_col0 (type: string), _col2 (type: int), _col4 (type: string), _col5 (type: string)
- Merge Join Operator [MERGEJOIN_72]
+ Merge Join Operator [MERGEJOIN_63]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col3 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col0","_col1","_col2","_col4","_col5"]
| Statistics:Num rows: 88000001 Data size: 75681779077 Basic stats: COMPLETE Column stats: NONE
|<-Map 1 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_19]
+ | Reduce Output Operator [RS_18]
| key expressions:_col3 (type: int)
| Map-reduce partition columns:_col3 (type: int)
| sort order:+
@@ -147,14 +147,14 @@ Stage-0
| Select Operator [SEL_2]
| outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
| Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_66]
+ | Filter Operator [FIL_57]
| predicate:((c_current_addr_sk is not null and c_current_cdemo_sk is not null) and c_current_hdemo_sk is not null) (type: boolean)
| Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_0]
| alias:customer
| Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
|<-Map 7 [SIMPLE_EDGE]
- Reduce Output Operator [RS_21]
+ Reduce Output Operator [RS_19]
key expressions:_col0 (type: int)
Map-reduce partition columns:_col0 (type: int)
sort order:+
@@ -162,7 +162,7 @@ Stage-0
Select Operator [SEL_5]
outputColumnNames:["_col0"]
Statistics:Num rows: 20000000 Data size: 20297597642 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_67]
+ Filter Operator [FIL_58]
predicate:((ca_city = 'Hopewell') and ca_address_sk is not null) (type: boolean)
Statistics:Num rows: 20000000 Data size: 20297597642 Basic stats: COMPLETE Column stats: NONE
TableScan [TS_3]
http://git-wip-us.apache.org/repos/asf/hive/blob/6f44fc81/ql/src/test/results/clientpositive/perf/query85.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/perf/query85.q.out b/ql/src/test/results/clientpositive/perf/query85.q.out
index 660c578..54061ce 100644
--- a/ql/src/test/results/clientpositive/perf/query85.q.out
+++ b/ql/src/test/results/clientpositive/perf/query85.q.out
@@ -20,173 +20,173 @@ Stage-0
limit:100
Stage-1
Reducer 10
- File Output Operator [FS_71]
+ File Output Operator [FS_57]
compressed:false
Statistics:Num rows: 100 Data size: 101400 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_70]
+ Limit [LIM_56]
Number of rows:100
Statistics:Num rows: 100 Data size: 101400 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_69]
+ Select Operator [SEL_55]
| outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows: 9982500 Data size: 10131039080 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 9 [SIMPLE_EDGE]
- Reduce Output Operator [RS_68]
+ Reduce Output Operator [RS_54]
key expressions:_col0 (type: string), _col1 (type: double), _col2 (type: decimal(11,6)), _col3 (type: decimal(11,6))
sort order:++++
Statistics:Num rows: 9982500 Data size: 10131039080 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_67]
+ Select Operator [SEL_53]
outputColumnNames:["_col0","_col1","_col2","_col3"]
Statistics:Num rows: 9982500 Data size: 10131039080 Basic stats: COMPLETE Column stats: NONE
- Group By Operator [GBY_66]
+ Group By Operator [GBY_52]
| aggregations:["avg(VALUE._col0)","avg(VALUE._col1)","avg(VALUE._col2)"]
| keys:KEY._col0 (type: string)
| outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows: 9982500 Data size: 10131039080 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 8 [SIMPLE_EDGE]
- Reduce Output Operator [RS_65]
+ Reduce Output Operator [RS_51]
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
Statistics:Num rows: 19965000 Data size: 20262078161 Basic stats: COMPLETE Column stats: NONE
value expressions:_col1 (type: struct<count:bigint,sum:double,input:int>), _col2 (type: struct<count:bigint,sum:decimal(17,2),input:decimal(7,2)>), _col3 (type: struct<count:bigint,sum:decimal(17,2),input:decimal(7,2)>)
- Group By Operator [GBY_64]
+ Group By Operator [GBY_50]
aggregations:["avg(_col4)","avg(_col14)","avg(_col13)"]
keys:_col28 (type: string)
outputColumnNames:["_col0","_col1","_col2","_col3"]
Statistics:Num rows: 19965000 Data size: 20262078161 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_63]
+ Select Operator [SEL_49]
outputColumnNames:["_col28","_col4","_col14","_col13"]
Statistics:Num rows: 19965000 Data size: 20262078161 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_123]
+ Merge Join Operator [MERGEJOIN_107]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col11 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col4","_col13","_col14","_col28"]
| Statistics:Num rows: 19965000 Data size: 20262078161 Basic stats: COMPLETE Column stats: NONE
|<-Map 17 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_61]
+ | Reduce Output Operator [RS_47]
| key expressions:_col0 (type: int)
| Map-reduce partition columns:_col0 (type: int)
| sort order:+
| Statistics:Num rows: 72 Data size: 14400 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col1 (type: string)
- | Select Operator [SEL_52]
+ | Select Operator [SEL_42]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 72 Data size: 14400 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_116]
+ | Filter Operator [FIL_100]
| predicate:r_reason_sk is not null (type: boolean)
| Statistics:Num rows: 72 Data size: 14400 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_50]
+ | TableScan [TS_40]
| alias:reason
| Statistics:Num rows: 72 Data size: 14400 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 7 [SIMPLE_EDGE]
- Reduce Output Operator [RS_59]
+ Reduce Output Operator [RS_46]
key expressions:_col11 (type: int)
Map-reduce partition columns:_col11 (type: int)
sort order:+
Statistics:Num rows: 18150000 Data size: 18420070657 Basic stats: COMPLETE Column stats: NONE
value expressions:_col4 (type: int), _col13 (type: decimal(7,2)), _col14 (type: decimal(7,2))
- Merge Join Operator [MERGEJOIN_122]
+ Merge Join Operator [MERGEJOIN_106]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col0 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col4","_col11","_col13","_col14"]
| Statistics:Num rows: 18150000 Data size: 18420070657 Basic stats: COMPLETE Column stats: NONE
|<-Map 16 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_56]
+ | Reduce Output Operator [RS_44]
| 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
- | Select Operator [SEL_49]
+ | Select Operator [SEL_39]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_115]
+ | Filter Operator [FIL_99]
| predicate:((d_year = 1998) and d_date_sk is not null) (type: boolean)
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_47]
+ | TableScan [TS_37]
| alias:date_dim
| Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 6 [SIMPLE_EDGE]
- Reduce Output Operator [RS_54]
+ Reduce Output Operator [RS_43]
key expressions:_col0 (type: int)
Map-reduce partition columns:_col0 (type: int)
sort order:+
Statistics:Num rows: 16500000 Data size: 16745518417 Basic stats: COMPLETE Column stats: NONE
value expressions:_col4 (type: int), _col11 (type: int), _col13 (type: decimal(7,2)), _col14 (type: decimal(7,2))
- Select Operator [SEL_46]
+ Select Operator [SEL_36]
outputColumnNames:["_col0","_col11","_col13","_col14","_col4"]
Statistics:Num rows: 16500000 Data size: 16745518417 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_107]
+ Filter Operator [FIL_35]
predicate:(((_col23) IN ('KY', 'GA', 'NM') and _col6 BETWEEN 100 AND 200) or ((_col23) IN ('MT', 'OR', 'IN') and _col6 BETWEEN 150 AND 300) or ((_col23) IN ('WI', 'MO', 'WV') and _col6 BETWEEN 50 AND 250)) (type: boolean)
Statistics:Num rows: 16500000 Data size: 16745518417 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_121]
+ Merge Join Operator [MERGEJOIN_105]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col9 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col0","_col4","_col6","_col11","_col13","_col14","_col23"]
| Statistics:Num rows: 22000000 Data size: 22327357890 Basic stats: COMPLETE Column stats: NONE
|<-Map 15 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_43]
+ | Reduce Output Operator [RS_33]
| key expressions:_col0 (type: int)
| Map-reduce partition columns:_col0 (type: int)
| sort order:+
| Statistics:Num rows: 20000000 Data size: 20297597642 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col1 (type: string)
- | Select Operator [SEL_34]
+ | Select Operator [SEL_28]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 20000000 Data size: 20297597642 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_114]
+ | Filter Operator [FIL_98]
| predicate:((((ca_state) IN ('KY', 'GA', 'NM') or (ca_state) IN ('MT', 'OR', 'IN') or (ca_state) IN ('WI', 'MO', 'WV')) and (ca_country = 'United States')) and ca_address_sk is not null) (type: boolean)
| Statistics:Num rows: 20000000 Data size: 20297597642 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_32]
+ | TableScan [TS_26]
| alias:customer_address
| Statistics:Num rows: 40000000 Data size: 40595195284 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 5 [SIMPLE_EDGE]
- Reduce Output Operator [RS_41]
+ Reduce Output Operator [RS_32]
key expressions:_col9 (type: int)
Map-reduce partition columns:_col9 (type: int)
sort order:+
Statistics:Num rows: 21780 Data size: 7888165 Basic stats: COMPLETE Column stats: NONE
value expressions:_col0 (type: int), _col4 (type: int), _col6 (type: decimal(7,2)), _col11 (type: int), _col13 (type: decimal(7,2)), _col14 (type: decimal(7,2))
- Merge Join Operator [MERGEJOIN_120]
+ Merge Join Operator [MERGEJOIN_104]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col10 (type: int), _col17 (type: string), _col18 (type: string)","1":"_col0 (type: int), _col1 (type: string), _col2 (type: string)"}
| outputColumnNames:["_col0","_col4","_col6","_col9","_col11","_col13","_col14"]
| Statistics:Num rows: 21780 Data size: 7888165 Basic stats: COMPLETE Column stats: NONE
|<-Map 14 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_38]
+ | Reduce Output Operator [RS_30]
| key expressions:_col0 (type: int), _col1 (type: string), _col2 (type: string)
| Map-reduce partition columns:_col0 (type: int), _col1 (type: string), _col2 (type: string)
| sort order:+++
| Statistics:Num rows: 19800 Data size: 7171059 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_31]
+ | Select Operator [SEL_25]
| outputColumnNames:["_col0","_col1","_col2"]
| Statistics:Num rows: 19800 Data size: 7171059 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_113]
+ | Filter Operator [FIL_97]
| predicate:((((((cd_education_status = '4 yr Degree') or (cd_education_status = 'Primary') or (cd_education_status = 'Advanced Degree')) and cd_education_status is not null) and ((cd_marital_status = 'M') or (cd_marital_status = 'D') or (cd_marital_status = 'U'))) and cd_marital_status is not null) and cd_demo_sk is not null) (type: boolean)
| Statistics:Num rows: 19800 Data size: 7171059 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_29]
+ | TableScan [TS_23]
| alias:cd1
| Statistics:Num rows: 19800 Data size: 7171059 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_36]
+ Reduce Output Operator [RS_29]
key expressions:_col10 (type: int), _col17 (type: string), _col18 (type: string)
Map-reduce partition columns:_col10 (type: int), _col17 (type: string), _col18 (type: string)
sort order:+++
Statistics:Num rows: 8166 Data size: 2957518 Basic stats: COMPLETE Column stats: NONE
value expressions:_col0 (type: int), _col4 (type: int), _col6 (type: decimal(7,2)), _col9 (type: int), _col11 (type: int), _col13 (type: decimal(7,2)), _col14 (type: decimal(7,2))
- Select Operator [SEL_28]
+ Select Operator [SEL_22]
outputColumnNames:["_col0","_col10","_col11","_col13","_col14","_col17","_col18","_col4","_col6","_col9"]
Statistics:Num rows: 8166 Data size: 2957518 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_108]
+ Filter Operator [FIL_21]
predicate:(((_col17 = 'M') and (_col18 = '4 yr Degree') and _col5 BETWEEN 100.0 AND 150.0) or ((_col17 = 'D') and (_col18 = 'Primary') and _col5 BETWEEN 50.0 AND 100.0) or ((_col17 = 'U') and (_col18 = 'Advanced Degree') and _col5 BETWEEN 150.0 AND 200.0)) (type: boolean)
Statistics:Num rows: 8166 Data size: 2957518 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_119]
+ Merge Join Operator [MERGEJOIN_103]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col8 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col0","_col4","_col5","_col6","_col9","_col10","_col11","_col13","_col14","_col17","_col18"]
| Statistics:Num rows: 21780 Data size: 7888165 Basic stats: COMPLETE Column stats: NONE
|<-Map 13 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_25]
+ | Reduce Output Operator [RS_19]
| key expressions:_col0 (type: int)
| Map-reduce partition columns:_col0 (type: int)
| sort order:+
@@ -195,26 +195,26 @@ Stage-0
| Select Operator [SEL_11]
| outputColumnNames:["_col0","_col1","_col2"]
| Statistics:Num rows: 19800 Data size: 7171059 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_112]
+ | Filter Operator [FIL_96]
| predicate:((((((cd_marital_status = 'M') or (cd_marital_status = 'D') or (cd_marital_status = 'U')) and ((cd_education_status = '4 yr Degree') or (cd_education_status = 'Primary') or (cd_education_status = 'Advanced Degree'))) and cd_demo_sk is not null) and cd_education_status is not null) and cd_marital_status is not null) (type: boolean)
| Statistics:Num rows: 19800 Data size: 7171059 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_9]
| alias:cd1
| Statistics:Num rows: 19800 Data size: 7171059 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 3 [SIMPLE_EDGE]
- Reduce Output Operator [RS_23]
+ Reduce Output Operator [RS_18]
key expressions:_col8 (type: int)
Map-reduce partition columns:_col8 (type: int)
sort order:+
Statistics:Num rows: 5062 Data size: 2965795 Basic stats: COMPLETE Column stats: NONE
value expressions:_col0 (type: int), _col4 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col9 (type: int), _col10 (type: int), _col11 (type: int), _col13 (type: decimal(7,2)), _col14 (type: decimal(7,2))
- Merge Join Operator [MERGEJOIN_118]
+ Merge Join Operator [MERGEJOIN_102]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col2 (type: int)","1":"_col0 (type: int)"}
| outputColumnNames:["_col0","_col4","_col5","_col6","_col8","_col9","_col10","_col11","_col13","_col14"]
| Statistics:Num rows: 5062 Data size: 2965795 Basic stats: COMPLETE Column stats: NONE
|<-Map 12 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_20]
+ | Reduce Output Operator [RS_16]
| key expressions:_col0 (type: int)
| Map-reduce partition columns:_col0 (type: int)
| sort order:+
@@ -222,26 +222,26 @@ Stage-0
| Select Operator [SEL_8]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 4602 Data size: 2696178 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_111]
+ | Filter Operator [FIL_95]
| predicate:wp_web_page_sk is not null (type: boolean)
| Statistics:Num rows: 4602 Data size: 2696178 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_6]
| alias:web_page
| Statistics:Num rows: 4602 Data size: 2696178 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 2 [SIMPLE_EDGE]
- Reduce Output Operator [RS_18]
+ Reduce Output Operator [RS_15]
key expressions:_col2 (type: int)
Map-reduce partition columns:_col2 (type: int)
sort order:+
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
value expressions:_col0 (type: int), _col4 (type: int), _col5 (type: decimal(7,2)), _col6 (type: decimal(7,2)), _col8 (type: int), _col9 (type: int), _col10 (type: int), _col11 (type: int), _col13 (type: decimal(7,2)), _col14 (type: decimal(7,2))
- Merge Join Operator [MERGEJOIN_117]
+ Merge Join Operator [MERGEJOIN_101]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col1 (type: int), _col3 (type: int)","1":"_col0 (type: int), _col5 (type: int)"}
| outputColumnNames:["_col0","_col2","_col4","_col5","_col6","_col8","_col9","_col10","_col11","_col13","_col14"]
| Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
|<-Map 1 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_13]
+ | Reduce Output Operator [RS_12]
| key expressions:_col1 (type: int), _col3 (type: int)
| Map-reduce partition columns:_col1 (type: int), _col3 (type: int)
| sort order:++
@@ -250,14 +250,14 @@ Stage-0
| Select Operator [SEL_2]
| outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6"]
| Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | Filter Operator [FIL_109]
+ | Filter Operator [FIL_93]
| predicate:(((((ws_item_sk is not null and (ws_sales_price BETWEEN 100.0 AND 150.0 or ws_sales_price BETWEEN 50.0 AND 100.0 or ws_sales_price BETWEEN 150.0 AND 200.0)) and ws_order_number is not null) and (ws_net_profit BETWEEN 100 AND 200 or ws_net_profit BETWEEN 150 AND 300 or ws_net_profit BETWEEN 50 AND 250)) and ws_web_page_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_0]
| alias:web_sales
| Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
|<-Map 11 [SIMPLE_EDGE]
- Reduce Output Operator [RS_15]
+ Reduce Output Operator [RS_13]
key expressions:_col0 (type: int), _col5 (type: int)
Map-reduce partition columns:_col0 (type: int), _col5 (type: int)
sort order:++
@@ -266,7 +266,7 @@ Stage-0
Select Operator [SEL_5]
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7"]
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- Filter Operator [FIL_110]
+ Filter Operator [FIL_94]
predicate:(((((wr_order_number is not null and wr_item_sk is not null) and wr_refunded_cdemo_sk is not null) and wr_returning_cdemo_sk is not null) and wr_refunded_addr_sk is not null) and wr_reason_sk is not null) (type: boolean)
Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
TableScan [TS_3]
http://git-wip-us.apache.org/repos/asf/hive/blob/6f44fc81/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 e4762b2..a336189 100644
--- a/ql/src/test/results/clientpositive/perf/query87.q.out
+++ b/ql/src/test/results/clientpositive/perf/query87.q.out
@@ -23,256 +23,256 @@ Stage-0
limit:-1
Stage-1
Reducer 7
- File Output Operator [FS_86]
+ 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_84]
+ 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_83]
+ 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_82]
+ 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_81]
+ Select Operator [SEL_69]
Statistics:Num rows: 24200000 Data size: 20812489029 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_108]
+ 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_126]
+ 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_78]
+ | 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_76]
+ | 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_75]
+ | 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_74]
+ | 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_73]
+ | 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_124]
+ | 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_70]
+ | | 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_61]
+ | | Select Operator [SEL_53]
| | outputColumnNames:["_col0","_col1","_col2"]
| | Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_118]
+ | | 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_59]
+ | | 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_68]
+ | 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_123]
+ | 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_63]
+ | | 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_55]
+ | | Select Operator [SEL_47]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter Operator [FIL_116]
+ | | 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_53]
+ | | 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_65]
+ | 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_58]
+ | Select Operator [SEL_50]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_117]
+ | Filter Operator [FIL_103]
| predicate:(d_month_seq BETWEEN 1193 AND 1204 and d_date_sk is not null) (type: boolean)
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_56]
+ | 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_77]
+ 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_52]
+ Select Operator [SEL_44]
outputColumnNames:["_col0","_col1","_col2"]
Statistics:Num rows: 24200000 Data size: 20812489029 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_109]
+ 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_125]
+ 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_49]
+ | 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_47]
+ | 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_46]
+ | 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_45]
+ | 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_44]
+ | 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_122]
+ | 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_41]
+ | | 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_32]
+ | | Select Operator [SEL_28]
| | outputColumnNames:["_col0","_col1","_col2"]
| | Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_115]
+ | | 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_30]
+ | | 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_39]
+ | 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_121]
+ | 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_34]
+ | | Reduce Output Operator [RS_29]
| | key expressions:_col0 (type: int)
| | Map-reduce partition columns:_col0 (type: int)
| | sort order:+
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
| | value expressions:_col1 (type: int)
- | | Select Operator [SEL_26]
+ | | Select Operator [SEL_22]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | | Filter Operator [FIL_113]
+ | | 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_24]
+ | | 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_36]
+ | 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_29]
+ | Select Operator [SEL_25]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_114]
+ | Filter Operator [FIL_100]
| predicate:(d_month_seq BETWEEN 1193 AND 1204 and d_date_sk is not null) (type: boolean)
| Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_27]
+ | TableScan [TS_23]
| alias:date_dim
| Statistics:Num rows: 73049 Data size: 81741831 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_48]
+ 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_23]
+ 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_22]
+ 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_21]
+ 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_20]
+ 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_120]
+ 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_17]
+ | Reduce Output Operator [RS_13]
| key expressions:_col0 (type: int)
| Map-reduce partition columns:_col0 (type: int)
| sort order:+
@@ -281,26 +281,26 @@ Stage-0
| Select Operator [SEL_8]
| outputColumnNames:["_col0","_col1","_col2"]
| Statistics:Num rows: 80000000 Data size: 68801615852 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_112]
+ | 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_15]
+ 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_119]
+ 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_10]
+ | Reduce Output Operator [RS_9]
| key expressions:_col0 (type: int)
| Map-reduce partition columns:_col0 (type: int)
| sort order:+
@@ -309,14 +309,14 @@ Stage-0
| Select Operator [SEL_2]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
- | Filter Operator [FIL_110]
+ | 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_12]
+ Reduce Output Operator [RS_10]
key expressions:_col0 (type: int)
Map-reduce partition columns:_col0 (type: int)
sort order:+
@@ -325,7 +325,7 @@ Stage-0
Select Operator [SEL_5]
outputColumnNames:["_col0","_col1"]
Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_111]
+ Filter Operator [FIL_97]
predicate:(d_month_seq BETWEEN 1193 AND 1204 and d_date_sk is not null) (type: boolean)
Statistics:Num rows: 36524 Data size: 40870356 Basic stats: COMPLETE Column stats: NONE
TableScan [TS_3]