You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by rh...@apache.org on 2014/04/09 19:29:15 UTC

svn commit: r1586046 [4/4] - in /hive/trunk/ql/src: java/org/apache/hadoop/hive/ql/optimizer/ java/org/apache/hadoop/hive/ql/optimizer/correlation/ java/org/apache/hadoop/hive/ql/parse/ test/queries/clientpositive/ test/results/clientpositive/ test/res...

Modified: hive/trunk/ql/src/test/results/clientpositive/union_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union_view.q.out?rev=1586046&r1=1586045&r2=1586046&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union_view.q.out Wed Apr  9 17:29:14 2014
@@ -821,37 +821,35 @@ STAGE PLANS:
           TableScan
             alias: src_union_1
             filterExpr: (ds = '1') (type: boolean)
-            Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE
             Select Operator
-              expressions: key (type: int), value (type: string), ds (type: string)
-              outputColumnNames: _col0, _col1, _col2
-              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 500 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
               Union
-                Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 500 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
                 Select Operator
-                  Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 500 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
                   Group By Operator
                     aggregations: count(1)
                     mode: hash
                     outputColumnNames: _col0
-                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                     Reduce Output Operator
                       sort order: 
-                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                       value expressions: _col0 (type: bigint)
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
           mode: mergepartial
           outputColumnNames: _col0
-          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
           Select Operator
             expressions: _col0 (type: bigint)
             outputColumnNames: _col0
-            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
             File Output Operator
               compressed: false
-              Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -896,37 +894,35 @@ STAGE PLANS:
           TableScan
             alias: src_union_2
             filterExpr: (ds = '2') (type: boolean)
-            Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: COMPLETE
             Select Operator
-              expressions: key (type: int), value (type: string), ds (type: string)
-              outputColumnNames: _col0, _col1, _col2
-              Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 1000 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
               Union
-                Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 1000 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
                 Select Operator
-                  Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1000 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
                   Group By Operator
                     aggregations: count(1)
                     mode: hash
                     outputColumnNames: _col0
-                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                     Reduce Output Operator
                       sort order: 
-                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                       value expressions: _col0 (type: bigint)
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
           mode: mergepartial
           outputColumnNames: _col0
-          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
           Select Operator
             expressions: _col0 (type: bigint)
             outputColumnNames: _col0
-            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
             File Output Operator
               compressed: false
-              Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -971,37 +967,35 @@ STAGE PLANS:
           TableScan
             alias: src_union_3
             filterExpr: (ds = '3') (type: boolean)
-            Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: COMPLETE
             Select Operator
-              expressions: key (type: int), value (type: string), ds (type: string)
-              outputColumnNames: _col0, _col1, _col2
-              Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 1000 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
               Union
-                Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 1000 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
                 Select Operator
-                  Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 1000 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
                   Group By Operator
                     aggregations: count(1)
                     mode: hash
                     outputColumnNames: _col0
-                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                     Reduce Output Operator
                       sort order: 
-                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                       value expressions: _col0 (type: bigint)
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
           mode: mergepartial
           outputColumnNames: _col0
-          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
           Select Operator
             expressions: _col0 (type: bigint)
             outputColumnNames: _col0
-            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
             File Output Operator
               compressed: false
-              Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -1113,37 +1107,35 @@ STAGE PLANS:
           TableScan
             alias: src_union_3
             filterExpr: (ds = '4') (type: boolean)
-            Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: COMPLETE
             Select Operator
-              expressions: key (type: int), value (type: string), ds (type: string)
-              outputColumnNames: _col0, _col1, _col2
-              Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 500 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
               Union
-                Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                Statistics: Num rows: 500 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
                 Select Operator
-                  Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+                  Statistics: Num rows: 500 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
                   Group By Operator
                     aggregations: count(1)
                     mode: hash
                     outputColumnNames: _col0
-                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+                    Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                     Reduce Output Operator
                       sort order: 
-                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+                      Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
                       value expressions: _col0 (type: bigint)
       Reduce Operator Tree:
         Group By Operator
           aggregations: count(VALUE._col0)
           mode: mergepartial
           outputColumnNames: _col0
-          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+          Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
           Select Operator
             expressions: _col0 (type: bigint)
             outputColumnNames: _col0
-            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+            Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
             File Output Operator
               compressed: false
-              Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: NONE
+              Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat

Modified: hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out?rev=1586046&r1=1586045&r2=1586046&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_limit.q.out Wed Apr  9 17:29:14 2014
@@ -346,7 +346,6 @@ STAGE PLANS:
                   Map-reduce partition columns: _col0 (type: tinyint)
                   Statistics: Num rows: 31436 Data size: 377237 Basic stats: COMPLETE Column stats: NONE
                   TopN Hash Memory Usage: 0.3
-                  value expressions: _col2 (type: bigint)
       Execution mode: vectorized
       Reduce Operator Tree:
         Group By Operator

Modified: hive/trunk/ql/src/test/results/compiler/plan/groupby2.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/groupby2.q.xml?rev=1586046&r1=1586045&r2=1586046&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/groupby2.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/groupby2.q.xml Wed Apr  9 17:29:14 2014
@@ -221,24 +221,6 @@
                      </void> 
                     </object> 
                    </void> 
-                   <void method="put"> 
-                    <string>VALUE._col0</string> 
-                    <object id="ExprNodeColumnDesc3" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                     <void property="column"> 
-                      <string>_col2</string> 
-                     </void> 
-                     <void property="tabAlias"> 
-                      <string></string> 
-                     </void> 
-                     <void property="typeInfo"> 
-                      <object id="PrimitiveTypeInfo2" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> 
-                       <void property="typeName"> 
-                        <string>bigint</string> 
-                       </void> 
-                      </object> 
-                     </void> 
-                    </object> 
-                   </void> 
                   </object> 
                  </void> 
                  <void property="conf"> 
@@ -316,9 +298,6 @@
                    <void property="outputValueColumnNames"> 
                     <object class="java.util.ArrayList"> 
                      <void method="add"> 
-                      <string>_col0</string> 
-                     </void> 
-                     <void method="add"> 
                       <string>_col1</string> 
                      </void> 
                     </object> 
@@ -336,9 +315,6 @@
                    <void property="valueCols"> 
                     <object class="java.util.ArrayList"> 
                      <void method="add"> 
-                      <object idref="ExprNodeColumnDesc3"/> 
-                     </void> 
-                     <void method="add"> 
                       <object idref="ExprNodeColumnDesc1"/> 
                      </void> 
                     </object> 
@@ -355,7 +331,7 @@
                       <object class="java.util.Properties"> 
                        <void method="put"> 
                         <string>columns</string> 
-                        <string>_col0,_col1</string> 
+                        <string>_col1</string> 
                        </void> 
                        <void method="put"> 
                         <string>serialization.lib</string> 
@@ -363,7 +339,7 @@
                        </void> 
                        <void method="put"> 
                         <string>columns.types</string> 
-                        <string>bigint,double</string> 
+                        <string>double</string> 
                        </void> 
                        <void method="put"> 
                         <string>escape.delim</string> 
@@ -416,19 +392,6 @@
                      <void method="add"> 
                       <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
                        <void property="internalName"> 
-                        <string>VALUE._col0</string> 
-                       </void> 
-                       <void property="type"> 
-                        <object idref="PrimitiveTypeInfo2"/> 
-                       </void> 
-                       <void property="typeName"> 
-                        <string>bigint</string> 
-                       </void> 
-                      </object> 
-                     </void> 
-                     <void method="add"> 
-                      <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                       <void property="internalName"> 
                         <string>VALUE._col1</string> 
                        </void> 
                        <void property="type"> 
@@ -469,7 +432,7 @@
                     <void method="add"> 
                      <object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc"> 
                       <void property="typeInfo"> 
-                       <object id="PrimitiveTypeInfo3" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> 
+                       <object id="PrimitiveTypeInfo2" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> 
                         <void property="typeName"> 
                          <string>int</string> 
                         </void> 
@@ -518,7 +481,7 @@
                     <void method="add"> 
                      <object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc"> 
                       <void property="typeInfo"> 
-                       <object idref="PrimitiveTypeInfo3"/> 
+                       <object idref="PrimitiveTypeInfo2"/> 
                       </void> 
                       <void property="value"> 
                        <int>1</int> 
@@ -528,7 +491,7 @@
                     <void method="add"> 
                      <object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc"> 
                       <void property="typeInfo"> 
-                       <object idref="PrimitiveTypeInfo3"/> 
+                       <object idref="PrimitiveTypeInfo2"/> 
                       </void> 
                       <void property="value"> 
                        <int>1</int> 
@@ -596,7 +559,7 @@
                           <void method="add"> 
                            <object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc"> 
                             <void property="typeInfo"> 
-                             <object idref="PrimitiveTypeInfo3"/> 
+                             <object idref="PrimitiveTypeInfo2"/> 
                             </void> 
                             <void property="value"> 
                              <int>5</int> 
@@ -657,7 +620,7 @@
                           <void method="add"> 
                            <object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc"> 
                             <void property="typeInfo"> 
-                             <object idref="PrimitiveTypeInfo3"/> 
+                             <object idref="PrimitiveTypeInfo2"/> 
                             </void> 
                             <void property="value"> 
                              <int>5</int> 
@@ -788,7 +751,11 @@
                      <string></string> 
                     </void> 
                     <void property="type"> 
-                     <object idref="PrimitiveTypeInfo2"/> 
+                     <object id="PrimitiveTypeInfo3" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> 
+                      <void property="typeName"> 
+                       <string>bigint</string> 
+                      </void> 
+                     </object> 
                     </void> 
                     <void property="typeName"> 
                      <string>bigint</string> 
@@ -833,7 +800,7 @@
                 <string>src</string> 
                </void> 
                <void property="typeInfo"> 
-                <object idref="PrimitiveTypeInfo2"/> 
+                <object idref="PrimitiveTypeInfo3"/> 
                </void> 
               </object> 
              </void> 
@@ -1037,7 +1004,7 @@
                <string>src</string> 
               </void> 
               <void property="type"> 
-               <object idref="PrimitiveTypeInfo2"/> 
+               <object idref="PrimitiveTypeInfo3"/> 
               </void> 
               <void property="typeName"> 
                <string>bigint</string> 
@@ -1292,7 +1259,7 @@
                      <string></string> 
                     </void> 
                     <void property="type"> 
-                     <object idref="PrimitiveTypeInfo2"/> 
+                     <object idref="PrimitiveTypeInfo3"/> 
                     </void> 
                     <void property="typeName"> 
                      <string>bigint</string> 
@@ -1367,7 +1334,7 @@
              </void> 
              <void method="put"> 
               <string>_col1</string> 
-              <object id="ExprNodeColumnDesc4" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+              <object id="ExprNodeColumnDesc3" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
                <void property="column"> 
                 <string>_col1</string> 
                </void> 
@@ -1375,13 +1342,13 @@
                 <string></string> 
                </void> 
                <void property="typeInfo"> 
-                <object idref="PrimitiveTypeInfo2"/> 
+                <object idref="PrimitiveTypeInfo3"/> 
                </void> 
               </object> 
              </void> 
              <void method="put"> 
               <string>_col0</string> 
-              <object id="ExprNodeColumnDesc5" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+              <object id="ExprNodeColumnDesc4" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
                <void property="column"> 
                 <string>_col0</string> 
                </void> 
@@ -1400,10 +1367,10 @@
              <void property="colList"> 
               <object class="java.util.ArrayList"> 
                <void method="add"> 
-                <object idref="ExprNodeColumnDesc5"/> 
+                <object idref="ExprNodeColumnDesc4"/> 
                </void> 
                <void method="add"> 
-                <object idref="ExprNodeColumnDesc4"/> 
+                <object idref="ExprNodeColumnDesc3"/> 
                </void> 
                <void method="add"> 
                 <object idref="ExprNodeGenericFuncDesc2"/> 
@@ -1462,7 +1429,7 @@
                   <string>_col1</string> 
                  </void> 
                  <void property="type"> 
-                  <object idref="PrimitiveTypeInfo2"/> 
+                  <object idref="PrimitiveTypeInfo3"/> 
                  </void> 
                  <void property="typeName"> 
                   <string>bigint</string> 
@@ -1496,7 +1463,7 @@
          <object class="java.util.HashMap"> 
           <void method="put"> 
            <string>_col0</string> 
-           <object id="ExprNodeColumnDesc6" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+           <object id="ExprNodeColumnDesc5" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
             <void property="column"> 
              <string>KEY._col0</string> 
             </void> 
@@ -1583,7 +1550,7 @@
           <void property="keys"> 
            <object class="java.util.ArrayList"> 
             <void method="add"> 
-             <object idref="ExprNodeColumnDesc6"/> 
+             <object idref="ExprNodeColumnDesc5"/> 
             </void> 
            </object> 
           </void> 
@@ -1650,7 +1617,7 @@
                <string></string> 
               </void> 
               <void property="type"> 
-               <object idref="PrimitiveTypeInfo2"/> 
+               <object idref="PrimitiveTypeInfo3"/> 
               </void> 
               <void property="typeName"> 
                <string>bigint</string> 

Modified: hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml?rev=1586046&r1=1586045&r2=1586046&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml (original)
+++ hive/trunk/ql/src/test/results/compiler/plan/groupby3.q.xml Wed Apr  9 17:29:14 2014
@@ -204,10 +204,10 @@
                     </object> 
                    </void> 
                    <void method="put"> 
-                    <string>VALUE._col2</string> 
+                    <string>VALUE._col1</string> 
                     <object id="ExprNodeColumnDesc2" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
                      <void property="column"> 
-                      <string>_col3</string> 
+                      <string>_col2</string> 
                      </void> 
                      <void property="tabAlias"> 
                       <string></string> 
@@ -253,22 +253,8 @@
                     </object> 
                    </void> 
                    <void method="put"> 
-                    <string>VALUE._col1</string> 
-                    <object id="ExprNodeColumnDesc3" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
-                     <void property="column"> 
-                      <string>_col2</string> 
-                     </void> 
-                     <void property="tabAlias"> 
-                      <string></string> 
-                     </void> 
-                     <void property="typeInfo"> 
-                      <object idref="StructTypeInfo0"/> 
-                     </void> 
-                    </object> 
-                   </void> 
-                   <void method="put"> 
                     <string>VALUE._col0</string> 
-                    <object id="ExprNodeColumnDesc4" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+                    <object id="ExprNodeColumnDesc3" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
                      <void property="column"> 
                       <string>_col1</string> 
                      </void> 
@@ -282,7 +268,7 @@
                    </void> 
                    <void method="put"> 
                     <string>KEY._col0:0._col0</string> 
-                    <object id="ExprNodeColumnDesc5" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+                    <object id="ExprNodeColumnDesc4" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
                      <void property="column"> 
                       <string>_col0</string> 
                      </void> 
@@ -312,7 +298,7 @@
                    <void property="keyCols"> 
                     <object class="java.util.ArrayList"> 
                      <void method="add"> 
-                      <object idref="ExprNodeColumnDesc5"/> 
+                      <object idref="ExprNodeColumnDesc4"/> 
                      </void> 
                     </object> 
                    </void> 
@@ -368,9 +354,6 @@
                       <string>_col1</string> 
                      </void> 
                      <void method="add"> 
-                      <string>_col2</string> 
-                     </void> 
-                     <void method="add"> 
                       <string>_col3</string> 
                      </void> 
                      <void method="add"> 
@@ -387,9 +370,6 @@
                    <void property="valueCols"> 
                     <object class="java.util.ArrayList"> 
                      <void method="add"> 
-                      <object idref="ExprNodeColumnDesc4"/> 
-                     </void> 
-                     <void method="add"> 
                       <object idref="ExprNodeColumnDesc3"/> 
                      </void> 
                      <void method="add"> 
@@ -415,7 +395,7 @@
                       <object class="java.util.Properties"> 
                        <void method="put"> 
                         <string>columns</string> 
-                        <string>_col0,_col1,_col2,_col3,_col4</string> 
+                        <string>_col0,_col1,_col3,_col4</string> 
                        </void> 
                        <void method="put"> 
                         <string>serialization.lib</string> 
@@ -423,7 +403,7 @@
                        </void> 
                        <void method="put"> 
                         <string>columns.types</string> 
-                        <string>double,struct&lt;count:bigint,sum:double,input:string&gt;,struct&lt;count:bigint,sum:double,input:string&gt;,string,string</string> 
+                        <string>double,struct&lt;count:bigint,sum:double,input:string&gt;,string,string</string> 
                        </void> 
                        <void method="put"> 
                         <string>escape.delim</string> 
@@ -489,19 +469,6 @@
                      <void method="add"> 
                       <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
                        <void property="internalName"> 
-                        <string>VALUE._col2</string> 
-                       </void> 
-                       <void property="type"> 
-                        <object idref="StructTypeInfo0"/> 
-                       </void> 
-                       <void property="typeName"> 
-                        <string>struct&lt;count:bigint,sum:double,input:string&gt;</string> 
-                       </void> 
-                      </object> 
-                     </void> 
-                     <void method="add"> 
-                      <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                       <void property="internalName"> 
                         <string>VALUE._col3</string> 
                        </void> 
                        <void property="type"> 
@@ -1579,7 +1546,7 @@
             <object class="java.util.HashMap"> 
              <void method="put"> 
               <string>_col4</string> 
-              <object id="ExprNodeColumnDesc6" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+              <object id="ExprNodeColumnDesc5" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
                <void property="column"> 
                 <string>_col4</string> 
                </void> 
@@ -1593,7 +1560,7 @@
              </void> 
              <void method="put"> 
               <string>_col3</string> 
-              <object id="ExprNodeColumnDesc7" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+              <object id="ExprNodeColumnDesc6" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
                <void property="column"> 
                 <string>_col3</string> 
                </void> 
@@ -1607,7 +1574,7 @@
              </void> 
              <void method="put"> 
               <string>_col2</string> 
-              <object id="ExprNodeColumnDesc8" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+              <object id="ExprNodeColumnDesc7" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
                <void property="column"> 
                 <string>_col2</string> 
                </void> 
@@ -1621,7 +1588,7 @@
              </void> 
              <void method="put"> 
               <string>_col1</string> 
-              <object id="ExprNodeColumnDesc9" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+              <object id="ExprNodeColumnDesc8" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
                <void property="column"> 
                 <string>_col1</string> 
                </void> 
@@ -1635,7 +1602,7 @@
              </void> 
              <void method="put"> 
               <string>_col0</string> 
-              <object id="ExprNodeColumnDesc10" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
+              <object id="ExprNodeColumnDesc9" class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> 
                <void property="column"> 
                 <string>_col0</string> 
                </void> 
@@ -1654,9 +1621,6 @@
              <void property="colList"> 
               <object class="java.util.ArrayList"> 
                <void method="add"> 
-                <object idref="ExprNodeColumnDesc10"/> 
-               </void> 
-               <void method="add"> 
                 <object idref="ExprNodeColumnDesc9"/> 
                </void> 
                <void method="add"> 
@@ -1668,6 +1632,9 @@
                <void method="add"> 
                 <object idref="ExprNodeColumnDesc6"/> 
                </void> 
+               <void method="add"> 
+                <object idref="ExprNodeColumnDesc5"/> 
+               </void> 
               </object> 
              </void> 
              <void property="outputColumnNames">