hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dhr...@apache.org
Subject svn commit: r706708 [6/13] - in /hadoop/core/branches/branch-0.19: ./ src/contrib/hive/ src/contrib/hive/bin/ src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/ src/contrib/hive/common/src/java/org/apache/hadoop/hive/conf/ src/contrib/hive/conf/...
Date Tue, 21 Oct 2008 18:30:34 GMT
Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby5.q.out Tue Oct 21 11:29:18 2008
@@ -9,46 +9,51 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Reduce Operator Tree:
-          Group By Operator
-            keys:
-                  expr: VALUE.2
-                  type: string
-            mode: partial1
-          
-                expr: sum(VALUE.3)
-            File Output Operator
-              table:
-                  input format: org.apache.hadoop.mapred.TextInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         src 
             Reduce Output Operator
-              tag: -1
               key expressions:
-                    expr: 0
-                    type: int
-              value expressions:
-                    expr: key
-                    type: string
-                    expr: value
-                    type: string
                     expr: key
                     type: string
+              # partition fields: -1
+              tag: -1
+              value expressions:
                     expr: substr(value, 4)
                     type: string
-              # partition fields: -1
+      Reduce Operator Tree:
+        Group By Operator
+        
+              expr: sum(VALUE.0)
+          keys:
+                expr: KEY.0
+                type: string
+          mode: partial1
+          File Output Operator
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
 
   Stage: Stage-2
     Map Reduce
+      Alias -> Map Operator Tree:
+        /tmp/hive-njain/888102295/1013886705.10001 
+          Reduce Output Operator
+            key expressions:
+                  expr: 0
+                  type: string
+            # partition fields: 1
+            tag: -1
+            value expressions:
+                  expr: 1
+                  type: string
       Reduce Operator Tree:
         Group By Operator
+        
+              expr: sum(VALUE.0)
           keys:
                 expr: KEY.0
                 type: string
           mode: partial2
-        
-              expr: sum(VALUE.0)
           Select Operator
             expressions:
                   expr: 0
@@ -57,31 +62,20 @@
                   type: string
             File Output Operator
               table:
-                  name: dest1
-                  serde: simple_meta
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-      Alias -> Map Operator Tree:
-        /tmp/hive-zshao/317976905.10001 
-          Reduce Output Operator
-            tag: -1
-            key expressions:
-                  expr: 0
-                  type: string
-            value expressions:
-                  expr: 1
-                  type: string
-            # partition fields: 1
+                  serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                  name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 0	0.0
@@ -393,4 +387,3 @@
 96	96.0
 97	194.0
 98	196.0
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby6.q.out Tue Oct 21 11:29:18 2008
@@ -9,34 +9,35 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Reduce Operator Tree:
-          Group By Operator
-            keys:
-                  expr: VALUE.2
-                  type: string
-            mode: partial1
-            File Output Operator
-              table:
-                  input format: org.apache.hadoop.mapred.TextInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         src 
             Reduce Output Operator
-              tag: -1
               key expressions:
-                    expr: 0
-                    type: int
-              value expressions:
-                    expr: key
-                    type: string
-                    expr: value
-                    type: string
                     expr: substr(value, 4, 1)
                     type: string
               # partition fields: -1
+              tag: -1
+      Reduce Operator Tree:
+        Group By Operator
+          keys:
+                expr: KEY.0
+                type: string
+          mode: partial1
+          File Output Operator
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
 
   Stage: Stage-2
     Map Reduce
+      Alias -> Map Operator Tree:
+        /tmp/hive-njain/256745338/35530060.10001 
+          Reduce Output Operator
+            key expressions:
+                  expr: 0
+                  type: string
+            # partition fields: 1
+            tag: -1
       Reduce Operator Tree:
         Group By Operator
           keys:
@@ -49,28 +50,20 @@
                   type: string
             File Output Operator
               table:
-                  name: dest1
-                  serde: simple_meta
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-      Alias -> Map Operator Tree:
-        /tmp/hive-zshao/286498248.10001 
-          Reduce Output Operator
-            tag: -1
-            key expressions:
-                  expr: 0
-                  type: string
-            # partition fields: 1
+                  serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                  name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 0
@@ -83,4 +76,3 @@
 7
 8
 9
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby7.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby7.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby7.q.out Tue Oct 21 11:29:18 2008
@@ -307,7 +307,6 @@
 96	96.0
 97	194.0
 98	196.0
-
 0	0.0
 10	10.0
 100	200.0
@@ -617,4 +616,3 @@
 96	96.0
 97	194.0
 98	196.0
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby8.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby8.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/groupby8.q.out Tue Oct 21 11:29:18 2008
@@ -307,7 +307,6 @@
 96	1
 97	1
 98	1
-
 0	1
 10	1
 100	1
@@ -617,4 +616,3 @@
 96	1
 97	1
 98	1
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input1.q.out Tue Oct 21 11:29:18 2008
@@ -1,5 +1,5 @@
 ABSTRACT SYNTAX TREE:
-  (TOK_DESCTABLE TEST1)
+  (TOK_DESCTABLE (TOK_TAB TEST1))
 
 STAGE DEPENDENCIES:
   Stage-0 is a root stage

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input10.q.out Tue Oct 21 11:29:18 2008
@@ -1,5 +1,5 @@
 ABSTRACT SYNTAX TREE:
-  (TOK_DESCTABLE TEST10)
+  (TOK_DESCTABLE (TOK_TAB TEST10))
 
 STAGE DEPENDENCIES:
   Stage-0 is a root stage

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input11.q.out Tue Oct 21 11:29:18 2008
@@ -22,20 +22,20 @@
                       type: string
                 File Output Operator
                   table:
-                      name: dest1
-                      serde: simple_meta
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 86	val_86
@@ -122,4 +122,3 @@
 37	val_37
 90	val_90
 97	val_97
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out Tue Oct 21 11:29:18 2008
@@ -22,10 +22,10 @@
                       type: string
                 File Output Operator
                   table:
-                      name: dest1
-                      serde: simple_meta
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest1
             Filter Operator
               predicate:
                   expr: ((key >= 100) and (key < 200))
@@ -38,10 +38,10 @@
                       type: string
                 File Output Operator
                   table:
-                      name: dest2
-                      serde: simple_meta
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest2
             Filter Operator
               predicate:
                   expr: (key >= 200)
@@ -52,35 +52,35 @@
                       type: string
                 File Output Operator
                   table:
-                      name: dest3
-                      serde: simple_meta
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest3
 
   Stage: Stage-0
     Move Operator
       tables:
-            table:
-                name: dest1
-                serde: simple_meta
-                input format: org.apache.hadoop.mapred.TextInputFormat
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
             replace:
             table:
-                name: dest2
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
             replace:
             table:
-                name: dest3
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest2
             partition:
               ds 2008-04-08
               hr 12
             replace:
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest3
 
 
 86	val_86
@@ -167,7 +167,6 @@
 37	val_37
 90	val_90
 97	val_97
-
 165	val_165
 193	val_193
 150	val_150
@@ -273,7 +272,6 @@
 194	val_194
 126	val_126
 169	val_169
-
 238	NULL	2008-04-08	12
 311	NULL	2008-04-08	12
 409	NULL	2008-04-08	12
@@ -585,4 +583,3 @@
 403	NULL	2008-04-08	12
 400	NULL	2008-04-08	12
 200	NULL	2008-04-08	12
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out Tue Oct 21 11:29:18 2008
@@ -22,10 +22,10 @@
                       type: string
                 File Output Operator
                   table:
-                      name: dest1
-                      serde: simple_meta
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest1
             Filter Operator
               predicate:
                   expr: ((key >= 100) and (key < 200))
@@ -38,10 +38,10 @@
                       type: string
                 File Output Operator
                   table:
-                      name: dest2
-                      serde: simple_meta
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest2
             Filter Operator
               predicate:
                   expr: ((key >= 200) and (key < 300))
@@ -52,10 +52,10 @@
                       type: string
                 File Output Operator
                   table:
-                      name: dest3
-                      serde: simple_meta
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest3
             Filter Operator
               predicate:
                   expr: (key >= 300)
@@ -71,31 +71,31 @@
 
   Stage: Stage-0
     Move Operator
+      files:
+            hdfs directory:
+            destination: ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out
       tables:
-            table:
-                name: dest1
-                serde: simple_meta
-                input format: org.apache.hadoop.mapred.TextInputFormat
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
             replace:
             table:
-                name: dest2
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
             replace:
             table:
-                name: dest3
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest2
             partition:
               ds 2008-04-08
               hr 12
             replace:
-      files:
-            destination: ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out
-            hdfs directory:
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest3
 
 
 86	val_86
@@ -182,7 +182,6 @@
 37	val_37
 90	val_90
 97	val_97
-
 165	val_165
 193	val_193
 150	val_150
@@ -288,7 +287,6 @@
 194	val_194
 126	val_126
 169	val_169
-
 238	NULL	2008-04-08	12
 255	NULL	2008-04-08	12
 278	NULL	2008-04-08	12
@@ -392,7 +390,6 @@
 281	NULL	2008-04-08	12
 222	NULL	2008-04-08	12
 200	NULL	2008-04-08	12
-
 val_311
 val_409
 val_484

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out Tue Oct 21 11:29:18 2008
@@ -8,24 +8,6 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Reduce Operator Tree:
-        Extract
-          Filter Operator
-            predicate:
-                expr: (0 < 100)
-                type: Boolean
-            Select Operator
-              expressions:
-                    expr: 0
-                    type: string
-                    expr: 1
-                    type: string
-              File Output Operator
-                table:
-                    name: dest1
-                    serde: simple_meta
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         tmap:src 
             Select Operator
@@ -40,26 +22,44 @@
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
                 Reduce Output Operator
-                  tag: -1
                   key expressions:
                         expr: tkey
                         type: string
+                  # partition fields: 1
+                  tag: -1
                   value expressions:
                         expr: tkey
                         type: string
                         expr: tvalue
                         type: string
-                  # partition fields: 1
+      Reduce Operator Tree:
+        Extract
+          Filter Operator
+            predicate:
+                expr: (0 < 100)
+                type: Boolean
+            Select Operator
+              expressions:
+                    expr: 0
+                    type: string
+                    expr: 1
+                    type: string
+              File Output Operator
+                table:
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                    name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 0	val_0
@@ -146,4 +146,3 @@
 97	val_97
 98	val_98
 98	val_98
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out Tue Oct 21 11:29:18 2008
@@ -8,12 +8,12 @@
   Stage: Stage-0
       Create Table Operator:
         Create Table
-          isExternal:
-          name: TEST15
-          # buckets: -1
+          columns: key int, value string
           field delimiter: 	
+          # buckets: -1
+          name: TEST15
+          isExternal:
           isSequenceFile:
-          columns: key int, value string
 
 
 key	int

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out Tue Oct 21 11:29:18 2008
@@ -14,9 +14,9 @@
   Stage: Stage-0
       Alter Table Operator:
         Alter Table
-          old name: TEST3b
           type: add columns
-          new columns: a array<int>, b float, c map<float,int>, X float
+          new columns: X float
+          old name: TEST3b
 
 
 a	array<int>
@@ -33,9 +33,9 @@
   Stage: Stage-0
       Alter Table Operator:
         Alter Table
-          old name: TEST3b
-          new name: TEST3c
           type: rename
+          new name: TEST3c
+          old name: TEST3b
 
 
 a	array<int>
@@ -43,3 +43,22 @@
 c	map<float,int>
 x	float
 src	src1	src_sequencefile	src_thrift	srcbucket	srcpart	test3a	test3c
+ABSTRACT SYNTAX TREE:
+  (TOK_ALTERTABLE_REPLACECOLS TEST3c (TOK_TABCOLLIST (TOK_TABCOL R1 TOK_INT) (TOK_TABCOL R2 TOK_FLOAT)))
+
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+      Alter Table Operator:
+        Alter Table
+          type: replace columns
+          new columns: R1 int, R2 float
+          old name: TEST3c
+
+
+r1	int
+r2	float
+Detailed Table Information:
+Table(tableName:test3c,dbName:default,owner:njain,createTime:1224285029,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:r1,type:int,comment:null), FieldSchema(name:r2,type:float,comment:null)],location:file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/test3b,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{last_modified_by=njain,last_modified_time=1224285029,SORTBUCKETCOLSPREFIX=TRUE})

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out Tue Oct 21 11:29:18 2008
@@ -8,18 +8,18 @@
 STAGE PLANS:
   Stage: Stage-0
     Copy
-      source: file:/data/zshao/trunk/VENDOR/hadoop-0.17/src/contrib/hive/data/files/kv1.txt
-      destination: file:/tmp/hive-zshao/-1658380790
+      source: file:/home/njain/workspace/hadoop-0.17/src/contrib/hive/data/files/kv1.txt
+      destination: file:/tmp/hive-njain/-478939701
 
   Stage: Stage-1
     Move Operator
       tables:
+            replace:
             table:
-                name: input4
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: input4
 
 
 val_238	238
@@ -522,4 +522,3 @@
 val_400	400
 val_200	200
 val_97	97
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out Tue Oct 21 11:29:18 2008
@@ -8,20 +8,6 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Reduce Operator Tree:
-        Extract
-          Select Operator
-            expressions:
-                  expr: 0
-                  type: string
-                  expr: 1
-                  type: string
-            File Output Operator
-              table:
-                  name: dest1
-                  serde: simple_meta
-                  input format: org.apache.hadoop.mapred.TextInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         tmap:src_thrift 
             Select Operator
@@ -36,26 +22,40 @@
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
                 Reduce Output Operator
-                  tag: -1
                   key expressions:
                         expr: tkey
                         type: string
+                  # partition fields: 1
+                  tag: -1
                   value expressions:
                         expr: tkey
                         type: string
                         expr: tvalue
                         type: string
-                  # partition fields: 1
+      Reduce Operator Tree:
+        Extract
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                  name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 [0,0,0]	[{"myint":0,"mystring":"0"}]
@@ -68,4 +68,3 @@
 [7,14,21]	[{"myint":49,"mystring":"343"}]
 [8,16,24]	[{"myint":64,"mystring":"512"}]
 [9,18,27]	[{"myint":81,"mystring":"729"}]
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out Tue Oct 21 11:29:18 2008
@@ -22,19 +22,19 @@
                       type: string
                 File Output Operator
                   table:
-                      name: dest1
-                      serde: simple_meta
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input7.q.out Tue Oct 21 11:29:18 2008
@@ -18,34 +18,34 @@
                     type: string
               File Output Operator
                 table:
-                    name: dest1
-                    serde: simple_meta
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                    name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 NULL	238
-NULL	NULL
+NULL	
 NULL	311
-NULL	NULL
-NULL	NULL
-NULL	NULL
+NULL	
+NULL	
+NULL	
 NULL	255
 NULL	278
 NULL	98
-NULL	NULL
-NULL	NULL
-NULL	NULL
+NULL	
+NULL	
+NULL	
 NULL	401
 NULL	150
 NULL	273
@@ -56,7 +56,6 @@
 NULL	213
 NULL	146
 NULL	406
-NULL	NULL
-NULL	NULL
-NULL	NULL
-
+NULL	
+NULL	
+NULL	

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input8.q.out Tue Oct 21 11:29:18 2008
@@ -20,20 +20,20 @@
                     type: Byte
               File Output Operator
                 table:
-                    name: dest1
-                    serde: simple_meta
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                    name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 NULL	NULL	NULL
@@ -61,4 +61,3 @@
 NULL	NULL	NULL
 NULL	NULL	NULL
 NULL	NULL	NULL
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input9.q.out Tue Oct 21 11:29:18 2008
@@ -22,19 +22,19 @@
                       type: string
                 File Output Operator
                   table:
-                      name: dest1
-                      serde: simple_meta
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_part1.q.out Tue Oct 21 11:29:18 2008
@@ -25,21 +25,70 @@
                       expr: ds
                       type: string
                 File Output Operator
+                  directory: /tmp/hive-njain/13222008/293248514.10000.insclause-0
                   table:
-                      name: dest1
-                      serde: simple_meta
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                      properties:
+                        name dest1
+                        serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
+                        serialization.format 1
+                        columns key,value,hr,ds
+                        SORTBUCKETCOLSPREFIX TRUE
+                        bucket_count -1
+                        serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                        file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                        file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                        location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                      serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                      name: dest1
+      Needs Tagging:
+      Path -> Alias:
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+      Path -> Partition:
+        file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+          Partition
+            partition values:
+              ds 2008-04-08
+              hr 12
+          
+              input format: org.apache.hadoop.mapred.TextInputFormat
+              output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+              properties:
+                name srcpart
+                serialization.ddl struct srcpart { string key, string value}
+                serialization.format 1
+                columns key,value
+                partition_columns ds/hr
+                bucket_count -1
+                serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/srcpart
+              serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+              name: srcpart
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
+            source: /tmp/hive-njain/13222008/293248514.10000.insclause-0
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                properties:
+                  name dest1
+                  serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
+                  serialization.format 1
+                  columns key,value,hr,ds
+                  SORTBUCKETCOLSPREFIX TRUE
+                  bucket_count -1
+                  serialization.lib org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                  file.inputformat org.apache.hadoop.mapred.TextInputFormat
+                  file.outputformat org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  location file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/dest1
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 86	val_86	12	2008-04-08
@@ -126,4 +175,3 @@
 37	val_37	12	2008-04-08
 90	val_90	12	2008-04-08
 97	val_97	12	2008-04-08
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_testsequencefile.q.out Tue Oct 21 11:29:18 2008
@@ -18,20 +18,20 @@
                     type: string
               File Output Operator
                 table:
-                    name: dest4_sequencefile
-                    serde: simple_meta
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                    name: dest4_sequencefile
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest4_sequencefile
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest4_sequencefile
 
 
 238	val_238
@@ -534,4 +534,3 @@
 400	val_400
 200	val_200
 97	val_97
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/input_testxpath.q.out Tue Oct 21 11:29:18 2008
@@ -1,5 +1,5 @@
 ABSTRACT SYNTAX TREE:
-  (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_thrift lint) 1)) (TOK_SELEXPR (. ([ (TOK_COLREF src_thrift lintstring) 0) mystring)))))
+  (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR ([ (TOK_COLREF src_thrift lint) 1)) (TOK_SELEXPR (. ([ (TOK_COLREF src_thrift lintstring) 0) mystring)) (TOK_SELEXPR ([ (TOK_COLREF src_thrift mstringstring) 'key_2')))))
 
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
@@ -16,32 +16,33 @@
                     type: int
                     expr: lintstring[0].mystring
                     type: string
+                    expr: mstringstring['key_2']
+                    type: string
               File Output Operator
                 table:
-                    name: dest1
-                    serde: simple_meta
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                    name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
-
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
-0	0
-2	1
-4	8
-6	27
-8	64
-10	125
-12	216
-14	343
-16	512
-18	729
 
+0	0	NULL
+2	1	NULL
+4	8	value_2
+6	27	NULL
+8	64	NULL
+10	125	NULL
+12	216	NULL
+14	343	NULL
+16	512	NULL
+18	729	NULL

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl1.q.out Tue Oct 21 11:29:18 2008
@@ -8,10 +8,10 @@
   Stage: Stage-0
       Create Table Operator:
         Create Table
-          isExternal:
-          name: INPUTDDL1
+          columns: key int, value string
           # buckets: -1
+          name: INPUTDDL1
+          isExternal:
           isSequenceFile:
-          columns: key int, value string
 
 

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl2.q.out Tue Oct 21 11:29:18 2008
@@ -8,12 +8,12 @@
   Stage: Stage-0
       Create Table Operator:
         Create Table
-          isExternal:
-          name: INPUTDDL2
-          # buckets: -1
-          isSequenceFile:
           columns: key int, value string
+          # buckets: -1
           partition columns: ds datetime, country string
+          name: INPUTDDL2
+          isExternal:
+          isSequenceFile:
 
 
 key	int

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl3.q.out Tue Oct 21 11:29:18 2008
@@ -8,12 +8,12 @@
   Stage: Stage-0
       Create Table Operator:
         Create Table
-          isExternal:
-          name: INPUTDDL3
-          # buckets: -1
+          columns: key int, value string
           field delimiter: 	
+          # buckets: -1
+          name: INPUTDDL3
+          isExternal:
           isSequenceFile:
-          columns: key int, value string
 
 
 key	int

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl4.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl4.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl4.q.out Tue Oct 21 11:29:18 2008
@@ -7,3 +7,14 @@
 ip	string	'IP Address of the User'
 ds	datetime
 country	string
+viewtime	datetime
+userid	int
+page_url	string
+referrer_url	string
+friends	array<bigint>
+properties	map<string,string>
+ip	string	'IP Address of the User'
+ds	datetime
+country	string
+Detailed Table Information:
+Table(tableName:inputddl4,dbName:default,owner:njain,createTime:1224285030,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:viewtime,type:datetime,comment:null), FieldSchema(name:userid,type:int,comment:null), FieldSchema(name:page_url,type:string,comment:null), FieldSchema(name:referrer_url,type:string,comment:null), FieldSchema(name:friends,type:array<bigint>,comment:null), FieldSchema(name:properties,type:map<string,string>,comment:null), FieldSchema(name:ip,type:string,comment:'IP Address of the User')],location:file:/home/njain/workspace/hadoop-0.17/build/contrib/hive/ql/test/data/warehouse/inputddl4,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:32,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe,parameters:{serialization.format=1}),bucketCols:[userid],sortCols:[Order(col:viewtime,order:1)]
 ,parameters:{}),partitionKeys:[FieldSchema(name:ds,type:datetime,comment:null), FieldSchema(name:country,type:string,comment:null)],parameters:{comment='This is the page view table'})

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl5.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl5.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/inputddl5.q.out Tue Oct 21 11:29:18 2008
@@ -1,5 +1,3 @@
 name	string
 邵铮
-
 1
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join1.q.out Tue Oct 21 11:29:18 2008
@@ -8,60 +8,60 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Reduce Operator Tree:
-        Join Operator
-          condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
-          condition map:
-               Inner Join 0 to 1
-          Select Operator
-            expressions:
-                  expr: 0
-                  type: string
-                  expr: 3
-                  type: string
-            File Output Operator
-              table:
-                  name: dest1
-                  serde: simple_meta
-                  input format: org.apache.hadoop.mapred.TextInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         src2 
             Reduce Output Operator
-              tag: 1
               key expressions:
                     expr: key
                     type: string
+              # partition fields: 1
+              tag: 1
               value expressions:
                     expr: key
                     type: string
                     expr: value
                     type: string
-              # partition fields: 1
         src1 
             Reduce Output Operator
-              tag: 0
               key expressions:
                     expr: key
                     type: string
+              # partition fields: 1
+              tag: 0
               value expressions:
                     expr: key
                     type: string
                     expr: value
                     type: string
-              # partition fields: 1
+      Reduce Operator Tree:
+        Join Operator
+          condition map:
+               Inner Join 0 to 1
+          condition expressions:
+            0 {VALUE.0} {VALUE.1}
+            1 {VALUE.0} {VALUE.1}
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 3
+                  type: string
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                  name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 0	val_0
@@ -1092,4 +1092,3 @@
 98	val_98
 98	val_98
 98	val_98
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join2.q.out Tue Oct 21 11:29:18 2008
@@ -10,83 +10,65 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Reduce Operator Tree:
-        Join Operator
-          condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
-          condition map:
-               Inner Join 0 to 1
-          File Output Operator
-            table:
-                input format: org.apache.hadoop.mapred.TextInputFormat
-                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         src2 
             Reduce Output Operator
-              tag: 1
               key expressions:
                     expr: key
                     type: string
+              # partition fields: 1
+              tag: 1
               value expressions:
                     expr: key
                     type: string
                     expr: value
                     type: string
-              # partition fields: 1
         src1 
             Reduce Output Operator
-              tag: 0
               key expressions:
                     expr: key
                     type: string
+              # partition fields: 1
+              tag: 0
               value expressions:
                     expr: key
                     type: string
                     expr: value
                     type: string
-              # partition fields: 1
-
-  Stage: Stage-2
-    Map Reduce
       Reduce Operator Tree:
         Join Operator
-          condition expressions:
-            0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
-            1 {VALUE.0} {VALUE.1}
           condition map:
                Inner Join 0 to 1
-          Select Operator
-            expressions:
-                  expr: 2
-                  type: string
-                  expr: 5
-                  type: string
-            File Output Operator
-              table:
-                  name: dest1
-                  serde: simple_meta
-                  input format: org.apache.hadoop.mapred.TextInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+          condition expressions:
+            0 {VALUE.0} {VALUE.1}
+            1 {VALUE.0} {VALUE.1}
+          File Output Operator
+            table:
+                input format: org.apache.hadoop.mapred.TextInputFormat
+                output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+  Stage: Stage-2
+    Map Reduce
       Alias -> Map Operator Tree:
         src3 
             Reduce Output Operator
-              tag: 1
               key expressions:
                     expr: UDFToDouble(key)
                     type: double
+              # partition fields: 1
+              tag: 1
               value expressions:
                     expr: key
                     type: string
                     expr: value
                     type: string
-              # partition fields: 1
         $INTNAME 
           Reduce Output Operator
-            tag: 0
             key expressions:
                   expr: (UDFToDouble(0) + UDFToDouble(2))
                   type: double
+            # partition fields: 1
+            tag: 0
             value expressions:
                   expr: 2
                   type: string
@@ -96,17 +78,35 @@
                   type: string
                   expr: 1
                   type: string
-            # partition fields: 1
+      Reduce Operator Tree:
+        Join Operator
+          condition map:
+               Inner Join 0 to 1
+          condition expressions:
+            0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
+            1 {VALUE.0} {VALUE.1}
+          Select Operator
+            expressions:
+                  expr: 2
+                  type: string
+                  expr: 5
+                  type: string
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                  name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 0	val_0
@@ -581,4 +581,3 @@
 42	val_84
 42	val_84
 43	val_86
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join3.q.out Tue Oct 21 11:29:18 2008
@@ -8,74 +8,74 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Reduce Operator Tree:
-        Join Operator
-          condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
-            2 {VALUE.0} {VALUE.1}
-          condition map:
-               Inner Join 0 to 1
-               Inner Join 0 to 1
-          Select Operator
-            expressions:
-                  expr: 0
-                  type: string
-                  expr: 5
-                  type: string
-            File Output Operator
-              table:
-                  name: dest1
-                  serde: simple_meta
-                  input format: org.apache.hadoop.mapred.TextInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         src2 
             Reduce Output Operator
-              tag: 1
               key expressions:
                     expr: key
                     type: string
+              # partition fields: 1
+              tag: 1
               value expressions:
                     expr: key
                     type: string
                     expr: value
                     type: string
-              # partition fields: 1
         src3 
             Reduce Output Operator
-              tag: 2
               key expressions:
                     expr: key
                     type: string
+              # partition fields: 1
+              tag: 2
               value expressions:
                     expr: key
                     type: string
                     expr: value
                     type: string
-              # partition fields: 1
         src1 
             Reduce Output Operator
-              tag: 0
               key expressions:
                     expr: key
                     type: string
+              # partition fields: 1
+              tag: 0
               value expressions:
                     expr: key
                     type: string
                     expr: value
                     type: string
-              # partition fields: 1
+      Reduce Operator Tree:
+        Join Operator
+          condition map:
+               Inner Join 0 to 1
+               Inner Join 0 to 1
+          condition expressions:
+            0 {VALUE.0} {VALUE.1}
+            1 {VALUE.0} {VALUE.1}
+            2 {VALUE.0} {VALUE.1}
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 5
+                  type: string
+            File Output Operator
+              table:
+                  input format: org.apache.hadoop.mapred.TextInputFormat
+                  output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                  serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                  name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 0	val_0
@@ -2732,4 +2732,3 @@
 98	val_98
 98	val_98
 98	val_98
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join4.q.out Tue Oct 21 11:29:18 2008
@@ -8,39 +8,6 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Reduce Operator Tree:
-        Join Operator
-          condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
-          condition map:
-               Left Outer Join0 to 1
-          Select Operator
-            expressions:
-                  expr: 0
-                  type: string
-                  expr: 1
-                  type: string
-                  expr: 2
-                  type: string
-                  expr: 3
-                  type: string
-            Select Operator
-              expressions:
-                    expr: 0
-                    type: string
-                    expr: 1
-                    type: string
-                    expr: 2
-                    type: string
-                    expr: 3
-                    type: string
-              File Output Operator
-                table:
-                    name: dest1
-                    serde: simple_meta
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         c:b:src2 
             Filter Operator
@@ -54,16 +21,16 @@
                       expr: value
                       type: string
                 Reduce Output Operator
-                  tag: 1
                   key expressions:
                         expr: 0
                         type: string
+                  # partition fields: 1
+                  tag: 1
                   value expressions:
                         expr: 0
                         type: string
                         expr: 1
                         type: string
-                  # partition fields: 1
         c:a:src1 
             Filter Operator
               predicate:
@@ -76,26 +43,59 @@
                       expr: value
                       type: string
                 Reduce Output Operator
-                  tag: 0
                   key expressions:
                         expr: 0
                         type: string
+                  # partition fields: 1
+                  tag: 0
                   value expressions:
                         expr: 0
                         type: string
                         expr: 1
                         type: string
-                  # partition fields: 1
+      Reduce Operator Tree:
+        Join Operator
+          condition map:
+               Left Outer Join0 to 1
+          condition expressions:
+            0 {VALUE.0} {VALUE.1}
+            1 {VALUE.0} {VALUE.1}
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+                  expr: 2
+                  type: string
+                  expr: 3
+                  type: string
+            Select Operator
+              expressions:
+                    expr: 0
+                    type: string
+                    expr: 1
+                    type: string
+                    expr: 2
+                    type: string
+                    expr: 3
+                    type: string
+              File Output Operator
+                table:
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                    name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 11	val_11	NULL	NULL
@@ -109,4 +109,3 @@
 18	val_18	18	val_18
 18	val_18	18	val_18
 19	val_19	19	val_19
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join5.q.out Tue Oct 21 11:29:18 2008
@@ -8,39 +8,6 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Reduce Operator Tree:
-        Join Operator
-          condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
-          condition map:
-               Right Outer Join0 to 1
-          Select Operator
-            expressions:
-                  expr: 0
-                  type: string
-                  expr: 1
-                  type: string
-                  expr: 2
-                  type: string
-                  expr: 3
-                  type: string
-            Select Operator
-              expressions:
-                    expr: 0
-                    type: string
-                    expr: 1
-                    type: string
-                    expr: 2
-                    type: string
-                    expr: 3
-                    type: string
-              File Output Operator
-                table:
-                    name: dest1
-                    serde: simple_meta
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         c:b:src2 
             Filter Operator
@@ -54,16 +21,16 @@
                       expr: value
                       type: string
                 Reduce Output Operator
-                  tag: 1
                   key expressions:
                         expr: 0
                         type: string
+                  # partition fields: 1
+                  tag: 1
                   value expressions:
                         expr: 0
                         type: string
                         expr: 1
                         type: string
-                  # partition fields: 1
         c:a:src1 
             Filter Operator
               predicate:
@@ -76,26 +43,59 @@
                       expr: value
                       type: string
                 Reduce Output Operator
-                  tag: 0
                   key expressions:
                         expr: 0
                         type: string
+                  # partition fields: 1
+                  tag: 0
                   value expressions:
                         expr: 0
                         type: string
                         expr: 1
                         type: string
-                  # partition fields: 1
+      Reduce Operator Tree:
+        Join Operator
+          condition map:
+               Right Outer Join0 to 1
+          condition expressions:
+            0 {VALUE.0} {VALUE.1}
+            1 {VALUE.0} {VALUE.1}
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+                  expr: 2
+                  type: string
+                  expr: 3
+                  type: string
+            Select Operator
+              expressions:
+                    expr: 0
+                    type: string
+                    expr: 1
+                    type: string
+                    expr: 2
+                    type: string
+                    expr: 3
+                    type: string
+              File Output Operator
+                table:
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                    name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 17	val_17	17	val_17
@@ -107,4 +107,3 @@
 NULL	NULL	20	val_20
 NULL	NULL	24	val_24
 NULL	NULL	24	val_24
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join6.q.out Tue Oct 21 11:29:18 2008
@@ -8,39 +8,6 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Reduce Operator Tree:
-        Join Operator
-          condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
-          condition map:
-               Outer Join 0 to 1
-          Select Operator
-            expressions:
-                  expr: 0
-                  type: string
-                  expr: 1
-                  type: string
-                  expr: 2
-                  type: string
-                  expr: 3
-                  type: string
-            Select Operator
-              expressions:
-                    expr: 0
-                    type: string
-                    expr: 1
-                    type: string
-                    expr: 2
-                    type: string
-                    expr: 3
-                    type: string
-              File Output Operator
-                table:
-                    name: dest1
-                    serde: simple_meta
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         c:b:src2 
             Filter Operator
@@ -54,16 +21,16 @@
                       expr: value
                       type: string
                 Reduce Output Operator
-                  tag: 1
                   key expressions:
                         expr: 0
                         type: string
+                  # partition fields: 1
+                  tag: 1
                   value expressions:
                         expr: 0
                         type: string
                         expr: 1
                         type: string
-                  # partition fields: 1
         c:a:src1 
             Filter Operator
               predicate:
@@ -76,26 +43,59 @@
                       expr: value
                       type: string
                 Reduce Output Operator
-                  tag: 0
                   key expressions:
                         expr: 0
                         type: string
+                  # partition fields: 1
+                  tag: 0
                   value expressions:
                         expr: 0
                         type: string
                         expr: 1
                         type: string
-                  # partition fields: 1
+      Reduce Operator Tree:
+        Join Operator
+          condition map:
+               Outer Join 0 to 1
+          condition expressions:
+            0 {VALUE.0} {VALUE.1}
+            1 {VALUE.0} {VALUE.1}
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+                  expr: 2
+                  type: string
+                  expr: 3
+                  type: string
+            Select Operator
+              expressions:
+                    expr: 0
+                    type: string
+                    expr: 1
+                    type: string
+                    expr: 2
+                    type: string
+                    expr: 3
+                    type: string
+              File Output Operator
+                table:
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                    name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 11	val_11	NULL	NULL
@@ -112,4 +112,3 @@
 NULL	NULL	20	val_20
 NULL	NULL	24	val_24
 NULL	NULL	24	val_24
-

Modified: hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out?rev=706708&r1=706707&r2=706708&view=diff
==============================================================================
--- hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hadoop/core/branches/branch-0.19/src/contrib/hive/ql/src/test/results/clientpositive/join7.q.out Tue Oct 21 11:29:18 2008
@@ -8,49 +8,6 @@
 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
-      Reduce Operator Tree:
-        Join Operator
-          condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
-            2 {VALUE.0} {VALUE.1}
-          condition map:
-               Outer Join 0 to 1
-               Left Outer Join0 to 1
-          Select Operator
-            expressions:
-                  expr: 0
-                  type: string
-                  expr: 1
-                  type: string
-                  expr: 2
-                  type: string
-                  expr: 3
-                  type: string
-                  expr: 4
-                  type: string
-                  expr: 5
-                  type: string
-            Select Operator
-              expressions:
-                    expr: 0
-                    type: string
-                    expr: 1
-                    type: string
-                    expr: 2
-                    type: string
-                    expr: 3
-                    type: string
-                    expr: 4
-                    type: string
-                    expr: 5
-                    type: string
-              File Output Operator
-                table:
-                    name: dest1
-                    serde: simple_meta
-                    input format: org.apache.hadoop.mapred.TextInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
       Alias -> Map Operator Tree:
         c:b:src2 
             Filter Operator
@@ -64,16 +21,16 @@
                       expr: value
                       type: string
                 Reduce Output Operator
-                  tag: 1
                   key expressions:
                         expr: 0
                         type: string
+                  # partition fields: 1
+                  tag: 1
                   value expressions:
                         expr: 0
                         type: string
                         expr: 1
                         type: string
-                  # partition fields: 1
         c:a:src1 
             Filter Operator
               predicate:
@@ -86,16 +43,16 @@
                       expr: value
                       type: string
                 Reduce Output Operator
-                  tag: 0
                   key expressions:
                         expr: 0
                         type: string
+                  # partition fields: 1
+                  tag: 0
                   value expressions:
                         expr: 0
                         type: string
                         expr: 1
                         type: string
-                  # partition fields: 1
         c:c:src3 
             Filter Operator
               predicate:
@@ -108,26 +65,69 @@
                       expr: value
                       type: string
                 Reduce Output Operator
-                  tag: 2
                   key expressions:
                         expr: 0
                         type: string
+                  # partition fields: 1
+                  tag: 2
                   value expressions:
                         expr: 0
                         type: string
                         expr: 1
                         type: string
-                  # partition fields: 1
+      Reduce Operator Tree:
+        Join Operator
+          condition map:
+               Outer Join 0 to 1
+               Left Outer Join0 to 1
+          condition expressions:
+            0 {VALUE.0} {VALUE.1}
+            1 {VALUE.0} {VALUE.1}
+            2 {VALUE.0} {VALUE.1}
+          Select Operator
+            expressions:
+                  expr: 0
+                  type: string
+                  expr: 1
+                  type: string
+                  expr: 2
+                  type: string
+                  expr: 3
+                  type: string
+                  expr: 4
+                  type: string
+                  expr: 5
+                  type: string
+            Select Operator
+              expressions:
+                    expr: 0
+                    type: string
+                    expr: 1
+                    type: string
+                    expr: 2
+                    type: string
+                    expr: 3
+                    type: string
+                    expr: 4
+                    type: string
+                    expr: 5
+                    type: string
+              File Output Operator
+                table:
+                    input format: org.apache.hadoop.mapred.TextInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                    name: dest1
 
   Stage: Stage-0
     Move Operator
       tables:
+            replace:
             table:
-                name: dest1
-                serde: simple_meta
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-            replace:
+                serde: org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe
+                name: dest1
 
 
 11	val_11	NULL	NULL	NULL	NULL
@@ -146,4 +146,3 @@
 NULL	NULL	24	val_24	NULL	NULL
 NULL	NULL	24	val_24	NULL	NULL
 NULL	NULL	24	val_24	NULL	NULL
-



Mime
View raw message