hadoop-hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From na...@apache.org
Subject svn commit: r794129 [4/8] - 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/java/org/...
Date Wed, 15 Jul 2009 01:52:45 GMT
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join35.q.out Wed Jul 15 01:52:41 2009
@@ -60,9 +60,9 @@
                             type: bigint
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -77,7 +77,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/rmurthy/hive/build/ql/test/data/warehouse/src
+                location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
       Reduce Operator Tree:
@@ -97,20 +97,19 @@
             File Output Operator
               compressed: false
               GlobalTableId: 0
-              directory: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10002
+              directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10002
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                   properties:
-                    name binary_table
-                    serialization.ddl struct binary_table { string _col0, i64 _col1}
-                    serialization.format org.apache.thrift.protocol.TBinaryProtocol
-                  name: binary_table
+                    columns _col0,_col1
+                    columns.types string,bigint
+                    escape.delim \
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10002 
           Union
             Common Join Operator
               condition map:
@@ -149,7 +148,7 @@
                     File Output Operator
                       compressed: false
                       GlobalTableId: 1
-                      directory: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003
+                      directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -163,10 +162,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/rmurthy/hive/build/ql/test/data/warehouse/dest_j1
+                            location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                           name: dest_j1
-        file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10004 
           Union
             Common Join Operator
               condition map:
@@ -205,7 +204,7 @@
                     File Output Operator
                       compressed: false
                       GlobalTableId: 1
-                      directory: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003
+                      directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -219,7 +218,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/rmurthy/hive/build/ql/test/data/warehouse/dest_j1
+                            location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                           name: dest_j1
       Local Work:
@@ -267,7 +266,7 @@
                         File Output Operator
                           compressed: false
                           GlobalTableId: 1
-                          directory: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003
+                          directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003
                           table:
                               input format: org.apache.hadoop.mapred.TextInputFormat
                               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -281,34 +280,32 @@
                                 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/rmurthy/hive/build/ql/test/data/warehouse/dest_j1
+                                location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
                               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                               name: dest_j1
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10002 
-        file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10004 
       Path -> Partition:
-        file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                name binary_table
-                serialization.ddl struct binary_table { string _col0, i64 _col1}
-                serialization.format org.apache.thrift.protocol.TBinaryProtocol
-              name: binary_table
-        file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10004 
+                columns _col0,_col1
+                columns.types string,bigint
+                escape.delim \
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10004 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                name binary_table
-                serialization.ddl struct binary_table { string _col0, i64 _col1}
-                serialization.format org.apache.thrift.protocol.TBinaryProtocol
-              name: binary_table
+                columns _col0,_col1
+                columns.types string,bigint
+                escape.delim \
 
   Stage: Stage-5
     Conditional Operator
@@ -316,11 +313,11 @@
           Move Operator
             files:
                 hdfs directory: true
-                source: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003
-                destination: file:/data/users/rmurthy/hive/build/ql/tmp/751585738/10000
+                source: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003
+                destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1122040404/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -336,9 +333,9 @@
                           type: int
             Needs Tagging: false
             Path -> Alias:
-              file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003 
             Path -> Partition:
-              file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10003 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10003 
                 Partition
                 
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -353,7 +350,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/rmurthy/hive/build/ql/test/data/warehouse/dest_j1
+                      location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     name: dest_j1
             Reduce Operator Tree:
@@ -361,7 +358,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/data/users/rmurthy/hive/build/ql/tmp/751585738/10000
+                  directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1122040404/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -375,7 +372,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/rmurthy/hive/build/ql/test/data/warehouse/dest_j1
+                        location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: dest_j1
 
@@ -383,7 +380,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/rmurthy/hive/build/ql/tmp/751585738/10000
+          source: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1122040404/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -397,10 +394,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/rmurthy/hive/build/ql/test/data/warehouse/dest_j1
+                location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/dest_j1
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: dest_j1
-          tmp directory: file:/data/users/rmurthy/hive/build/ql/tmp/751585738/10001
+          tmp directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1122040404/10001
 
   Stage: Stage-6
     Map Reduce
@@ -439,9 +436,9 @@
                             type: bigint
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -456,7 +453,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/rmurthy/hive/build/ql/test/data/warehouse/src
+                location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
       Reduce Operator Tree:
@@ -476,15 +473,14 @@
             File Output Operator
               compressed: false
               GlobalTableId: 0
-              directory: file:/data/users/rmurthy/hive/build/ql/tmp/1831027677/10004
+              directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/8604588/10004
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                   properties:
-                    name binary_table
-                    serialization.ddl struct binary_table { string _col0, i64 _col1}
-                    serialization.format org.apache.thrift.protocol.TBinaryProtocol
-                  name: binary_table
+                    columns _col0,_col1
+                    columns.types string,bigint
+                    escape.delim \
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -500,7 +496,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/rmurthy/hive/build/ql/tmp/388644930/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/140307786/10000
 128		3
 146	val_146	2
 150	val_150	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_hive_626.q.out Wed Jul 15 01:52:41 2009
@@ -68,7 +68,6 @@
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                name: binary_table
 
   Stage: Stage-2
     Map Reduce
@@ -133,7 +132,7 @@
 Input: default/hive_foo
 Input: default/hive_count
 Input: default/hive_bar
-Output: file:/Users/char/Documents/workspace/Hive-Clean/build/ql/tmp/512847523/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/677923597/10000
 foo1	bar10	2
 query: drop table hive_foo
 query: drop table hive_bar

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out Wed Jul 15 01:52:41 2009
@@ -63,12 +63,11 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/926752707/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/792304338/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out Wed Jul 15 01:52:41 2009
@@ -54,7 +54,7 @@
 
 query: select count(1) from src x where x.key > 9999
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1268175684/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1008591078/10000
 0
 query: explain
 select count(1) from src x where x.key > 9999
@@ -112,7 +112,7 @@
 
 query: select count(1) from src x where x.key > 9999
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1223713151/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2013896638/10000
 0
 query: explain
 select count(1) from src x where x.key > 9999
@@ -158,12 +158,11 @@
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/163149910/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1522558889/10002 
             Reduce Output Operator
               sort order: 
               tag: -1
@@ -193,7 +192,7 @@
 
 query: select count(1) from src x where x.key > 9999
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1599407772/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1698315525/10000
 0
 query: explain
 select count(1) from src x where x.key > 9999
@@ -247,5 +246,5 @@
 
 query: select count(1) from src x where x.key > 9999
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1652857331/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1010160157/10000
 0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out Wed Jul 15 01:52:41 2009
@@ -51,19 +51,18 @@
           keys:
                 expr: KEY._col0
                 type: string
-          mode: partial2
+          mode: partials
           File Output Operator
             compressed: false
             GlobalTableId: 0
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/728386179/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/994469608/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -101,10 +100,9 @@
     Fetch Operator
       limit: -1
 
-
 query: select x.key, count(1) from src x where x.key > 9999 group by x.key
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/284238698/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/307851852/10000
 query: explain
 select x.key, count(1) from src x where x.key > 9999 group by x.key
 ABSTRACT SYNTAX TREE:
@@ -178,7 +176,7 @@
 
 query: select x.key, count(1) from src x where x.key > 9999 group by x.key
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1931999488/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1608573572/10000
 query: explain
 select x.key, count(1) from src x where x.key > 9999 group by x.key
 ABSTRACT SYNTAX TREE:
@@ -232,12 +230,11 @@
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1264700371/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/360265532/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -278,7 +275,7 @@
 
 query: select x.key, count(1) from src x where x.key > 9999 group by x.key
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/192620128/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/208705197/10000
 query: explain
 select x.key, count(1) from src x where x.key > 9999 group by x.key
 ABSTRACT SYNTAX TREE:
@@ -345,4 +342,4 @@
 
 query: select x.key, count(1) from src x where x.key > 9999 group by x.key
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/5517742/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1575645808/10000

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out Wed Jul 15 01:52:41 2009
@@ -52,19 +52,18 @@
           aggregations:
                 expr: count(VALUE._col0)
                 expr: count(DISTINCT KEY._col0)
-          mode: partial2
+          mode: partials
           File Output Operator
             compressed: false
             GlobalTableId: 0
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/630845842/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1530804093/10002 
             Reduce Output Operator
               sort order: 
               tag: -1
@@ -99,7 +98,7 @@
 
 query: select count(1), count(distinct x.value) from src x where x.key = 9999
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1938635713/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/429769664/10000
 0	0
 query: explain
 select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -172,7 +171,7 @@
 
 query: select count(1), count(distinct x.value) from src x where x.key = 9999
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2019754835/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1474714748/10000
 0	0
 query: explain
 select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -225,12 +224,11 @@
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1425841757/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1775276557/10002 
             Reduce Output Operator
               sort order: 
               tag: -1
@@ -265,7 +263,7 @@
 
 query: select count(1), count(distinct x.value) from src x where x.key = 9999
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2042822876/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/559124922/10000
 0	0
 query: explain
 select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -328,5 +326,5 @@
 
 query: select count(1), count(distinct x.value) from src x where x.key = 9999
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2013029014/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2134992556/10000
 0	0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Wed Jul 15 01:52:41 2009
@@ -56,7 +56,7 @@
 
 query: SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/673778413/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1968231476/10000
 10	val_10
 query: EXPLAIN 
 SELECT x.key, x.value as v1, y.key  FROM SRC x JOIN SRC y ON (x.key = y.key)  where x.key = 20 CLUSTER BY v1
@@ -129,12 +129,11 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1323731431/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/955520378/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col1
@@ -167,5 +166,5 @@
 
 query: SELECT x.key, x.value as v1, y.key  FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1056466885/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1619244792/10000
 20	val_20	20

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out Wed Jul 15 01:52:41 2009
@@ -87,12 +87,11 @@
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                        name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1551152352/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1611172064/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -137,7 +136,7 @@
 WHERE src1.c1 > 'val_200' AND (src1.c2 > 30 OR src1.c1 < 'val_400')
 GROUP BY src1.c2
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/455848953/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/283923095/10000
 val_4	1
 val_399	2
 val_396	3

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out Wed Jul 15 01:52:41 2009
@@ -105,12 +105,11 @@
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1497686794/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/322267744/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out Wed Jul 15 01:52:41 2009
@@ -96,7 +96,6 @@
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                name: binary_table
 
   Stage: Stage-2
     Map Reduce
@@ -187,7 +186,7 @@
 ON src1.c2 = src3.c6
 WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13)
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/976262349/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1593170677/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out Wed Jul 15 01:52:41 2009
@@ -103,12 +103,11 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1627716724/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1412459815/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -173,7 +172,7 @@
 ORDER BY a.key, a.value, a.ds, a.hr, b.key, b.value, b.ds, b.hr
 Input: default/srcpart/ds=2008-04-08/hr=11
 Input: default/srcpart/ds=2008-04-08/hr=12
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/12175819/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2131288754/10000
 27	val_27	2008-04-08	11	27	val_27	2008-04-08	11
 27	val_27	2008-04-08	11	27	val_27	2008-04-08	12
 27	val_27	2008-04-08	12	27	val_27	2008-04-08	11

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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -241,12 +241,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1521077193/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/54303527/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -281,7 +280,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:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1366398818/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1566516401/10000
 2008-04-08	11
 2008-04-08	11
 2008-04-08	11
@@ -445,7 +444,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:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/544471444/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/332258618/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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -58,12 +58,12 @@
                         type: string
       Needs Tagging: true
       Path -> Alias:
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
       Path -> Partition:
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
           Partition
             partition values:
               ds 2008-04-08
@@ -82,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/rmurthy/hive/build/ql/test/data/warehouse/srcpart
+                location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
           Partition
             partition values:
               ds 2008-04-08
@@ -104,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/rmurthy/hive/build/ql/test/data/warehouse/srcpart
+                location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=11 
           Partition
             partition values:
               ds 2008-04-09
@@ -126,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/rmurthy/hive/build/ql/test/data/warehouse/srcpart
+                location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
-        file:/data/users/rmurthy/hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12 
           Partition
             partition values:
               ds 2008-04-09
@@ -148,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/rmurthy/hive/build/ql/test/data/warehouse/srcpart
+                location file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
       Reduce Operator Tree:
@@ -175,20 +175,19 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/rmurthy/hive/build/ql/tmp/993281011/10002
+                directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/90130211/10002
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
-                      name binary_table
-                      serialization.ddl struct binary_table { string _col0, string _col1, string _col2, string _col3}
-                      serialization.format org.apache.thrift.protocol.TBinaryProtocol
-                    name: binary_table
+                      columns _col0,_col1,_col2,_col3
+                      columns.types string,string,string,string
+                      escape.delim \
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/rmurthy/hive/build/ql/tmp/993281011/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/90130211/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -213,24 +212,23 @@
                     type: string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/rmurthy/hive/build/ql/tmp/993281011/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/90130211/10002 
       Path -> Partition:
-        file:/data/users/rmurthy/hive/build/ql/tmp/993281011/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/90130211/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                name binary_table
-                serialization.ddl struct binary_table { string _col0, string _col1, string _col2, string _col3}
-                serialization.format org.apache.thrift.protocol.TBinaryProtocol
-              name: binary_table
+                columns _col0,_col1,_col2,_col3
+                columns.types string,string,string,string
+                escape.delim \
       Reduce Operator Tree:
         Extract
           File Output Operator
             compressed: false
             GlobalTableId: 0
-            directory: file:/data/users/rmurthy/hive/build/ql/tmp/993281011/10001
+            directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/90130211/10001
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -254,7 +252,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/rmurthy/hive/build/ql/tmp/673725995/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/320178544/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out Wed Jul 15 01:52:41 2009
@@ -18,8 +18,8 @@
               Group By Operator
                 aggregations:
                       expr: count(UDFToInteger(''))
-                      expr: sum(UDFToDouble(UDFToInteger('')))
-                      expr: avg(UDFToDouble(UDFToInteger('')))
+                      expr: sum(UDFToInteger(''))
+                      expr: avg(UDFToInteger(''))
                       expr: min(UDFToInteger(''))
                       expr: max(UDFToInteger(''))
                 mode: hash
@@ -30,9 +30,9 @@
                         expr: _col0
                         type: bigint
                         expr: _col1
-                        type: double
+                        type: bigint
                         expr: _col2
-                        type: string
+                        type: struct<count:bigint,sum:double>
                         expr: _col3
                         type: int
                         expr: _col4
@@ -51,7 +51,7 @@
                   expr: _col0
                   type: bigint
                   expr: _col1
-                  type: double
+                  type: bigint
                   expr: _col2
                   type: double
                   expr: _col3
@@ -84,5 +84,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1577421576/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/973262666/10000
 0	NULL	NULL	NULL	NULL

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out Wed Jul 15 01:52:41 2009
@@ -25,8 +25,8 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: avg(UDFToDouble(c1))
-                      expr: sum(UDFToDouble(c1))
+                      expr: avg(c1)
+                      expr: sum(c1)
                       expr: count(c1)
                 mode: hash
                 Reduce Output Operator
@@ -34,7 +34,7 @@
                   tag: -1
                   value expressions:
                         expr: _col0
-                        type: string
+                        type: struct<count:bigint,sum:double>
                         expr: _col1
                         type: double
                         expr: _col2
@@ -68,5 +68,5 @@
 
 query: SELECT avg(c1), sum(c1), count(c1) FROM dest1
 Input: default/dest1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1344361217/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/148949332/10000
 1.0	1.0	1

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=794129&r1=794128&r2=794129&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 Wed Jul 15 01:52:41 2009
@@ -59,12 +59,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1330132213/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/881693184/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -98,7 +97,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/303679320/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1098336610/10000
 5
 5
 5

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.q.out Wed Jul 15 01:52:41 2009
@@ -59,12 +59,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1047259223/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/663445085/10002 
           Union
             Select Operator
               expressions:
@@ -86,7 +85,7 @@
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: tmptable
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1047259223/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/663445085/10004 
           Union
             Select Operator
               expressions:
@@ -108,7 +107,7 @@
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: tmptable
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1047259223/10005 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/663445085/10005 
           Union
             Select Operator
               expressions:
@@ -137,10 +136,10 @@
           Move Operator
             files:
                 hdfs directory: true
-                destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/899550883/10000
+                destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1900390672/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/njain/hive4/hive4/build/ql/tmp/1047259223/10003 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/663445085/10003 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -205,7 +204,6 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-7
     Map Reduce
@@ -239,7 +237,6 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
 
 query: insert overwrite table tmptable
@@ -252,7 +249,7 @@
 Output: default/tmptable
 query: select * from tmptable x sort by x.key
 Input: default/tmptable
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1029379727/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1983301805/10000
 tst1	500
 tst2	500
 tst3	500

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out Wed Jul 15 01:52:41 2009
@@ -51,12 +51,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1039026532/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/615733629/10002 
           Union
             Select Operator
               expressions:
@@ -81,7 +80,7 @@
                   value expressions:
                         expr: _col1
                         type: bigint
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1039026532/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/615733629/10003 
           Union
             Select Operator
               expressions:
@@ -106,7 +105,7 @@
                   value expressions:
                         expr: _col1
                         type: bigint
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1039026532/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/615733629/10004 
           Union
             Select Operator
               expressions:
@@ -184,7 +183,6 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-4
     Map Reduce
@@ -218,7 +216,6 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-0
     Fetch Operator
@@ -231,7 +228,7 @@
                                         UNION ALL
                                             select 'tst3' as key, count(1) as value from src s3) unionsrc group by unionsrc.key
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1124432682/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/498602862/10000
 tst1	1
 tst2	1
 tst3	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.q.out Wed Jul 15 01:52:41 2009
@@ -59,12 +59,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1811518672/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/96530042/10002 
           Union
             Select Operator
               expressions:
@@ -86,7 +85,7 @@
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: tmptable
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1811518672/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/96530042/10004 
           Union
             Select Operator
               expressions:
@@ -108,7 +107,7 @@
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: tmptable
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1811518672/10005 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/96530042/10005 
           Union
             Select Operator
               expressions:
@@ -137,10 +136,10 @@
           Move Operator
             files:
                 hdfs directory: true
-                destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1301288760/10000
+                destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/981352387/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/njain/hive4/hive4/build/ql/tmp/1811518672/10003 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/96530042/10003 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -205,7 +204,6 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-7
     Map Reduce
@@ -239,7 +237,6 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
 
 query: insert overwrite table tmptable
@@ -254,7 +251,7 @@
 Output: default/tmptable
 query: select * from tmptable x sort by x.key
 Input: default/tmptable
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/65502755/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/251427651/10000
 tst1	500
 tst2	25
 tst3	1000

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out Wed Jul 15 01:52:41 2009
@@ -32,12 +32,11 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/427160604/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1103651888/10002 
           Union
             Select Operator
               expressions:
@@ -62,7 +61,7 @@
                   value expressions:
                         expr: _col1
                         type: bigint
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/427160604/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1103651888/10003 
           Union
             Select Operator
               expressions:
@@ -140,7 +139,6 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-0
     Fetch Operator
@@ -153,7 +151,7 @@
   unionsrc group by unionsrc.key
 Input: default/src1
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/332041097/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/452775957/10000
 	10
 128	1
 146	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out Wed Jul 15 01:52:41 2009
@@ -51,12 +51,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500235306/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/44626625/10002 
           Union
             Select Operator
               expressions:
@@ -81,7 +80,7 @@
                   value expressions:
                         expr: _col1
                         type: bigint
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500235306/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/44626625/10003 
           Union
             Select Operator
               expressions:
@@ -106,7 +105,7 @@
                   value expressions:
                         expr: _col1
                         type: bigint
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500235306/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/44626625/10004 
           Union
             Select Operator
               expressions:
@@ -168,7 +167,6 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
   Stage: Stage-4
     Map Reduce
@@ -186,7 +184,6 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
   Stage: Stage-0
     Fetch Operator
@@ -200,7 +197,7 @@
                                             select s3.key as key, s3.value as value from src1 s3) unionsrc group by unionsrc.key
 Input: default/src
 Input: default/src1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/439174720/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1736666761/10000
 	20
 128	2
 146	2

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out Wed Jul 15 01:52:41 2009
@@ -58,12 +58,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1604156998/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2115299971/10004 
           Union
             Select Operator
               expressions:
@@ -117,8 +116,7 @@
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      name: binary_table
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1604156998/10006 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2115299971/10006 
           Union
             Select Operator
               expressions:
@@ -172,7 +170,6 @@
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                      name: binary_table
       Reduce Operator Tree:
         Group By Operator
           aggregations:
@@ -209,7 +206,7 @@
   Stage: Stage-4
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1604156998/10005 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2115299971/10005 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -281,7 +278,6 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
 
 query: FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
@@ -294,7 +290,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/631945377/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1781230787/10000
 0	1
 10	1
 100	1
@@ -604,10 +600,10 @@
 96	1
 97	1
 98	1
-tst1	0
+tst1	1
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1564293168/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/891535145/10000
 0	val_0	1
 10	val_10	1
 100	val_100	1
@@ -917,6 +913,6 @@
 96	val_96	1
 97	val_97	1
 98	val_98	1
-tst1	500	0
+tst1	500	1
 query: drop table DEST1
 query: drop table DEST2

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out Wed Jul 15 01:52:41 2009
@@ -60,12 +60,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/350775461/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1677640228/10004 
           Union
             Select Operator
               expressions:
@@ -97,7 +96,7 @@
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     name: dest2
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/350775461/10007 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1677640228/10007 
           Union
             Select Operator
               expressions:
@@ -136,10 +135,10 @@
           Move Operator
             files:
                 hdfs directory: true
-                destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1724840448/10000
+                destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1791034081/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/njain/hive4/hive4/build/ql/tmp/350775461/10005 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1677640228/10005 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -178,10 +177,10 @@
           Move Operator
             files:
                 hdfs directory: true
-                destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1724840448/10002
+                destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1791034081/10002
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/njain/hive4/hive4/build/ql/tmp/350775461/10006 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1677640228/10006 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -232,7 +231,6 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
 
 query: FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
@@ -245,7 +243,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/579835717/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/481629855/10000
 0	val_0
 0	val_0
 0	val_0
@@ -749,7 +747,7 @@
 tst1	500
 query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1139474399/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1239038760/10000
 0	val_0	val_0
 0	val_0	val_0
 0	val_0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.q.out Wed Jul 15 01:52:41 2009
@@ -56,12 +56,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/850471669/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1000894455/10004 
           Union
             Select Operator
               expressions:
@@ -104,7 +103,7 @@
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     name: dest2
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/850471669/10005 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1000894455/10005 
           Union
             Select Operator
               expressions:
@@ -206,7 +205,6 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
 
 query: FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
@@ -219,7 +217,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/584098642/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1842108854/10000
 0	3
 10	1
 100	2
@@ -532,7 +530,7 @@
 tst1	1
 query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/106612674/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1264340998/10000
 0	val_0	val_0
 0	val_0	val_0
 0	val_0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out Wed Jul 15 01:52:41 2009
@@ -59,12 +59,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/579163613/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2117443883/10002 
           Union
             Reduce Output Operator
               key expressions:
@@ -80,7 +79,7 @@
                     type: string
                     expr: _col1
                     type: string
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/579163613/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2117443883/10003 
           Union
             Reduce Output Operator
               key expressions:
@@ -159,7 +158,6 @@
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                        name: binary_table
 
   Stage: Stage-4
     Map Reduce
@@ -185,12 +183,11 @@
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                        name: binary_table
 
   Stage: Stage-5
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/579163613/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2117443883/10004 
           Union
             File Output Operator
               compressed: false
@@ -198,8 +195,7 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/579163613/10006 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2117443883/10006 
           Union
             File Output Operator
               compressed: false
@@ -207,7 +203,6 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-6
     Map Reduce
@@ -241,7 +236,6 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-0
     Fetch Operator
@@ -258,7 +252,7 @@
       select s4.key as key, s4.value as value from src s4 where s4.key < 10) unionsrc2
 ON (unionsrc1.key = unionsrc2.key)
 Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1483573814/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2027041799/10000
 0	val_0	0	val_0
 0	val_0	0	val_0
 0	val_0	0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out Wed Jul 15 01:52:41 2009
@@ -64,12 +64,11 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/312943406/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10002 
           Union
             Select Operator
               expressions:
@@ -81,7 +80,7 @@
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/312943406/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10003 
           Union
             Select Operator
               expressions:
@@ -93,7 +92,7 @@
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/312943406/10005 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10005 
           Union
             Select Operator
               expressions:
@@ -105,7 +104,7 @@
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/312943406/10007 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10007 
           Union
             Select Operator
               expressions:
@@ -150,7 +149,6 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
   Stage: Stage-4
     Map Reduce
@@ -184,12 +182,11 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
   Stage: Stage-5
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/312943406/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10004 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -210,7 +207,6 @@
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                name: binary_table
 
   Stage: Stage-6
     Map Reduce
@@ -244,12 +240,11 @@
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
 
   Stage: Stage-7
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/312943406/10006 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1599706373/10006 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -270,7 +265,6 @@
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                name: binary_table
 
   Stage: Stage-0
     Fetch Operator
@@ -300,7 +294,7 @@
 Output: default/union_out
 query: select * from union_out cluster by id
 Input: default/union_out
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1024406189/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1772585743/10000
 1
 2
 3

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out Wed Jul 15 01:52:41 2009
@@ -53,12 +53,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/617946957/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/800954913/10002 
           Union
             Select Operator
               expressions:
@@ -80,7 +79,7 @@
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: tmptable
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/617946957/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/800954913/10004 
           Union
             Select Operator
               expressions:
@@ -109,10 +108,10 @@
           Move Operator
             files:
                 hdfs directory: true
-                destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/22706365/10000
+                destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/97307442/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/njain/hive4/hive4/build/ql/tmp/617946957/10003 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/800954913/10003 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -177,7 +176,6 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
 
 query: insert overwrite table tmptable
@@ -188,7 +186,7 @@
 Output: default/tmptable
 query: select * from tmptable x sort by x.key
 Input: default/tmptable
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1336849489/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1062910028/10000
 tst1	500
 tst2	500
 query: drop table tmptable

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out Wed Jul 15 01:52:41 2009
@@ -47,12 +47,11 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/788110677/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/991394606/10002 
           Union
             Select Operator
               expressions:
@@ -77,7 +76,7 @@
                   value expressions:
                         expr: _col1
                         type: bigint
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/788110677/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/991394606/10003 
           Union
             Select Operator
               expressions:
@@ -155,7 +154,6 @@
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
 
   Stage: Stage-0
     Fetch Operator
@@ -166,6 +164,6 @@
                                   UNION  ALL  
                                     select 'tst2' as key, count(1) as value from src s2) unionsrc group by unionsrc.key
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/428835180/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/625257949/10000
 tst1	1
 tst2	1



Mime
View raw message