[11/51] [partial] hive git commit: HIVE-11110: Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation (Laljo John Pullokkaran reviewed by Jesus Camacho Rodriguez, Ashutosh Chauhan)

Fri, 11 Dec 2015 22:55:23 -0800 

http://git-wip-us.apache.org/repos/asf/hive/blob/08f73adc/ql/src/test/results/clientpositive/semijoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/semijoin.q.out 
b/ql/src/test/results/clientpositive/semijoin.q.out
index fb2c0c4..496cec9 100644
--- a/ql/src/test/results/clientpositive/semijoin.q.out
+++ b/ql/src/test/results/clientpositive/semijoin.q.out
@@ -136,33 +136,33 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
           TableScan
             alias: b
             Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: int)
                   mode: hash
                   outputColumnNames: _col0
-                  Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                   Reduce Output Operator
                     key expressions: _col0 (type: int)
                     sort order: +
                     Map-reduce partition columns: _col0 (type: int)
-                    Statistics: Num rows: 6 Data size: 45 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 11 Data size: 84 Basic stats: 
COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -171,7 +171,7 @@ STAGE PLANS:
             0 key (type: int)
             1 _col0 (type: int)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
             table:
@@ -186,15 +186,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: int), _col1 (type: string)
               sort order: ++
-              Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 
(type: string)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -240,33 +240,33 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
           TableScan
             alias: b
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: int)
                   mode: hash
                   outputColumnNames: _col0
-                  Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                   Reduce Output Operator
                     key expressions: _col0 (type: int)
                     sort order: +
                     Map-reduce partition columns: _col0 (type: int)
-                    Statistics: Num rows: 6 Data size: 43 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 11 Data size: 79 Basic stats: 
COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -275,7 +275,7 @@ STAGE PLANS:
             0 key (type: int)
             1 _col0 (type: int)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 49 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 92 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
             table:
@@ -290,15 +290,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: int), _col1 (type: string)
               sort order: ++
-              Statistics: Num rows: 6 Data size: 49 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 12 Data size: 92 Basic stats: COMPLETE 
Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 
(type: string)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 49 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 92 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 6 Data size: 49 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 92 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -346,12 +346,12 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
           TableScan
             alias: b
@@ -381,7 +381,7 @@ STAGE PLANS:
             0 key (type: int)
             1 _col0 (type: int)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
             table:
@@ -396,15 +396,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: int), _col1 (type: string)
               sort order: ++
-              Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 
(type: string)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -444,12 +444,12 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
           TableScan
             alias: b
@@ -479,11 +479,11 @@ STAGE PLANS:
             0 key (type: int)
             1 _col1 (type: int)
           outputColumnNames: _col1
-          Statistics: Num rows: 7 Data size: 56 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           Select Operator
             expressions: _col1 (type: string)
             outputColumnNames: _col0
-            Statistics: Num rows: 7 Data size: 56 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
             File Output Operator
               compressed: false
               table:
@@ -498,15 +498,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
-              Statistics: Num rows: 7 Data size: 56 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: string)
           outputColumnNames: _col0
-          Statistics: Num rows: 7 Data size: 56 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 7 Data size: 56 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -557,33 +557,33 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
           TableScan
             alias: b
             Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: ((value < 'val_10') and key is not null) (type: 
boolean)
-              Statistics: Num rows: 2 Data size: 15 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 3 Data size: 22 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int), value (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 2 Data size: 15 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 3 Data size: 22 Basic stats: COMPLETE 
Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: int), _col1 (type: string)
                   mode: hash
                   outputColumnNames: _col0, _col1
-                  Statistics: Num rows: 2 Data size: 15 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 3 Data size: 22 Basic stats: COMPLETE 
Column stats: NONE
                   Reduce Output Operator
                     key expressions: _col0 (type: int)
                     sort order: +
                     Map-reduce partition columns: _col0 (type: int)
-                    Statistics: Num rows: 2 Data size: 15 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 3 Data size: 22 Basic stats: 
COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -592,7 +592,7 @@ STAGE PLANS:
             0 key (type: int)
             1 _col0 (type: int)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
             table:
@@ -607,15 +607,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: int), _col1 (type: string)
               sort order: ++
-              Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 
(type: string)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -678,12 +678,12 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
       Reduce Operator Tree:
         Join Operator
@@ -693,11 +693,11 @@ STAGE PLANS:
             0 key (type: int)
             1 _col0 (type: int)
           outputColumnNames: _col1
-          Statistics: Num rows: 7 Data size: 56 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           Select Operator
             expressions: _col1 (type: string)
             outputColumnNames: _col0
-            Statistics: Num rows: 7 Data size: 56 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
             File Output Operator
               compressed: false
               table:
@@ -712,15 +712,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
-              Statistics: Num rows: 7 Data size: 56 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: string)
           outputColumnNames: _col0
-          Statistics: Num rows: 7 Data size: 56 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 7 Data size: 56 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -783,12 +783,12 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
       Reduce Operator Tree:
         Join Operator
@@ -798,11 +798,11 @@ STAGE PLANS:
             0 key (type: int)
             1 _col0 (type: int)
           outputColumnNames: _col1
-          Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           Select Operator
             expressions: _col1 (type: string)
             outputColumnNames: _col0
-            Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
             File Output Operator
               compressed: false
               table:
@@ -817,15 +817,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
-              Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: string)
           outputColumnNames: _col0
-          Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -885,12 +885,12 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
       Reduce Operator Tree:
         Join Operator
@@ -900,7 +900,7 @@ STAGE PLANS:
             0 key (type: int)
             1 _col0 (type: int)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 49 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 92 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
             table:
@@ -915,15 +915,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: int), _col1 (type: string)
               sort order: ++
-              Statistics: Num rows: 6 Data size: 49 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 12 Data size: 92 Basic stats: COMPLETE 
Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 
(type: string)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 49 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 92 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 6 Data size: 49 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 92 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -973,16 +973,16 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: int)
                   mode: hash
                   outputColumnNames: _col0
-                  Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                   HashTable Sink Operator
                     keys:
                       0 key (type: int)
@@ -996,7 +996,7 @@ STAGE PLANS:
             Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 11 Data size: 81 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
               Map Join Operator
                 condition map:
                      Left Semi Join 0 to 1
@@ -1004,21 +1004,21 @@ STAGE PLANS:
                   0 key (type: int)
                   1 _col0 (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 12 Data size: 89 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 24 Data size: 179 Basic stats: COMPLETE 
Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: int)
                   sort order: +
-                  Statistics: Num rows: 12 Data size: 89 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 24 Data size: 179 Basic stats: 
COMPLETE Column stats: NONE
       Local Work:
         Map Reduce Local Work
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: int)
           outputColumnNames: _col0
-          Statistics: Num rows: 12 Data size: 89 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 24 Data size: 179 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 12 Data size: 89 Basic stats: COMPLETE 
Column stats: NONE
+            Statistics: Num rows: 24 Data size: 179 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1077,33 +1077,33 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
           TableScan
             alias: b
             Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: (2 * key) is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: int)
                   mode: hash
                   outputColumnNames: _col0
-                  Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                   Reduce Output Operator
                     key expressions: (2 * _col0) (type: int)
                     sort order: +
                     Map-reduce partition columns: (2 * _col0) (type: int)
-                    Statistics: Num rows: 6 Data size: 45 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 11 Data size: 84 Basic stats: 
COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -1112,7 +1112,7 @@ STAGE PLANS:
             0 key (type: int)
             1 (2 * _col0) (type: int)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
             table:
@@ -1127,15 +1127,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: int), _col1 (type: string)
               sort order: ++
-              Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 
(type: string)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 6 Data size: 47 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 86 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1179,45 +1179,45 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
           TableScan
             alias: b
             Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
           TableScan
             alias: c
             Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 11 Data size: 81 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 11 Data size: 81 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: int)
                   mode: hash
                   outputColumnNames: _col0
-                  Statistics: Num rows: 11 Data size: 81 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 22 Data size: 163 Basic stats: 
COMPLETE Column stats: NONE
                   Reduce Output Operator
                     key expressions: _col0 (type: int)
                     sort order: +
                     Map-reduce partition columns: _col0 (type: int)
-                    Statistics: Num rows: 11 Data size: 81 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 22 Data size: 163 Basic stats: 
COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -1228,11 +1228,11 @@ STAGE PLANS:
             1 key (type: int)
             2 _col0 (type: int)
           outputColumnNames: _col0, _col1, _col5, _col6
-          Statistics: Num rows: 24 Data size: 178 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 48 Data size: 358 Basic stats: COMPLETE Column 
stats: NONE
           Select Operator
             expressions: _col0 (type: int), _col1 (type: string), _col5 (type: 
int), _col6 (type: string)
             outputColumnNames: _col0, _col1, _col2, _col3
-            Statistics: Num rows: 24 Data size: 178 Basic stats: COMPLETE 
Column stats: NONE
+            Statistics: Num rows: 48 Data size: 358 Basic stats: COMPLETE 
Column stats: NONE
             File Output Operator
               compressed: false
               table:
@@ -1247,16 +1247,16 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: int), _col1 (type: string)
               sort order: ++
-              Statistics: Num rows: 24 Data size: 178 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 48 Data size: 358 Basic stats: COMPLETE 
Column stats: NONE
               value expressions: _col2 (type: int), _col3 (type: string)
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 
(type: string), VALUE._col0 (type: int), VALUE._col1 (type: string)
           outputColumnNames: _col0, _col1, _col2, _col3
-          Statistics: Num rows: 24 Data size: 178 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 48 Data size: 358 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 24 Data size: 178 Basic stats: COMPLETE 
Column stats: NONE
+            Statistics: Num rows: 48 Data size: 358 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1312,32 +1312,32 @@ STAGE PLANS:
             Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: (key is not null and value is not null) (type: 
boolean)
-              Statistics: Num rows: 6 Data size: 44 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int), value (type: string)
                 sort order: ++
                 Map-reduce partition columns: key (type: int), value (type: 
string)
-                Statistics: Num rows: 6 Data size: 44 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
           TableScan
             alias: b
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: (key is not null and value is not null) (type: 
boolean)
-              Statistics: Num rows: 3 Data size: 21 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int), value (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 3 Data size: 21 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: int), _col1 (type: string)
                   mode: hash
                   outputColumnNames: _col0, _col1
-                  Statistics: Num rows: 3 Data size: 21 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                   Reduce Output Operator
                     key expressions: _col0 (type: int), _col1 (type: string)
                     sort order: ++
                     Map-reduce partition columns: _col0 (type: int), _col1 
(type: string)
-                    Statistics: Num rows: 3 Data size: 21 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 11 Data size: 79 Basic stats: 
COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -1346,7 +1346,7 @@ STAGE PLANS:
             0 key (type: int), value (type: string)
             1 _col0 (type: int), _col1 (type: string)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 48 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 24 Data size: 179 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
             table:
@@ -1361,15 +1361,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: int), _col1 (type: string)
               sort order: ++
-              Statistics: Num rows: 6 Data size: 48 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 24 Data size: 179 Basic stats: COMPLETE 
Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: int), KEY.reducesinkkey1 
(type: string)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 6 Data size: 48 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 24 Data size: 179 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 6 Data size: 48 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 24 Data size: 179 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1431,16 +1431,16 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: int)
                   mode: hash
                   outputColumnNames: _col0
-                  Statistics: Num rows: 6 Data size: 43 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 79 Basic stats: COMPLETE 
Column stats: NONE
                   HashTable Sink Operator
                     keys:
                       0 key (type: int)
@@ -1452,16 +1452,16 @@ STAGE PLANS:
             Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: int)
                   mode: hash
                   outputColumnNames: _col0
-                  Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                   HashTable Sink Operator
                     keys:
                       0 key (type: int)
@@ -1476,7 +1476,7 @@ STAGE PLANS:
             Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 11 Data size: 81 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
               Map Join Operator
                 condition map:
                      Left Semi Join 0 to 1
@@ -1486,21 +1486,21 @@ STAGE PLANS:
                   1 _col0 (type: int)
                   2 _col0 (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 24 Data size: 178 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 48 Data size: 358 Basic stats: COMPLETE 
Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: int)
                   sort order: +
-                  Statistics: Num rows: 24 Data size: 178 Basic stats: 
COMPLETE Column stats: NONE
+                  Statistics: Num rows: 48 Data size: 358 Basic stats: 
COMPLETE Column stats: NONE
       Local Work:
         Map Reduce Local Work
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: int)
           outputColumnNames: _col0
-          Statistics: Num rows: 24 Data size: 178 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 48 Data size: 358 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 24 Data size: 178 Basic stats: COMPLETE 
Column stats: NONE
+            Statistics: Num rows: 48 Data size: 358 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2361,33 +2361,33 @@ STAGE PLANS:
             Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 11 Data size: 81 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: key (type: int)
                 sort order: +
                 Map-reduce partition columns: key (type: int)
-                Statistics: Num rows: 11 Data size: 81 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
                 value expressions: value (type: string)
           TableScan
             alias: b
             Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: int)
                   mode: hash
                   outputColumnNames: _col0
-                  Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                   Reduce Output Operator
                     key expressions: _col0 (type: int)
                     sort order: +
                     Map-reduce partition columns: _col0 (type: int)
-                    Statistics: Num rows: 6 Data size: 45 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 11 Data size: 84 Basic stats: 
COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -2396,7 +2396,7 @@ STAGE PLANS:
             0 key (type: int)
             1 _col0 (type: int)
           outputColumnNames: _col0, _col1
-          Statistics: Num rows: 12 Data size: 89 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 24 Data size: 179 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
             table:
@@ -2412,7 +2412,7 @@ STAGE PLANS:
               key expressions: _col1 (type: string)
               sort order: +
               Map-reduce partition columns: _col1 (type: string)
-              Statistics: Num rows: 12 Data size: 89 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 24 Data size: 179 Basic stats: COMPLETE 
Column stats: NONE
               value expressions: _col0 (type: int)
           TableScan
             alias: c
@@ -2430,7 +2430,7 @@ STAGE PLANS:
             0 _col1 (type: string)
             1 value (type: string)
           outputColumnNames: _col0
-          Statistics: Num rows: 13 Data size: 97 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 26 Data size: 196 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
             table:
@@ -2445,15 +2445,15 @@ STAGE PLANS:
             Reduce Output Operator
               key expressions: _col0 (type: int)
               sort order: +
-              Statistics: Num rows: 13 Data size: 97 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 26 Data size: 196 Basic stats: COMPLETE 
Column stats: NONE
       Reduce Operator Tree:
         Select Operator
           expressions: KEY.reducesinkkey0 (type: int)
           outputColumnNames: _col0
-          Statistics: Num rows: 13 Data size: 97 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 26 Data size: 196 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 13 Data size: 97 Basic stats: COMPLETE 
Column stats: NONE
+            Statistics: Num rows: 26 Data size: 196 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -2529,37 +2529,37 @@ STAGE PLANS:
             Statistics: Num rows: 22 Data size: 163 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: ((key > 100) and value is not null) (type: boolean)
-              Statistics: Num rows: 4 Data size: 29 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 7 Data size: 51 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int), value (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 4 Data size: 29 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 7 Data size: 51 Basic stats: COMPLETE 
Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col1 (type: string)
                   sort order: +
                   Map-reduce partition columns: _col1 (type: string)
-                  Statistics: Num rows: 4 Data size: 29 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 7 Data size: 51 Basic stats: COMPLETE 
Column stats: NONE
                   value expressions: _col0 (type: int)
           TableScan
             alias: b
             Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: value is not null (type: boolean)
-              Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: value (type: string)
                 outputColumnNames: _col0
-                Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                 Group By Operator
                   keys: _col0 (type: string)
                   mode: hash
                   outputColumnNames: _col0
-                  Statistics: Num rows: 6 Data size: 45 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 11 Data size: 84 Basic stats: COMPLETE 
Column stats: NONE
                   Reduce Output Operator
                     key expressions: _col0 (type: string)
                     sort order: +
                     Map-reduce partition columns: _col0 (type: string)
-                    Statistics: Num rows: 6 Data size: 45 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 11 Data size: 84 Basic stats: 
COMPLETE Column stats: NONE
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -2568,10 +2568,10 @@ STAGE PLANS:
             0 _col1 (type: string)
             1 _col0 (type: string)
           outputColumnNames: _col0
-          Statistics: Num rows: 6 Data size: 49 Basic stats: COMPLETE Column 
stats: NONE
+          Statistics: Num rows: 12 Data size: 92 Basic stats: COMPLETE Column 
stats: NONE
           File Output Operator
             compressed: false
-            Statistics: Num rows: 6 Data size: 49 Basic stats: COMPLETE Column 
stats: NONE
+            Statistics: Num rows: 12 Data size: 92 Basic stats: COMPLETE 
Column stats: NONE
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

http://git-wip-us.apache.org/repos/asf/hive/blob/08f73adc/ql/src/test/results/clientpositive/skewjoin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/skewjoin.q.out 
b/ql/src/test/results/clientpositive/skewjoin.q.out
index 13c4470..947e67a 100644
--- a/ql/src/test/results/clientpositive/skewjoin.q.out
+++ b/ql/src/test/results/clientpositive/skewjoin.q.out
@@ -99,31 +99,31 @@ STAGE PLANS:
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string)
                 outputColumnNames: _col0
-                Statistics: Num rows: 250 Data size: 2656 Basic stats: 
COMPLETE Column stats: NONE
+                Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
                   Map-reduce partition columns: _col0 (type: string)
-                  Statistics: Num rows: 250 Data size: 2656 Basic stats: 
COMPLETE Column stats: NONE
+                  Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
           TableScan
             alias: src1
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 2656 Basic stats: 
COMPLETE Column stats: NONE
+                Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
                   Map-reduce partition columns: _col0 (type: string)
-                  Statistics: Num rows: 250 Data size: 2656 Basic stats: 
COMPLETE Column stats: NONE
+                  Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
                   value expressions: _col1 (type: string)
       Reduce Operator Tree:
         Join Operator
@@ -134,14 +134,14 @@ STAGE PLANS:
             0 _col0 (type: string)
             1 _col0 (type: string)
           outputColumnNames: _col0, _col2
-          Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE 
Column stats: NONE
+          Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE 
Column stats: NONE
           Select Operator
             expressions: UDFToInteger(_col0) (type: int), _col2 (type: string)
             outputColumnNames: _col0, _col1
-            Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE 
Column stats: NONE
+            Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE 
Column stats: NONE
             File Output Operator
               compressed: false
-              Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE 
Column stats: NONE
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -179,10 +179,10 @@ STAGE PLANS:
               Select Operator
                 expressions: UDFToInteger(_col0) (type: int), _col2 (type: 
string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 275 Data size: 2921 Basic stats: 
COMPLETE Column stats: NONE
+                Statistics: Num rows: 550 Data size: 5843 Basic stats: 
COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
-                  Statistics: Num rows: 275 Data size: 2921 Basic stats: 
COMPLETE Column stats: NONE
+                  Statistics: Num rows: 550 Data size: 5843 Basic stats: 
COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -495,12 +495,12 @@ STAGE PLANS:
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: (key + 1) is not null (type: boolean)
-              Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
               Reduce Output Operator
                 key expressions: (key + 1) (type: double)
                 sort order: +
                 Map-reduce partition columns: (key + 1) (type: double)
-                Statistics: Num rows: 250 Data size: 2656 Basic stats: 
COMPLETE Column stats: NONE
+                Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
                 value expressions: key (type: string)
       Reduce Operator Tree:
         Join Operator
@@ -510,7 +510,7 @@ STAGE PLANS:
             0 UDFToDouble(key) (type: double)
             1 (key + 1) (type: double)
           outputColumnNames: _col0, _col1, _col5
-          Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE 
Column stats: NONE
+          Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE 
Column stats: NONE
           Group By Operator
             aggregations: sum(hash(_col0)), sum(hash(_col1)), sum(hash(_col5))
             mode: hash
@@ -593,31 +593,31 @@ STAGE PLANS:
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string)
                 outputColumnNames: _col0
-                Statistics: Num rows: 250 Data size: 2656 Basic stats: 
COMPLETE Column stats: NONE
+                Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
                   Map-reduce partition columns: _col0 (type: string)
-                  Statistics: Num rows: 250 Data size: 2656 Basic stats: 
COMPLETE Column stats: NONE
+                  Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
           TableScan
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
               predicate: key is not null (type: boolean)
-              Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 250 Data size: 2656 Basic stats: 
COMPLETE Column stats: NONE
+                Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
                   Map-reduce partition columns: _col0 (type: string)
-                  Statistics: Num rows: 250 Data size: 2656 Basic stats: 
COMPLETE Column stats: NONE
+                  Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
                   value expressions: _col1 (type: string)
       Reduce Operator Tree:
         Join Operator
@@ -628,11 +628,11 @@ STAGE PLANS:
             0 _col0 (type: string)
             1 _col0 (type: string)
           outputColumnNames: _col1, _col2
-          Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE 
Column stats: NONE
+          Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE 
Column stats: NONE
           Select Operator
             expressions: hash(_col1) (type: int), hash(_col2) (type: int)
             outputColumnNames: _col0, _col1
-            Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE 
Column stats: NONE
+            Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE 
Column stats: NONE
             Group By Operator
               aggregations: sum(_col0), sum(_col1)
               mode: hash
@@ -676,7 +676,7 @@ STAGE PLANS:
               Select Operator
                 expressions: hash(_col1) (type: int), hash(_col2) (type: int)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 275 Data size: 2921 Basic stats: 
COMPLETE Column stats: NONE
+                Statistics: Num rows: 550 Data size: 5843 Basic stats: 
COMPLETE Column stats: NONE
                 Group By Operator
                   aggregations: sum(_col0), sum(_col1)
                   mode: hash
@@ -768,32 +768,32 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (key is not null and UDFToDouble(substring(value, 5)) 
is not null) (type: boolean)
-              Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE 
Column stats: NONE
+              predicate: ((value is not null and key is not null) and 
UDFToDouble(substring(value, 5)) is not null) (type: boolean)
+              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 125 Data size: 1328 Basic stats: 
COMPLETE Column stats: NONE
+                Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string), 
UDFToDouble(substring(_col1, 5)) (type: double)
                   sort order: ++
                   Map-reduce partition columns: _col0 (type: string), 
UDFToDouble(substring(_col1, 5)) (type: double)
-                  Statistics: Num rows: 125 Data size: 1328 Basic stats: 
COMPLETE Column stats: NONE
+                  Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
           TableScan
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (key is not null and (UDFToDouble(substring(value, 
5)) + 1.0) is not null) (type: boolean)
-              Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE 
Column stats: NONE
+              predicate: ((value is not null and key is not null) and 
(UDFToDouble(substring(value, 5)) + 1.0) is not null) (type: boolean)
+              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 125 Data size: 1328 Basic stats: 
COMPLETE Column stats: NONE
+                Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string), 
(UDFToDouble(substring(_col1, 5)) + 1.0) (type: double)
                   sort order: ++
                   Map-reduce partition columns: _col0 (type: string), 
(UDFToDouble(substring(_col1, 5)) + 1.0) (type: double)
-                  Statistics: Num rows: 125 Data size: 1328 Basic stats: 
COMPLETE Column stats: NONE
+                  Statistics: Num rows: 500 Data size: 5312 Basic stats: 
COMPLETE Column stats: NONE
                   value expressions: _col1 (type: string)
       Reduce Operator Tree:
         Join Operator
@@ -804,11 +804,11 @@ STAGE PLANS:
             0 _col0 (type: string), UDFToDouble(substring(_col1, 5)) (type: 
double)
             1 _col0 (type: string), (UDFToDouble(substring(_col1, 5)) + 1.0) 
(type: double)
           outputColumnNames: _col2, _col3
-          Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE 
Column stats: NONE
+          Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE 
Column stats: NONE
           Select Operator
             expressions: hash(_col2) (type: int), hash(_col3) (type: int)
             outputColumnNames: _col0, _col1
-            Statistics: Num rows: 137 Data size: 1460 Basic stats: COMPLETE 
Column stats: NONE
+            Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE 
Column stats: NONE
             Group By Operator
               aggregations: sum(_col0), sum(_col1)
               mode: hash
@@ -852,7 +852,7 @@ STAGE PLANS:
               Select Operator
                 expressions: hash(_col2) (type: int), hash(_col3) (type: int)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 137 Data size: 1460 Basic stats: 
COMPLETE Column stats: NONE
+                Statistics: Num rows: 550 Data size: 5843 Basic stats: 
COMPLETE Column stats: NONE
                 Group By Operator
                   aggregations: sum(_col0), sum(_col1)
                   mode: hash
@@ -937,26 +937,24 @@ JOIN
 ON src1.c1 = src3.c5 AND src3.c5 < 80
 POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
-  Stage-3 is a root stage
-  Stage-8 depends on stages: Stage-3 , consists of Stage-10, Stage-1
-  Stage-10
-  Stage-7 depends on stages: Stage-10
-  Stage-1 depends on stages: Stage-7
-  Stage-6 depends on stages: Stage-1 , consists of Stage-9, Stage-2
+  Stage-1 is a root stage
+  Stage-7 depends on stages: Stage-1 , consists of Stage-8, Stage-9, Stage-2
+  Stage-8
+  Stage-5 depends on stages: Stage-8
+  Stage-2 depends on stages: Stage-5, Stage-6
   Stage-9
-  Stage-5 depends on stages: Stage-9
-  Stage-2 depends on stages: Stage-5
+  Stage-6 depends on stages: Stage-9
   Stage-0 depends on stages: Stage-2
 
 STAGE PLANS:
-  Stage: Stage-3
+  Stage: Stage-1
     Map Reduce
       Map Operator Tree:
           TableScan
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: ((UDFToDouble(key) < 100.0) and (UDFToDouble(key) < 
80.0)) (type: boolean)
+              predicate: (((UDFToDouble(key) < 100.0) and (UDFToDouble(key) < 
80.0)) and key is not null) (type: boolean)
               Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: string)
@@ -971,111 +969,49 @@ STAGE PLANS:
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: ((UDFToDouble(key) < 100.0) and (UDFToDouble(key) < 
80.0)) (type: boolean)
+              predicate: (((UDFToDouble(key) < 80.0) and (UDFToDouble(key) < 
100.0)) and key is not null) (type: boolean)
               Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
-                expressions: key (type: string), value (type: string)
-                outputColumnNames: _col0, _col1
+                expressions: key (type: string)
+                outputColumnNames: _col0
                 Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE 
Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
                   Map-reduce partition columns: _col0 (type: string)
                   Statistics: Num rows: 55 Data size: 584 Basic stats: 
COMPLETE Column stats: NONE
-                  value expressions: _col1 (type: string)
-      Reduce Operator Tree:
-        Join Operator
-          condition map:
-               Inner Join 0 to 1
-          handleSkewJoin: true
-          keys:
-            0 _col0 (type: string)
-            1 _col0 (type: string)
-          outputColumnNames: _col0, _col2
-          Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE Column 
stats: NONE
-          File Output Operator
-            compressed: false
-            table:
-                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-
-  Stage: Stage-8
-    Conditional Operator
-
-  Stage: Stage-10
-    Map Reduce Local Work
-      Alias -> Map Local Tables:
-        1 
-          Fetch Operator
-            limit: -1
-      Alias -> Map Local Operator Tree:
-        1 
-          TableScan
-            HashTable Sink Operator
-              keys:
-                0 reducesinkkey0 (type: string)
-                1 reducesinkkey0 (type: string)
-
-  Stage: Stage-7
-    Map Reduce
-      Map Operator Tree:
-          TableScan
-            Map Join Operator
-              condition map:
-                   Inner Join 0 to 1
-              keys:
-                0 reducesinkkey0 (type: string)
-                1 reducesinkkey0 (type: string)
-              outputColumnNames: _col0, _col2
-              File Output Operator
-                compressed: false
-                table:
-                    input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
-                    output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    serde: 
org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
-      Local Work:
-        Map Reduce Local Work
-
-  Stage: Stage-1
-    Map Reduce
-      Map Operator Tree:
           TableScan
             alias: src
             Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE 
Column stats: NONE
             Filter Operator
-              predicate: (((UDFToDouble(key) < 80.0) and (UDFToDouble(key) < 
100.0)) and key is not null) (type: boolean)
-              Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE 
Column stats: NONE
+              predicate: (UDFToDouble(key) < 100.0) (type: boolean)
+              Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
-                expressions: key (type: string)
-                outputColumnNames: _col0
-                Statistics: Num rows: 28 Data size: 297 Basic stats: COMPLETE 
Column stats: NONE
+                expressions: key (type: string), value (type: string)
+                outputColumnNames: _col0, _col1
+                Statistics: Num rows: 166 Data size: 1763 Basic stats: 
COMPLETE Column stats: NONE
                 Reduce Output Operator
                   key expressions: _col0 (type: string)
                   sort order: +
                   Map-reduce partition columns: _col0 (type: string)
-                  Statistics: Num rows: 28 Data size: 297 Basic stats: 
COMPLETE Column stats: NONE
-          TableScan
-            Reduce Output Operator
-              key expressions: _col0 (type: string)
-              sort order: +
-              Map-reduce partition columns: _col0 (type: string)
-              Statistics: Num rows: 60 Data size: 642 Basic stats: COMPLETE 
Column stats: NONE
-              value expressions: _col2 (type: string)
+                  Statistics: Num rows: 166 Data size: 1763 Basic stats: 
COMPLETE Column stats: NONE
+                  value expressions: _col1 (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
+               Inner Join 0 to 2
           handleSkewJoin: true
           keys:
             0 _col0 (type: string)
             1 _col0 (type: string)
-          outputColumnNames: _col1, _col3
-          Statistics: Num rows: 66 Data size: 706 Basic stats: COMPLETE Column 
stats: NONE
+            2 _col0 (type: string)
+          outputColumnNames: _col0, _col3
+          Statistics: Num rows: 365 Data size: 3878 Basic stats: COMPLETE 
Column stats: NONE
           Select Operator
-            expressions: hash(_col1) (type: int), hash(_col3) (type: int)
+            expressions: hash(_col0) (type: int), hash(_col3) (type: int)
             outputColumnNames: _col0, _col1
-            Statistics: Num rows: 66 Data size: 706 Basic stats: COMPLETE 
Column stats: NONE
+            Statistics: Num rows: 365 Data size: 3878 Basic stats: COMPLETE 
Column stats: NONE
             Group By Operator
               aggregations: sum(_col0), sum(_col1)
               mode: hash
@@ -1088,15 +1024,18 @@ STAGE PLANS:
                     output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     serde: 
org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
 
-  Stage: Stage-6
+  Stage: Stage-7
     Conditional Operator
 
-  Stage: Stage-9
+  Stage: Stage-8
     Map Reduce Local Work
       Alias -> Map Local Tables:
         1 
           Fetch Operator
             limit: -1
+        2 
+          Fetch Operator
+            limit: -1
       Alias -> Map Local Operator Tree:
         1 
           TableScan
@@ -1104,6 +1043,14 @@ STAGE PLANS:
               keys:
                 0 reducesinkkey0 (type: string)
                 1 reducesinkkey0 (type: string)
+                2 reducesinkkey0 (type: string)
+        2 
+          TableScan
+            HashTable Sink Operator
+              keys:
+                0 reducesinkkey0 (type: string)
+                1 reducesinkkey0 (type: string)
+                2 reducesinkkey0 (type: string)
 
   Stage: Stage-5
     Map Reduce
@@ -1112,14 +1059,16 @@ STAGE PLANS:
             Map Join Operator
               condition map:
                    Inner Join 0 to 1
+                   Inner Join 0 to 2
               keys:
                 0 reducesinkkey0 (type: string)
                 1 reducesinkkey0 (type: string)
-              outputColumnNames: _col1, _col3
+                2 reducesinkkey0 (type: string)
+              outputColumnNames: _col0, _col3
               Select Operator
-                expressions: hash(_col1) (type: int), hash(_col3) (type: int)
+                expressions: hash(_col0) (type: int), hash(_col3) (type: int)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 66 Data size: 706 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 365 Data size: 3878 Basic stats: 
COMPLETE Column stats: NONE
                 Group By Operator
                   aggregations: sum(_col0), sum(_col1)
                   mode: hash
@@ -1156,6 +1105,62 @@ STAGE PLANS:
                 output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 
+  Stage: Stage-9
+    Map Reduce Local Work
+      Alias -> Map Local Tables:
+        0 
+          Fetch Operator
+            limit: -1
+        2 
+          Fetch Operator
+            limit: -1
+      Alias -> Map Local Operator Tree:
+        0 
+          TableScan
+            HashTable Sink Operator
+              keys:
+                0 reducesinkkey0 (type: string)
+                1 reducesinkkey0 (type: string)
+                2 reducesinkkey0 (type: string)
+        2 
+          TableScan
+            HashTable Sink Operator
+              keys:
+                0 reducesinkkey0 (type: string)
+                1 reducesinkkey0 (type: string)
+                2 reducesinkkey0 (type: string)
+
+  Stage: Stage-6
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            Map Join Operator
+              condition map:
+                   Inner Join 0 to 1
+                   Inner Join 0 to 2
+              keys:
+                0 reducesinkkey0 (type: string)
+                1 reducesinkkey0 (type: string)
+                2 reducesinkkey0 (type: string)
+              outputColumnNames: _col0, _col3
+              Select Operator
+                expressions: hash(_col0) (type: int), hash(_col3) (type: int)
+                outputColumnNames: _col0, _col1
+                Statistics: Num rows: 365 Data size: 3878 Basic stats: 
COMPLETE Column stats: NONE
+                Group By Operator
+                  aggregations: sum(_col0), sum(_col1)
+                  mode: hash
+                  outputColumnNames: _col0, _col1
+                  Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE 
Column stats: NONE
+                  File Output Operator
+                    compressed: false
+                    table:
+                        input format: 
org.apache.hadoop.mapred.SequenceFileInputFormat
+                        output format: 
org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                        serde: 
org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+      Local Work:
+        Map Reduce Local Work
+
   Stage: Stage-0
     Fetch Operator
       limit: -1

http://git-wip-us.apache.org/repos/asf/hive/blob/08f73adc/ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out 
b/ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out
index faba29e..de1ddcb 100644
--- a/ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out
+++ b/ql/src/test/results/clientpositive/skewjoin_mapjoin10.q.out
@@ -112,11 +112,11 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column 
stats: NONE
             Filter Operator
               predicate: (key is not null and ((key = 2) or (key = 3))) (type: 
boolean)
-              Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int), val (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE 
Column stats: NONE
                 HashTable Sink Operator
                   keys:
                     0 _col0 (type: int)
@@ -145,11 +145,11 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column 
stats: NONE
             Filter Operator
               predicate: (key is not null and ((key = 2) or (key = 3))) (type: 
boolean)
-              Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int), val (type: string)
                 outputColumnNames: _col0, _col1
-                Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE 
Column stats: NONE
                 Map Join Operator
                   condition map:
                        Inner Join 0 to 1
@@ -157,12 +157,12 @@ STAGE PLANS:
                     0 _col0 (type: int)
                     1 _col0 (type: int)
                   outputColumnNames: _col0, _col1, _col2, _col3
-                  Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 6 Data size: 26 Basic stats: COMPLETE 
Column stats: NONE
                   Union
-                    Statistics: Num rows: 3 Data size: 12 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 7 Data size: 30 Basic stats: 
COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 3 Data size: 12 Basic stats: 
COMPLETE Column stats: NONE
+                      Statistics: Num rows: 7 Data size: 30 Basic stats: 
COMPLETE Column stats: NONE
                       table:
                           input format: 
org.apache.hadoop.mapred.TextInputFormat
                           output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -186,10 +186,10 @@ STAGE PLANS:
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE 
Column stats: NONE
                   Union
-                    Statistics: Num rows: 3 Data size: 12 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 7 Data size: 30 Basic stats: 
COMPLETE Column stats: NONE
                     File Output Operator
                       compressed: false
-                      Statistics: Num rows: 3 Data size: 12 Basic stats: 
COMPLETE Column stats: NONE
+                      Statistics: Num rows: 7 Data size: 30 Basic stats: 
COMPLETE Column stats: NONE
                       table:
                           input format: 
org.apache.hadoop.mapred.TextInputFormat
                           output format: 
org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -396,11 +396,11 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column 
stats: NONE
             Filter Operator
               predicate: (key is not null and ((key = 2) or (key = 3))) (type: 
boolean)
-              Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE 
Column stats: NONE
                 HashTable Sink Operator
                   keys:
                     0 _col0 (type: int)
@@ -429,20 +429,20 @@ STAGE PLANS:
             Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE Column 
stats: NONE
             Filter Operator
               predicate: (key is not null and ((key = 2) or (key = 3))) (type: 
boolean)
-              Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+              Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE 
Column stats: NONE
               Select Operator
                 expressions: key (type: int)
                 outputColumnNames: _col0
-                Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 6 Data size: 24 Basic stats: COMPLETE 
Column stats: NONE
                 Map Join Operator
                   condition map:
                        Inner Join 0 to 1
                   keys:
                     0 _col0 (type: int)
                     1 _col0 (type: int)
-                  Statistics: Num rows: 2 Data size: 8 Basic stats: COMPLETE 
Column stats: NONE
+                  Statistics: Num rows: 6 Data size: 26 Basic stats: COMPLETE 
Column stats: NONE
                   Union
-                    Statistics: Num rows: 3 Data size: 12 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 7 Data size: 30 Basic stats: 
COMPLETE Column stats: NONE
                     Group By Operator
                       aggregations: count(1)
                       mode: hash
@@ -470,7 +470,7 @@ STAGE PLANS:
                     1 _col0 (type: int)
                   Statistics: Num rows: 1 Data size: 4 Basic stats: COMPLETE 
Column stats: NONE
                   Union
-                    Statistics: Num rows: 3 Data size: 12 Basic stats: 
COMPLETE Column stats: NONE
+                    Statistics: Num rows: 7 Data size: 30 Basic stats: 
COMPLETE Column stats: NONE
                     Group By Operator
                       aggregations: count(1)
                       mode: hash

Reply via email to