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:18:14 UTC
[07/15] 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/827ff37f/ql/src/test/results/clientpositive/tez/explainuser_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/explainuser_2.q.out b/ql/src/test/results/clientpositive/tez/explainuser_2.q.out
index 61a9580..eb7d564 100644
--- a/ql/src/test/results/clientpositive/tez/explainuser_2.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainuser_2.q.out
@@ -189,20 +189,20 @@ Stage-0
limit:-1
Stage-1
Reducer 3
- File Output Operator [FS_20]
+ File Output Operator [FS_16]
compressed:false
Statistics:Num rows: 605 Data size: 6427 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_19]
+ Select Operator [SEL_15]
outputColumnNames:["_col0","_col1","_col2"]
Statistics:Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_30]
+ Merge Join Operator [MERGEJOIN_26]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col3 (type: string)","1":"_col0 (type: string)"}
| outputColumnNames:["_col0","_col3","_col6"]
| Statistics:Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
|<-Map 5 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_17]
+ | Reduce Output Operator [RS_13]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
@@ -211,26 +211,26 @@ Stage-0
| Select Operator [SEL_8]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_28]
+ | Filter Operator [FIL_24]
| predicate:key is not null (type: boolean)
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_6]
| alias:y
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 2 [SIMPLE_EDGE]
- Reduce Output Operator [RS_15]
+ Reduce Output Operator [RS_12]
key expressions:_col3 (type: string)
Map-reduce partition columns:_col3 (type: string)
sort order:+
Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
value expressions:_col0 (type: string)
- Merge Join Operator [MERGEJOIN_29]
+ Merge Join Operator [MERGEJOIN_25]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col0 (type: string)","1":"_col1 (type: string)"}
| outputColumnNames:["_col0","_col3"]
| Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
|<-Map 1 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_10]
+ | Reduce Output Operator [RS_9]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
@@ -238,14 +238,14 @@ Stage-0
| Select Operator [SEL_2]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_26]
+ | Filter Operator [FIL_22]
| predicate:value is not null (type: boolean)
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_0]
| alias:z
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
|<-Map 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_12]
+ Reduce Output Operator [RS_10]
key expressions:_col1 (type: string)
Map-reduce partition columns:_col1 (type: string)
sort order:+
@@ -254,7 +254,7 @@ Stage-0
Select Operator [SEL_5]
outputColumnNames:["_col0","_col1"]
Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_27]
+ Filter Operator [FIL_23]
predicate:(key is not null and value is not null) (type: boolean)
Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
TableScan [TS_3]
@@ -335,79 +335,79 @@ Stage-0
limit:100
Stage-1
Reducer 5
- File Output Operator [FS_69]
+ File Output Operator [FS_55]
compressed:false
Statistics:Num rows: 100 Data size: 1000 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_68]
+ Limit [LIM_54]
Number of rows:100
Statistics:Num rows: 100 Data size: 1000 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_67]
+ Select Operator [SEL_53]
| outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
| Statistics:Num rows: 805 Data size: 8553 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_66]
+ Reduce Output Operator [RS_52]
key expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string)
sort order:+++
Statistics:Num rows: 805 Data size: 8553 Basic stats: COMPLETE Column stats: NONE
value expressions:_col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint)
- Select Operator [SEL_65]
+ Select Operator [SEL_51]
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
Statistics:Num rows: 805 Data size: 8553 Basic stats: COMPLETE Column stats: NONE
- Group By Operator [GBY_64]
+ Group By Operator [GBY_50]
| aggregations:["count(VALUE._col0)","count(VALUE._col1)","count(VALUE._col2)"]
| keys:KEY._col0 (type: string), KEY._col1 (type: string), KEY._col2 (type: string)
| outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
| Statistics:Num rows: 805 Data size: 8553 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 3 [SIMPLE_EDGE]
- Reduce Output Operator [RS_63]
+ Reduce Output Operator [RS_49]
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: 1610 Data size: 17107 Basic stats: COMPLETE Column stats: NONE
value expressions:_col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint)
- Group By Operator [GBY_62]
+ Group By Operator [GBY_48]
aggregations:["count(_col13)","count(_col21)","count(_col3)"]
keys:_col2 (type: string), _col12 (type: string), _col20 (type: string)
outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
Statistics:Num rows: 1610 Data size: 17107 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_61]
+ Select Operator [SEL_47]
outputColumnNames:["_col2","_col12","_col20","_col13","_col21","_col3"]
Statistics:Num rows: 1610 Data size: 17107 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_111]
+ Merge Join Operator [MERGEJOIN_97]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col1 (type: string), _col3 (type: string)","1":"_col15 (type: string), _col17 (type: string)"}
| outputColumnNames:["_col2","_col3","_col12","_col13","_col20","_col21"]
| Statistics:Num rows: 1610 Data size: 17107 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 11 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_59]
+ | Reduce Output Operator [RS_45]
| key expressions:_col15 (type: string), _col17 (type: string)
| Map-reduce partition columns:_col15 (type: string), _col17 (type: string)
| sort order:++
| Statistics:Num rows: 1464 Data size: 15552 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col6 (type: string), _col7 (type: string), _col14 (type: string)
- | Select Operator [SEL_50]
+ | Select Operator [SEL_40]
| outputColumnNames:["_col14","_col15","_col17","_col6","_col7"]
| Statistics:Num rows: 1464 Data size: 15552 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_110]
+ | Merge Join Operator [MERGEJOIN_96]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col4 (type: string), _col6 (type: string)","1":"_col2 (type: string), _col4 (type: string)"}
| | outputColumnNames:["_col2","_col3","_col14","_col15","_col17"]
| | Statistics:Num rows: 1464 Data size: 15552 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 10 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_46]
+ | | Reduce Output Operator [RS_37]
| | key expressions:_col4 (type: string), _col6 (type: string)
| | Map-reduce partition columns:_col4 (type: string), _col6 (type: string)
| | sort order:++
| | Statistics:Num rows: 1331 Data size: 14139 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col2 (type: string), _col3 (type: string)
- | | Merge Join Operator [MERGEJOIN_108]
+ | | Merge Join Operator [MERGEJOIN_94]
| | | condition map:[{"":"Inner Join 0 to 1"}]
| | | keys:{"0":"_col3 (type: string)","1":"_col1 (type: string)"}
| | | outputColumnNames:["_col2","_col3","_col4","_col6"]
| | | Statistics:Num rows: 1331 Data size: 14139 Basic stats: COMPLETE Column stats: NONE
| | |<-Map 14 [SIMPLE_EDGE]
- | | | Reduce Output Operator [RS_43]
+ | | | Reduce Output Operator [RS_35]
| | | key expressions:_col1 (type: string)
| | | Map-reduce partition columns:_col1 (type: string)
| | | sort order:+
@@ -415,26 +415,26 @@ Stage-0
| | | Select Operator [SEL_17]
| | | outputColumnNames:["_col1"]
| | | Statistics:Num rows: 12 Data size: 91 Basic stats: COMPLETE Column stats: NONE
- | | | Filter Operator [FIL_102]
+ | | | Filter Operator [FIL_88]
| | | predicate:((key = 'src1key') and value is not null) (type: boolean)
| | | Statistics:Num rows: 12 Data size: 91 Basic stats: COMPLETE Column stats: NONE
| | | TableScan [TS_15]
| | | alias:src1
| | | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
| | |<-Reducer 9 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_41]
+ | | Reduce Output Operator [RS_34]
| | key expressions:_col3 (type: string)
| | Map-reduce partition columns:_col3 (type: string)
| | sort order:+
| | Statistics:Num rows: 1210 Data size: 12854 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col2 (type: string), _col4 (type: string), _col6 (type: string)
- | | Merge Join Operator [MERGEJOIN_107]
+ | | Merge Join Operator [MERGEJOIN_93]
| | | condition map:[{"":"Inner Join 0 to 1"}]
| | | keys:{"0":"_col2 (type: string)","1":"_col0 (type: string)"}
| | | outputColumnNames:["_col2","_col3","_col4","_col6"]
| | | Statistics:Num rows: 1210 Data size: 12854 Basic stats: COMPLETE Column stats: NONE
| | |<-Map 13 [SIMPLE_EDGE]
- | | | Reduce Output Operator [RS_38]
+ | | | Reduce Output Operator [RS_32]
| | | key expressions:_col0 (type: string)
| | | Map-reduce partition columns:_col0 (type: string)
| | | sort order:+
@@ -442,26 +442,26 @@ Stage-0
| | | Select Operator [SEL_14]
| | | outputColumnNames:["_col0"]
| | | Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- | | | Filter Operator [FIL_101]
+ | | | Filter Operator [FIL_87]
| | | predicate:((value = 'd1value') and key is not null) (type: boolean)
| | | Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
| | | TableScan [TS_12]
| | | alias:d1
| | | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| | |<-Reducer 8 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_36]
+ | | Reduce Output Operator [RS_31]
| | key expressions:_col2 (type: string)
| | Map-reduce partition columns:_col2 (type: string)
| | sort order:+
| | Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col3 (type: string), _col4 (type: string), _col6 (type: string)
- | | Merge Join Operator [MERGEJOIN_106]
+ | | Merge Join Operator [MERGEJOIN_92]
| | | condition map:[{"":"Inner Join 0 to 1"}]
| | | keys:{"0":"_col1 (type: string)","1":"_col3 (type: string)"}
| | | outputColumnNames:["_col2","_col3","_col4","_col6"]
| | | Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
| | |<-Map 12 [SIMPLE_EDGE]
- | | | Reduce Output Operator [RS_33]
+ | | | Reduce Output Operator [RS_29]
| | | key expressions:_col3 (type: string)
| | | Map-reduce partition columns:_col3 (type: string)
| | | sort order:+
@@ -470,14 +470,14 @@ Stage-0
| | | Select Operator [SEL_11]
| | | outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
| | | Statistics:Num rows: 42 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
- | | | Filter Operator [FIL_100]
+ | | | Filter Operator [FIL_86]
| | | predicate:(((((k3 is not null and (v3 = 'ssv3')) and k2 is not null) and k1 is not null) and v1 is not null) and v2 is not null) (type: boolean)
| | | Statistics:Num rows: 42 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
| | | TableScan [TS_9]
| | | alias:ss
| | | Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
| | |<-Map 7 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_31]
+ | | Reduce Output Operator [RS_28]
| | key expressions:_col1 (type: string)
| | Map-reduce partition columns:_col1 (type: string)
| | sort order:+
@@ -485,26 +485,26 @@ Stage-0
| | Select Operator [SEL_8]
| | outputColumnNames:["_col1"]
| | Statistics:Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_99]
+ | | Filter Operator [FIL_85]
| | predicate:((key = 'srcpartkey') and value is not null) (type: boolean)
| | Statistics:Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
| | TableScan [TS_6]
| | alias:srcpart
| | Statistics:Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 16 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_48]
+ | Reduce Output Operator [RS_38]
| key expressions:_col2 (type: string), _col4 (type: string)
| Map-reduce partition columns:_col2 (type: string), _col4 (type: string)
| sort order:++
| Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col3 (type: string), _col5 (type: string)
- | Merge Join Operator [MERGEJOIN_109]
+ | Merge Join Operator [MERGEJOIN_95]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col0 (type: string)","1":"_col0 (type: string)"}
| | outputColumnNames:["_col2","_col3","_col4","_col5"]
| | Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
| |<-Map 15 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_25]
+ | | Reduce Output Operator [RS_24]
| | key expressions:_col0 (type: string)
| | Map-reduce partition columns:_col0 (type: string)
| | sort order:+
@@ -513,14 +513,14 @@ Stage-0
| | Select Operator [SEL_20]
| | outputColumnNames:["_col0","_col2","_col3","_col4","_col5"]
| | Statistics:Num rows: 42 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_103]
+ | | Filter Operator [FIL_89]
| | predicate:((((((v1 = 'srv1') and k3 is not null) and k2 is not null) and v3 is not null) and v2 is not null) and k1 is not null) (type: boolean)
| | Statistics:Num rows: 42 Data size: 1455 Basic stats: COMPLETE Column stats: NONE
| | TableScan [TS_18]
| | alias:sr
| | Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
| |<-Map 17 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_27]
+ | Reduce Output Operator [RS_25]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
@@ -528,26 +528,26 @@ Stage-0
| Select Operator [SEL_23]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_104]
+ | Filter Operator [FIL_90]
| predicate:((value) IN ('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
| Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_21]
| alias:d1
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 2 [SIMPLE_EDGE]
- Reduce Output Operator [RS_57]
+ Reduce Output Operator [RS_44]
key expressions:_col1 (type: string), _col3 (type: string)
Map-reduce partition columns:_col1 (type: string), _col3 (type: string)
sort order:++
Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
value expressions:_col2 (type: string)
- Merge Join Operator [MERGEJOIN_105]
+ Merge Join Operator [MERGEJOIN_91]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col0 (type: string)","1":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col2","_col3"]
| Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
|<-Map 1 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_52]
+ | Reduce Output Operator [RS_41]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
@@ -556,14 +556,14 @@ Stage-0
| Select Operator [SEL_2]
| outputColumnNames:["_col0","_col1","_col2","_col3"]
| Statistics:Num rows: 170 Data size: 5890 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_97]
+ | Filter Operator [FIL_83]
| predicate:((v3 is not null and v2 is not null) and k1 is not null) (type: boolean)
| Statistics:Num rows: 170 Data size: 5890 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_0]
| alias:cs
| Statistics:Num rows: 170 Data size: 5890 Basic stats: COMPLETE Column stats: NONE
|<-Map 6 [SIMPLE_EDGE]
- Reduce Output Operator [RS_54]
+ Reduce Output Operator [RS_42]
key expressions:_col0 (type: string)
Map-reduce partition columns:_col0 (type: string)
sort order:+
@@ -571,7 +571,7 @@ Stage-0
Select Operator [SEL_5]
outputColumnNames:["_col0"]
Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_98]
+ Filter Operator [FIL_84]
predicate:((value) IN ('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
TableScan [TS_3]
@@ -616,148 +616,148 @@ Stage-0
limit:-1
Stage-1
Reducer 7
- File Output Operator [FS_67]
+ File Output Operator [FS_59]
compressed:false
Statistics:Num rows: 550 Data size: 5843 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_65]
+ Group By Operator [GBY_57]
| keys:KEY._col0 (type: string), KEY._col1 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
|<-Union 6 [SIMPLE_EDGE]
|<-Reducer 15 [CONTAINS]
- | Reduce Output Operator [RS_64]
+ | Reduce Output Operator [RS_56]
| key expressions:_col0 (type: string), _col1 (type: string)
| Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| sort order:++
| Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_63]
+ | Group By Operator [GBY_55]
| keys:_col0 (type: string), _col1 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_59]
+ | Select Operator [SEL_51]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_93]
+ | Merge Join Operator [MERGEJOIN_85]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col2 (type: string)","1":"_col0 (type: string)"}
| | outputColumnNames:["_col1","_col2"]
| | Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
| |<-Map 18 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_57]
+ | | Reduce Output Operator [RS_49]
| | key expressions:_col0 (type: string)
| | Map-reduce partition columns:_col0 (type: string)
| | sort order:+
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | Select Operator [SEL_48]
+ | | Select Operator [SEL_44]
| | outputColumnNames:["_col0"]
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_89]
+ | | Filter Operator [FIL_81]
| | predicate:key is not null (type: boolean)
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_46]
+ | | TableScan [TS_42]
| | alias:y
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 14 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_55]
+ | Reduce Output Operator [RS_48]
| key expressions:_col2 (type: string)
| Map-reduce partition columns:_col2 (type: string)
| sort order:+
| Statistics:Num rows: 288 Data size: 3020 Basic stats: COMPLETE Column stats: NONE
| value expressions:_col1 (type: string)
- | Merge Join Operator [MERGEJOIN_92]
+ | Merge Join Operator [MERGEJOIN_84]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col1 (type: string)","1":"_col1 (type: string)"}
| | outputColumnNames:["_col1","_col2"]
| | Statistics:Num rows: 288 Data size: 3020 Basic stats: COMPLETE Column stats: NONE
| |<-Map 17 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_52]
+ | | Reduce Output Operator [RS_46]
| | key expressions:_col1 (type: string)
| | Map-reduce partition columns:_col1 (type: string)
| | sort order:+
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col0 (type: string)
- | | Select Operator [SEL_45]
+ | | Select Operator [SEL_41]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_88]
+ | | Filter Operator [FIL_80]
| | predicate:(key is not null and value is not null) (type: boolean)
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_43]
+ | | TableScan [TS_39]
| | alias:x
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 13 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_50]
+ | Reduce Output Operator [RS_45]
| key expressions:_col1 (type: string)
| Map-reduce partition columns:_col1 (type: string)
| sort order:+
| Statistics:Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_42]
+ | Select Operator [SEL_38]
| outputColumnNames:["_col1"]
| Statistics:Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_41]
+ | Group By Operator [GBY_37]
| | keys:KEY._col0 (type: string), KEY._col1 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
| |<-Union 12 [SIMPLE_EDGE]
| |<-Map 11 [CONTAINS]
- | | Reduce Output Operator [RS_40]
+ | | Reduce Output Operator [RS_36]
| | key expressions:_col0 (type: string), _col1 (type: string)
| | Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| | sort order:++
| | Statistics:Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
- | | Group By Operator [GBY_39]
+ | | Group By Operator [GBY_35]
| | keys:_col0 (type: string), _col1 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
- | | Select Operator [SEL_32]
+ | | Select Operator [SEL_28]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_86]
+ | | Filter Operator [FIL_78]
| | predicate:value is not null (type: boolean)
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_30]
+ | | TableScan [TS_26]
| | alias:x
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
| |<-Map 16 [CONTAINS]
- | Reduce Output Operator [RS_40]
+ | Reduce Output Operator [RS_36]
| key expressions:_col0 (type: string), _col1 (type: string)
| Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| sort order:++
| Statistics:Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_39]
+ | Group By Operator [GBY_35]
| keys:_col0 (type: string), _col1 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_35]
+ | Select Operator [SEL_31]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_87]
+ | Filter Operator [FIL_79]
| predicate:value is not null (type: boolean)
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_33]
+ | TableScan [TS_29]
| alias:y
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 5 [CONTAINS]
- Reduce Output Operator [RS_64]
+ Reduce Output Operator [RS_56]
key expressions:_col0 (type: string), _col1 (type: string)
Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
sort order:++
Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
- Group By Operator [GBY_63]
+ Group By Operator [GBY_55]
keys:_col0 (type: string), _col1 (type: string)
outputColumnNames:["_col0","_col1"]
Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
- Select Operator [SEL_29]
+ Select Operator [SEL_25]
outputColumnNames:["_col0","_col1"]
Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
- Merge Join Operator [MERGEJOIN_91]
+ Merge Join Operator [MERGEJOIN_83]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col2 (type: string)","1":"_col0 (type: string)"}
| outputColumnNames:["_col1","_col2"]
| Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
|<-Map 10 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_27]
+ | Reduce Output Operator [RS_23]
| key expressions:_col0 (type: string)
| Map-reduce partition columns:_col0 (type: string)
| sort order:+
@@ -765,26 +765,26 @@ Stage-0
| Select Operator [SEL_18]
| outputColumnNames:["_col0"]
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_85]
+ | Filter Operator [FIL_77]
| predicate:key is not null (type: boolean)
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_16]
| alias:y
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 4 [SIMPLE_EDGE]
- Reduce Output Operator [RS_25]
+ Reduce Output Operator [RS_22]
key expressions:_col2 (type: string)
Map-reduce partition columns:_col2 (type: string)
sort order:+
Statistics:Num rows: 288 Data size: 3020 Basic stats: COMPLETE Column stats: NONE
value expressions:_col1 (type: string)
- Merge Join Operator [MERGEJOIN_90]
+ Merge Join Operator [MERGEJOIN_82]
| condition map:[{"":"Inner Join 0 to 1"}]
| keys:{"0":"_col1 (type: string)","1":"_col1 (type: string)"}
| outputColumnNames:["_col1","_col2"]
| Statistics:Num rows: 288 Data size: 3020 Basic stats: COMPLETE Column stats: NONE
|<-Map 9 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_22]
+ | Reduce Output Operator [RS_20]
| key expressions:_col1 (type: string)
| Map-reduce partition columns:_col1 (type: string)
| sort order:+
@@ -793,14 +793,14 @@ Stage-0
| Select Operator [SEL_15]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_84]
+ | Filter Operator [FIL_76]
| predicate:(key is not null and value is not null) (type: boolean)
| Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_13]
| alias:x
| Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 3 [SIMPLE_EDGE]
- Reduce Output Operator [RS_20]
+ Reduce Output Operator [RS_19]
key expressions:_col1 (type: string)
Map-reduce partition columns:_col1 (type: string)
sort order:+
@@ -826,7 +826,7 @@ Stage-0
| Select Operator [SEL_2]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_82]
+ | Filter Operator [FIL_74]
| predicate:value is not null (type: boolean)
| Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
| TableScan [TS_0]
@@ -845,7 +845,7 @@ Stage-0
Select Operator [SEL_5]
outputColumnNames:["_col0","_col1"]
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- Filter Operator [FIL_83]
+ Filter Operator [FIL_75]
predicate:value is not null (type: boolean)
Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
TableScan [TS_3]
@@ -910,378 +910,378 @@ Stage-0
limit:-1
Stage-1
Reducer 9
- File Output Operator [FS_134]
+ File Output Operator [FS_122]
compressed:false
Statistics:Num rows: 550 Data size: 5843 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_132]
+ Group By Operator [GBY_120]
| keys:KEY._col0 (type: string), KEY._col1 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
|<-Union 8 [SIMPLE_EDGE]
|<-Reducer 32 [CONTAINS]
- | Reduce Output Operator [RS_131]
+ | Reduce Output Operator [RS_119]
| key expressions:_col0 (type: string), _col1 (type: string)
| Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| sort order:++
| Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_130]
+ | Group By Operator [GBY_118]
| keys:_col0 (type: string), _col1 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_126]
+ | Select Operator [SEL_114]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_182]
+ | Merge Join Operator [MERGEJOIN_170]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col2 (type: string)","1":"_col0 (type: string)"}
| | outputColumnNames:["_col2","_col5"]
| | Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
| |<-Map 37 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_124]
+ | | Reduce Output Operator [RS_112]
| | key expressions:_col0 (type: string)
| | Map-reduce partition columns:_col0 (type: string)
| | sort order:+
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col1 (type: string)
- | | Select Operator [SEL_115]
+ | | Select Operator [SEL_107]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_176]
+ | | Filter Operator [FIL_164]
| | predicate:key is not null (type: boolean)
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_113]
+ | | TableScan [TS_105]
| | alias:y
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 31 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_122]
+ | Reduce Output Operator [RS_111]
| key expressions:_col2 (type: string)
| Map-reduce partition columns:_col2 (type: string)
| sort order:+
| Statistics:Num rows: 484 Data size: 5131 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_181]
+ | Merge Join Operator [MERGEJOIN_169]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col1 (type: string)","1":"_col1 (type: string)"}
| | outputColumnNames:["_col2"]
| | Statistics:Num rows: 484 Data size: 5131 Basic stats: COMPLETE Column stats: NONE
| |<-Map 36 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_119]
+ | | Reduce Output Operator [RS_109]
| | key expressions:_col1 (type: string)
| | Map-reduce partition columns:_col1 (type: string)
| | sort order:+
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col0 (type: string)
- | | Select Operator [SEL_112]
+ | | Select Operator [SEL_104]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_175]
+ | | Filter Operator [FIL_163]
| | predicate:(key is not null and value is not null) (type: boolean)
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_110]
+ | | TableScan [TS_102]
| | alias:x
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 30 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_117]
+ | Reduce Output Operator [RS_108]
| key expressions:_col1 (type: string)
| Map-reduce partition columns:_col1 (type: string)
| sort order:+
| Statistics:Num rows: 440 Data size: 4665 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_109]
+ | Select Operator [SEL_101]
| outputColumnNames:["_col1"]
| Statistics:Num rows: 440 Data size: 4665 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_108]
+ | Group By Operator [GBY_100]
| | keys:KEY._col0 (type: string), KEY._col1 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 440 Data size: 4665 Basic stats: COMPLETE Column stats: NONE
| |<-Union 29 [SIMPLE_EDGE]
| |<-Map 35 [CONTAINS]
- | | Reduce Output Operator [RS_107]
+ | | Reduce Output Operator [RS_99]
| | key expressions:_col0 (type: string), _col1 (type: string)
| | Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| | sort order:++
| | Statistics:Num rows: 881 Data size: 9341 Basic stats: COMPLETE Column stats: NONE
- | | Group By Operator [GBY_106]
+ | | Group By Operator [GBY_98]
| | keys:_col0 (type: string), _col1 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 881 Data size: 9341 Basic stats: COMPLETE Column stats: NONE
- | | Select Operator [SEL_102]
+ | | Select Operator [SEL_94]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_174]
+ | | Filter Operator [FIL_162]
| | predicate:value is not null (type: boolean)
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_100]
+ | | TableScan [TS_92]
| | alias:y
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 28 [CONTAINS]
- | Reduce Output Operator [RS_107]
+ | Reduce Output Operator [RS_99]
| key expressions:_col0 (type: string), _col1 (type: string)
| Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| sort order:++
| Statistics:Num rows: 881 Data size: 9341 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_106]
+ | Group By Operator [GBY_98]
| keys:_col0 (type: string), _col1 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 881 Data size: 9341 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_98]
+ | Group By Operator [GBY_90]
| | keys:KEY._col0 (type: string), KEY._col1 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 381 Data size: 4029 Basic stats: COMPLETE Column stats: NONE
| |<-Union 27 [SIMPLE_EDGE]
| |<-Map 34 [CONTAINS]
- | | Reduce Output Operator [RS_97]
+ | | Reduce Output Operator [RS_89]
| | key expressions:_col0 (type: string), _col1 (type: string)
| | Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| | sort order:++
| | Statistics:Num rows: 762 Data size: 8058 Basic stats: COMPLETE Column stats: NONE
- | | Group By Operator [GBY_96]
+ | | Group By Operator [GBY_88]
| | keys:_col0 (type: string), _col1 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 762 Data size: 8058 Basic stats: COMPLETE Column stats: NONE
- | | Select Operator [SEL_92]
+ | | Select Operator [SEL_84]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_173]
+ | | Filter Operator [FIL_161]
| | predicate:value is not null (type: boolean)
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_90]
+ | | TableScan [TS_82]
| | alias:y
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 26 [CONTAINS]
- | Reduce Output Operator [RS_97]
+ | Reduce Output Operator [RS_89]
| key expressions:_col0 (type: string), _col1 (type: string)
| Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| sort order:++
| Statistics:Num rows: 762 Data size: 8058 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_96]
+ | Group By Operator [GBY_88]
| keys:_col0 (type: string), _col1 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 762 Data size: 8058 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_88]
+ | Group By Operator [GBY_80]
| | keys:KEY._col0 (type: string), KEY._col1 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
| |<-Union 25 [SIMPLE_EDGE]
| |<-Map 24 [CONTAINS]
- | | Reduce Output Operator [RS_87]
+ | | Reduce Output Operator [RS_79]
| | key expressions:_col0 (type: string), _col1 (type: string)
| | Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| | sort order:++
| | Statistics:Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
- | | Group By Operator [GBY_86]
+ | | Group By Operator [GBY_78]
| | keys:_col0 (type: string), _col1 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
- | | Select Operator [SEL_79]
+ | | Select Operator [SEL_71]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_171]
+ | | Filter Operator [FIL_159]
| | predicate:value is not null (type: boolean)
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_77]
+ | | TableScan [TS_69]
| | alias:x
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
| |<-Map 33 [CONTAINS]
- | Reduce Output Operator [RS_87]
+ | Reduce Output Operator [RS_79]
| key expressions:_col0 (type: string), _col1 (type: string)
| Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| sort order:++
| Statistics:Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_86]
+ | Group By Operator [GBY_78]
| keys:_col0 (type: string), _col1 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_82]
+ | Select Operator [SEL_74]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | Filter Operator [FIL_172]
+ | Filter Operator [FIL_160]
| predicate:value is not null (type: boolean)
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | TableScan [TS_80]
+ | TableScan [TS_72]
| alias:y
| Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
|<-Reducer 7 [CONTAINS]
- Reduce Output Operator [RS_131]
+ Reduce Output Operator [RS_119]
key expressions:_col0 (type: string), _col1 (type: string)
Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
sort order:++
Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
- Group By Operator [GBY_130]
+ Group By Operator [GBY_118]
keys:_col0 (type: string), _col1 (type: string)
outputColumnNames:["_col0","_col1"]
Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
- Group By Operator [GBY_75]
+ Group By Operator [GBY_67]
| keys:KEY._col0 (type: string), KEY._col1 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
|<-Union 6 [SIMPLE_EDGE]
|<-Reducer 19 [CONTAINS]
- | Reduce Output Operator [RS_74]
+ | Reduce Output Operator [RS_66]
| key expressions:_col0 (type: string), _col1 (type: string)
| Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| sort order:++
| Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_73]
+ | Group By Operator [GBY_65]
| keys:_col0 (type: string), _col1 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 1100 Data size: 11686 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_69]
+ | Select Operator [SEL_61]
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_180]
+ | Merge Join Operator [MERGEJOIN_168]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col2 (type: string)","1":"_col0 (type: string)"}
| | outputColumnNames:["_col2","_col5"]
| | Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
| |<-Map 23 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_67]
+ | | Reduce Output Operator [RS_59]
| | key expressions:_col0 (type: string)
| | Map-reduce partition columns:_col0 (type: string)
| | sort order:+
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col1 (type: string)
- | | Select Operator [SEL_58]
+ | | Select Operator [SEL_54]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_170]
+ | | Filter Operator [FIL_158]
| | predicate:key is not null (type: boolean)
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_56]
+ | | TableScan [TS_52]
| | alias:y
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 18 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_65]
+ | Reduce Output Operator [RS_58]
| key expressions:_col2 (type: string)
| Map-reduce partition columns:_col2 (type: string)
| sort order:+
| Statistics:Num rows: 419 Data size: 4431 Basic stats: COMPLETE Column stats: NONE
- | Merge Join Operator [MERGEJOIN_179]
+ | Merge Join Operator [MERGEJOIN_167]
| | condition map:[{"":"Inner Join 0 to 1"}]
| | keys:{"0":"_col1 (type: string)","1":"_col1 (type: string)"}
| | outputColumnNames:["_col2"]
| | Statistics:Num rows: 419 Data size: 4431 Basic stats: COMPLETE Column stats: NONE
| |<-Map 22 [SIMPLE_EDGE]
- | | Reduce Output Operator [RS_62]
+ | | Reduce Output Operator [RS_56]
| | key expressions:_col1 (type: string)
| | Map-reduce partition columns:_col1 (type: string)
| | sort order:+
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
| | value expressions:_col0 (type: string)
- | | Select Operator [SEL_55]
+ | | Select Operator [SEL_51]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_169]
+ | | Filter Operator [FIL_157]
| | predicate:(key is not null and value is not null) (type: boolean)
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_53]
+ | | TableScan [TS_49]
| | alias:x
| | Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 17 [SIMPLE_EDGE]
- | Reduce Output Operator [RS_60]
+ | Reduce Output Operator [RS_55]
| key expressions:_col1 (type: string)
| Map-reduce partition columns:_col1 (type: string)
| sort order:+
| Statistics:Num rows: 381 Data size: 4029 Basic stats: COMPLETE Column stats: NONE
- | Select Operator [SEL_52]
+ | Select Operator [SEL_48]
| outputColumnNames:["_col1"]
| Statistics:Num rows: 381 Data size: 4029 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_51]
+ | Group By Operator [GBY_47]
| | keys:KEY._col0 (type: string), KEY._col1 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 381 Data size: 4029 Basic stats: COMPLETE Column stats: NONE
| |<-Union 16 [SIMPLE_EDGE]
| |<-Map 21 [CONTAINS]
- | | Reduce Output Operator [RS_50]
+ | | Reduce Output Operator [RS_46]
| | key expressions:_col0 (type: string), _col1 (type: string)
| | Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| | sort order:++
| | Statistics:Num rows: 762 Data size: 8058 Basic stats: COMPLETE Column stats: NONE
- | | Group By Operator [GBY_49]
+ | | Group By Operator [GBY_45]
| | keys:_col0 (type: string), _col1 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 762 Data size: 8058 Basic stats: COMPLETE Column stats: NONE
- | | Select Operator [SEL_45]
+ | | Select Operator [SEL_41]
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | Filter Operator [FIL_168]
+ | | Filter Operator [FIL_156]
| | predicate:value is not null (type: boolean)
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
- | | TableScan [TS_43]
+ | | TableScan [TS_39]
| | alias:y
| | Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
| |<-Reducer 15 [CONTAINS]
- | Reduce Output Operator [RS_50]
+ | Reduce Output Operator [RS_46]
| key expressions:_col0 (type: string), _col1 (type: string)
| Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| sort order:++
| Statistics:Num rows: 762 Data size: 8058 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_49]
+ | Group By Operator [GBY_45]
| keys:_col0 (type: string), _col1 (type: string)
| outputColumnNames:["_col0","_col1"]
| Statistics:Num rows: 762 Data size: 8058 Basic stats: COMPLETE Column stats: NONE
- | Group By Operator [GBY_41]
+ | Group By Operator [GBY_37]
| | keys:KEY._col0 (type: string), KEY._col1 (type: string)
| | outputColumnNames:["_col0","_col1"]
| | Statistics:Num rows: 262 Data size: 2746 Basic stats: COMPLETE Column stats: NONE
| |<-Union 14 [SIMPLE_EDGE]
| |<-Map 13 [CONTAINS]
- | | Reduce Output Operator [RS_40]
+ | | Reduce Output Operator [RS_36]
| | key expressions:_col0 (type: string), _col1 (type: string)
| | Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
| | sort order:++
| | Statistics:Num rows: 525 Data size: 5503 Basic stats: COMPLETE Column stats: NONE
- | | Group By Operator [GBY_39]
+ |
<TRUNCATED>