hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jcama...@apache.org
Subject [4/5] hive git commit: HIVE-11954: Extend logic to choose side table in MapJoin Conversion algorithm (Jesus Camacho Rodriguez, reviewed by Laljo John Pullokkaran)
Date Fri, 23 Oct 2015 15:31:01 GMT
http://git-wip-us.apache.org/repos/asf/hive/blob/8e62edac/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/explainuser_2.q.out b/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
index 57fcc3c..7b361ac 100644
--- a/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/explainuser_2.q.out
@@ -1745,19 +1745,17 @@ Plan optimized by CBO.
 Vertex dependency in root stage
 Map 1 <- Union 2 (CONTAINS)
 Map 12 <- Union 10 (CONTAINS)
-Map 14 <- Reducer 11 (BROADCAST_EDGE), Union 7 (CONTAINS)
-Map 4 <- Union 2 (CONTAINS)
-Map 6 <- Reducer 3 (BROADCAST_EDGE), Union 7 (CONTAINS)
+Map 6 <- Union 2 (CONTAINS)
 Map 9 <- Union 10 (CONTAINS)
-Reducer 11 <- Map 13 (BROADCAST_EDGE), Union 10 (SIMPLE_EDGE)
-Reducer 3 <- Map 5 (BROADCAST_EDGE), Union 2 (SIMPLE_EDGE)
-Reducer 8 <- Union 7 (SIMPLE_EDGE)
+Reducer 11 <- Map 13 (BROADCAST_EDGE), Map 14 (BROADCAST_EDGE), Union 10 (SIMPLE_EDGE), Union 4 (CONTAINS)
+Reducer 3 <- Map 7 (BROADCAST_EDGE), Map 8 (BROADCAST_EDGE), Union 2 (SIMPLE_EDGE), Union 4 (CONTAINS)
+Reducer 5 <- Union 4 (SIMPLE_EDGE)
 
 Stage-0
    Fetch Operator
       limit:-1
       Stage-1
-         Reducer 8
+         Reducer 5
          File Output Operator [FS_59]
             compressed:false
             Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
@@ -1766,8 +1764,8 @@ Stage-0
             |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
             |  outputColumnNames:["_col0","_col1"]
             |  Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
-            |<-Union 7 [SIMPLE_EDGE]
-               |<-Map 14 [CONTAINS]
+            |<-Union 4 [SIMPLE_EDGE]
+               |<-Reducer 11 [CONTAINS]
                |  Reduce Output Operator [RS_56]
                |     key expressions:_col0 (type: string), _col1 (type: string)
                |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
@@ -1785,90 +1783,89 @@ Stage-0
                |           |  keys:{"Reducer 11":"_col2 (type: string)","Map 14":"_col0 (type: string)"}
                |           |  outputColumnNames:["_col1","_col2"]
                |           |  Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
-               |           |<-Reducer 11 [BROADCAST_EDGE]
-               |           |  Reduce Output Operator [RS_47]
-               |           |     key expressions:_col2 (type: string)
-               |           |     Map-reduce partition columns:_col2 (type: string)
+               |           |<-Map 14 [BROADCAST_EDGE]
+               |           |  Reduce Output Operator [RS_49]
+               |           |     key expressions:_col0 (type: string)
+               |           |     Map-reduce partition columns:_col0 (type: string)
                |           |     sort order:+
-               |           |     Statistics:Num rows: 144 Data size: 1509 Basic stats: COMPLETE Column stats: NONE
-               |           |     value expressions:_col1 (type: string)
-               |           |     Map Join Operator [MAPJOIN_84]
-               |           |     |  condition map:[{"":"Inner Join 0 to 1"}]
-               |           |     |  keys:{"Reducer 11":"_col1 (type: string)","Map 13":"_col1 (type: string)"}
-               |           |     |  outputColumnNames:["_col1","_col2"]
-               |           |     |  Statistics:Num rows: 144 Data size: 1509 Basic stats: COMPLETE Column stats: NONE
-               |           |     |<-Map 13 [BROADCAST_EDGE]
-               |           |     |  Reduce Output Operator [RS_44]
-               |           |     |     key expressions:_col1 (type: string)
-               |           |     |     Map-reduce partition columns:_col1 (type: string)
-               |           |     |     sort order:+
-               |           |     |     Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-               |           |     |     value expressions:_col0 (type: string)
-               |           |     |     Select Operator [SEL_38]
-               |           |     |        outputColumnNames:["_col0","_col1"]
-               |           |     |        Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-               |           |     |        Filter Operator [FIL_80]
-               |           |     |           predicate:(value is not null and key is not null) (type: boolean)
-               |           |     |           Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-               |           |     |           TableScan [TS_37]
-               |           |     |              alias:x
-               |           |     |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
-               |           |     |<-Select Operator [SEL_36]
-               |           |           outputColumnNames:["_col1"]
-               |           |           Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
-               |           |           Group By Operator [GBY_35]
-               |           |           |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
-               |           |           |  outputColumnNames:["_col0","_col1"]
-               |           |           |  Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
-               |           |           |<-Union 10 [SIMPLE_EDGE]
-               |           |              |<-Map 12 [CONTAINS]
-               |           |              |  Reduce Output Operator [RS_34]
-               |           |              |     key expressions:_col0 (type: string), _col1 (type: string)
-               |           |              |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-               |           |              |     sort order:++
-               |           |              |     Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-               |           |              |     Group By Operator [GBY_33]
-               |           |              |        keys:_col0 (type: string), _col1 (type: string)
-               |           |              |        outputColumnNames:["_col0","_col1"]
-               |           |              |        Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-               |           |              |        Select Operator [SEL_29]
-               |           |              |           outputColumnNames:["_col0","_col1"]
-               |           |              |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |           |              |           Filter Operator [FIL_79]
-               |           |              |              predicate:value is not null (type: boolean)
-               |           |              |              Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |           |              |              TableScan [TS_28]
-               |           |              |                 alias:y
-               |           |              |                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-               |           |              |<-Map 9 [CONTAINS]
-               |           |                 Reduce Output Operator [RS_34]
-               |           |                    key expressions:_col0 (type: string), _col1 (type: string)
-               |           |                    Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-               |           |                    sort order:++
-               |           |                    Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-               |           |                    Group By Operator [GBY_33]
-               |           |                       keys:_col0 (type: string), _col1 (type: string)
-               |           |                       outputColumnNames:["_col0","_col1"]
-               |           |                       Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-               |           |                       Select Operator [SEL_27]
-               |           |                          outputColumnNames:["_col0","_col1"]
-               |           |                          Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
-               |           |                          Filter Operator [FIL_78]
-               |           |                             predicate:value is not null (type: boolean)
-               |           |                             Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
-               |           |                             TableScan [TS_26]
-               |           |                                alias:x
-               |           |                                Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
-               |           |<-Select Operator [SEL_40]
-               |                 outputColumnNames:["_col0"]
-               |                 Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |                 Filter Operator [FIL_81]
-               |                    predicate:key is not null (type: boolean)
-               |                    Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |                    TableScan [TS_39]
-               |                       alias:y
-               |                       Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-               |<-Map 6 [CONTAINS]
+               |           |     Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |           |     Select Operator [SEL_40]
+               |           |        outputColumnNames:["_col0"]
+               |           |        Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |           |        Filter Operator [FIL_81]
+               |           |           predicate:key is not null (type: boolean)
+               |           |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |           |           TableScan [TS_39]
+               |           |              alias:y
+               |           |              Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+               |           |<-Map Join Operator [MAPJOIN_84]
+               |              |  condition map:[{"":"Inner Join 0 to 1"}]
+               |              |  keys:{"Reducer 11":"_col1 (type: string)","Map 13":"_col1 (type: string)"}
+               |              |  outputColumnNames:["_col1","_col2"]
+               |              |  Statistics:Num rows: 144 Data size: 1509 Basic stats: COMPLETE Column stats: NONE
+               |              |<-Map 13 [BROADCAST_EDGE]
+               |              |  Reduce Output Operator [RS_44]
+               |              |     key expressions:_col1 (type: string)
+               |              |     Map-reduce partition columns:_col1 (type: string)
+               |              |     sort order:+
+               |              |     Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+               |              |     value expressions:_col0 (type: string)
+               |              |     Select Operator [SEL_38]
+               |              |        outputColumnNames:["_col0","_col1"]
+               |              |        Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+               |              |        Filter Operator [FIL_80]
+               |              |           predicate:(value is not null and key is not null) (type: boolean)
+               |              |           Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+               |              |           TableScan [TS_37]
+               |              |              alias:x
+               |              |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+               |              |<-Select Operator [SEL_36]
+               |                    outputColumnNames:["_col1"]
+               |                    Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
+               |                    Group By Operator [GBY_35]
+               |                    |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
+               |                    |  outputColumnNames:["_col0","_col1"]
+               |                    |  Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
+               |                    |<-Union 10 [SIMPLE_EDGE]
+               |                       |<-Map 12 [CONTAINS]
+               |                       |  Reduce Output Operator [RS_34]
+               |                       |     key expressions:_col0 (type: string), _col1 (type: string)
+               |                       |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+               |                       |     sort order:++
+               |                       |     Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+               |                       |     Group By Operator [GBY_33]
+               |                       |        keys:_col0 (type: string), _col1 (type: string)
+               |                       |        outputColumnNames:["_col0","_col1"]
+               |                       |        Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+               |                       |        Select Operator [SEL_29]
+               |                       |           outputColumnNames:["_col0","_col1"]
+               |                       |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |                       |           Filter Operator [FIL_79]
+               |                       |              predicate:value is not null (type: boolean)
+               |                       |              Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |                       |              TableScan [TS_28]
+               |                       |                 alias:y
+               |                       |                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+               |                       |<-Map 9 [CONTAINS]
+               |                          Reduce Output Operator [RS_34]
+               |                             key expressions:_col0 (type: string), _col1 (type: string)
+               |                             Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+               |                             sort order:++
+               |                             Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+               |                             Group By Operator [GBY_33]
+               |                                keys:_col0 (type: string), _col1 (type: string)
+               |                                outputColumnNames:["_col0","_col1"]
+               |                                Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+               |                                Select Operator [SEL_27]
+               |                                   outputColumnNames:["_col0","_col1"]
+               |                                   Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+               |                                   Filter Operator [FIL_78]
+               |                                      predicate:value is not null (type: boolean)
+               |                                      Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+               |                                      TableScan [TS_26]
+               |                                         alias:x
+               |                                         Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+               |<-Reducer 3 [CONTAINS]
                   Reduce Output Operator [RS_56]
                      key expressions:_col0 (type: string), _col1 (type: string)
                      Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
@@ -1883,92 +1880,91 @@ Stage-0
                            Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
                            Map Join Operator [MAPJOIN_83]
                            |  condition map:[{"":"Inner Join 0 to 1"}]
-                           |  keys:{"Reducer 3":"_col2 (type: string)","Map 6":"_col0 (type: string)"}
+                           |  keys:{"Reducer 3":"_col2 (type: string)","Map 8":"_col0 (type: string)"}
                            |  outputColumnNames:["_col1","_col2"]
                            |  Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
-                           |<-Reducer 3 [BROADCAST_EDGE]
-                           |  Reduce Output Operator [RS_21]
-                           |     key expressions:_col2 (type: string)
-                           |     Map-reduce partition columns:_col2 (type: string)
+                           |<-Map 8 [BROADCAST_EDGE]
+                           |  Reduce Output Operator [RS_23]
+                           |     key expressions:_col0 (type: string)
+                           |     Map-reduce partition columns:_col0 (type: string)
                            |     sort order:+
-                           |     Statistics:Num rows: 144 Data size: 1509 Basic stats: COMPLETE Column stats: NONE
-                           |     value expressions:_col1 (type: string)
-                           |     Map Join Operator [MAPJOIN_82]
-                           |     |  condition map:[{"":"Inner Join 0 to 1"}]
-                           |     |  keys:{"Reducer 3":"_col1 (type: string)","Map 5":"_col1 (type: string)"}
-                           |     |  outputColumnNames:["_col1","_col2"]
-                           |     |  Statistics:Num rows: 144 Data size: 1509 Basic stats: COMPLETE Column stats: NONE
-                           |     |<-Map 5 [BROADCAST_EDGE]
-                           |     |  Reduce Output Operator [RS_18]
-                           |     |     key expressions:_col1 (type: string)
-                           |     |     Map-reduce partition columns:_col1 (type: string)
-                           |     |     sort order:+
-                           |     |     Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-                           |     |     value expressions:_col0 (type: string)
-                           |     |     Select Operator [SEL_12]
-                           |     |        outputColumnNames:["_col0","_col1"]
-                           |     |        Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-                           |     |        Filter Operator [FIL_76]
-                           |     |           predicate:(value is not null and key is not null) (type: boolean)
-                           |     |           Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-                           |     |           TableScan [TS_11]
-                           |     |              alias:x
-                           |     |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
-                           |     |<-Select Operator [SEL_10]
-                           |           outputColumnNames:["_col1"]
-                           |           Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
-                           |           Group By Operator [GBY_9]
-                           |           |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
-                           |           |  outputColumnNames:["_col0","_col1"]
-                           |           |  Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
-                           |           |<-Union 2 [SIMPLE_EDGE]
-                           |              |<-Map 1 [CONTAINS]
-                           |              |  Reduce Output Operator [RS_8]
-                           |              |     key expressions:_col0 (type: string), _col1 (type: string)
-                           |              |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-                           |              |     sort order:++
-                           |              |     Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-                           |              |     Group By Operator [GBY_7]
-                           |              |        keys:_col0 (type: string), _col1 (type: string)
-                           |              |        outputColumnNames:["_col0","_col1"]
-                           |              |        Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-                           |              |        Select Operator [SEL_1]
-                           |              |           outputColumnNames:["_col0","_col1"]
-                           |              |           Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
-                           |              |           Filter Operator [FIL_74]
-                           |              |              predicate:value is not null (type: boolean)
-                           |              |              Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
-                           |              |              TableScan [TS_0]
-                           |              |                 alias:x
-                           |              |                 Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
-                           |              |<-Map 4 [CONTAINS]
-                           |                 Reduce Output Operator [RS_8]
-                           |                    key expressions:_col0 (type: string), _col1 (type: string)
-                           |                    Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-                           |                    sort order:++
-                           |                    Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-                           |                    Group By Operator [GBY_7]
-                           |                       keys:_col0 (type: string), _col1 (type: string)
-                           |                       outputColumnNames:["_col0","_col1"]
-                           |                       Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-                           |                       Select Operator [SEL_3]
-                           |                          outputColumnNames:["_col0","_col1"]
-                           |                          Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                           |                          Filter Operator [FIL_75]
-                           |                             predicate:value is not null (type: boolean)
-                           |                             Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                           |                             TableScan [TS_2]
-                           |                                alias:y
-                           |                                Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                           |<-Select Operator [SEL_14]
-                                 outputColumnNames:["_col0"]
-                                 Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                                 Filter Operator [FIL_77]
-                                    predicate:key is not null (type: boolean)
-                                    Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                                    TableScan [TS_13]
-                                       alias:y
-                                       Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                           |     Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                           |     Select Operator [SEL_14]
+                           |        outputColumnNames:["_col0"]
+                           |        Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                           |        Filter Operator [FIL_77]
+                           |           predicate:key is not null (type: boolean)
+                           |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                           |           TableScan [TS_13]
+                           |              alias:y
+                           |              Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                           |<-Map Join Operator [MAPJOIN_82]
+                              |  condition map:[{"":"Inner Join 0 to 1"}]
+                              |  keys:{"Reducer 3":"_col1 (type: string)","Map 7":"_col1 (type: string)"}
+                              |  outputColumnNames:["_col1","_col2"]
+                              |  Statistics:Num rows: 144 Data size: 1509 Basic stats: COMPLETE Column stats: NONE
+                              |<-Map 7 [BROADCAST_EDGE]
+                              |  Reduce Output Operator [RS_18]
+                              |     key expressions:_col1 (type: string)
+                              |     Map-reduce partition columns:_col1 (type: string)
+                              |     sort order:+
+                              |     Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+                              |     value expressions:_col0 (type: string)
+                              |     Select Operator [SEL_12]
+                              |        outputColumnNames:["_col0","_col1"]
+                              |        Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+                              |        Filter Operator [FIL_76]
+                              |           predicate:(value is not null and key is not null) (type: boolean)
+                              |           Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+                              |           TableScan [TS_11]
+                              |              alias:x
+                              |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+                              |<-Select Operator [SEL_10]
+                                    outputColumnNames:["_col1"]
+                                    Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
+                                    Group By Operator [GBY_9]
+                                    |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
+                                    |  outputColumnNames:["_col0","_col1"]
+                                    |  Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
+                                    |<-Union 2 [SIMPLE_EDGE]
+                                       |<-Map 1 [CONTAINS]
+                                       |  Reduce Output Operator [RS_8]
+                                       |     key expressions:_col0 (type: string), _col1 (type: string)
+                                       |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+                                       |     sort order:++
+                                       |     Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+                                       |     Group By Operator [GBY_7]
+                                       |        keys:_col0 (type: string), _col1 (type: string)
+                                       |        outputColumnNames:["_col0","_col1"]
+                                       |        Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+                                       |        Select Operator [SEL_1]
+                                       |           outputColumnNames:["_col0","_col1"]
+                                       |           Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+                                       |           Filter Operator [FIL_74]
+                                       |              predicate:value is not null (type: boolean)
+                                       |              Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+                                       |              TableScan [TS_0]
+                                       |                 alias:x
+                                       |                 Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+                                       |<-Map 6 [CONTAINS]
+                                          Reduce Output Operator [RS_8]
+                                             key expressions:_col0 (type: string), _col1 (type: string)
+                                             Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+                                             sort order:++
+                                             Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+                                             Group By Operator [GBY_7]
+                                                keys:_col0 (type: string), _col1 (type: string)
+                                                outputColumnNames:["_col0","_col1"]
+                                                Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+                                                Select Operator [SEL_3]
+                                                   outputColumnNames:["_col0","_col1"]
+                                                   Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                                                   Filter Operator [FIL_75]
+                                                      predicate:value is not null (type: boolean)
+                                                      Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                                                      TableScan [TS_2]
+                                                         alias:y
+                                                         Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
 
 PREHOOK: query: explain
 SELECT x.key, y.value
@@ -2003,28 +1999,25 @@ Map 1 <- Union 2 (CONTAINS)
 Map 11 <- Union 12 (CONTAINS)
 Map 16 <- Union 12 (CONTAINS)
 Map 17 <- Union 14 (CONTAINS)
-Map 19 <- Reducer 15 (BROADCAST_EDGE), Union 7 (CONTAINS)
 Map 20 <- Union 21 (CONTAINS)
 Map 27 <- Union 21 (CONTAINS)
 Map 28 <- Union 23 (CONTAINS)
 Map 29 <- Union 25 (CONTAINS)
-Map 31 <- Reducer 26 (BROADCAST_EDGE), Union 9 (CONTAINS)
-Map 4 <- Union 2 (CONTAINS)
-Map 6 <- Reducer 3 (BROADCAST_EDGE), Union 7 (CONTAINS)
-Reducer 10 <- Union 9 (SIMPLE_EDGE)
+Map 8 <- Union 2 (CONTAINS)
 Reducer 13 <- Union 12 (SIMPLE_EDGE), Union 14 (CONTAINS)
-Reducer 15 <- Map 18 (BROADCAST_EDGE), Union 14 (SIMPLE_EDGE)
+Reducer 15 <- Map 18 (BROADCAST_EDGE), Map 19 (BROADCAST_EDGE), Union 14 (SIMPLE_EDGE), Union 4 (CONTAINS)
 Reducer 22 <- Union 21 (SIMPLE_EDGE), Union 23 (CONTAINS)
 Reducer 24 <- Union 23 (SIMPLE_EDGE), Union 25 (CONTAINS)
-Reducer 26 <- Map 30 (BROADCAST_EDGE), Union 25 (SIMPLE_EDGE)
-Reducer 3 <- Map 5 (BROADCAST_EDGE), Union 2 (SIMPLE_EDGE)
-Reducer 8 <- Union 7 (SIMPLE_EDGE), Union 9 (CONTAINS)
+Reducer 26 <- Map 30 (BROADCAST_EDGE), Map 31 (BROADCAST_EDGE), Union 25 (SIMPLE_EDGE), Union 6 (CONTAINS)
+Reducer 3 <- Map 10 (BROADCAST_EDGE), Map 9 (BROADCAST_EDGE), Union 2 (SIMPLE_EDGE), Union 4 (CONTAINS)
+Reducer 5 <- Union 4 (SIMPLE_EDGE), Union 6 (CONTAINS)
+Reducer 7 <- Union 6 (SIMPLE_EDGE)
 
 Stage-0
    Fetch Operator
       limit:-1
       Stage-1
-         Reducer 10
+         Reducer 7
          File Output Operator [FS_119]
             compressed:false
             Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
@@ -2033,8 +2026,8 @@ Stage-0
             |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
             |  outputColumnNames:["_col0","_col1"]
             |  Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
-            |<-Union 9 [SIMPLE_EDGE]
-               |<-Map 31 [CONTAINS]
+            |<-Union 6 [SIMPLE_EDGE]
+               |<-Reducer 26 [CONTAINS]
                |  Reduce Output Operator [RS_116]
                |     key expressions:_col0 (type: string), _col1 (type: string)
                |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
@@ -2052,157 +2045,158 @@ Stage-0
                |           |  keys:{"Reducer 26":"_col2 (type: string)","Map 31":"_col0 (type: string)"}
                |           |  outputColumnNames:["_col2","_col5"]
                |           |  Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
-               |           |<-Reducer 26 [BROADCAST_EDGE]
-               |           |  Reduce Output Operator [RS_107]
-               |           |     key expressions:_col2 (type: string)
-               |           |     Map-reduce partition columns:_col2 (type: string)
+               |           |<-Map 31 [BROADCAST_EDGE]
+               |           |  Reduce Output Operator [RS_109]
+               |           |     key expressions:_col0 (type: string)
+               |           |     Map-reduce partition columns:_col0 (type: string)
                |           |     sort order:+
-               |           |     Statistics:Num rows: 242 Data size: 2565 Basic stats: COMPLETE Column stats: NONE
-               |           |     Map Join Operator [MAPJOIN_166]
-               |           |     |  condition map:[{"":"Inner Join 0 to 1"}]
-               |           |     |  keys:{"Reducer 26":"_col1 (type: string)","Map 30":"_col1 (type: string)"}
-               |           |     |  outputColumnNames:["_col2"]
-               |           |     |  Statistics:Num rows: 242 Data size: 2565 Basic stats: COMPLETE Column stats: NONE
-               |           |     |<-Map 30 [BROADCAST_EDGE]
-               |           |     |  Reduce Output Operator [RS_104]
-               |           |     |     key expressions:_col1 (type: string)
-               |           |     |     Map-reduce partition columns:_col1 (type: string)
-               |           |     |     sort order:+
-               |           |     |     Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-               |           |     |     value expressions:_col0 (type: string)
-               |           |     |     Select Operator [SEL_98]
-               |           |     |        outputColumnNames:["_col0","_col1"]
-               |           |     |        Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-               |           |     |        Filter Operator [FIL_160]
-               |           |     |           predicate:(value is not null and key is not null) (type: boolean)
-               |           |     |           Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-               |           |     |           TableScan [TS_97]
-               |           |     |              alias:x
-               |           |     |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
-               |           |     |<-Select Operator [SEL_96]
-               |           |           outputColumnNames:["_col1"]
-               |           |           Statistics:Num rows: 220 Data size: 2332 Basic stats: COMPLETE Column stats: NONE
-               |           |           Group By Operator [GBY_95]
-               |           |           |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
-               |           |           |  outputColumnNames:["_col0","_col1"]
-               |           |           |  Statistics:Num rows: 220 Data size: 2332 Basic stats: COMPLETE Column stats: NONE
-               |           |           |<-Union 25 [SIMPLE_EDGE]
-               |           |              |<-Map 29 [CONTAINS]
-               |           |              |  Reduce Output Operator [RS_94]
-               |           |              |     key expressions:_col0 (type: string), _col1 (type: string)
-               |           |              |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-               |           |              |     sort order:++
-               |           |              |     Statistics:Num rows: 440 Data size: 4664 Basic stats: COMPLETE Column stats: NONE
-               |           |              |     Group By Operator [GBY_93]
-               |           |              |        keys:_col0 (type: string), _col1 (type: string)
-               |           |              |        outputColumnNames:["_col0","_col1"]
-               |           |              |        Statistics:Num rows: 440 Data size: 4664 Basic stats: COMPLETE Column stats: NONE
-               |           |              |        Select Operator [SEL_89]
-               |           |              |           outputColumnNames:["_col0","_col1"]
-               |           |              |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |           |              |           Filter Operator [FIL_159]
-               |           |              |              predicate:value is not null (type: boolean)
-               |           |              |              Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |           |              |              TableScan [TS_88]
-               |           |              |                 alias:y
-               |           |              |                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-               |           |              |<-Reducer 24 [CONTAINS]
-               |           |                 Reduce Output Operator [RS_94]
-               |           |                    key expressions:_col0 (type: string), _col1 (type: string)
-               |           |                    Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-               |           |                    sort order:++
-               |           |                    Statistics:Num rows: 440 Data size: 4664 Basic stats: COMPLETE Column stats: NONE
-               |           |                    Group By Operator [GBY_93]
-               |           |                       keys:_col0 (type: string), _col1 (type: string)
-               |           |                       outputColumnNames:["_col0","_col1"]
-               |           |                       Statistics:Num rows: 440 Data size: 4664 Basic stats: COMPLETE Column stats: NONE
-               |           |                       Group By Operator [GBY_86]
-               |           |                       |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
-               |           |                       |  outputColumnNames:["_col0","_col1"]
-               |           |                       |  Statistics:Num rows: 190 Data size: 2008 Basic stats: COMPLETE Column stats: NONE
-               |           |                       |<-Union 23 [SIMPLE_EDGE]
-               |           |                          |<-Map 28 [CONTAINS]
-               |           |                          |  Reduce Output Operator [RS_85]
-               |           |                          |     key expressions:_col0 (type: string), _col1 (type: string)
-               |           |                          |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-               |           |                          |     sort order:++
-               |           |                          |     Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
-               |           |                          |     Group By Operator [GBY_84]
-               |           |                          |        keys:_col0 (type: string), _col1 (type: string)
-               |           |                          |        outputColumnNames:["_col0","_col1"]
-               |           |                          |        Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
-               |           |                          |        Select Operator [SEL_80]
-               |           |                          |           outputColumnNames:["_col0","_col1"]
-               |           |                          |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |           |                          |           Filter Operator [FIL_158]
-               |           |                          |              predicate:value is not null (type: boolean)
-               |           |                          |              Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |           |                          |              TableScan [TS_79]
-               |           |                          |                 alias:y
-               |           |                          |                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-               |           |                          |<-Reducer 22 [CONTAINS]
-               |           |                             Reduce Output Operator [RS_85]
-               |           |                                key expressions:_col0 (type: string), _col1 (type: string)
-               |           |                                Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-               |           |                                sort order:++
-               |           |                                Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
-               |           |                                Group By Operator [GBY_84]
-               |           |                                   keys:_col0 (type: string), _col1 (type: string)
-               |           |                                   outputColumnNames:["_col0","_col1"]
-               |           |                                   Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
-               |           |                                   Group By Operator [GBY_77]
-               |           |                                   |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
-               |           |                                   |  outputColumnNames:["_col0","_col1"]
-               |           |                                   |  Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
-               |           |                                   |<-Union 21 [SIMPLE_EDGE]
-               |           |                                      |<-Map 20 [CONTAINS]
-               |           |                                      |  Reduce Output Operator [RS_76]
-               |           |                                      |     key expressions:_col0 (type: string), _col1 (type: string)
-               |           |                                      |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-               |           |                                      |     sort order:++
-               |           |                                      |     Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-               |           |                                      |     Group By Operator [GBY_75]
-               |           |                                      |        keys:_col0 (type: string), _col1 (type: string)
-               |           |                                      |        outputColumnNames:["_col0","_col1"]
-               |           |                                      |        Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-               |           |                                      |        Select Operator [SEL_69]
-               |           |                                      |           outputColumnNames:["_col0","_col1"]
-               |           |                                      |           Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
-               |           |                                      |           Filter Operator [FIL_156]
-               |           |                                      |              predicate:value is not null (type: boolean)
-               |           |                                      |              Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
-               |           |                                      |              TableScan [TS_68]
-               |           |                                      |                 alias:x
-               |           |                                      |                 Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
-               |           |                                      |<-Map 27 [CONTAINS]
-               |           |                                         Reduce Output Operator [RS_76]
-               |           |                                            key expressions:_col0 (type: string), _col1 (type: string)
-               |           |                                            Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-               |           |                                            sort order:++
-               |           |                                            Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-               |           |                                            Group By Operator [GBY_75]
-               |           |                                               keys:_col0 (type: string), _col1 (type: string)
-               |           |                                               outputColumnNames:["_col0","_col1"]
-               |           |                                               Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-               |           |                                               Select Operator [SEL_71]
-               |           |                                                  outputColumnNames:["_col0","_col1"]
-               |           |                                                  Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |           |                                                  Filter Operator [FIL_157]
-               |           |                                                     predicate:value is not null (type: boolean)
-               |           |                                                     Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |           |                                                     TableScan [TS_70]
-               |           |                                                        alias:y
-               |           |                                                        Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-               |           |<-Select Operator [SEL_100]
-               |                 outputColumnNames:["_col0","_col1"]
-               |                 Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |                 Filter Operator [FIL_161]
-               |                    predicate:key is not null (type: boolean)
-               |                    Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |                    TableScan [TS_99]
-               |                       alias:y
-               |                       Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-               |<-Reducer 8 [CONTAINS]
+               |           |     Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |           |     value expressions:_col1 (type: string)
+               |           |     Select Operator [SEL_100]
+               |           |        outputColumnNames:["_col0","_col1"]
+               |           |        Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |           |        Filter Operator [FIL_161]
+               |           |           predicate:key is not null (type: boolean)
+               |           |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |           |           TableScan [TS_99]
+               |           |              alias:y
+               |           |              Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+               |           |<-Map Join Operator [MAPJOIN_166]
+               |              |  condition map:[{"":"Inner Join 0 to 1"}]
+               |              |  keys:{"Reducer 26":"_col1 (type: string)","Map 30":"_col1 (type: string)"}
+               |              |  outputColumnNames:["_col2"]
+               |              |  Statistics:Num rows: 242 Data size: 2565 Basic stats: COMPLETE Column stats: NONE
+               |              |<-Map 30 [BROADCAST_EDGE]
+               |              |  Reduce Output Operator [RS_104]
+               |              |     key expressions:_col1 (type: string)
+               |              |     Map-reduce partition columns:_col1 (type: string)
+               |              |     sort order:+
+               |              |     Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+               |              |     value expressions:_col0 (type: string)
+               |              |     Select Operator [SEL_98]
+               |              |        outputColumnNames:["_col0","_col1"]
+               |              |        Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+               |              |        Filter Operator [FIL_160]
+               |              |           predicate:(value is not null and key is not null) (type: boolean)
+               |              |           Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+               |              |           TableScan [TS_97]
+               |              |              alias:x
+               |              |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+               |              |<-Select Operator [SEL_96]
+               |                    outputColumnNames:["_col1"]
+               |                    Statistics:Num rows: 220 Data size: 2332 Basic stats: COMPLETE Column stats: NONE
+               |                    Group By Operator [GBY_95]
+               |                    |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
+               |                    |  outputColumnNames:["_col0","_col1"]
+               |                    |  Statistics:Num rows: 220 Data size: 2332 Basic stats: COMPLETE Column stats: NONE
+               |                    |<-Union 25 [SIMPLE_EDGE]
+               |                       |<-Map 29 [CONTAINS]
+               |                       |  Reduce Output Operator [RS_94]
+               |                       |     key expressions:_col0 (type: string), _col1 (type: string)
+               |                       |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+               |                       |     sort order:++
+               |                       |     Statistics:Num rows: 440 Data size: 4664 Basic stats: COMPLETE Column stats: NONE
+               |                       |     Group By Operator [GBY_93]
+               |                       |        keys:_col0 (type: string), _col1 (type: string)
+               |                       |        outputColumnNames:["_col0","_col1"]
+               |                       |        Statistics:Num rows: 440 Data size: 4664 Basic stats: COMPLETE Column stats: NONE
+               |                       |        Select Operator [SEL_89]
+               |                       |           outputColumnNames:["_col0","_col1"]
+               |                       |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |                       |           Filter Operator [FIL_159]
+               |                       |              predicate:value is not null (type: boolean)
+               |                       |              Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |                       |              TableScan [TS_88]
+               |                       |                 alias:y
+               |                       |                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+               |                       |<-Reducer 24 [CONTAINS]
+               |                          Reduce Output Operator [RS_94]
+               |                             key expressions:_col0 (type: string), _col1 (type: string)
+               |                             Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+               |                             sort order:++
+               |                             Statistics:Num rows: 440 Data size: 4664 Basic stats: COMPLETE Column stats: NONE
+               |                             Group By Operator [GBY_93]
+               |                                keys:_col0 (type: string), _col1 (type: string)
+               |                                outputColumnNames:["_col0","_col1"]
+               |                                Statistics:Num rows: 440 Data size: 4664 Basic stats: COMPLETE Column stats: NONE
+               |                                Group By Operator [GBY_86]
+               |                                |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
+               |                                |  outputColumnNames:["_col0","_col1"]
+               |                                |  Statistics:Num rows: 190 Data size: 2008 Basic stats: COMPLETE Column stats: NONE
+               |                                |<-Union 23 [SIMPLE_EDGE]
+               |                                   |<-Map 28 [CONTAINS]
+               |                                   |  Reduce Output Operator [RS_85]
+               |                                   |     key expressions:_col0 (type: string), _col1 (type: string)
+               |                                   |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+               |                                   |     sort order:++
+               |                                   |     Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
+               |                                   |     Group By Operator [GBY_84]
+               |                                   |        keys:_col0 (type: string), _col1 (type: string)
+               |                                   |        outputColumnNames:["_col0","_col1"]
+               |                                   |        Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
+               |                                   |        Select Operator [SEL_80]
+               |                                   |           outputColumnNames:["_col0","_col1"]
+               |                                   |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |                                   |           Filter Operator [FIL_158]
+               |                                   |              predicate:value is not null (type: boolean)
+               |                                   |              Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |                                   |              TableScan [TS_79]
+               |                                   |                 alias:y
+               |                                   |                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+               |                                   |<-Reducer 22 [CONTAINS]
+               |                                      Reduce Output Operator [RS_85]
+               |                                         key expressions:_col0 (type: string), _col1 (type: string)
+               |                                         Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+               |                                         sort order:++
+               |                                         Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
+               |                                         Group By Operator [GBY_84]
+               |                                            keys:_col0 (type: string), _col1 (type: string)
+               |                                            outputColumnNames:["_col0","_col1"]
+               |                                            Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
+               |                                            Group By Operator [GBY_77]
+               |                                            |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
+               |                                            |  outputColumnNames:["_col0","_col1"]
+               |                                            |  Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
+               |                                            |<-Union 21 [SIMPLE_EDGE]
+               |                                               |<-Map 20 [CONTAINS]
+               |                                               |  Reduce Output Operator [RS_76]
+               |                                               |     key expressions:_col0 (type: string), _col1 (type: string)
+               |                                               |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+               |                                               |     sort order:++
+               |                                               |     Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+               |                                               |     Group By Operator [GBY_75]
+               |                                               |        keys:_col0 (type: string), _col1 (type: string)
+               |                                               |        outputColumnNames:["_col0","_col1"]
+               |                                               |        Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+               |                                               |        Select Operator [SEL_69]
+               |                                               |           outputColumnNames:["_col0","_col1"]
+               |                                               |           Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+               |                                               |           Filter Operator [FIL_156]
+               |                                               |              predicate:value is not null (type: boolean)
+               |                                               |              Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+               |                                               |              TableScan [TS_68]
+               |                                               |                 alias:x
+               |                                               |                 Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+               |                                               |<-Map 27 [CONTAINS]
+               |                                                  Reduce Output Operator [RS_76]
+               |                                                     key expressions:_col0 (type: string), _col1 (type: string)
+               |                                                     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+               |                                                     sort order:++
+               |                                                     Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+               |                                                     Group By Operator [GBY_75]
+               |                                                        keys:_col0 (type: string), _col1 (type: string)
+               |                                                        outputColumnNames:["_col0","_col1"]
+               |                                                        Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+               |                                                        Select Operator [SEL_71]
+               |                                                           outputColumnNames:["_col0","_col1"]
+               |                                                           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |                                                           Filter Operator [FIL_157]
+               |                                                              predicate:value is not null (type: boolean)
+               |                                                              Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+               |                                                              TableScan [TS_70]
+               |                                                                 alias:y
+               |                                                                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+               |<-Reducer 5 [CONTAINS]
                   Reduce Output Operator [RS_116]
                      key expressions:_col0 (type: string), _col1 (type: string)
                      Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
@@ -2216,8 +2210,8 @@ Stage-0
                         |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
                         |  outputColumnNames:["_col0","_col1"]
                         |  Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
-                        |<-Union 7 [SIMPLE_EDGE]
-                           |<-Map 19 [CONTAINS]
+                        |<-Union 4 [SIMPLE_EDGE]
+                           |<-Reducer 15 [CONTAINS]
                            |  Reduce Output Operator [RS_65]
                            |     key expressions:_col0 (type: string), _col1 (type: string)
                            |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
@@ -2235,123 +2229,124 @@ Stage-0
                            |           |  keys:{"Reducer 15":"_col2 (type: string)","Map 19":"_col0 (type: string)"}
                            |           |  outputColumnNames:["_col2","_col5"]
                            |           |  Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
-                           |           |<-Reducer 15 [BROADCAST_EDGE]
-                           |           |  Reduce Output Operator [RS_56]
-                           |           |     key expressions:_col2 (type: string)
-                           |           |     Map-reduce partition columns:_col2 (type: string)
+                           |           |<-Map 19 [BROADCAST_EDGE]
+                           |           |  Reduce Output Operator [RS_58]
+                           |           |     key expressions:_col0 (type: string)
+                           |           |     Map-reduce partition columns:_col0 (type: string)
                            |           |     sort order:+
-                           |           |     Statistics:Num rows: 209 Data size: 2208 Basic stats: COMPLETE Column stats: NONE
-                           |           |     Map Join Operator [MAPJOIN_164]
-                           |           |     |  condition map:[{"":"Inner Join 0 to 1"}]
-                           |           |     |  keys:{"Reducer 15":"_col1 (type: string)","Map 18":"_col1 (type: string)"}
-                           |           |     |  outputColumnNames:["_col2"]
-                           |           |     |  Statistics:Num rows: 209 Data size: 2208 Basic stats: COMPLETE Column stats: NONE
-                           |           |     |<-Map 18 [BROADCAST_EDGE]
-                           |           |     |  Reduce Output Operator [RS_53]
-                           |           |     |     key expressions:_col1 (type: string)
-                           |           |     |     Map-reduce partition columns:_col1 (type: string)
-                           |           |     |     sort order:+
-                           |           |     |     Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-                           |           |     |     value expressions:_col0 (type: string)
-                           |           |     |     Select Operator [SEL_47]
-                           |           |     |        outputColumnNames:["_col0","_col1"]
-                           |           |     |        Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-                           |           |     |        Filter Operator [FIL_154]
-                           |           |     |           predicate:(value is not null and key is not null) (type: boolean)
-                           |           |     |           Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
-                           |           |     |           TableScan [TS_46]
-                           |           |     |              alias:x
-                           |           |     |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
-                           |           |     |<-Select Operator [SEL_45]
-                           |           |           outputColumnNames:["_col1"]
-                           |           |           Statistics:Num rows: 190 Data size: 2008 Basic stats: COMPLETE Column stats: NONE
-                           |           |           Group By Operator [GBY_44]
-                           |           |           |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
-                           |           |           |  outputColumnNames:["_col0","_col1"]
-                           |           |           |  Statistics:Num rows: 190 Data size: 2008 Basic stats: COMPLETE Column stats: NONE
-                           |           |           |<-Union 14 [SIMPLE_EDGE]
-                           |           |              |<-Map 17 [CONTAINS]
-                           |           |              |  Reduce Output Operator [RS_43]
-                           |           |              |     key expressions:_col0 (type: string), _col1 (type: string)
-                           |           |              |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-                           |           |              |     sort order:++
-                           |           |              |     Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
-                           |           |              |     Group By Operator [GBY_42]
-                           |           |              |        keys:_col0 (type: string), _col1 (type: string)
-                           |           |              |        outputColumnNames:["_col0","_col1"]
-                           |           |              |        Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
-                           |           |              |        Select Operator [SEL_38]
-                           |           |              |           outputColumnNames:["_col0","_col1"]
-                           |           |              |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                           |           |              |           Filter Operator [FIL_153]
-                           |           |              |              predicate:value is not null (type: boolean)
-                           |           |              |              Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                           |           |              |              TableScan [TS_37]
-                           |           |              |                 alias:y
-                           |           |              |                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                           |           |              |<-Reducer 13 [CONTAINS]
-                           |           |                 Reduce Output Operator [RS_43]
-                           |           |                    key expressions:_col0 (type: string), _col1 (type: string)
-                           |           |                    Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-                           |           |                    sort order:++
-                           |           |                    Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
-                           |           |                    Group By Operator [GBY_42]
-                           |           |                       keys:_col0 (type: string), _col1 (type: string)
-                           |           |                       outputColumnNames:["_col0","_col1"]
-                           |           |                       Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
-                           |           |                       Group By Operator [GBY_35]
-                           |           |                       |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
-                           |           |                       |  outputColumnNames:["_col0","_col1"]
-                           |           |                       |  Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
-                           |           |                       |<-Union 12 [SIMPLE_EDGE]
-                           |           |                          |<-Map 11 [CONTAINS]
-                           |           |                          |  Reduce Output Operator [RS_34]
-                           |           |                          |     key expressions:_col0 (type: string), _col1 (type: string)
-                           |           |                          |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-                           |           |                          |     sort order:++
-                           |           |                          |     Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-                           |           |                          |     Group By Operator [GBY_33]
-                           |           |                          |        keys:_col0 (type: string), _col1 (type: string)
-                           |           |                          |        outputColumnNames:["_col0","_col1"]
-                           |           |                          |        Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-                           |           |                          |        Select Operator [SEL_27]
-                           |           |                          |           outputColumnNames:["_col0","_col1"]
-                           |           |                          |           Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
-                           |           |                          |           Filter Operator [FIL_151]
-                           |           |                          |              predicate:value is not null (type: boolean)
-                           |           |                          |              Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
-                           |           |                          |              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_34]
-                           |           |                                key expressions:_col0 (type: string), _col1 (type: string)
-                           |           |                                Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
-                           |           |                                sort order:++
-                           |           |                                Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-                           |           |                                Group By Operator [GBY_33]
-                           |           |                                   keys:_col0 (type: string), _col1 (type: string)
-                           |           |                                   outputColumnNames:["_col0","_col1"]
-                           |           |                                   Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
-                           |           |                                   Select Operator [SEL_29]
-                           |           |                                      outputColumnNames:["_col0","_col1"]
-                           |           |                                      Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                           |           |                                      Filter Operator [FIL_152]
-                           |           |                                         predicate:value is not null (type: boolean)
-                           |           |                                         Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                           |           |                                         TableScan [TS_28]
-                           |           |                                            alias:y
-                           |           |                                            Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                           |           |<-Select Operator [SEL_49]
-                           |                 outputColumnNames:["_col0","_col1"]
-                           |                 Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                           |                 Filter Operator [FIL_155]
-                           |                    predicate:key is not null (type: boolean)
-                           |                    Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                           |                    TableScan [TS_48]
-                           |                       alias:y
-                           |                       Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                           |<-Map 6 [CONTAINS]
+                           |           |     Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                           |           |     value expressions:_col1 (type: string)
+                           |           |     Select Operator [SEL_49]
+                           |           |        outputColumnNames:["_col0","_col1"]
+                           |           |        Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                           |           |        Filter Operator [FIL_155]
+                           |           |           predicate:key is not null (type: boolean)
+                           |           |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                           |           |           TableScan [TS_48]
+                           |           |              alias:y
+                           |           |              Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                           |           |<-Map Join Operator [MAPJOIN_164]
+                           |              |  condition map:[{"":"Inner Join 0 to 1"}]
+                           |              |  keys:{"Reducer 15":"_col1 (type: string)","Map 18":"_col1 (type: string)"}
+                           |              |  outputColumnNames:["_col2"]
+                           |              |  Statistics:Num rows: 209 Data size: 2208 Basic stats: COMPLETE Column stats: NONE
+                           |              |<-Map 18 [BROADCAST_EDGE]
+                           |              |  Reduce Output Operator [RS_53]
+                           |              |     key expressions:_col1 (type: string)
+                           |              |     Map-reduce partition columns:_col1 (type: string)
+                           |              |     sort order:+
+                           |              |     Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+                           |              |     value expressions:_col0 (type: string)
+                           |              |     Select Operator [SEL_47]
+                           |              |        outputColumnNames:["_col0","_col1"]
+                           |              |        Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+                           |              |        Filter Operator [FIL_154]
+                           |              |           predicate:(value is not null and key is not null) (type: boolean)
+                           |              |           Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
+                           |              |           TableScan [TS_46]
+                           |              |              alias:x
+                           |              |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+                           |              |<-Select Operator [SEL_45]
+                           |                    outputColumnNames:["_col1"]
+                           |                    Statistics:Num rows: 190 Data size: 2008 Basic stats: COMPLETE Column stats: NONE
+                           |                    Group By Operator [GBY_44]
+                           |                    |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
+                           |                    |  outputColumnNames:["_col0","_col1"]
+                           |                    |  Statistics:Num rows: 190 Data size: 2008 Basic stats: COMPLETE Column stats: NONE
+                           |                    |<-Union 14 [SIMPLE_EDGE]
+                           |                       |<-Map 17 [CONTAINS]
+                           |                       |  Reduce Output Operator [RS_43]
+                           |                       |     key expressions:_col0 (type: string), _col1 (type: string)
+                           |                       |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+                           |                       |     sort order:++
+                           |                       |     Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
+                           |                       |     Group By Operator [GBY_42]
+                           |                       |        keys:_col0 (type: string), _col1 (type: string)
+                           |                       |        outputColumnNames:["_col0","_col1"]
+                           |                       |        Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
+                           |                       |        Select Operator [SEL_38]
+                           |                       |           outputColumnNames:["_col0","_col1"]
+                           |                       |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                           |                       |           Filter Operator [FIL_153]
+                           |                       |              predicate:value is not null (type: boolean)
+                           |                       |              Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+                           |                       |              TableScan [TS_37]
+                           |                       |                 alias:y
+                           |                       |                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                           |                       |<-Reducer 13 [CONTAINS]
+                           |                          Reduce Output Operator [RS_43]
+                           |                             key expressions:_col0 (type: string), _col1 (type: string)
+                           |                             Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+                           |                             sort order:++
+                           |                             Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
+                           |                             Group By Operator [GBY_42]
+                           |                                keys:_col0 (type: string), _col1 (type: string)
+                           |                                outputColumnNames:["_col0","_col1"]
+                           |                                Statistics:Num rows: 381 Data size: 4028 Basic stats: COMPLETE Column stats: NONE
+                           |                                Group By Operator [GBY_35]
+                           |                                |  keys:KEY._col0 (type: string), KEY._col1 (type: string)
+                           |                                |  outputColumnNames:["_col0","_col1"]
+                           |                                |  Statistics:Num rows: 131 Data size: 1372 Basic stats: COMPLETE Column stats: NONE
+                           |                                |<-Union 12 [SIMPLE_EDGE]
+                           |                                   |<-Map 11 [CONTAINS]
+                           |                                   |  Reduce Output Operator [RS_34]
+                           |                                   |     key expressions:_col0 (type: string), _col1 (type: string)
+                           |                                   |     Map-reduce partition columns:_col0 (type: string), _col1 (type: string)
+                           |                                   |     sort order:++
+                           |                                   |     Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+                           |                                   |     Group By Operator [GBY_33]
+                           |                                   |        keys:_col0 (type: string), _col1 (type: string)
+                           |                                   |        outputColumnNames:["_col0","_col1"]
+                           |                                   |        Statistics:Num rows: 263 Data size: 2755 Basic stats: COMPLETE Column stats: NONE
+                           |                                   |        Select Operator [SEL_27]
+                           |                                   |           outputColumnNames:["_col0","_col1"]
+                           |                                   |           Statistics:Num rows: 13 Data size: 99 Basic stats: COMPLETE Column stats: NONE
+                           |                                   |           Filter Operator [FIL_151]
+                           |                                   |              predicate:value is not null (type: boolean)
+                           |                                   |              Statistics:Num ro

<TRUNCATED>

Mime
View raw message