You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2009/06/25 07:50:51 UTC

svn commit: r788269 [3/4] - in /hadoop/hive/trunk: ./ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/apache/hadoop/hive/ql/parse/ ql/src/java/org/apache/hadoop/hive/ql/plan/ ql/src/test/resu...

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join4.q.out Thu Jun 25 05:50:50 2009
@@ -48,8 +48,6 @@
               value expressions:
                     expr: key
                     type: string
-                    expr: value
-                    type: string
         a 
             Reduce Output Operator
               key expressions:
@@ -73,7 +71,7 @@
           condition expressions:
             0 {VALUE._col0} {VALUE._col1}
             1 {VALUE._col0} {VALUE._col1}
-            2 {VALUE._col0} {VALUE._col1}
+            2 {VALUE._col0}
           Filter Operator
             predicate:
                 expr: (((((_col0 > '10') and (_col0 < '20')) and (_col2 > '15')) and (_col2 < '25')) and (sqrt(UDFToDouble(_col4)) <> UDFToDouble(13)))
@@ -113,7 +111,7 @@
  SELECT a.key, a.value, b.key, b.value, c.key
  WHERE a.key > '10' AND a.key < '20' AND b.key > '15' AND b.key < '25' AND sqrt(c.key) <> 13
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/706058332/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/390144859/10000
 150	val_150	150	val_150	150
 152	val_152	152	val_152	152
 152	val_152	152	val_152	152

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_random.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_random.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_random.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_random.q.out Thu Jun 25 05:50:50 2009
@@ -42,8 +42,6 @@
                           type: string
                     tag: 1
                     value expressions:
-                          expr: _col0
-                          type: string
                           expr: _col1
                           type: string
         src1:src 
@@ -68,8 +66,8 @@
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {VALUE._col0}
+            1 {VALUE._col1}
           Filter Operator
             predicate:
                 expr: (rand() > 0.5)

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out Thu Jun 25 05:50:50 2009
@@ -105,10 +105,6 @@
                     type: string
               tag: 1
               value expressions:
-                    expr: key
-                    type: string
-                    expr: value
-                    type: string
                     expr: ds
                     type: string
                     expr: hr
@@ -128,10 +124,6 @@
                     type: string
               tag: 0
               value expressions:
-                    expr: key
-                    type: string
-                    expr: value
-                    type: string
                     expr: ds
                     type: string
                     expr: hr
@@ -141,8 +133,8 @@
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
-            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+            0 {VALUE._col2} {VALUE._col3}
+            1 {VALUE._col2} {VALUE._col3}
           Select Operator
             expressions:
                   expr: _col2
@@ -200,10 +192,6 @@
                     type: string
               tag: 1
               value expressions:
-                    expr: key
-                    type: string
-                    expr: value
-                    type: string
                     expr: ds
                     type: string
                     expr: hr
@@ -234,22 +222,13 @@
                         expr: ds
                         type: string
                   tag: 0
-                  value expressions:
-                        expr: key
-                        type: string
-                        expr: value
-                        type: string
-                        expr: ds
-                        type: string
-                        expr: hr
-                        type: string
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
-            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+            0 
+            1 {VALUE._col2} {VALUE._col3}
           Select Operator
             expressions:
                   expr: _col6
@@ -267,7 +246,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/805719823/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1521077193/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -302,7 +281,7 @@
 Input: default/srcpart/ds=2008-04-08/hr=12
 Input: default/srcpart/ds=2008-04-09/hr=11
 Input: default/srcpart/ds=2008-04-09/hr=12
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1129854195/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1366398818/10000
 2008-04-08	11
 2008-04-08	11
 2008-04-08	11
@@ -466,7 +445,7 @@
 Input: default/srcpart/ds=2008-04-08/hr=12
 Input: default/srcpart/ds=2008-04-09/hr=11
 Input: default/srcpart/ds=2008-04-09/hr=12
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1035513263/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/544471444/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out Thu Jun 25 05:50:50 2009
@@ -35,10 +35,6 @@
                         type: string
                         expr: value
                         type: string
-                        expr: ds
-                        type: string
-                        expr: hr
-                        type: string
         s 
             Filter Operator
               predicate:
@@ -62,12 +58,12 @@
                         type: string
       Needs Tagging: true
       Path -> Alias:
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
           Partition
             partition values:
               ds 2008-04-08
@@ -86,10 +82,10 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
+                location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
           Partition
             partition values:
               ds 2008-04-08
@@ -108,10 +104,10 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
+                location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 
           Partition
             partition values:
               ds 2008-04-09
@@ -130,10 +126,10 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
+                location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
           Partition
             partition values:
               ds 2008-04-09
@@ -152,7 +148,7 @@
                 serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 file.inputformat org.apache.hadoop.mapred.TextInputFormat
                 file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-                location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
+                location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
       Reduce Operator Tree:
@@ -161,7 +157,7 @@
                Inner Join 0 to 1
           condition expressions:
             0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
-            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+            1 {VALUE._col0} {VALUE._col1}
           Filter Operator
             predicate:
                 expr: ((((((_col4 = _col0) and (_col5 = _col1)) and (_col2 = '2008-04-08')) and (_col3 = '11')) and (_col2 = '2008-04-08')) and (_col3 = '11'))
@@ -179,7 +175,7 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/709064843/10002
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/179920971/10002
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -192,7 +188,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/709064843/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/179920971/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -217,9 +213,9 @@
                     type: string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/709064843/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/179920971/10002 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/709064843/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/179920971/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -234,7 +230,7 @@
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/709064843/10001
+            directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/179920971/10001
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -257,7 +253,7 @@
 Input: default/srcpart/ds=2008-04-08/hr=12
 Input: default/srcpart/ds=2008-04-09/hr=11
 Input: default/srcpart/ds=2008-04-09/hr=12
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/362051028/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1641045144/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out Thu Jun 25 05:50:50 2009
@@ -29,11 +29,6 @@
                     expr: key
                     type: string
               tag: 1
-              value expressions:
-                    expr: key
-                    type: string
-                    expr: value
-                    type: string
         a 
             Reduce Output Operator
               key expressions:
@@ -47,15 +42,13 @@
               value expressions:
                     expr: key
                     type: string
-                    expr: value
-                    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 {VALUE._col0}
+            1 
           Select Operator
             expressions:
                   expr: CASE (_col0) WHEN ('1') THEN (2) WHEN ('3') THEN (4) ELSE (5) END
@@ -71,7 +64,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1081703636/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1330132213/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -105,7 +98,7 @@
 ON a.key = b.key
 ORDER BY key LIMIT 10
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/10034618/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/303679320/10000
 5
 5
 5

Modified: hadoop/hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml (original)
+++ hadoop/hive/trunk/ql/src/test/results/compiler/plan/join1.q.xml Thu Jun 25 05:50:50 2009
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8"?> 
-<java version="1.6.0_07" class="java.beans.XMLDecoder"> 
+<java version="1.6.0_03-p3" class="java.beans.XMLDecoder"> 
  <object id="MapRedTask0" class="org.apache.hadoop.hive.ql.exec.MapRedTask"> 
   <void property="childTasks"> 
    <object class="java.util.ArrayList"> 
@@ -26,7 +26,7 @@
            <boolean>true</boolean> 
           </void> 
           <void property="sourceDir"> 
-           <string>file:/data/users/njain/hive4/hive4/build/ql/tmp/1688226816/10000</string> 
+           <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/27679623/10000</string> 
           </void> 
           <void property="table"> 
            <object id="tableDesc0" class="org.apache.hadoop.hive.ql.plan.tableDesc"> 
@@ -79,7 +79,7 @@
               </void> 
               <void method="put"> 
                <string>location</string> 
-               <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1</string> 
+               <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1</string> 
               </void> 
              </object> 
             </void> 
@@ -89,7 +89,7 @@
            </object> 
           </void> 
           <void property="tmpDir"> 
-           <string>file:/data/users/njain/hive4/hive4/build/ql/tmp/1688226816/10001</string> 
+           <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/27679623/10001</string> 
           </void> 
          </object> 
         </void> 
@@ -162,7 +162,7 @@
            </void> 
            <void method="put"> 
             <string>location</string> 
-            <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src</string> 
+            <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src</string> 
            </void> 
           </object> 
          </void> 
@@ -230,7 +230,7 @@
            </void> 
            <void method="put"> 
             <string>location</string> 
-            <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src</string> 
+            <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src</string> 
            </void> 
           </object> 
          </void> 
@@ -268,17 +268,6 @@
                 </void> 
                </object> 
               </void> 
-              <void method="put"> 
-               <string>VALUE._col0</string> 
-               <object id="exprNodeColumnDesc1" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                <void property="column"> 
-                 <string>key</string> 
-                </void> 
-                <void property="typeInfo"> 
-                 <object idref="PrimitiveTypeInfo0"/> 
-                </void> 
-               </object> 
-              </void> 
              </object> 
             </void> 
             <void property="conf"> 
@@ -343,9 +332,6 @@
               <void property="outputValueColumnNames"> 
                <object class="java.util.ArrayList"> 
                 <void method="add"> 
-                 <string>_col0</string> 
-                </void> 
-                <void method="add"> 
                  <string>_col1</string> 
                 </void> 
                </object> 
@@ -359,9 +345,6 @@
               <void property="valueCols"> 
                <object class="java.util.ArrayList"> 
                 <void method="add"> 
-                 <object idref="exprNodeColumnDesc1"/> 
-                </void> 
-                <void method="add"> 
                  <object idref="exprNodeColumnDesc0"/> 
                 </void> 
                </object> 
@@ -381,11 +364,11 @@
                  <object class="java.util.Properties"> 
                   <void method="put"> 
                    <string>columns</string> 
-                   <string>_col0,_col1</string> 
+                   <string>_col1</string> 
                   </void> 
                   <void method="put"> 
                    <string>columns.types</string> 
-                   <string>string,string</string> 
+                   <string>string</string> 
                   </void> 
                  </object> 
                 </void> 
@@ -407,16 +390,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="PrimitiveTypeInfo0"/> 
-                  </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"> 
@@ -472,19 +445,8 @@
             <void property="columnExprMap"> 
              <object class="java.util.HashMap"> 
               <void method="put"> 
-               <string>VALUE._col1</string> 
-               <object id="exprNodeColumnDesc2" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                <void property="column"> 
-                 <string>value</string> 
-                </void> 
-                <void property="typeInfo"> 
-                 <object idref="PrimitiveTypeInfo0"/> 
-                </void> 
-               </object> 
-              </void> 
-              <void method="put"> 
                <string>VALUE._col0</string> 
-               <object id="exprNodeColumnDesc3" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+               <object id="exprNodeColumnDesc1" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
                 <void property="column"> 
                  <string>key</string> 
                 </void> 
@@ -559,9 +521,6 @@
                 <void method="add"> 
                  <string>_col0</string> 
                 </void> 
-                <void method="add"> 
-                 <string>_col1</string> 
-                </void> 
                </object> 
               </void> 
               <void property="partitionCols"> 
@@ -570,10 +529,7 @@
               <void property="valueCols"> 
                <object class="java.util.ArrayList"> 
                 <void method="add"> 
-                 <object idref="exprNodeColumnDesc3"/> 
-                </void> 
-                <void method="add"> 
-                 <object idref="exprNodeColumnDesc2"/> 
+                 <object idref="exprNodeColumnDesc1"/> 
                 </void> 
                </object> 
               </void> 
@@ -592,11 +548,11 @@
                  <object class="java.util.Properties"> 
                   <void method="put"> 
                    <string>columns</string> 
-                   <string>_col0,_col1</string> 
+                   <string>_col0</string> 
                   </void> 
                   <void method="put"> 
                    <string>columns.types</string> 
-                   <string>string,string</string> 
+                   <string>string</string> 
                   </void> 
                  </object> 
                 </void> 
@@ -625,16 +581,6 @@
                   </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"> 
-                   <object idref="PrimitiveTypeInfo0"/> 
-                  </void> 
-                 </object> 
-                </void> 
                </object> 
               </void> 
              </object> 
@@ -687,7 +633,7 @@
     <void property="pathToAliases"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src</string> 
+       <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src</string> 
        <object class="java.util.ArrayList"> 
         <void method="add"> 
          <string>src2</string> 
@@ -702,7 +648,7 @@
     <void property="pathToPartitionInfo"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src</string> 
+       <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src</string> 
        <object class="org.apache.hadoop.hive.ql.plan.partitionDesc"> 
         <void property="partSpec"> 
          <object idref="LinkedHashMap0"/> 
@@ -746,7 +692,7 @@
                  <int>1</int> 
                 </void> 
                 <void property="dirName"> 
-                 <string>file:/data/users/njain/hive4/hive4/build/ql/tmp/1688226816/10000</string> 
+                 <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/27679623/10000</string> 
                 </void> 
                 <void property="tableInfo"> 
                  <object idref="tableDesc0"/> 
@@ -796,7 +742,7 @@
            <object class="java.util.HashMap"> 
             <void method="put"> 
              <string>_col1</string> 
-             <object id="exprNodeColumnDesc4" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+             <object id="exprNodeColumnDesc2" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
               <void property="column"> 
                <string>_col3</string> 
               </void> 
@@ -807,7 +753,7 @@
             </void> 
             <void method="put"> 
              <string>_col0</string> 
-             <object id="exprNodeColumnDesc5" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+             <object id="exprNodeColumnDesc3" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
               <void property="column"> 
                <string>_col0</string> 
               </void> 
@@ -823,10 +769,10 @@
             <void property="colList"> 
              <object class="java.util.ArrayList"> 
               <void method="add"> 
-               <object idref="exprNodeColumnDesc5"/> 
+               <object idref="exprNodeColumnDesc3"/> 
               </void> 
               <void method="add"> 
-               <object idref="exprNodeColumnDesc4"/> 
+               <object idref="exprNodeColumnDesc2"/> 
               </void> 
              </object> 
             </void> 
@@ -885,29 +831,7 @@
        <object class="java.util.HashMap"> 
         <void method="put"> 
          <string>_col3</string> 
-         <object id="exprNodeColumnDesc6" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-          <void property="column"> 
-           <string>VALUE._col1</string> 
-          </void> 
-          <void property="typeInfo"> 
-           <object idref="PrimitiveTypeInfo0"/> 
-          </void> 
-         </object> 
-        </void> 
-        <void method="put"> 
-         <string>_col2</string> 
-         <object id="exprNodeColumnDesc7" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-          <void property="column"> 
-           <string>VALUE._col0</string> 
-          </void> 
-          <void property="typeInfo"> 
-           <object idref="PrimitiveTypeInfo0"/> 
-          </void> 
-         </object> 
-        </void> 
-        <void method="put"> 
-         <string>_col1</string> 
-         <object id="exprNodeColumnDesc8" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+         <object id="exprNodeColumnDesc4" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
           <void property="column"> 
            <string>VALUE._col1</string> 
           </void> 
@@ -918,7 +842,7 @@
         </void> 
         <void method="put"> 
          <string>_col0</string> 
-         <object id="exprNodeColumnDesc9" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+         <object id="exprNodeColumnDesc5" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
           <void property="column"> 
            <string>VALUE._col0</string> 
           </void> 
@@ -948,10 +872,7 @@
            <byte>0</byte> 
            <object class="java.util.ArrayList"> 
             <void method="add"> 
-             <object idref="exprNodeColumnDesc9"/> 
-            </void> 
-            <void method="add"> 
-             <object idref="exprNodeColumnDesc8"/> 
+             <object idref="exprNodeColumnDesc5"/> 
             </void> 
            </object> 
           </void> 
@@ -959,10 +880,7 @@
            <byte>1</byte> 
            <object class="java.util.ArrayList"> 
             <void method="add"> 
-             <object idref="exprNodeColumnDesc7"/> 
-            </void> 
-            <void method="add"> 
-             <object idref="exprNodeColumnDesc6"/> 
+             <object idref="exprNodeColumnDesc4"/> 
             </void> 
            </object> 
           </void> 
@@ -974,13 +892,27 @@
            <string>_col0</string> 
           </void> 
           <void method="add"> 
-           <string>_col1</string> 
+           <string>_col3</string> 
           </void> 
-          <void method="add"> 
+         </object> 
+        </void> 
+        <void property="reversedExprs"> 
+         <object class="java.util.HashMap"> 
+          <void method="put"> 
+           <string>_col3</string> 
+           <byte>1</byte> 
+          </void> 
+          <void method="put"> 
            <string>_col2</string> 
+           <byte>1</byte> 
           </void> 
-          <void method="add"> 
-           <string>_col3</string> 
+          <void method="put"> 
+           <string>_col1</string> 
+           <byte>0</byte> 
+          </void> 
+          <void method="put"> 
+           <string>_col0</string> 
+           <byte>0</byte> 
           </void> 
          </object> 
         </void> 
@@ -1033,26 +965,6 @@
           <void method="add"> 
            <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
             <void property="internalName"> 
-             <string>_col1</string> 
-            </void> 
-            <void property="type"> 
-             <object idref="PrimitiveTypeInfo0"/> 
-            </void> 
-           </object> 
-          </void> 
-          <void method="add"> 
-           <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-            <void property="internalName"> 
-             <string>_col2</string> 
-            </void> 
-            <void property="type"> 
-             <object idref="PrimitiveTypeInfo0"/> 
-            </void> 
-           </object> 
-          </void> 
-          <void method="add"> 
-           <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-            <void property="internalName"> 
              <string>_col3</string> 
             </void> 
             <void property="type"> 

Modified: hadoop/hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml (original)
+++ hadoop/hive/trunk/ql/src/test/results/compiler/plan/join2.q.xml Thu Jun 25 05:50:50 2009
@@ -1,5 +1,5 @@
 <?xml version="1.0" encoding="UTF-8"?> 
-<java version="1.6.0_07" class="java.beans.XMLDecoder"> 
+<java version="1.6.0_03-p3" class="java.beans.XMLDecoder"> 
  <object id="MapRedTask0" class="org.apache.hadoop.hive.ql.exec.MapRedTask"> 
   <void property="childTasks"> 
    <object class="java.util.ArrayList"> 
@@ -30,7 +30,7 @@
                <boolean>true</boolean> 
               </void> 
               <void property="sourceDir"> 
-               <string>file:/data/users/njain/hive4/hive4/build/ql/tmp/1920214870/10000</string> 
+               <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/397277816/10000</string> 
               </void> 
               <void property="table"> 
                <object id="tableDesc0" class="org.apache.hadoop.hive.ql.plan.tableDesc"> 
@@ -83,7 +83,7 @@
                   </void> 
                   <void method="put"> 
                    <string>location</string> 
-                   <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1</string> 
+                   <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1</string> 
                   </void> 
                  </object> 
                 </void> 
@@ -93,7 +93,7 @@
                </object> 
               </void> 
               <void property="tmpDir"> 
-               <string>file:/data/users/njain/hive4/hive4/build/ql/tmp/1920214870/10001</string> 
+               <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/397277816/10001</string> 
               </void> 
              </object> 
             </void> 
@@ -173,7 +173,7 @@
                </void> 
                <void method="put"> 
                 <string>location</string> 
-                <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src</string> 
+                <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src</string> 
                </void> 
               </object> 
              </void> 
@@ -197,10 +197,10 @@
                 <void property="columnExprMap"> 
                  <object class="java.util.HashMap"> 
                   <void method="put"> 
-                   <string>VALUE._col3</string> 
+                   <string>VALUE._col2</string> 
                    <object id="exprNodeColumnDesc0" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
                     <void property="column"> 
-                     <string>_col1</string> 
+                     <string>_col0</string> 
                     </void> 
                     <void property="typeInfo"> 
                      <object id="PrimitiveTypeInfo0" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> 
@@ -211,39 +211,6 @@
                     </void> 
                    </object> 
                   </void> 
-                  <void method="put"> 
-                   <string>VALUE._col2</string> 
-                   <object id="exprNodeColumnDesc1" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                    <void property="column"> 
-                     <string>_col0</string> 
-                    </void> 
-                    <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo0"/> 
-                    </void> 
-                   </object> 
-                  </void> 
-                  <void method="put"> 
-                   <string>VALUE._col1</string> 
-                   <object id="exprNodeColumnDesc2" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                    <void property="column"> 
-                     <string>_col3</string> 
-                    </void> 
-                    <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo0"/> 
-                    </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="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo0"/> 
-                    </void> 
-                   </object> 
-                  </void> 
                  </object> 
                 </void> 
                 <void property="conf"> 
@@ -397,17 +364,8 @@
                   <void property="outputValueColumnNames"> 
                    <object class="java.util.ArrayList"> 
                     <void method="add"> 
-                     <string>_col0</string> 
-                    </void> 
-                    <void method="add"> 
-                     <string>_col1</string> 
-                    </void> 
-                    <void method="add"> 
                      <string>_col2</string> 
                     </void> 
-                    <void method="add"> 
-                     <string>_col3</string> 
-                    </void> 
                    </object> 
                   </void> 
                   <void property="partitionCols"> 
@@ -416,15 +374,6 @@
                   <void property="valueCols"> 
                    <object class="java.util.ArrayList"> 
                     <void method="add"> 
-                     <object idref="exprNodeColumnDesc3"/> 
-                    </void> 
-                    <void method="add"> 
-                     <object idref="exprNodeColumnDesc2"/> 
-                    </void> 
-                    <void method="add"> 
-                     <object idref="exprNodeColumnDesc1"/> 
-                    </void> 
-                    <void method="add"> 
                      <object idref="exprNodeColumnDesc0"/> 
                     </void> 
                    </object> 
@@ -444,11 +393,11 @@
                      <object class="java.util.Properties"> 
                       <void method="put"> 
                        <string>columns</string> 
-                       <string>_col0,_col1,_col2,_col3</string> 
+                       <string>_col2</string> 
                       </void> 
                       <void method="put"> 
                        <string>columns.types</string> 
-                       <string>string,string,string,string</string> 
+                       <string>string</string> 
                       </void> 
                      </object> 
                     </void> 
@@ -470,26 +419,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="PrimitiveTypeInfo0"/> 
-                      </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"> 
-                       <object idref="PrimitiveTypeInfo0"/> 
-                      </void> 
-                     </object> 
-                    </void> 
-                    <void method="add"> 
-                     <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                      <void property="internalName"> 
                        <string>VALUE._col2</string> 
                       </void> 
                       <void property="type"> 
@@ -497,16 +426,6 @@
                       </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"> 
-                       <object idref="PrimitiveTypeInfo0"/> 
-                      </void> 
-                     </object> 
-                    </void> 
                    </object> 
                   </void> 
                  </object> 
@@ -532,16 +451,6 @@
                 <void method="add"> 
                  <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
                   <void property="internalName"> 
-                   <string>_col1</string> 
-                  </void> 
-                  <void property="type"> 
-                   <object idref="PrimitiveTypeInfo0"/> 
-                  </void> 
-                 </object> 
-                </void> 
-                <void method="add"> 
-                 <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                  <void property="internalName"> 
                    <string>_col2</string> 
                   </void> 
                   <void property="type"> 
@@ -549,16 +458,6 @@
                   </void> 
                  </object> 
                 </void> 
-                <void method="add"> 
-                 <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                  <void property="internalName"> 
-                   <string>_col3</string> 
-                  </void> 
-                  <void property="type"> 
-                   <object idref="PrimitiveTypeInfo0"/> 
-                  </void> 
-                 </object> 
-                </void> 
                </object> 
               </void> 
              </object> 
@@ -576,7 +475,7 @@
                  <object class="java.util.HashMap"> 
                   <void method="put"> 
                    <string>VALUE._col1</string> 
-                   <object id="exprNodeColumnDesc4" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+                   <object id="exprNodeColumnDesc1" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
                     <void property="column"> 
                      <string>value</string> 
                     </void> 
@@ -585,17 +484,6 @@
                     </void> 
                    </object> 
                   </void> 
-                  <void method="put"> 
-                   <string>VALUE._col0</string> 
-                   <object id="exprNodeColumnDesc5" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                    <void property="column"> 
-                     <string>key</string> 
-                    </void> 
-                    <void property="typeInfo"> 
-                     <object idref="PrimitiveTypeInfo0"/> 
-                    </void> 
-                   </object> 
-                  </void> 
                  </object> 
                 </void> 
                 <void property="conf"> 
@@ -684,9 +572,6 @@
                   <void property="outputValueColumnNames"> 
                    <object class="java.util.ArrayList"> 
                     <void method="add"> 
-                     <string>_col0</string> 
-                    </void> 
-                    <void method="add"> 
                      <string>_col1</string> 
                     </void> 
                    </object> 
@@ -700,10 +585,7 @@
                   <void property="valueCols"> 
                    <object class="java.util.ArrayList"> 
                     <void method="add"> 
-                     <object idref="exprNodeColumnDesc5"/> 
-                    </void> 
-                    <void method="add"> 
-                     <object idref="exprNodeColumnDesc4"/> 
+                     <object idref="exprNodeColumnDesc1"/> 
                     </void> 
                    </object> 
                   </void> 
@@ -722,11 +604,11 @@
                      <object class="java.util.Properties"> 
                       <void method="put"> 
                        <string>columns</string> 
-                       <string>_col0,_col1</string> 
+                       <string>_col1</string> 
                       </void> 
                       <void method="put"> 
                        <string>columns.types</string> 
-                       <string>string,string</string> 
+                       <string>string</string> 
                       </void> 
                      </object> 
                     </void> 
@@ -748,16 +630,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="PrimitiveTypeInfo0"/> 
-                      </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"> 
@@ -817,7 +689,7 @@
         <void property="pathToAliases"> 
          <object class="java.util.LinkedHashMap"> 
           <void method="put"> 
-           <string>file:/data/users/njain/hive4/hive4/build/ql/tmp/1381792002/10002</string> 
+           <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1187118357/10002</string> 
            <object class="java.util.ArrayList"> 
             <void method="add"> 
              <string>$INTNAME</string> 
@@ -825,7 +697,7 @@
            </object> 
           </void> 
           <void method="put"> 
-           <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src</string> 
+           <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src</string> 
            <object class="java.util.ArrayList"> 
             <void method="add"> 
              <string>src3</string> 
@@ -837,7 +709,7 @@
         <void property="pathToPartitionInfo"> 
          <object class="java.util.LinkedHashMap"> 
           <void method="put"> 
-           <string>file:/data/users/njain/hive4/hive4/build/ql/tmp/1381792002/10002</string> 
+           <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1187118357/10002</string> 
            <object class="org.apache.hadoop.hive.ql.plan.partitionDesc"> 
             <void property="tableDesc"> 
              <object id="tableDesc4" class="org.apache.hadoop.hive.ql.plan.tableDesc"> 
@@ -858,7 +730,7 @@
                 </void> 
                 <void method="put"> 
                  <string>serialization.ddl</string> 
-                 <string>struct binary_table { string _col0, string _col1, string _col2, string _col3}</string> 
+                 <string>struct binary_table { string _col0, string _col2}</string> 
                 </void> 
                 <void method="put"> 
                  <string>serialization.format</string> 
@@ -871,7 +743,7 @@
            </object> 
           </void> 
           <void method="put"> 
-           <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src</string> 
+           <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src</string> 
            <object class="org.apache.hadoop.hive.ql.plan.partitionDesc"> 
             <void property="partSpec"> 
              <object idref="LinkedHashMap0"/> 
@@ -915,7 +787,7 @@
                      <int>1</int> 
                     </void> 
                     <void property="dirName"> 
-                     <string>file:/data/users/njain/hive4/hive4/build/ql/tmp/1920214870/10000</string> 
+                     <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/397277816/10000</string> 
                     </void> 
                     <void property="tableInfo"> 
                      <object idref="tableDesc0"/> 
@@ -965,7 +837,7 @@
                <object class="java.util.HashMap"> 
                 <void method="put"> 
                  <string>_col1</string> 
-                 <object id="exprNodeColumnDesc6" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+                 <object id="exprNodeColumnDesc2" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
                   <void property="column"> 
                    <string>_col5</string> 
                   </void> 
@@ -976,7 +848,7 @@
                 </void> 
                 <void method="put"> 
                  <string>_col0</string> 
-                 <object id="exprNodeColumnDesc7" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+                 <object id="exprNodeColumnDesc3" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
                   <void property="column"> 
                    <string>_col2</string> 
                   </void> 
@@ -992,10 +864,10 @@
                 <void property="colList"> 
                  <object class="java.util.ArrayList"> 
                   <void method="add"> 
-                   <object idref="exprNodeColumnDesc7"/> 
+                   <object idref="exprNodeColumnDesc3"/> 
                   </void> 
                   <void method="add"> 
-                   <object idref="exprNodeColumnDesc6"/> 
+                   <object idref="exprNodeColumnDesc2"/> 
                   </void> 
                  </object> 
                 </void> 
@@ -1054,7 +926,7 @@
            <object class="java.util.HashMap"> 
             <void method="put"> 
              <string>_col5</string> 
-             <object id="exprNodeColumnDesc8" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+             <object id="exprNodeColumnDesc4" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
               <void property="column"> 
                <string>VALUE._col1</string> 
               </void> 
@@ -1064,30 +936,8 @@
              </object> 
             </void> 
             <void method="put"> 
-             <string>_col4</string> 
-             <object id="exprNodeColumnDesc9" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-              <void property="column"> 
-               <string>VALUE._col0</string> 
-              </void> 
-              <void property="typeInfo"> 
-               <object idref="PrimitiveTypeInfo0"/> 
-              </void> 
-             </object> 
-            </void> 
-            <void method="put"> 
-             <string>_col3</string> 
-             <object id="exprNodeColumnDesc10" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-              <void property="column"> 
-               <string>VALUE._col3</string> 
-              </void> 
-              <void property="typeInfo"> 
-               <object idref="PrimitiveTypeInfo0"/> 
-              </void> 
-             </object> 
-            </void> 
-            <void method="put"> 
              <string>_col2</string> 
-             <object id="exprNodeColumnDesc11" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+             <object id="exprNodeColumnDesc5" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
               <void property="column"> 
                <string>VALUE._col2</string> 
               </void> 
@@ -1096,28 +946,6 @@
               </void> 
              </object> 
             </void> 
-            <void method="put"> 
-             <string>_col1</string> 
-             <object id="exprNodeColumnDesc12" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-              <void property="column"> 
-               <string>VALUE._col1</string> 
-              </void> 
-              <void property="typeInfo"> 
-               <object idref="PrimitiveTypeInfo0"/> 
-              </void> 
-             </object> 
-            </void> 
-            <void method="put"> 
-             <string>_col0</string> 
-             <object id="exprNodeColumnDesc13" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-              <void property="column"> 
-               <string>VALUE._col0</string> 
-              </void> 
-              <void property="typeInfo"> 
-               <object idref="PrimitiveTypeInfo0"/> 
-              </void> 
-             </object> 
-            </void> 
            </object> 
           </void> 
           <void property="conf"> 
@@ -1139,16 +967,7 @@
                <byte>0</byte> 
                <object class="java.util.ArrayList"> 
                 <void method="add"> 
-                 <object idref="exprNodeColumnDesc13"/> 
-                </void> 
-                <void method="add"> 
-                 <object idref="exprNodeColumnDesc12"/> 
-                </void> 
-                <void method="add"> 
-                 <object idref="exprNodeColumnDesc11"/> 
-                </void> 
-                <void method="add"> 
-                 <object idref="exprNodeColumnDesc10"/> 
+                 <object idref="exprNodeColumnDesc5"/> 
                 </void> 
                </object> 
               </void> 
@@ -1156,10 +975,7 @@
                <byte>1</byte> 
                <object class="java.util.ArrayList"> 
                 <void method="add"> 
-                 <object idref="exprNodeColumnDesc9"/> 
-                </void> 
-                <void method="add"> 
-                 <object idref="exprNodeColumnDesc8"/> 
+                 <object idref="exprNodeColumnDesc4"/> 
                 </void> 
                </object> 
               </void> 
@@ -1168,22 +984,38 @@
             <void property="outputColumnNames"> 
              <object class="java.util.ArrayList"> 
               <void method="add"> 
-               <string>_col0</string> 
+               <string>_col2</string> 
               </void> 
               <void method="add"> 
-               <string>_col1</string> 
+               <string>_col5</string> 
               </void> 
-              <void method="add"> 
-               <string>_col2</string> 
+             </object> 
+            </void> 
+            <void property="reversedExprs"> 
+             <object class="java.util.HashMap"> 
+              <void method="put"> 
+               <string>_col5</string> 
+               <byte>1</byte> 
               </void> 
-              <void method="add"> 
+              <void method="put"> 
+               <string>_col4</string> 
+               <byte>1</byte> 
+              </void> 
+              <void method="put"> 
                <string>_col3</string> 
+               <byte>0</byte> 
               </void> 
-              <void method="add"> 
-               <string>_col4</string> 
+              <void method="put"> 
+               <string>_col2</string> 
+               <byte>0</byte> 
               </void> 
-              <void method="add"> 
-               <string>_col5</string> 
+              <void method="put"> 
+               <string>_col1</string> 
+               <byte>0</byte> 
+              </void> 
+              <void method="put"> 
+               <string>_col0</string> 
+               <byte>0</byte> 
               </void> 
              </object> 
             </void> 
@@ -1229,26 +1061,6 @@
               <void method="add"> 
                <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
                 <void property="internalName"> 
-                 <string>_col0</string> 
-                </void> 
-                <void property="type"> 
-                 <object idref="PrimitiveTypeInfo0"/> 
-                </void> 
-               </object> 
-              </void> 
-              <void method="add"> 
-               <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                <void property="internalName"> 
-                 <string>_col1</string> 
-                </void> 
-                <void property="type"> 
-                 <object idref="PrimitiveTypeInfo0"/> 
-                </void> 
-               </object> 
-              </void> 
-              <void method="add"> 
-               <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                <void property="internalName"> 
                  <string>_col2</string> 
                 </void> 
                 <void property="type"> 
@@ -1259,26 +1071,6 @@
               <void method="add"> 
                <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
                 <void property="internalName"> 
-                 <string>_col3</string> 
-                </void> 
-                <void property="type"> 
-                 <object idref="PrimitiveTypeInfo0"/> 
-                </void> 
-               </object> 
-              </void> 
-              <void method="add"> 
-               <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                <void property="internalName"> 
-                 <string>_col4</string> 
-                </void> 
-                <void property="type"> 
-                 <object idref="PrimitiveTypeInfo0"/> 
-                </void> 
-               </object> 
-              </void> 
-              <void method="add"> 
-               <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> 
-                <void property="internalName"> 
                  <string>_col5</string> 
                 </void> 
                 <void property="type"> 
@@ -1371,7 +1163,7 @@
            </void> 
            <void method="put"> 
             <string>location</string> 
-            <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src</string> 
+            <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src</string> 
            </void> 
           </object> 
          </void> 
@@ -1439,7 +1231,7 @@
            </void> 
            <void method="put"> 
             <string>location</string> 
-            <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src</string> 
+            <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src</string> 
            </void> 
           </object> 
          </void> 
@@ -1463,19 +1255,8 @@
             <void property="columnExprMap"> 
              <object class="java.util.HashMap"> 
               <void method="put"> 
-               <string>VALUE._col1</string> 
-               <object id="exprNodeColumnDesc14" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                <void property="column"> 
-                 <string>value</string> 
-                </void> 
-                <void property="typeInfo"> 
-                 <object idref="PrimitiveTypeInfo0"/> 
-                </void> 
-               </object> 
-              </void> 
-              <void method="put"> 
                <string>VALUE._col0</string> 
-               <object id="exprNodeColumnDesc15" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+               <object id="exprNodeColumnDesc6" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
                 <void property="column"> 
                  <string>key</string> 
                 </void> 
@@ -1550,9 +1331,6 @@
                 <void method="add"> 
                  <string>_col0</string> 
                 </void> 
-                <void method="add"> 
-                 <string>_col1</string> 
-                </void> 
                </object> 
               </void> 
               <void property="partitionCols"> 
@@ -1564,10 +1342,7 @@
               <void property="valueCols"> 
                <object class="java.util.ArrayList"> 
                 <void method="add"> 
-                 <object idref="exprNodeColumnDesc15"/> 
-                </void> 
-                <void method="add"> 
-                 <object idref="exprNodeColumnDesc14"/> 
+                 <object idref="exprNodeColumnDesc6"/> 
                 </void> 
                </object> 
               </void> 
@@ -1586,11 +1361,11 @@
                  <object class="java.util.Properties"> 
                   <void method="put"> 
                    <string>columns</string> 
-                   <string>_col0,_col1</string> 
+                   <string>_col0</string> 
                   </void> 
                   <void method="put"> 
                    <string>columns.types</string> 
-                   <string>string,string</string> 
+                   <string>string</string> 
                   </void> 
                  </object> 
                 </void> 
@@ -1619,16 +1394,6 @@
                   </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"> 
-                   <object idref="PrimitiveTypeInfo0"/> 
-                  </void> 
-                 </object> 
-                </void> 
                </object> 
               </void> 
              </object> 
@@ -1677,19 +1442,8 @@
             <void property="columnExprMap"> 
              <object class="java.util.HashMap"> 
               <void method="put"> 
-               <string>VALUE._col1</string> 
-               <object id="exprNodeColumnDesc16" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-                <void property="column"> 
-                 <string>value</string> 
-                </void> 
-                <void property="typeInfo"> 
-                 <object idref="PrimitiveTypeInfo0"/> 
-                </void> 
-               </object> 
-              </void> 
-              <void method="put"> 
                <string>VALUE._col0</string> 
-               <object id="exprNodeColumnDesc17" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+               <object id="exprNodeColumnDesc7" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
                 <void property="column"> 
                  <string>key</string> 
                 </void> 
@@ -1764,9 +1518,6 @@
                 <void method="add"> 
                  <string>_col0</string> 
                 </void> 
-                <void method="add"> 
-                 <string>_col1</string> 
-                </void> 
                </object> 
               </void> 
               <void property="partitionCols"> 
@@ -1775,10 +1526,7 @@
               <void property="valueCols"> 
                <object class="java.util.ArrayList"> 
                 <void method="add"> 
-                 <object idref="exprNodeColumnDesc17"/> 
-                </void> 
-                <void method="add"> 
-                 <object idref="exprNodeColumnDesc16"/> 
+                 <object idref="exprNodeColumnDesc7"/> 
                 </void> 
                </object> 
               </void> 
@@ -1797,11 +1545,11 @@
                  <object class="java.util.Properties"> 
                   <void method="put"> 
                    <string>columns</string> 
-                   <string>_col0,_col1</string> 
+                   <string>_col0</string> 
                   </void> 
                   <void method="put"> 
                    <string>columns.types</string> 
-                   <string>string,string</string> 
+                   <string>string</string> 
                   </void> 
                  </object> 
                 </void> 
@@ -1830,16 +1578,6 @@
                   </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"> 
-                   <object idref="PrimitiveTypeInfo0"/> 
-                  </void> 
-                 </object> 
-                </void> 
                </object> 
               </void> 
              </object> 
@@ -1892,7 +1630,7 @@
     <void property="pathToAliases"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src</string> 
+       <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src</string> 
        <object class="java.util.ArrayList"> 
         <void method="add"> 
          <string>src2</string> 
@@ -1907,7 +1645,7 @@
     <void property="pathToPartitionInfo"> 
      <object class="java.util.LinkedHashMap"> 
       <void method="put"> 
-       <string>file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src</string> 
+       <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src</string> 
        <object class="org.apache.hadoop.hive.ql.plan.partitionDesc"> 
         <void property="partSpec"> 
          <object idref="LinkedHashMap1"/> 
@@ -1944,7 +1682,7 @@
           <void property="conf"> 
            <object class="org.apache.hadoop.hive.ql.plan.fileSinkDesc"> 
             <void property="dirName"> 
-             <string>file:/data/users/njain/hive4/hive4/build/ql/tmp/1381792002/10002</string> 
+             <string>file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1187118357/10002</string> 
             </void> 
             <void property="tableInfo"> 
              <object idref="tableDesc4"/> 
@@ -1968,19 +1706,8 @@
       <void property="columnExprMap"> 
        <object class="java.util.HashMap"> 
         <void method="put"> 
-         <string>_col3</string> 
-         <object id="exprNodeColumnDesc18" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-          <void property="column"> 
-           <string>VALUE._col1</string> 
-          </void> 
-          <void property="typeInfo"> 
-           <object idref="PrimitiveTypeInfo0"/> 
-          </void> 
-         </object> 
-        </void> 
-        <void method="put"> 
          <string>_col2</string> 
-         <object id="exprNodeColumnDesc19" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+         <object id="exprNodeColumnDesc8" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
           <void property="column"> 
            <string>VALUE._col0</string> 
           </void> 
@@ -1990,19 +1717,8 @@
          </object> 
         </void> 
         <void method="put"> 
-         <string>_col1</string> 
-         <object id="exprNodeColumnDesc20" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
-          <void property="column"> 
-           <string>VALUE._col1</string> 
-          </void> 
-          <void property="typeInfo"> 
-           <object idref="PrimitiveTypeInfo0"/> 
-          </void> 
-         </object> 
-        </void> 
-        <void method="put"> 
          <string>_col0</string> 
-         <object id="exprNodeColumnDesc21" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
+         <object id="exprNodeColumnDesc9" class="org.apache.hadoop.hive.ql.plan.exprNodeColumnDesc"> 
           <void property="column"> 
            <string>VALUE._col0</string> 
           </void> 
@@ -2032,10 +1748,7 @@
            <byte>0</byte> 
            <object class="java.util.ArrayList"> 
             <void method="add"> 
-             <object idref="exprNodeColumnDesc21"/> 
-            </void> 
-            <void method="add"> 
-             <object idref="exprNodeColumnDesc20"/> 
+             <object idref="exprNodeColumnDesc9"/> 
             </void> 
            </object> 
           </void> 
@@ -2043,10 +1756,7 @@
            <byte>1</byte> 
            <object class="java.util.ArrayList"> 
             <void method="add"> 
-             <object idref="exprNodeColumnDesc19"/> 
-            </void> 
-            <void method="add"> 
-             <object idref="exprNodeColumnDesc18"/> 
+             <object idref="exprNodeColumnDesc8"/> 
             </void> 
            </object> 
           </void> 
@@ -2058,13 +1768,27 @@
            <string>_col0</string> 
           </void> 
           <void method="add"> 
-           <string>_col1</string> 
-          </void> 
-          <void method="add"> 
            <string>_col2</string> 
           </void> 
-          <void method="add"> 
+         </object> 
+        </void> 
+        <void property="reversedExprs"> 
+         <object class="java.util.HashMap"> 
+          <void method="put"> 
            <string>_col3</string> 
+           <byte>1</byte> 
+          </void> 
+          <void method="put"> 
+           <string>_col2</string> 
+           <byte>1</byte> 
+          </void> 
+          <void method="put"> 
+           <string>_col1</string> 
+           <byte>0</byte> 
+          </void> 
+          <void method="put"> 
+           <string>_col0</string> 
+           <byte>0</byte> 
           </void> 
          </object> 
         </void>