Return-Path: X-Original-To: apmail-hive-commits-archive@www.apache.org Delivered-To: apmail-hive-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 04303188F7 for ; Mon, 21 Dec 2015 01:06:43 +0000 (UTC) Received: (qmail 91044 invoked by uid 500); 21 Dec 2015 01:06:42 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 90881 invoked by uid 500); 21 Dec 2015 01:06:42 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 90825 invoked by uid 99); 21 Dec 2015 01:06:42 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 21 Dec 2015 01:06:42 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 63507DFD7A; Mon, 21 Dec 2015 01:06:42 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: jcamacho@apache.org To: commits@hive.apache.org Date: Mon, 21 Dec 2015 01:06:44 -0000 Message-Id: <4d92f8c1e76e4e5a877118f2f8fcdcb6@git.apache.org> In-Reply-To: <099e918df5764cb6ace80ed6013af428@git.apache.org> References: <099e918df5764cb6ace80ed6013af428@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [03/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/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] + |