hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jpull...@apache.org
Subject [1/4] hive git commit: HIVE-10526: CBO (Calcite Return Path): HiveCost epsilon comparison should take row count in to account (Laljo John Pullokkaran reviewed by Ashutosh Chauhan)
Date Thu, 07 May 2015 21:17:20 GMT
Repository: hive
Updated Branches:
  refs/heads/master 4a0ccd11f -> 809fcb014


http://git-wip-us.apache.org/repos/asf/hive/blob/809fcb01/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 f7026a8..f84524b 100644
--- a/ql/src/test/results/clientpositive/tez/explainuser_2.q.out
+++ b/ql/src/test/results/clientpositive/tez/explainuser_2.q.out
@@ -53,11 +53,11 @@ POSTHOOK: Input: default@srcpart
 POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
 POSTHOOK: Output: default@ss
 POSTHOOK: Lineage: ss.k1 SIMPLE [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: ss.k2 EXPRESSION [(src)y.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: ss.k3 SIMPLE [(srcpart)z.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ss.k2 SIMPLE [(src)y.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: ss.k3 EXPRESSION [(srcpart)z.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: ss.v1 SIMPLE [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: ss.v2 EXPRESSION [(src)y.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: ss.v3 SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: ss.v2 SIMPLE [(src)y.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: ss.v3 EXPRESSION [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
 PREHOOK: query: INSERT OVERWRITE TABLE sr
 SELECT x.key,x.value,y.key,y.value,z.key,z.value
 FROM src1 x 
@@ -81,11 +81,11 @@ POSTHOOK: Input: default@srcpart
 POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
 POSTHOOK: Output: default@sr
 POSTHOOK: Lineage: sr.k1 SIMPLE [(src1)x.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: sr.k2 EXPRESSION [(src)y.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: sr.k3 SIMPLE [(srcpart)z.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: sr.k2 SIMPLE [(src)y.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: sr.k3 EXPRESSION [(srcpart)z.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: sr.v1 SIMPLE [(src1)x.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: sr.v2 EXPRESSION [(src)y.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: sr.v3 SIMPLE [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: sr.v2 SIMPLE [(src)y.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: sr.v3 EXPRESSION [(srcpart)z.FieldSchema(name:value, type:string, comment:default), ]
 PREHOOK: query: INSERT OVERWRITE TABLE cs
 SELECT x.key,x.value,y.key,y.value,z.key,z.value
 FROM src1 x 
@@ -195,7 +195,7 @@ Stage-0
                Merge Join Operator [MERGEJOIN_29]
                |  condition map:[{"":"Inner Join 0 to 1"}]
                |  keys:{"1":"_col3 (type: string)","0":"_col0 (type: string)"}
-               |  outputColumnNames:["_col0","_col4","_col5"]
+               |  outputColumnNames:["_col1","_col2","_col5"]
                |  Statistics:Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
                |<-Map 1 [SIMPLE_EDGE]
                |  Reduce Output Operator [RS_14]
@@ -203,14 +203,15 @@ Stage-0
                |     Map-reduce partition columns:_col0 (type: string)
                |     sort order:+
                |     Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |     Select Operator [SEL_2]
-               |        outputColumnNames:["_col0"]
+               |     value expressions:_col1 (type: string)
+               |     Select Operator [SEL_1]
+               |        outputColumnNames:["_col0","_col1"]
                |        Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                |        Filter Operator [FIL_25]
-               |           predicate:value is not null (type: boolean)
+               |           predicate:key is not null (type: boolean)
                |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                |           TableScan [TS_0]
-               |              alias:z
+               |              alias:y
                |              Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                |<-Reducer 4 [SIMPLE_EDGE]
                   Reduce Output Operator [RS_16]
@@ -218,11 +219,11 @@ Stage-0
                      Map-reduce partition columns:_col3 (type: string)
                      sort order:+
                      Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
-                     value expressions:_col1 (type: string), _col2 (type: string)
+                     value expressions:_col0 (type: string)
                      Merge Join Operator [MERGEJOIN_28]
                      |  condition map:[{"":"Inner Join 0 to 1"}]
-                     |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
-                     |  outputColumnNames:["_col1","_col2","_col3"]
+                     |  keys:{"1":"_col1 (type: string)","0":"_col0 (type: string)"}
+                     |  outputColumnNames:["_col0","_col3"]
                      |  Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
                      |<-Map 3 [SIMPLE_EDGE]
                      |  Reduce Output Operator [RS_8]
@@ -230,28 +231,27 @@ Stage-0
                      |     Map-reduce partition columns:_col0 (type: string)
                      |     sort order:+
                      |     Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                     |     value expressions:_col1 (type: string)
                      |     Select Operator [SEL_4]
-                     |        outputColumnNames:["_col0","_col1"]
+                     |        outputColumnNames:["_col0"]
                      |        Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                      |        Filter Operator [FIL_26]
-                     |           predicate:key is not null (type: boolean)
+                     |           predicate:value is not null (type: boolean)
                      |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                     |           TableScan [TS_3]
-                     |              alias:y
+                     |           TableScan [TS_2]
+                     |              alias:z
                      |              Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                      |<-Map 5 [SIMPLE_EDGE]
                         Reduce Output Operator [RS_10]
-                           key expressions:_col0 (type: string)
-                           Map-reduce partition columns:_col0 (type: string)
+                           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:_col1 (type: string)
+                           value expressions:_col0 (type: string)
                            Select Operator [SEL_6]
                               outputColumnNames:["_col0","_col1"]
                               Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
                               Filter Operator [FIL_27]
-                                 predicate:(key is not null and value is not null) (type: boolean)
+                                 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_5]
                                     alias:x
@@ -315,21 +315,21 @@ POSTHOOK: type: QUERY
 Plan optimized by CBO.
 
 Vertex dependency in root stage
-Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 7 (SIMPLE_EDGE)
+Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 6 (SIMPLE_EDGE)
+Reducer 13 <- Map 12 (SIMPLE_EDGE), Map 14 (SIMPLE_EDGE)
 Reducer 3 <- Reducer 2 (SIMPLE_EDGE), Reducer 9 (SIMPLE_EDGE)
-Reducer 14 <- Map 13 (SIMPLE_EDGE), Reducer 16 (SIMPLE_EDGE)
-Reducer 12 <- Map 11 (SIMPLE_EDGE), Reducer 14 (SIMPLE_EDGE)
+Reducer 11 <- Map 10 (SIMPLE_EDGE), Reducer 13 (SIMPLE_EDGE)
 Reducer 5 <- Reducer 4 (SIMPLE_EDGE)
-Reducer 4 <- Reducer 12 (SIMPLE_EDGE), Reducer 3 (SIMPLE_EDGE)
-Reducer 6 <- Reducer 5 (SIMPLE_EDGE)
-Reducer 9 <- Map 10 (SIMPLE_EDGE), Map 8 (SIMPLE_EDGE)
+Reducer 4 <- Reducer 3 (SIMPLE_EDGE)
+Reducer 9 <- Reducer 16 (SIMPLE_EDGE), Reducer 8 (SIMPLE_EDGE)
+Reducer 8 <- Map 7 (SIMPLE_EDGE), Reducer 11 (SIMPLE_EDGE)
 Reducer 16 <- Map 15 (SIMPLE_EDGE), Map 17 (SIMPLE_EDGE)
 
 Stage-0
    Fetch Operator
       limit:100
       Stage-1
-         Reducer 6
+         Reducer 5
          File Output Operator [FS_71]
             compressed:false
             Statistics:Num rows: 100 Data size: 1000 Basic stats: COMPLETE Column stats: NONE
@@ -339,236 +339,236 @@ Stage-0
                Statistics:Num rows: 100 Data size: 1000 Basic stats: COMPLETE Column stats: NONE
                Select Operator [SEL_69]
                |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
-               |  Statistics:Num rows: 365 Data size: 3882 Basic stats: COMPLETE Column stats: NONE
-               |<-Reducer 5 [SIMPLE_EDGE]
+               |  Statistics:Num rows: 402 Data size: 4276 Basic stats: COMPLETE Column stats: NONE
+               |<-Reducer 4 [SIMPLE_EDGE]
                   Reduce Output Operator [RS_68]
                      key expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                      sort order:+++
-                     Statistics:Num rows: 365 Data size: 3882 Basic stats: COMPLETE Column stats: NONE
+                     Statistics:Num rows: 402 Data size: 4276 Basic stats: COMPLETE Column stats: NONE
                      value expressions:_col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint)
                      Group By Operator [GBY_66]
                      |  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: 365 Data size: 3882 Basic stats: COMPLETE Column stats: NONE
-                     |<-Reducer 4 [SIMPLE_EDGE]
+                     |  Statistics:Num rows: 402 Data size: 4276 Basic stats: COMPLETE Column stats: NONE
+                     |<-Reducer 3 [SIMPLE_EDGE]
                         Reduce Output Operator [RS_65]
                            key expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                            Map-reduce partition columns:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                            sort order:+++
-                           Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
+                           Statistics:Num rows: 804 Data size: 8552 Basic stats: COMPLETE Column stats: NONE
                            value expressions:_col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint)
                            Group By Operator [GBY_64]
                               aggregations:["count(_col3)","count(_col4)","count(_col5)"]
                               keys:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                               outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
-                              Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
+                              Statistics:Num rows: 804 Data size: 8552 Basic stats: COMPLETE Column stats: NONE
                               Select Operator [SEL_62]
                                  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
-                                 Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
-                                 Merge Join Operator [MERGEJOIN_111]
+                                 Statistics:Num rows: 804 Data size: 8552 Basic stats: COMPLETE Column stats: NONE
+                                 Merge Join Operator [MERGEJOIN_113]
                                  |  condition map:[{"":"Inner Join 0 to 1"}]
-                                 |  keys:{"1":"_col8 (type: string), _col10 (type: string)","0":"_col8 (type: string), _col10 (type: string)"}
-                                 |  outputColumnNames:["_col2","_col3","_col8","_col9","_col20","_col21"]
-                                 |  Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
-                                 |<-Reducer 12 [SIMPLE_EDGE]
-                                 |  Reduce Output Operator [RS_60]
-                                 |     key expressions:_col8 (type: string), _col10 (type: string)
-                                 |     Map-reduce partition columns:_col8 (type: string), _col10 (type: string)
+                                 |  keys:{"1":"_col15 (type: string), _col17 (type: string)","0":"_col1 (type: string), _col3 (type: string)"}
+                                 |  outputColumnNames:["_col2","_col3","_col12","_col13","_col20","_col21"]
+                                 |  Statistics:Num rows: 804 Data size: 8552 Basic stats: COMPLETE Column stats: NONE
+                                 |<-Reducer 2 [SIMPLE_EDGE]
+                                 |  Reduce Output Operator [RS_58]
+                                 |     key expressions:_col1 (type: string), _col3 (type: string)
+                                 |     Map-reduce partition columns:_col1 (type: string), _col3 (type: string)
                                  |     sort order:++
-                                 |     Statistics:Num rows: 665 Data size: 7069 Basic stats: COMPLETE Column stats: NONE
-                                 |     value expressions:_col6 (type: string), _col7 (type: string)
-                                 |     Select Operator [SEL_46]
-                                 |        outputColumnNames:["_col10","_col6","_col7","_col8"]
-                                 |        Statistics:Num rows: 665 Data size: 7069 Basic stats: COMPLETE Column stats: NONE
-                                 |        Merge Join Operator [MERGEJOIN_109]
-                                 |        |  condition map:[{"":"Inner Join 0 to 1"}]
-                                 |        |  keys:{"1":"_col5 (type: string)","0":"_col1 (type: string)"}
-                                 |        |  outputColumnNames:["_col6","_col7","_col8","_col10"]
-                                 |        |  Statistics:Num rows: 665 Data size: 7069 Basic stats: COMPLETE Column stats: NONE
-                                 |        |<-Map 11 [SIMPLE_EDGE]
-                                 |        |  Reduce Output Operator [RS_42]
-                                 |        |     key expressions:_col1 (type: string)
-                                 |        |     Map-reduce partition columns:_col1 (type: string)
-                                 |        |     sort order:+
-                                 |        |     Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
-                                 |        |     Select Operator [SEL_19]
-                                 |        |        outputColumnNames:["_col1"]
-                                 |        |        Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
-                                 |        |        Filter Operator [FIL_101]
-                                 |        |           predicate:((key = 'src1key') and value is not null) (type: boolean)
-                                 |        |           Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
-                                 |        |           TableScan [TS_17]
-                                 |        |              alias:src1
-                                 |        |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
-                                 |        |<-Reducer 14 [SIMPLE_EDGE]
-                                 |           Reduce Output Operator [RS_44]
-                                 |              key expressions:_col5 (type: string)
-                                 |              Map-reduce partition columns:_col5 (type: string)
-                                 |              sort order:+
-                                 |              Statistics:Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
-                                 |              value expressions:_col4 (type: string), _col6 (type: string), _col8 (type: string)
-                                 |              Merge Join Operator [MERGEJOIN_108]
-                                 |              |  condition map:[{"":"Inner Join 0 to 1"}]
-                                 |              |  keys:{"1":"_col2 (type: string)","0":"_col0 (type: string)"}
-                                 |              |  outputColumnNames:["_col4","_col5","_col6","_col8"]
-                                 |              |  Statistics:Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
-                                 |              |<-Map 13 [SIMPLE_EDGE]
-                                 |              |  Reduce Output Operator [RS_36]
-                                 |              |     key expressions:_col0 (type: string)
-                                 |              |     Map-reduce partition columns:_col0 (type: string)
-                                 |              |     sort order:+
-                                 |              |     Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                 |              |     Select Operator [SEL_22]
-                                 |              |        outputColumnNames:["_col0"]
-                                 |              |        Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                 |              |        Filter Operator [FIL_102]
-                                 |              |           predicate:((value = 'd1value') and key is not null) (type: boolean)
-                                 |              |           Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                 |              |           TableScan [TS_20]
-                                 |              |              alias:d1
-                                 |              |              Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                                 |              |<-Reducer 16 [SIMPLE_EDGE]
-                                 |                 Reduce Output Operator [RS_38]
-                                 |                    key expressions:_col2 (type: string)
-                                 |                    Map-reduce partition columns:_col2 (type: string)
-                                 |                    sort order:+
-                                 |                    Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
-                                 |                    value expressions:_col3 (type: string), _col4 (type: string), _col6 (type: string)
-                                 |                    Merge Join Operator [MERGEJOIN_107]
-                                 |                    |  condition map:[{"":"Inner Join 0 to 1"}]
-                                 |                    |  keys:{"1":"_col3 (type: string)","0":"_col1 (type: string)"}
-                                 |                    |  outputColumnNames:["_col2","_col3","_col4","_col6"]
-                                 |                    |  Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
-                                 |                    |<-Map 15 [SIMPLE_EDGE]
-                                 |                    |  Reduce Output Operator [RS_30]
-                                 |                    |     key expressions:_col1 (type: string)
-                                 |                    |     Map-reduce partition columns:_col1 (type: string)
-                                 |                    |     sort order:+
-                                 |                    |     Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                                 |                    |     Select Operator [SEL_25]
-                                 |                    |        outputColumnNames:["_col1"]
-                                 |                    |        Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                                 |                    |        Filter Operator [FIL_103]
-                                 |                    |           predicate:((key = 'srcpartkey') and value is not null) (type: boolean)
-                                 |                    |           Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                                 |                    |           TableScan [TS_23]
-                                 |                    |              alias:srcpart
-                                 |                    |              Statistics:Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
-                                 |                    |<-Map 17 [SIMPLE_EDGE]
-                                 |                       Reduce Output Operator [RS_32]
-                                 |                          key expressions:_col3 (type: string)
-                                 |                          Map-reduce partition columns:_col3 (type: string)
-                                 |                          sort order:+
-                                 |                          Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                 |                          value expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string), _col4 (type: string)
-                                 |                          Select Operator [SEL_28]
-                                 |                             outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
-                                 |                             Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                 |                             Filter Operator [FIL_104]
-                                 |                                predicate:((((((v3 = 'ssv3') and v2 is not null) and k1 is not null) and v1 is not null) and k2 is not null) and k3 is not null) (type: boolean)
-                                 |                                Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                 |                                TableScan [TS_26]
-                                 |                                   alias:ss
-                                 |                                   Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
-                                 |<-Reducer 3 [SIMPLE_EDGE]
-                                    Reduce Output Operator [RS_58]
-                                       key expressions:_col8 (type: string), _col10 (type: string)
-                                       Map-reduce partition columns:_col8 (type: string), _col10 (type: string)
+                                 |     Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+                                 |     value expressions:_col2 (type: string)
+                                 |     Merge Join Operator [MERGEJOIN_107]
+                                 |     |  condition map:[{"":"Inner Join 0 to 1"}]
+                                 |     |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
+                                 |     |  outputColumnNames:["_col1","_col2","_col3"]
+                                 |     |  Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+                                 |     |<-Map 1 [SIMPLE_EDGE]
+                                 |     |  Reduce Output Operator [RS_53]
+                                 |     |     key expressions:_col0 (type: string)
+                                 |     |     Map-reduce partition columns:_col0 (type: string)
+                                 |     |     sort order:+
+                                 |     |     Statistics:Num rows: 22 Data size: 762 Basic stats: COMPLETE Column stats: NONE
+                                 |     |     value expressions:_col1 (type: string), _col2 (type: string), _col3 (type: string)
+                                 |     |     Select Operator [SEL_1]
+                                 |     |        outputColumnNames:["_col0","_col1","_col2","_col3"]
+                                 |     |        Statistics:Num rows: 22 Data size: 762 Basic stats: COMPLETE Column stats: NONE
+                                 |     |        Filter Operator [FIL_99]
+                                 |     |           predicate:((k1 is not null and v2 is not null) and v3 is not null) (type: boolean)
+                                 |     |           Statistics:Num rows: 22 Data size: 762 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_55]
+                                 |           key expressions:_col0 (type: string)
+                                 |           Map-reduce partition columns:_col0 (type: string)
+                                 |           sort order:+
+                                 |           Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                 |           Select Operator [SEL_4]
+                                 |              outputColumnNames:["_col0"]
+                                 |              Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                 |              Filter Operator [FIL_100]
+                                 |                 predicate:((value) IN ('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
+                                 |                 Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                 |                 TableScan [TS_2]
+                                 |                    alias:d1
+                                 |                    Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                                 |<-Reducer 9 [SIMPLE_EDGE]
+                                    Reduce Output Operator [RS_60]
+                                       key expressions:_col15 (type: string), _col17 (type: string)
+                                       Map-reduce partition columns:_col15 (type: string), _col17 (type: string)
                                        sort order:++
-                                       Statistics:Num rows: 150 Data size: 1606 Basic stats: COMPLETE Column stats: NONE
-                                       value expressions:_col2 (type: string), _col3 (type: string), _col9 (type: string)
-                                       Merge Join Operator [MERGEJOIN_110]
-                                       |  condition map:[{"":"Inner Join 0 to 1"}]
-                                       |  keys:{"1":"_col3 (type: string), _col5 (type: string)","0":"_col1 (type: string), _col3 (type: string)"}
-                                       |  outputColumnNames:["_col2","_col3","_col8","_col9","_col10"]
-                                       |  Statistics:Num rows: 150 Data size: 1606 Basic stats: COMPLETE Column stats: NONE
-                                       |<-Reducer 2 [SIMPLE_EDGE]
-                                       |  Reduce Output Operator [RS_53]
-                                       |     key expressions:_col1 (type: string), _col3 (type: string)
-                                       |     Map-reduce partition columns:_col1 (type: string), _col3 (type: string)
-                                       |     sort order:++
-                                       |     Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
-                                       |     value expressions:_col2 (type: string)
-                                       |     Merge Join Operator [MERGEJOIN_105]
-                                       |     |  condition map:[{"":"Inner Join 0 to 1"}]
-                                       |     |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
-                                       |     |  outputColumnNames:["_col1","_col2","_col3"]
-                                       |     |  Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
-                                       |     |<-Map 1 [SIMPLE_EDGE]
-                                       |     |  Reduce Output Operator [RS_48]
-                                       |     |     key expressions:_col0 (type: string)
-                                       |     |     Map-reduce partition columns:_col0 (type: string)
-                                       |     |     sort order:+
-                                       |     |     Statistics:Num rows: 22 Data size: 762 Basic stats: COMPLETE Column stats: NONE
-                                       |     |     value expressions:_col1 (type: string), _col2 (type: string), _col3 (type: string)
-                                       |     |     Select Operator [SEL_1]
-                                       |     |        outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                       |     |        Statistics:Num rows: 22 Data size: 762 Basic stats: COMPLETE Column stats: NONE
-                                       |     |        Filter Operator [FIL_97]
-                                       |     |           predicate:((k1 is not null and v2 is not null) and v3 is not null) (type: boolean)
-                                       |     |           Statistics:Num rows: 22 Data size: 762 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 7 [SIMPLE_EDGE]
-                                       |        Reduce Output Operator [RS_50]
-                                       |           key expressions:_col0 (type: string)
-                                       |           Map-reduce partition columns:_col0 (type: string)
-                                       |           sort order:+
-                                       |           Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                       |           Select Operator [SEL_4]
-                                       |              outputColumnNames:["_col0"]
-                                       |              Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                       |              Filter Operator [FIL_98]
-                                       |                 predicate:((value) IN ('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
-                                       |                 Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                       |                 TableScan [TS_2]
-                                       |                    alias:d1
-                                       |                    Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                                       |<-Reducer 9 [SIMPLE_EDGE]
-                                          Reduce Output Operator [RS_55]
-                                             key expressions:_col3 (type: string), _col5 (type: string)
-                                             Map-reduce partition columns:_col3 (type: string), _col5 (type: string)
-                                             sort order:++
-                                             Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
-                                             value expressions:_col2 (type: string), _col4 (type: string)
-                                             Merge Join Operator [MERGEJOIN_106]
-                                             |  condition map:[{"":"Inner Join 0 to 1"}]
-                                             |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
-                                             |  outputColumnNames:["_col2","_col3","_col4","_col5"]
-                                             |  Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
-                                             |<-Map 10 [SIMPLE_EDGE]
-                                             |  Reduce Output Operator [RS_14]
-                                             |     key expressions:_col0 (type: string)
-                                             |     Map-reduce partition columns:_col0 (type: string)
-                                             |     sort order:+
-                                             |     Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                             |     Select Operator [SEL_10]
-                                             |        outputColumnNames:["_col0"]
-                                             |        Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                             |        Filter Operator [FIL_100]
-                                             |           predicate:((value) IN ('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
-                                             |           Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                             |           TableScan [TS_8]
-                                             |              alias:d1
-                                             |              Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                                             |<-Map 8 [SIMPLE_EDGE]
-                                                Reduce Output Operator [RS_12]
-                                                   key expressions:_col0 (type: string)
-                                                   Map-reduce partition columns:_col0 (type: string)
-                                                   sort order:+
-                                                   Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                                   value expressions:_col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
-                                                   Select Operator [SEL_7]
-                                                      outputColumnNames:["_col0","_col2","_col3","_col4","_col5"]
-                                                      Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                                      Filter Operator [FIL_99]
-                                                         predicate:((((((v1 = 'srv1') and k1 is not null) and v2 is not null) and v3 is not null) and k2 is not null) and k3 is not null) (type: boolean)
-                                                         Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                                         TableScan [TS_5]
-                                                            alias:sr
-                                                            Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
+                                       Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
+                                       value expressions:_col6 (type: string), _col7 (type: string), _col14 (type: string)
+                                       Select Operator [SEL_51]
+                                          outputColumnNames:["_col14","_col15","_col17","_col6","_col7"]
+                                          Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
+                                          Merge Join Operator [MERGEJOIN_112]
+                                          |  condition map:[{"":"Inner Join 0 to 1"}]
+                                          |  keys:{"1":"_col2 (type: string), _col4 (type: string)","0":"_col8 (type: string), _col10 (type: string)"}
+                                          |  outputColumnNames:["_col6","_col7","_col14","_col15","_col17"]
+                                          |  Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
+                                          |<-Reducer 16 [SIMPLE_EDGE]
+                                          |  Reduce Output Operator [RS_49]
+                                          |     key expressions:_col2 (type: string), _col4 (type: string)
+                                          |     Map-reduce partition columns:_col2 (type: string), _col4 (type: string)
+                                          |     sort order:++
+                                          |     Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+                                          |     value expressions:_col3 (type: string), _col5 (type: string)
+                                          |     Merge Join Operator [MERGEJOIN_111]
+                                          |     |  condition map:[{"":"Inner Join 0 to 1"}]
+                                          |     |  keys:{"1":"_col0 (type: string)","0":"_col0 (type: string)"}
+                                          |     |  outputColumnNames:["_col2","_col3","_col4","_col5"]
+                                          |     |  Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+                                          |     |<-Map 15 [SIMPLE_EDGE]
+                                          |     |  Reduce Output Operator [RS_36]
+                                          |     |     key expressions:_col0 (type: string)
+                                          |     |     Map-reduce partition columns:_col0 (type: string)
+                                          |     |     sort order:+
+                                          |     |     Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+                                          |     |     value expressions:_col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
+                                          |     |     Select Operator [SEL_31]
+                                          |     |        outputColumnNames:["_col0","_col2","_col3","_col4","_col5"]
+                                          |     |        Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+                                          |     |        Filter Operator [FIL_105]
+                                          |     |           predicate:((((((v1 = 'srv1') and k1 is not null) and k2 is not null) and k3 is not null) and v2 is not null) and v3 is not null) (type: boolean)
+                                          |     |           Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+                                          |     |           TableScan [TS_29]
+                                          |     |              alias:sr
+                                          |     |              Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
+                                          |     |<-Map 17 [SIMPLE_EDGE]
+                                          |        Reduce Output Operator [RS_38]
+                                          |           key expressions:_col0 (type: string)
+                                          |           Map-reduce partition columns:_col0 (type: string)
+                                          |           sort order:+
+                                          |           Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                          |           Select Operator [SEL_34]
+                                          |              outputColumnNames:["_col0"]
+                                          |              Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                          |              Filter Operator [FIL_106]
+                                          |                 predicate:((value) IN ('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
+                                          |                 Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                          |                 TableScan [TS_32]
+                                          |                    alias:d1
+                                          |                    Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                                          |<-Reducer 8 [SIMPLE_EDGE]
+                                             Reduce Output Operator [RS_47]
+                                                key expressions:_col8 (type: string), _col10 (type: string)
+                                                Map-reduce partition columns:_col8 (type: string), _col10 (type: string)
+                                                sort order:++
+                                                Statistics:Num rows: 665 Data size: 7069 Basic stats: COMPLETE Column stats: NONE
+                                                value expressions:_col6 (type: string), _col7 (type: string)
+                                                Merge Join Operator [MERGEJOIN_110]
+                                                |  condition map:[{"":"Inner Join 0 to 1"}]
+                                                |  keys:{"1":"_col5 (type: string)","0":"_col1 (type: string)"}
+                                                |  outputColumnNames:["_col6","_col7","_col8","_col10"]
+                                                |  Statistics:Num rows: 665 Data size: 7069 Basic stats: COMPLETE Column stats: NONE
+                                                |<-Map 7 [SIMPLE_EDGE]
+                                                |  Reduce Output Operator [RS_42]
+                                                |     key expressions:_col1 (type: string)
+                                                |     Map-reduce partition columns:_col1 (type: string)
+                                                |     sort order:+
+                                                |     Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+                                                |     Select Operator [SEL_7]
+                                                |        outputColumnNames:["_col1"]
+                                                |        Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+                                                |        Filter Operator [FIL_101]
+                                                |           predicate:((key = 'src1key') and value is not null) (type: boolean)
+                                                |           Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+                                                |           TableScan [TS_5]
+                                                |              alias:src1
+                                                |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+                                                |<-Reducer 11 [SIMPLE_EDGE]
+                                                   Reduce Output Operator [RS_44]
+                                                      key expressions:_col5 (type: string)
+                                                      Map-reduce partition columns:_col5 (type: string)
+                                                      sort order:+
+                                                      Statistics:Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
+                                                      value expressions:_col4 (type: string), _col6 (type: string), _col8 (type: string)
+                                                      Merge Join Operator [MERGEJOIN_109]
+                                                      |  condition map:[{"":"Inner Join 0 to 1"}]
+                                                      |  keys:{"1":"_col2 (type: string)","0":"_col0 (type: string)"}
+                                                      |  outputColumnNames:["_col4","_col5","_col6","_col8"]
+                                                      |  Statistics:Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
+                                                      |<-Map 10 [SIMPLE_EDGE]
+                                                      |  Reduce Output Operator [RS_24]
+                                                      |     key expressions:_col0 (type: string)
+                                                      |     Map-reduce partition columns:_col0 (type: string)
+                                                      |     sort order:+
+                                                      |     Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                                      |     Select Operator [SEL_10]
+                                                      |        outputColumnNames:["_col0"]
+                                                      |        Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                                      |        Filter Operator [FIL_102]
+                                                      |           predicate:((value = 'd1value') and key is not null) (type: boolean)
+                                                      |           Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                                      |           TableScan [TS_8]
+                                                      |              alias:d1
+                                                      |              Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                                                      |<-Reducer 13 [SIMPLE_EDGE]
+                                                         Reduce Output Operator [RS_26]
+                                                            key expressions:_col2 (type: string)
+                                                            Map-reduce partition columns:_col2 (type: string)
+                                                            sort order:+
+                                                            Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+                                                            value expressions:_col3 (type: string), _col4 (type: string), _col6 (type: string)
+                                                            Merge Join Operator [MERGEJOIN_108]
+                                                            |  condition map:[{"":"Inner Join 0 to 1"}]
+                                                            |  keys:{"1":"_col3 (type: string)","0":"_col1 (type: string)"}
+                                                            |  outputColumnNames:["_col2","_col3","_col4","_col6"]
+                                                            |  Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
+                                                            |<-Map 12 [SIMPLE_EDGE]
+                                                            |  Reduce Output Operator [RS_18]
+                                                            |     key expressions:_col1 (type: string)
+                                                            |     Map-reduce partition columns:_col1 (type: string)
+                                                            |     sort order:+
+                                                            |     Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                                                            |     Select Operator [SEL_13]
+                                                            |        outputColumnNames:["_col1"]
+                                                            |        Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                                                            |        Filter Operator [FIL_103]
+                                                            |           predicate:((key = 'srcpartkey') and value is not null) (type: boolean)
+                                                            |           Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                                                            |           TableScan [TS_11]
+                                                            |              alias:srcpart
+                                                            |              Statistics:Num rows: 2000 Data size: 21248 Basic stats: COMPLETE Column stats: NONE
+                                                            |<-Map 14 [SIMPLE_EDGE]
+                                                               Reduce Output Operator [RS_20]
+                                                                  key expressions:_col3 (type: string)
+                                                                  Map-reduce partition columns:_col3 (type: string)
+                                                                  sort order:+
+                                                                  Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+                                                                  value expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string), _col4 (type: string)
+                                                                  Select Operator [SEL_16]
+                                                                     outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
+                                                                     Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+                                                                     Filter Operator [FIL_104]
+                                                                        predicate:((((((v3 = 'ssv3') and v2 is not null) and k1 is not null) and v1 is not null) and k2 is not null) and k3 is not null) (type: boolean)
+                                                                        Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+                                                                        TableScan [TS_14]
+                                                                           alias:ss
+                                                                           Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
 PREHOOK: query: explain
 SELECT x.key, z.value, y.value
 FROM src1 x JOIN src y ON (x.key = y.key) 
@@ -1298,7 +1298,7 @@ Stage-0
                Map Join Operator [MAPJOIN_29]
                |  condition map:[{"":"Inner Join 0 to 1"}]
                |  keys:{"Map 1":"_col0 (type: string)","Map 2":"_col3 (type: string)"}
-               |  outputColumnNames:["_col0","_col4","_col5"]
+               |  outputColumnNames:["_col1","_col2","_col5"]
                |  Statistics:Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
                |<-Map 1 [BROADCAST_EDGE]
                |  Reduce Output Operator [RS_14]
@@ -1306,44 +1306,45 @@ Stage-0
                |     Map-reduce partition columns:_col0 (type: string)
                |     sort order:+
                |     Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-               |     Select Operator [SEL_2]
-               |        outputColumnNames:["_col0"]
+               |     value expressions:_col1 (type: string)
+               |     Select Operator [SEL_1]
+               |        outputColumnNames:["_col0","_col1"]
                |        Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                |        Filter Operator [FIL_25]
-               |           predicate:value is not null (type: boolean)
+               |           predicate:key is not null (type: boolean)
                |           Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                |           TableScan [TS_0]
-               |              alias:z
+               |              alias:y
                |              Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
                |<-Map Join Operator [MAPJOIN_28]
                   |  condition map:[{"":"Inner Join 0 to 1"}]
-                  |  keys:{"Map 2":"_col0 (type: string)","Map 3":"_col0 (type: string)"}
-                  |  outputColumnNames:["_col1","_col2","_col3"]
+                  |  keys:{"Map 2":"_col0 (type: string)","Map 3":"_col1 (type: string)"}
+                  |  outputColumnNames:["_col0","_col3"]
                   |  Statistics:Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
                   |<-Map 3 [BROADCAST_EDGE]
                   |  Reduce Output Operator [RS_10]
-                  |     key expressions:_col0 (type: string)
-                  |     Map-reduce partition columns:_col0 (type: string)
+                  |     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:_col1 (type: string)
+                  |     value expressions:_col0 (type: string)
                   |     Select Operator [SEL_6]
                   |        outputColumnNames:["_col0","_col1"]
                   |        Statistics:Num rows: 7 Data size: 53 Basic stats: COMPLETE Column stats: NONE
                   |        Filter Operator [FIL_27]
-                  |           predicate:(key is not null and value is not null) (type: boolean)
+                  |           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_5]
                   |              alias:x
                   |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
                   |<-Select Operator [SEL_4]
-                        outputColumnNames:["_col0","_col1"]
+                        outputColumnNames:["_col0"]
                         Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
                         Filter Operator [FIL_26]
-                           predicate:key is not null (type: boolean)
+                           predicate:value is not null (type: boolean)
                            Statistics:Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
-                           TableScan [TS_3]
-                              alias:y
+                           TableScan [TS_2]
+                              alias:z
                               Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
 PREHOOK: query: EXPLAIN
 select 
@@ -1404,17 +1405,17 @@ POSTHOOK: type: QUERY
 Plan optimized by CBO.
 
 Vertex dependency in root stage
-Map 2 <- Map 1 (BROADCAST_EDGE), Map 4 (BROADCAST_EDGE)
-Map 4 <- Map 3 (BROADCAST_EDGE)
-Map 7 <- Map 10 (BROADCAST_EDGE), Map 2 (BROADCAST_EDGE), Map 5 (BROADCAST_EDGE), Map 6 (BROADCAST_EDGE)
-Reducer 9 <- Reducer 8 (SIMPLE_EDGE)
-Reducer 8 <- Map 7 (SIMPLE_EDGE)
+Map 2 <- Map 1 (BROADCAST_EDGE)
+Map 10 <- Map 9 (BROADCAST_EDGE)
+Map 5 <- Map 10 (BROADCAST_EDGE), Map 2 (BROADCAST_EDGE), Map 3 (BROADCAST_EDGE), Map 4 (BROADCAST_EDGE), Map 8 (BROADCAST_EDGE)
+Reducer 7 <- Reducer 6 (SIMPLE_EDGE)
+Reducer 6 <- Map 5 (SIMPLE_EDGE)
 
 Stage-0
    Fetch Operator
       limit:100
       Stage-1
-         Reducer 9
+         Reducer 7
          File Output Operator [FS_71]
             compressed:false
             Statistics:Num rows: 100 Data size: 1000 Basic stats: COMPLETE Column stats: NONE
@@ -1424,190 +1425,190 @@ Stage-0
                Statistics:Num rows: 100 Data size: 1000 Basic stats: COMPLETE Column stats: NONE
                Select Operator [SEL_69]
                |  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
-               |  Statistics:Num rows: 365 Data size: 3882 Basic stats: COMPLETE Column stats: NONE
-               |<-Reducer 8 [SIMPLE_EDGE]
+               |  Statistics:Num rows: 402 Data size: 4276 Basic stats: COMPLETE Column stats: NONE
+               |<-Reducer 6 [SIMPLE_EDGE]
                   Reduce Output Operator [RS_68]
                      key expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                      sort order:+++
-                     Statistics:Num rows: 365 Data size: 3882 Basic stats: COMPLETE Column stats: NONE
+                     Statistics:Num rows: 402 Data size: 4276 Basic stats: COMPLETE Column stats: NONE
                      value expressions:_col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint)
                      Group By Operator [GBY_66]
                      |  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: 365 Data size: 3882 Basic stats: COMPLETE Column stats: NONE
-                     |<-Map 7 [SIMPLE_EDGE]
+                     |  Statistics:Num rows: 402 Data size: 4276 Basic stats: COMPLETE Column stats: NONE
+                     |<-Map 5 [SIMPLE_EDGE]
                         Reduce Output Operator [RS_65]
                            key expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                            Map-reduce partition columns:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                            sort order:+++
-                           Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
+                           Statistics:Num rows: 804 Data size: 8552 Basic stats: COMPLETE Column stats: NONE
                            value expressions:_col3 (type: bigint), _col4 (type: bigint), _col5 (type: bigint)
                            Group By Operator [GBY_64]
                               aggregations:["count(_col3)","count(_col4)","count(_col5)"]
                               keys:_col0 (type: string), _col1 (type: string), _col2 (type: string)
                               outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
-                              Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
+                              Statistics:Num rows: 804 Data size: 8552 Basic stats: COMPLETE Column stats: NONE
                               Select Operator [SEL_62]
                                  outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5"]
-                                 Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
-                                 Map Join Operator [MAPJOIN_111]
+                                 Statistics:Num rows: 804 Data size: 8552 Basic stats: COMPLETE Column stats: NONE
+                                 Map Join Operator [MAPJOIN_113]
                                  |  condition map:[{"":"Inner Join 0 to 1"}]
-                                 |  keys:{"Map 2":"_col8 (type: string), _col10 (type: string)","Map 7":"_col8 (type: string), _col10 (type: string)"}
-                                 |  outputColumnNames:["_col2","_col3","_col8","_col9","_col20","_col21"]
-                                 |  Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
+                                 |  keys:{"Map 2":"_col1 (type: string), _col3 (type: string)","Map 5":"_col15 (type: string), _col17 (type: string)"}
+                                 |  outputColumnNames:["_col2","_col3","_col12","_col13","_col20","_col21"]
+                                 |  Statistics:Num rows: 804 Data size: 8552 Basic stats: COMPLETE Column stats: NONE
                                  |<-Map 2 [BROADCAST_EDGE]
                                  |  Reduce Output Operator [RS_58]
-                                 |     key expressions:_col8 (type: string), _col10 (type: string)
-                                 |     Map-reduce partition columns:_col8 (type: string), _col10 (type: string)
+                                 |     key expressions:_col1 (type: string), _col3 (type: string)
+                                 |     Map-reduce partition columns:_col1 (type: string), _col3 (type: string)
                                  |     sort order:++
-                                 |     Statistics:Num rows: 150 Data size: 1606 Basic stats: COMPLETE Column stats: NONE
-                                 |     value expressions:_col2 (type: string), _col3 (type: string), _col9 (type: string)
-                                 |     Map Join Operator [MAPJOIN_110]
+                                 |     Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+                                 |     value expressions:_col2 (type: string)
+                                 |     Map Join Operator [MAPJOIN_107]
                                  |     |  condition map:[{"":"Inner Join 0 to 1"}]
-                                 |     |  keys:{"Map 2":"_col1 (type: string), _col3 (type: string)","Map 4":"_col3 (type: string), _col5 (type: string)"}
-                                 |     |  outputColumnNames:["_col2","_col3","_col8","_col9","_col10"]
-                                 |     |  Statistics:Num rows: 150 Data size: 1606 Basic stats: COMPLETE Column stats: NONE
-                                 |     |<-Map 4 [BROADCAST_EDGE]
-                                 |     |  Reduce Output Operator [RS_55]
-                                 |     |     key expressions:_col3 (type: string), _col5 (type: string)
-                                 |     |     Map-reduce partition columns:_col3 (type: string), _col5 (type: string)
-                                 |     |     sort order:++
-                                 |     |     Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
-                                 |     |     value expressions:_col2 (type: string), _col4 (type: string)
-                                 |     |     Map Join Operator [MAPJOIN_106]
-                                 |     |     |  condition map:[{"":"Inner Join 0 to 1"}]
-                                 |     |     |  keys:{"Map 3":"_col0 (type: string)","Map 4":"_col0 (type: string)"}
-                                 |     |     |  outputColumnNames:["_col2","_col3","_col4","_col5"]
-                                 |     |     |  Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
-                                 |     |     |<-Map 3 [BROADCAST_EDGE]
-                                 |     |     |  Reduce Output Operator [RS_12]
-                                 |     |     |     key expressions:_col0 (type: string)
-                                 |     |     |     Map-reduce partition columns:_col0 (type: string)
-                                 |     |     |     sort order:+
-                                 |     |     |     Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                 |     |     |     value expressions:_col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
-                                 |     |     |     Select Operator [SEL_7]
-                                 |     |     |        outputColumnNames:["_col0","_col2","_col3","_col4","_col5"]
-                                 |     |     |        Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                 |     |     |        Filter Operator [FIL_99]
-                                 |     |     |           predicate:((((((v1 = 'srv1') and k1 is not null) and v2 is not null) and v3 is not null) and k2 is not null) and k3 is not null) (type: boolean)
-                                 |     |     |           Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                 |     |     |           TableScan [TS_5]
-                                 |     |     |              alias:sr
-                                 |     |     |              Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
-                                 |     |     |<-Select Operator [SEL_10]
-                                 |     |           outputColumnNames:["_col0"]
-                                 |     |           Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                 |     |           Filter Operator [FIL_100]
-                                 |     |              predicate:((value) IN ('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
-                                 |     |              Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                 |     |              TableScan [TS_8]
-                                 |     |                 alias:d1
-                                 |     |                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                                 |     |<-Map Join Operator [MAPJOIN_105]
-                                 |        |  condition map:[{"":"Inner Join 0 to 1"}]
-                                 |        |  keys:{"Map 1":"_col0 (type: string)","Map 2":"_col0 (type: string)"}
-                                 |        |  outputColumnNames:["_col1","_col2","_col3"]
-                                 |        |  Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
-                                 |        |<-Map 1 [BROADCAST_EDGE]
-                                 |        |  Reduce Output Operator [RS_48]
-                                 |        |     key expressions:_col0 (type: string)
-                                 |        |     Map-reduce partition columns:_col0 (type: string)
-                                 |        |     sort order:+
-                                 |        |     Statistics:Num rows: 22 Data size: 762 Basic stats: COMPLETE Column stats: NONE
-                                 |        |     value expressions:_col1 (type: string), _col2 (type: string), _col3 (type: string)
-                                 |        |     Select Operator [SEL_1]
-                                 |        |        outputColumnNames:["_col0","_col1","_col2","_col3"]
-                                 |        |        Statistics:Num rows: 22 Data size: 762 Basic stats: COMPLETE Column stats: NONE
-                                 |        |        Filter Operator [FIL_97]
-                                 |        |           predicate:((k1 is not null and v2 is not null) and v3 is not null) (type: boolean)
-                                 |        |           Statistics:Num rows: 22 Data size: 762 Basic stats: COMPLETE Column stats: NONE
-                                 |        |           TableScan [TS_0]
-                                 |        |              alias:cs
-                                 |        |              Statistics:Num rows: 170 Data size: 5890 Basic stats: COMPLETE Column stats: NONE
-                                 |        |<-Select Operator [SEL_4]
-                                 |              outputColumnNames:["_col0"]
+                                 |     |  keys:{"Map 1":"_col0 (type: string)","Map 2":"_col0 (type: string)"}
+                                 |     |  outputColumnNames:["_col1","_col2","_col3"]
+                                 |     |  Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+                                 |     |<-Map 1 [BROADCAST_EDGE]
+                                 |     |  Reduce Output Operator [RS_53]
+                                 |     |     key expressions:_col0 (type: string)
+                                 |     |     Map-reduce partition columns:_col0 (type: string)
+                                 |     |     sort order:+
+                                 |     |     Statistics:Num rows: 22 Data size: 762 Basic stats: COMPLETE Column stats: NONE
+                                 |     |     value expressions:_col1 (type: string), _col2 (type: string), _col3 (type: string)
+                                 |     |     Select Operator [SEL_1]
+                                 |     |        outputColumnNames:["_col0","_col1","_col2","_col3"]
+                                 |     |        Statistics:Num rows: 22 Data size: 762 Basic stats: COMPLETE Column stats: NONE
+                                 |     |        Filter Operator [FIL_99]
+                                 |     |           predicate:((k1 is not null and v2 is not null) and v3 is not null) (type: boolean)
+                                 |     |           Statistics:Num rows: 22 Data size: 762 Basic stats: COMPLETE Column stats: NONE
+                                 |     |           TableScan [TS_0]
+                                 |     |              alias:cs
+                                 |     |              Statistics:Num rows: 170 Data size: 5890 Basic stats: COMPLETE Column stats: NONE
+                                 |     |<-Select Operator [SEL_4]
+                                 |           outputColumnNames:["_col0"]
+                                 |           Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                 |           Filter Operator [FIL_100]
+                                 |              predicate:((value) IN ('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
                                  |              Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                 |              Filter Operator [FIL_98]
-                                 |                 predicate:((value) IN ('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
-                                 |                 Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                 |                 TableScan [TS_2]
-                                 |                    alias:d1
-                                 |                    Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                                 |<-Select Operator [SEL_46]
-                                       outputColumnNames:["_col10","_col6","_col7","_col8"]
-                                       Statistics:Num rows: 665 Data size: 7069 Basic stats: COMPLETE Column stats: NONE
-                                       Map Join Operator [MAPJOIN_109]
+                                 |              TableScan [TS_2]
+                                 |                 alias:d1
+                                 |                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                                 |<-Select Operator [SEL_51]
+                                       outputColumnNames:["_col14","_col15","_col17","_col6","_col7"]
+                                       Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
+                                       Map Join Operator [MAPJOIN_112]
                                        |  condition map:[{"":"Inner Join 0 to 1"}]
-                                       |  keys:{"Map 5":"_col1 (type: string)","Map 7":"_col5 (type: string)"}
-                                       |  outputColumnNames:["_col6","_col7","_col8","_col10"]
-                                       |  Statistics:Num rows: 665 Data size: 7069 Basic stats: COMPLETE Column stats: NONE
-                                       |<-Map 5 [BROADCAST_EDGE]
-                                       |  Reduce Output Operator [RS_42]
-                                       |     key expressions:_col1 (type: string)
-                                       |     Map-reduce partition columns:_col1 (type: string)
-                                       |     sort order:+
-                                       |     Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
-                                       |     Select Operator [SEL_19]
-                                       |        outputColumnNames:["_col1"]
-                                       |        Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
-                                       |        Filter Operator [FIL_101]
-                                       |           predicate:((key = 'src1key') and value is not null) (type: boolean)
-                                       |           Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
-                                       |           TableScan [TS_17]
-                                       |              alias:src1
-                                       |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
-                                       |<-Map Join Operator [MAPJOIN_108]
+                                       |  keys:{"Map 10":"_col2 (type: string), _col4 (type: string)","Map 5":"_col8 (type: string), _col10 (type: string)"}
+                                       |  outputColumnNames:["_col6","_col7","_col14","_col15","_col17"]
+                                       |  Statistics:Num rows: 731 Data size: 7775 Basic stats: COMPLETE Column stats: NONE
+                                       |<-Map 10 [BROADCAST_EDGE]
+                                       |  Reduce Output Operator [RS_49]
+                                       |     key expressions:_col2 (type: string), _col4 (type: string)
+                                       |     Map-reduce partition columns:_col2 (type: string), _col4 (type: string)
+                                       |     sort order:++
+                                       |     Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+                                       |     value expressions:_col3 (type: string), _col5 (type: string)
+                                       |     Map Join Operator [MAPJOIN_111]
+                                       |     |  condition map:[{"":"Inner Join 0 to 1"}]
+                                       |     |  keys:{"Map 10":"_col0 (type: string)","Map 9":"_col0 (type: string)"}
+                                       |     |  outputColumnNames:["_col2","_col3","_col4","_col5"]
+                                       |     |  Statistics:Num rows: 137 Data size: 1460 Basic stats: COMPLETE Column stats: NONE
+                                       |     |<-Map 9 [BROADCAST_EDGE]
+                                       |     |  Reduce Output Operator [RS_36]
+                                       |     |     key expressions:_col0 (type: string)
+                                       |     |     Map-reduce partition columns:_col0 (type: string)
+                                       |     |     sort order:+
+                                       |     |     Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+                                       |     |     value expressions:_col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string)
+                                       |     |     Select Operator [SEL_31]
+                                       |     |        outputColumnNames:["_col0","_col2","_col3","_col4","_col5"]
+                                       |     |        Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+                                       |     |        Filter Operator [FIL_105]
+                                       |     |           predicate:((((((v1 = 'srv1') and k1 is not null) and k2 is not null) and k3 is not null) and v2 is not null) and v3 is not null) (type: boolean)
+                                       |     |           Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
+                                       |     |           TableScan [TS_29]
+                                       |     |              alias:sr
+                                       |     |              Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
+                                       |     |<-Select Operator [SEL_34]
+                                       |           outputColumnNames:["_col0"]
+                                       |           Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                       |           Filter Operator [FIL_106]
+                                       |              predicate:((value) IN ('2000Q1', '2000Q2', '2000Q3') and key is not null) (type: boolean)
+                                       |              Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
+                                       |              TableScan [TS_32]
+                                       |                 alias:d1
+                                       |                 Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                                       |<-Map Join Operator [MAPJOIN_110]
                                           |  condition map:[{"":"Inner Join 0 to 1"}]
-                                          |  keys:{"Map 7":"_col2 (type: string)","Map 6":"_col0 (type: string)"}
-                                          |  outputColumnNames:["_col4","_col5","_col6","_col8"]
-                                          |  Statistics:Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
-                                          |<-Map 6 [BROADCAST_EDGE]
-                                          |  Reduce Output Operator [RS_36]
-                                          |     key expressions:_col0 (type: string)
-                                          |     Map-reduce partition columns:_col0 (type: string)
+                                          |  keys:{"Map 3":"_col1 (type: string)","Map 5":"_col5 (type: string)"}
+                                          |  outputColumnNames:["_col6","_col7","_col8","_col10"]
+                                          |  Statistics:Num rows: 665 Data size: 7069 Basic stats: COMPLETE Column stats: NONE
+                                          |<-Map 3 [BROADCAST_EDGE]
+                                          |  Reduce Output Operator [RS_42]
+                                          |     key expressions:_col1 (type: string)
+                                          |     Map-reduce partition columns:_col1 (type: string)
                                           |     sort order:+
-                                          |     Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                          |     Select Operator [SEL_22]
-                                          |        outputColumnNames:["_col0"]
-                                          |        Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                          |        Filter Operator [FIL_102]
-                                          |           predicate:((value = 'd1value') and key is not null) (type: boolean)
-                                          |           Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE
-                                          |           TableScan [TS_20]
-                                          |              alias:d1
-                                          |              Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                                          |<-Map Join Operator [MAPJOIN_107]
+                                          |     Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+                                          |     Select Operator [SEL_7]
+                                          |        outputColumnNames:["_col1"]
+                                          |        Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+                                          |        Filter Operator [FIL_101]
+                                          |           predicate:((key = 'src1key') and value is not null) (type: boolean)
+                                          |           Statistics:Num rows: 6 Data size: 45 Basic stats: COMPLETE Column stats: NONE
+                                          |           TableScan [TS_5]
+                                          |              alias:src1
+                                          |              Statistics:Num rows: 25 Data size: 191 Basic stats: COMPLETE Column stats: NONE
+                                          |<-Map Join Operator [MAPJOIN_109]
                                              |  condition map:[{"":"Inner Join 0 to 1"}]
-                                             |  keys:{"Map 10":"_col3 (type: string)","Map 7":"_col1 (type: string)"}
-                                             |  outputColumnNames:["_col2","_col3","_col4","_col6"]
-                                             |  Statistics:Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
-                                             |<-Map 10 [BROADCAST_EDGE]
-                                             |  Reduce Output Operator [RS_32]
-                                             |     key expressions:_col3 (type: string)
-                                             |     Map-reduce partition columns:_col3 (type: string)
+                                             |  keys:{"Map 5":"_col2 (type: string)","Map 4":"_col0 (type: string)"}
+                                             |  outputColumnNames:["_col4","_col5","_col6","_col8"]
+                                             |  Statistics:Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE
+                                             |<-Map 4 [BROADCAST_EDGE]
+                                             |  Reduce Output Operator [RS_24]
+                                             |     key expressions:_col0 (type: string)
+                                             |     Map-reduce partition columns:_col0 (type: string)
                                              |     sort order:+
-                                             |     Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                             |     value expressions:_col0 (type: string), _col1 (type: string), _col2 (type: string), _col4 (type: string)
-                                             |     Select Operator [SEL_28]
-                                             |        outputColumnNames:["_col0","_col1","_col2","_col3","_col4"]
-                                             |        Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                             |        Filter Operator [FIL_104]
-                                             |           predicate:((((((v3 = 'ssv3') and v2 is not null) and k1 is not null) and v1 is not null) and k2 is not null) and k3 is not null) (type: boolean)
-                                             |           Statistics:Num rows: 2 Data size: 69 Basic stats: COMPLETE Column stats: NONE
-                                             |           TableScan [TS_26]
-                                             |              alias:ss
-                                             |              Statistics:Num rows: 85 Data size: 2945 Basic stats: COMPLETE Column stats: NONE
-                                             |<-Select Operator [SEL_25]
-                                                   outputColumnNames:["_col1"]
-                                                   Statistics:Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
-                                                   Filter Operator [FIL_103]
-                                                      predicate:((key = 'srcpartkey') and value is not null) (type: boolean)
+                                             |     Statistics:Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column 

<TRUNCATED>

Mime
View raw message