hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1600719 [5/40] - in /hive/trunk: contrib/src/test/results/clientpositive/ hbase-handler/src/test/results/positive/ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/ ql/src/java/org/apache/h...
Date Thu, 05 Jun 2014 18:28:15 GMT
Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer15.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer15.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer15.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer15.q.out Thu Jun  5 18:28:07 2014
@@ -41,7 +41,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -55,7 +54,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 2 Data size: 237 Basic stats: COMPLETE Column stats: NONE
@@ -115,21 +114,20 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 1 Data size: 118 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
+            1 {KEY.reducesinkkey0}
           outputColumnNames: _col0, _col1, _col2
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -151,9 +149,10 @@ STAGE PLANS:
               key expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: string)
               sort order: +++
               Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: string)
       Reduce Operator Tree:
-        Extract
+        Select Operator
+          expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: bigint), KEY.reducesinkkey2 (type: string)
+          outputColumnNames: _col0, _col1, _col2
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
             compressed: false
@@ -254,7 +253,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: x
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -263,7 +261,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -279,7 +276,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -305,8 +302,8 @@ STAGE PLANS:
                         condition map:
                              Inner Join 0 to 1
                         condition expressions:
-                          0 {VALUE._col0} {VALUE._col1}
-                          1 {VALUE._col0}
+                          0 {KEY.reducesinkkey0} {VALUE._col0}
+                          1 {KEY.reducesinkkey0}
                         outputColumnNames: _col0, _col1, _col2
                         Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                         Select Operator
@@ -326,8 +323,8 @@ STAGE PLANS:
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {VALUE._col0} {VALUE._col1}
-                1 {VALUE._col0}
+                0 {KEY.reducesinkkey0} {VALUE._col0}
+                1 {KEY.reducesinkkey0}
               outputColumnNames: _col0, _col1, _col2
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer2.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer2.q.out Thu Jun  5 18:28:07 2014
@@ -81,21 +81,21 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
           TableScan
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
+            1 {KEY.reducesinkkey0} {VALUE._col0}
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics: Num rows: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -285,8 +285,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -320,8 +320,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -464,21 +464,21 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
           TableScan
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Left Outer Join0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
+            1 {KEY.reducesinkkey0} {VALUE._col0}
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics: Num rows: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -668,8 +668,8 @@ STAGE PLANS:
                   condition map:
                        Left Outer Join0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -703,8 +703,8 @@ STAGE PLANS:
                   condition map:
                        Left Outer Join0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -847,21 +847,21 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
           TableScan
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Right Outer Join0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
+            1 {KEY.reducesinkkey0} {VALUE._col0}
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics: Num rows: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -1051,8 +1051,8 @@ STAGE PLANS:
                   condition map:
                        Right Outer Join0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -1086,8 +1086,8 @@ STAGE PLANS:
                   condition map:
                        Right Outer Join0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -1230,21 +1230,21 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
           TableScan
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Outer Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
+            1 {KEY.reducesinkkey0} {VALUE._col0}
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics: Num rows: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -1434,8 +1434,8 @@ STAGE PLANS:
                   condition map:
                        Outer Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -1469,8 +1469,8 @@ STAGE PLANS:
                   condition map:
                        Outer Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -1620,13 +1620,12 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Outer Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 15 Data size: 3085 Basic stats: COMPLETE Column stats: NONE
@@ -1862,7 +1861,7 @@ STAGE PLANS:
                   condition map:
                        Outer Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0}
+                    0 {KEY.reducesinkkey0}
                     1 
                   outputColumnNames: _col0
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1898,7 +1897,7 @@ STAGE PLANS:
                   condition map:
                        Outer Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0}
+                    0 {KEY.reducesinkkey0}
                     1 
                   outputColumnNames: _col0
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -2084,21 +2083,21 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
           TableScan
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: string)
+              value expressions: _col1 (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
+            1 {KEY.reducesinkkey0} {VALUE._col0}
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics: Num rows: 69 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -2154,7 +2153,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string), value (type: string)
+              value expressions: value (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2168,7 +2167,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
             1 
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -2258,7 +2257,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string), value (type: string)
+              value expressions: value (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2274,7 +2273,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0} {VALUE._col1}
+              0 {KEY.reducesinkkey0} {VALUE._col0}
               1 
             outputColumnNames: _col0, _col1
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -2288,8 +2287,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -2323,8 +2322,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer3.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer3.q.out Thu Jun  5 18:28:07 2014
@@ -46,7 +46,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -60,7 +59,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -118,7 +117,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 31 Data size: 3145 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
           TableScan
             Reduce Output Operator
               key expressions: _col0 (type: string)
@@ -131,8 +130,8 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
+            1 {VALUE._col0}
           outputColumnNames: _col0, _col1, _col3
           Statistics: Num rows: 69 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -196,13 +195,13 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string), value (type: string)
+              value expressions: value (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
             1 
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -273,7 +272,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: x
             Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -282,7 +280,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string), value (type: string)
+              value expressions: value (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -306,7 +304,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -332,8 +330,8 @@ STAGE PLANS:
                         condition map:
                              Inner Join 0 to 1
                         condition expressions:
-                          0 {VALUE._col0} {VALUE._col1}
-                          1 {VALUE._col1}
+                          0 {KEY.reducesinkkey0} {VALUE._col0}
+                          1 {VALUE._col0}
                         outputColumnNames: _col0, _col1, _col3
                         Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                         Select Operator
@@ -355,7 +353,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0} {VALUE._col1}
+              0 {KEY.reducesinkkey0} {VALUE._col0}
               1 
             outputColumnNames: _col0, _col1
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -369,8 +367,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -574,8 +572,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -599,8 +597,8 @@ STAGE PLANS:
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {VALUE._col0} {VALUE._col1}
-                1 {VALUE._col1}
+                0 {KEY.reducesinkkey0} {VALUE._col0}
+                1 {VALUE._col0}
               outputColumnNames: _col0, _col1, _col3
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
@@ -704,7 +702,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string), value (type: string)
+              value expressions: value (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -718,7 +716,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
             1 
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -749,14 +747,14 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 31 Data size: 3145 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {VALUE._col0}
+            1 {KEY.reducesinkkey0} {VALUE._col0}
           outputColumnNames: _col1, _col2, _col3
           Statistics: Num rows: 69 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -820,13 +818,12 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -931,7 +928,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 1 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string), value (type: string)
+              value expressions: value (type: string)
           TableScan
             alias: x
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -940,7 +937,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -964,7 +960,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0} {VALUE._col1}
+              0 {KEY.reducesinkkey0} {VALUE._col0}
               1 
             outputColumnNames: _col0, _col1
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -978,8 +974,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -1001,7 +997,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1027,8 +1023,8 @@ STAGE PLANS:
                         condition map:
                              Inner Join 0 to 1
                         condition expressions:
-                          0 {VALUE._col1}
-                          1 {VALUE._col0} {VALUE._col1}
+                          0 {VALUE._col0}
+                          1 {KEY.reducesinkkey0} {VALUE._col0}
                         outputColumnNames: _col1, _col2, _col3
                         Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                         Select Operator
@@ -1222,8 +1218,8 @@ STAGE PLANS:
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {VALUE._col1}
-                1 {VALUE._col0} {VALUE._col1}
+                0 {VALUE._col0}
+                1 {KEY.reducesinkkey0} {VALUE._col0}
               outputColumnNames: _col1, _col2, _col3
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
@@ -1257,8 +1253,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer4.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer4.q.out Thu Jun  5 18:28:07 2014
@@ -97,7 +97,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -105,7 +104,7 @@ STAGE PLANS:
                Inner Join 1 to 2
           condition expressions:
             0 
-            1 {VALUE._col0}
+            1 {KEY.reducesinkkey0}
             2 
           outputColumnNames: _col4
           Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
@@ -255,7 +254,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
       Reduce Operator Tree:
         Demux Operator
           Statistics: Num rows: 21 Data size: 90 Basic stats: COMPLETE Column stats: NONE
@@ -265,7 +263,7 @@ STAGE PLANS:
                  Inner Join 1 to 2
             condition expressions:
               0 
-              1 {VALUE._col0}
+              1 {KEY.reducesinkkey0}
               2 
             outputColumnNames: _col4
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -552,7 +550,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
           TableScan
             alias: z
             Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
@@ -575,7 +572,7 @@ STAGE PLANS:
                Left Outer Join0 to 1
                Left Outer Join1 to 2
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
             2 
           outputColumnNames: _col0
@@ -710,7 +707,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
           TableScan
             alias: z
             Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
@@ -735,7 +731,7 @@ STAGE PLANS:
                  Left Outer Join0 to 1
                  Left Outer Join1 to 2
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
               2 
             outputColumnNames: _col0
@@ -871,7 +867,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -879,7 +874,7 @@ STAGE PLANS:
                Left Outer Join1 to 2
           condition expressions:
             0 
-            1 {VALUE._col0}
+            1 {KEY.reducesinkkey0}
             2 
           outputColumnNames: _col4
           Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
@@ -1026,7 +1021,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
           TableScan
             alias: y
             Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
@@ -1043,7 +1037,7 @@ STAGE PLANS:
           condition expressions:
             0 
             1 
-            2 {VALUE._col0}
+            2 {KEY.reducesinkkey0}
           outputColumnNames: _col8
           Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -1184,7 +1178,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
           TableScan
             alias: y
             Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
@@ -1203,7 +1196,7 @@ STAGE PLANS:
             condition expressions:
               0 
               1 
-              2 {VALUE._col0}
+              2 {KEY.reducesinkkey0}
             outputColumnNames: _col8
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
             Select Operator
@@ -1337,7 +1330,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -1345,7 +1337,7 @@ STAGE PLANS:
                Right Outer Join1 to 2
           condition expressions:
             0 
-            1 {VALUE._col0}
+            1 {KEY.reducesinkkey0}
             2 
           outputColumnNames: _col4
           Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
@@ -1500,7 +1492,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -1508,7 +1499,7 @@ STAGE PLANS:
                Outer Join 1 to 2
           condition expressions:
             0 
-            1 {VALUE._col0}
+            1 {KEY.reducesinkkey0}
             2 
           outputColumnNames: _col4
           Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE
@@ -1659,7 +1650,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 7 Data size: 30 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -1667,7 +1657,7 @@ STAGE PLANS:
                Outer Join 1 to 2
           condition expressions:
             0 
-            1 {VALUE._col0}
+            1 {KEY.reducesinkkey0}
             2 
           outputColumnNames: _col4
           Statistics: Num rows: 15 Data size: 66 Basic stats: COMPLETE Column stats: NONE

Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer5.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer5.q.out Thu Jun  5 18:28:07 2014
@@ -120,7 +120,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 54 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
           TableScan
             alias: n
             Statistics: Num rows: 2 Data size: 280 Basic stats: COMPLETE Column stats: NONE
@@ -135,8 +134,8 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
-            1 {VALUE._col1}
+            0 {KEY.reducesinkkey0}
+            1 {VALUE._col0}
           outputColumnNames: _col0, _col5
           Statistics: Num rows: 59 Data size: 237 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -166,14 +165,13 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: int)
               Statistics: Num rows: 1598 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: int)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
-            1 {VALUE._col1}
+            0 {KEY.reducesinkkey0}
+            1 {VALUE._col0}
           outputColumnNames: _col0, _col3
           Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -213,7 +211,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
           TableScan
             alias: y
             Statistics: Num rows: 1447 Data size: 5791 Basic stats: COMPLETE Column stats: NONE
@@ -227,7 +224,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 1598 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -305,7 +302,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 54 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
           TableScan
             alias: x
             Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -314,7 +310,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: int)
               Statistics: Num rows: 1453 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: int)
           TableScan
             alias: n
             Statistics: Num rows: 2 Data size: 280 Basic stats: COMPLETE Column stats: NONE
@@ -339,7 +334,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -353,8 +348,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0}
-                    1 {VALUE._col1}
+                    0 {KEY.reducesinkkey0}
+                    1 {VALUE._col0}
                   outputColumnNames: _col0, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -373,8 +368,8 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
-              1 {VALUE._col1}
+              0 {KEY.reducesinkkey0}
+              1 {VALUE._col0}
             outputColumnNames: _col0, _col5
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
             Select Operator
@@ -387,8 +382,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0}
-                    1 {VALUE._col1}
+                    0 {KEY.reducesinkkey0}
+                    1 {VALUE._col0}
                   outputColumnNames: _col0, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -649,14 +644,13 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: int)
               Statistics: Num rows: 1598 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: int)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
-            1 {VALUE._col1}
+            0 {KEY.reducesinkkey0}
+            1 {VALUE._col0}
           outputColumnNames: _col0, _col3
           Statistics: Num rows: 1757 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
           Select Operator

Modified: hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer6.q.out?rev=1600719&r1=1600718&r2=1600719&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/correlationoptimizer6.q.out Thu Jun  5 18:28:07 2014
@@ -44,7 +44,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -58,7 +57,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -116,21 +115,21 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 31 Data size: 3145 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
           TableScan
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 1 Data size: 118 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
+            1 {KEY.reducesinkkey0} {VALUE._col0}
           outputColumnNames: _col0, _col1, _col2, _col3
           Statistics: Num rows: 34 Data size: 3459 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -156,7 +155,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -170,7 +168,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 2 Data size: 237 Basic stats: COMPLETE Column stats: NONE
@@ -292,7 +290,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -309,7 +306,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -325,7 +321,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -351,8 +347,8 @@ STAGE PLANS:
                         condition map:
                              Inner Join 0 to 1
                         condition expressions:
-                          0 {VALUE._col0} {VALUE._col1}
-                          1 {VALUE._col0} {VALUE._col1}
+                          0 {KEY.reducesinkkey0} {VALUE._col0}
+                          1 {KEY.reducesinkkey0} {VALUE._col0}
                         outputColumnNames: _col0, _col1, _col2, _col3
                         Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                         Select Operator
@@ -370,7 +366,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -396,8 +392,8 @@ STAGE PLANS:
                         condition map:
                              Inner Join 0 to 1
                         condition expressions:
-                          0 {VALUE._col0} {VALUE._col1}
-                          1 {VALUE._col0} {VALUE._col1}
+                          0 {KEY.reducesinkkey0} {VALUE._col0}
+                          1 {KEY.reducesinkkey0} {VALUE._col0}
                         outputColumnNames: _col0, _col1, _col2, _col3
                         Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                         Select Operator
@@ -594,8 +590,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -625,8 +621,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col2, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -757,7 +753,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
           TableScan
             alias: xx
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -766,14 +762,13 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0}
+            1 {KEY.reducesinkkey0} {VALUE._col0}
           outputColumnNames: _col0, _col4, _col5
           Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -876,7 +871,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
       Reduce Operator Tree:
         Demux Operator
           Statistics: Num rows: 60 Data size: 6028 Basic stats: COMPLETE Column stats: NONE
@@ -886,8 +880,8 @@ STAGE PLANS:
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {VALUE._col0}
-                1 {VALUE._col0} {VALUE._col1}
+                0 {KEY.reducesinkkey0}
+                1 {KEY.reducesinkkey0} {VALUE._col0}
               outputColumnNames: _col0, _col4, _col5
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
@@ -917,8 +911,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0}
-                    1 {VALUE._col0} {VALUE._col1}
+                    0 {KEY.reducesinkkey0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0}
                   outputColumnNames: _col0, _col4, _col5
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -1010,7 +1004,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -1024,7 +1017,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -1082,7 +1075,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 31 Data size: 3145 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
           TableScan
             alias: xx
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -1091,14 +1084,13 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0}
+            1 {KEY.reducesinkkey0} {VALUE._col0}
           outputColumnNames: _col0, _col4, _col5
           Statistics: Num rows: 34 Data size: 3459 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -1182,7 +1174,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -1199,7 +1190,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
       Reduce Operator Tree:
         Demux Operator
           Statistics: Num rows: 118 Data size: 11840 Basic stats: COMPLETE Column stats: NONE
@@ -1209,8 +1199,8 @@ STAGE PLANS:
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {VALUE._col0}
-                1 {VALUE._col0} {VALUE._col1}
+                0 {KEY.reducesinkkey0}
+                1 {KEY.reducesinkkey0} {VALUE._col0}
               outputColumnNames: _col0, _col4, _col5
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
@@ -1228,7 +1218,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1254,8 +1244,8 @@ STAGE PLANS:
                         condition map:
                              Inner Join 0 to 1
                         condition expressions:
-                          0 {VALUE._col0}
-                          1 {VALUE._col0} {VALUE._col1}
+                          0 {KEY.reducesinkkey0}
+                          1 {KEY.reducesinkkey0} {VALUE._col0}
                         outputColumnNames: _col0, _col4, _col5
                         Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                         Select Operator
@@ -1347,7 +1337,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -1361,7 +1350,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 2 Data size: 237 Basic stats: COMPLETE Column stats: NONE
@@ -1421,21 +1410,20 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 1 Data size: 118 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
+            1 {KEY.reducesinkkey0}
           outputColumnNames: _col0, _col1, _col2
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -1541,7 +1529,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: x
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -1550,7 +1537,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -1566,7 +1552,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -1592,8 +1578,8 @@ STAGE PLANS:
                         condition map:
                              Inner Join 0 to 1
                         condition expressions:
-                          0 {VALUE._col0} {VALUE._col1}
-                          1 {VALUE._col0}
+                          0 {KEY.reducesinkkey0} {VALUE._col0}
+                          1 {KEY.reducesinkkey0}
                         outputColumnNames: _col0, _col1, _col2
                         Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                         Select Operator
@@ -1613,8 +1599,8 @@ STAGE PLANS:
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {VALUE._col0} {VALUE._col1}
-                1 {VALUE._col0}
+                0 {KEY.reducesinkkey0} {VALUE._col0}
+                1 {KEY.reducesinkkey0}
               outputColumnNames: _col0, _col1, _col2
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
@@ -1730,7 +1716,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -1744,7 +1729,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -1810,7 +1795,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 31 Data size: 3145 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
           TableScan
             alias: xx
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -1819,16 +1804,15 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
                Inner Join 1 to 2
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
-            2 {VALUE._col0} {VALUE._col1}
+            2 {KEY.reducesinkkey0} {VALUE._col0}
           outputColumnNames: _col0, _col8, _col9
           Statistics: Num rows: 127 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -1952,7 +1936,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -1969,7 +1952,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
       Reduce Operator Tree:
         Demux Operator
           Statistics: Num rows: 176 Data size: 17652 Basic stats: COMPLETE Column stats: NONE
@@ -1980,9 +1962,9 @@ STAGE PLANS:
                    Inner Join 0 to 1
                    Inner Join 1 to 2
               condition expressions:
-                0 {VALUE._col0}
+                0 {KEY.reducesinkkey0}
                 1 
-                2 {VALUE._col0} {VALUE._col1}
+                2 {KEY.reducesinkkey0} {VALUE._col0}
               outputColumnNames: _col0, _col8, _col9
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
@@ -2000,7 +1982,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -2027,9 +2009,9 @@ STAGE PLANS:
                              Inner Join 0 to 1
                              Inner Join 1 to 2
                         condition expressions:
-                          0 {VALUE._col0}
+                          0 {KEY.reducesinkkey0}
                           1 
-                          2 {VALUE._col0} {VALUE._col1}
+                          2 {KEY.reducesinkkey0} {VALUE._col0}
                         outputColumnNames: _col0, _col8, _col9
                         Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                         Select Operator
@@ -2147,7 +2129,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2161,7 +2142,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -2227,7 +2208,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 31 Data size: 3145 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
           TableScan
             alias: xx
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -2236,15 +2217,14 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
                Inner Join 1 to 2
           condition expressions:
-            0 {VALUE._col0}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0}
+            1 {KEY.reducesinkkey0} {VALUE._col0}
             2 
           outputColumnNames: _col0, _col4, _col5
           Statistics: Num rows: 127 Data size: 12786 Basic stats: COMPLETE Column stats: NONE
@@ -2363,7 +2343,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2380,7 +2359,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
       Reduce Operator Tree:
         Demux Operator
           Statistics: Num rows: 176 Data size: 17652 Basic stats: COMPLETE Column stats: NONE
@@ -2391,8 +2369,8 @@ STAGE PLANS:
                    Inner Join 0 to 1
                    Inner Join 1 to 2
               condition expressions:
-                0 {VALUE._col0}
-                1 {VALUE._col0} {VALUE._col1}
+                0 {KEY.reducesinkkey0}
+                1 {KEY.reducesinkkey0} {VALUE._col0}
                 2 
               outputColumnNames: _col0, _col4, _col5
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -2411,7 +2389,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -2438,8 +2416,8 @@ STAGE PLANS:
                              Inner Join 0 to 1
                              Inner Join 1 to 2
                         condition expressions:
-                          0 {VALUE._col0}
-                          1 {VALUE._col0} {VALUE._col1}
+                          0 {KEY.reducesinkkey0}
+                          1 {KEY.reducesinkkey0} {VALUE._col0}
                           2 
                         outputColumnNames: _col0, _col4, _col5
                         Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -2607,14 +2585,14 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
+            1 {VALUE._col0}
           outputColumnNames: _col0, _col1, _col3
           Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -2671,7 +2649,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 15 Data size: 1546 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: bigint)
+              value expressions: _col1 (type: bigint), _col2 (type: bigint)
           TableScan
             alias: z
             Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2680,14 +2658,14 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string), value (type: string)
+              value expressions: value (type: string)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1} {VALUE._col2}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+            1 {KEY.reducesinkkey0} {VALUE._col0}
           outputColumnNames: _col0, _col1, _col2, _col3, _col4
           Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -2860,7 +2838,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string), value (type: string)
+              value expressions: value (type: string)
           TableScan
             alias: x
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -2899,8 +2877,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -2925,8 +2903,8 @@ STAGE PLANS:
                               condition map:
                                    Inner Join 0 to 1
                               condition expressions:
-                                0 {VALUE._col0} {VALUE._col1} {VALUE._col2}
-                                1 {VALUE._col0} {VALUE._col1}
+                                0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+                                1 {KEY.reducesinkkey0} {VALUE._col0}
                               outputColumnNames: _col0, _col1, _col2, _col3, _col4
                               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                               Select Operator
@@ -2956,8 +2934,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col1}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {VALUE._col0}
                   outputColumnNames: _col0, _col1, _col3
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -2982,8 +2960,8 @@ STAGE PLANS:
                               condition map:
                                    Inner Join 0 to 1
                               condition expressions:
-                                0 {VALUE._col0} {VALUE._col1} {VALUE._col2}
-                                1 {VALUE._col0} {VALUE._col1}
+                                0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+                                1 {KEY.reducesinkkey0} {VALUE._col0}
                               outputColumnNames: _col0, _col1, _col2, _col3, _col4
                               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                               Select Operator
@@ -3003,8 +2981,8 @@ STAGE PLANS:
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {VALUE._col0} {VALUE._col1} {VALUE._col2}
-                1 {VALUE._col0} {VALUE._col1}
+                0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
+                1 {KEY.reducesinkkey0} {VALUE._col0}
               outputColumnNames: _col0, _col1, _col2, _col3, _col4
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
@@ -3129,7 +3107,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string), value (type: string)
+              value expressions: value (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -3143,7 +3121,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
             1 
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -3201,21 +3179,21 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 31 Data size: 3145 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
+              value expressions: _col1 (type: string), _col2 (type: bigint)
           TableScan
             Reduce Output Operator
               key expressions: _col0 (type: string)
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 1 Data size: 118 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint)
+              value expressions: _col1 (type: bigint)
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
+            1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
           outputColumnNames: _col0, _col1, _col2, _col3, _col4
           Statistics: Num rows: 34 Data size: 3459 Basic stats: COMPLETE Column stats: NONE
           Select Operator
@@ -3237,9 +3215,10 @@ STAGE PLANS:
               key expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: string), _col3 (type: string), _col4 (type: bigint)
               sort order: +++++
               Statistics: Num rows: 34 Data size: 3459 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: bigint), _col2 (type: string), _col3 (type: string), _col4 (type: bigint)
       Reduce Operator Tree:
-        Extract
+        Select Operator
+          expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: bigint), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: bigint)
+          outputColumnNames: _col0, _col1, _col2, _col3, _col4
           Statistics: Num rows: 34 Data size: 3459 Basic stats: COMPLETE Column stats: NONE
           File Output Operator
             compressed: false
@@ -3260,7 +3239,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -3274,7 +3252,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0}
+            0 {KEY.reducesinkkey0}
             1 
           outputColumnNames: _col0
           Statistics: Num rows: 2 Data size: 237 Basic stats: COMPLETE Column stats: NONE
@@ -3398,7 +3376,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string), value (type: string)
+              value expressions: value (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE
@@ -3412,7 +3390,7 @@ STAGE PLANS:
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
+            0 {KEY.reducesinkkey0} {VALUE._col0}
             1 
           outputColumnNames: _col0, _col1
           Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
@@ -3470,7 +3448,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 31 Data size: 3145 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
+              value expressions: _col1 (type: string), _col2 (type: bigint)
           TableScan
             alias: x
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -3479,7 +3457,6 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: key (type: string)
               Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
-              value expressions: key (type: string)
           TableScan
             alias: y
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -3495,7 +3472,7 @@ STAGE PLANS:
             condition map:
                  Inner Join 0 to 1
             condition expressions:
-              0 {VALUE._col0}
+              0 {KEY.reducesinkkey0}
               1 
             outputColumnNames: _col0
             Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -3521,8 +3498,8 @@ STAGE PLANS:
                         condition map:
                              Inner Join 0 to 1
                         condition expressions:
-                          0 {VALUE._col0} {VALUE._col1}
-                          1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
+                          0 {KEY.reducesinkkey0} {VALUE._col0}
+                          1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
                         outputColumnNames: _col0, _col1, _col2, _col3, _col4
                         Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                         Select Operator
@@ -3542,8 +3519,8 @@ STAGE PLANS:
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {VALUE._col0} {VALUE._col1}
-                1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
+                0 {KEY.reducesinkkey0} {VALUE._col0}
+                1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
               outputColumnNames: _col0, _col1, _col2, _col3, _col4
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator
@@ -3723,7 +3700,7 @@ STAGE PLANS:
               sort order: +
               Map-reduce partition columns: _col0 (type: string)
               Statistics: Num rows: 31 Data size: 3145 Basic stats: COMPLETE Column stats: NONE
-              value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: bigint)
+              value expressions: _col1 (type: string), _col2 (type: bigint)
           TableScan
             alias: y
             Statistics: Num rows: 2 Data size: 216 Basic stats: COMPLETE Column stats: NONE
@@ -3775,8 +3752,8 @@ STAGE PLANS:
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {VALUE._col0} {VALUE._col1}
-                    1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
+                    0 {KEY.reducesinkkey0} {VALUE._col0}
+                    1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
                   outputColumnNames: _col0, _col1, _col2, _col3, _col4
                   Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                   Select Operator
@@ -3796,8 +3773,8 @@ STAGE PLANS:
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {VALUE._col0} {VALUE._col1}
-                1 {VALUE._col0} {VALUE._col1} {VALUE._col2}
+                0 {KEY.reducesinkkey0} {VALUE._col0}
+                1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1}
               outputColumnNames: _col0, _col1, _col2, _col3, _col4
               Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
               Select Operator



Mime
View raw message