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

svn commit: r794129 [3/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/...

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out Wed Jul 15 01:52:41 2009
@@ -21,9 +21,9 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: sum(UDFToDouble(substr(value, 5)))
-                      expr: avg(UDFToDouble(substr(value, 5)))
-                      expr: avg(DISTINCT UDFToDouble(substr(value, 5)))
+                      expr: sum(substr(value, 5))
+                      expr: avg(substr(value, 5))
+                      expr: avg(DISTINCT substr(value, 5))
                       expr: max(substr(value, 5))
                       expr: min(substr(value, 5))
                 keys:
@@ -43,9 +43,9 @@
                         expr: _col1
                         type: double
                         expr: _col2
-                        type: string
+                        type: struct<count:bigint,sum:double>
                         expr: _col3
-                        type: string
+                        type: struct<count:bigint,sum:double>
                         expr: _col4
                         type: string
                         expr: _col5
@@ -55,22 +55,21 @@
           aggregations:
                 expr: sum(VALUE._col0)
                 expr: avg(VALUE._col1)
-                expr: avg(DISTINCT UDFToDouble(KEY._col0))
+                expr: avg(DISTINCT KEY._col0)
                 expr: max(VALUE._col3)
                 expr: min(VALUE._col4)
-          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:/data/users/njain/hive4/hive4/build/ql/tmp/1228327883/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1038557328/10002 
             Reduce Output Operator
               sort order: 
               tag: -1
@@ -78,9 +77,9 @@
                     expr: _col0
                     type: double
                     expr: _col1
-                    type: string
+                    type: struct<count:bigint,sum:double>
                     expr: _col2
-                    type: string
+                    type: struct<count:bigint,sum:double>
                     expr: _col3
                     type: string
                     expr: _col4
@@ -144,5 +143,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/820936142/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/419092325/10000
 130091.0	260.182	256.10355987055016	98.0	0.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out Wed Jul 15 01:52:41 2009
@@ -27,9 +27,9 @@
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(UDFToDouble(KEY._col0))
-                expr: avg(UDFToDouble(KEY._col0))
-                expr: avg(DISTINCT UDFToDouble(KEY._col0))
+                expr: sum(KEY._col0)
+                expr: avg(KEY._col0)
+                expr: avg(DISTINCT KEY._col0)
                 expr: max(KEY._col0)
                 expr: min(KEY._col0)
           mode: complete
@@ -83,5 +83,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/812556087/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1412035042/10000
 130091.0	260.182	256.10355987055016	98.0	0.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out Wed Jul 15 01:52:41 2009
@@ -40,12 +40,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/109948629/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/238763710/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -91,7 +90,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1413679175/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/705798724/10000
 0
 1
 2

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out Wed Jul 15 01:52:41 2009
@@ -38,7 +38,7 @@
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(UDFToDouble(VALUE._col0))
+                expr: sum(VALUE._col0)
           keys:
                 expr: KEY._col0
                 type: string
@@ -49,12 +49,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/1596834878/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1023721383/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -115,7 +114,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1785134146/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1858809382/10000
 0	0.0
 10	10.0
 100	200.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out Wed Jul 15 01:52:41 2009
@@ -19,7 +19,7 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: sum(UDFToDouble(key))
+                      expr: sum(key)
                 mode: hash
                 Reduce Output Operator
                   sort order: 
@@ -65,5 +65,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1649758304/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/430800667/10000
 130091

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out Wed Jul 15 01:52:41 2009
@@ -19,7 +19,7 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: sum(UDFToDouble(key))
+                      expr: sum(key)
                 mode: hash
                 Reduce Output Operator
                   sort order: 
@@ -65,5 +65,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1898688763/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/535679117/10000
 130091

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out Wed Jul 15 01:52:41 2009
@@ -37,7 +37,7 @@
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(UDFToDouble(VALUE._col0))
+                expr: sum(VALUE._col0)
           keys:
                 expr: KEY._col0
                 type: string
@@ -82,7 +82,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/990860736/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1880216237/10000
 0	0.0
 10	10.0
 100	200.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out Wed Jul 15 01:52:41 2009
@@ -40,12 +40,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/1494846209/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2034874876/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -91,7 +90,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1921611682/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/770471577/10000
 0
 1
 2

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out Wed Jul 15 01:52:41 2009
@@ -38,19 +38,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:/data/users/njain/hive4/hive4/build/ql/tmp/1834003124/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/745628298/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -96,7 +95,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1944209858/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/6016821/10000
 0
 1
 2

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out Wed Jul 15 01:52:41 2009
@@ -26,7 +26,7 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: sum(UDFToDouble(substr(value, 5)))
+                      expr: sum(substr(value, 5))
                 keys:
                       expr: key
                       type: string
@@ -51,7 +51,7 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: sum(UDFToDouble(substr(value, 5)))
+                      expr: sum(substr(value, 5))
                 keys:
                       expr: key
                       type: string
@@ -62,7 +62,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:
@@ -105,7 +104,7 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1567721211/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/183709519/10004 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -166,7 +165,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/573082325/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1600502847/10000
 0	0.0
 10	10.0
 100	200.0
@@ -478,7 +477,7 @@
 98	196.0
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/749695907/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1252175276/10000
 0	0.0
 10	10.0
 100	200.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out Wed Jul 15 01:52:41 2009
@@ -28,7 +28,7 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: sum(UDFToDouble(substr(value, 5)))
+                      expr: sum(substr(value, 5))
                 keys:
                       expr: key
                       type: string
@@ -53,7 +53,7 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: sum(UDFToDouble(substr(value, 5)))
+                      expr: sum(substr(value, 5))
                 keys:
                       expr: key
                       type: string
@@ -64,7 +64,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:
@@ -72,19 +71,18 @@
           keys:
                 expr: KEY._col0
                 type: string
-          mode: partial2
+          mode: partials
           File Output Operator
             compressed: true
             GlobalTableId: 0
             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/1954125949/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/107805350/10004 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -139,7 +137,7 @@
   Stage: Stage-4
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1954125949/10005 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/107805350/10005 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -159,19 +157,18 @@
           keys:
                 expr: KEY._col0
                 type: string
-          mode: partial2
+          mode: partials
           File Output Operator
             compressed: true
             GlobalTableId: 0
             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/1954125949/10006 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/107805350/10006 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -232,7 +229,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/454858363/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/735440976/10000
 0	0.0
 10	10.0
 100	200.0
@@ -544,7 +541,7 @@
 98	196.0
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/207448427/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2032949852/10000
 0	0.0
 10	10.0
 100	200.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out Wed Jul 15 01:52:41 2009
@@ -48,11 +48,10 @@
                 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:
-                expr: sum(UDFToDouble(VALUE._col0))
+                expr: sum(VALUE._col0)
           keys:
                 expr: KEY._col0
                 type: string
@@ -91,7 +90,7 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/654919673/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1533892009/10004 
             Reduce Output Operator
               key expressions:
                     expr: key
@@ -107,7 +106,7 @@
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(UDFToDouble(VALUE._col0))
+                expr: sum(VALUE._col0)
           keys:
                 expr: KEY._col0
                 type: string
@@ -152,7 +151,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/988624770/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1595159754/10000
 0	0.0
 10	10.0
 100	200.0
@@ -464,7 +463,7 @@
 98	196.0
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/104017678/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/25705563/10000
 0	0.0
 10	10.0
 100	200.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out Wed Jul 15 01:52:41 2009
@@ -51,7 +51,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:
@@ -66,12 +65,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/375925648/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/276821233/10004 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -126,7 +124,7 @@
   Stage: Stage-4
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/375925648/10005 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/276821233/10005 
             Reduce Output Operator
               key expressions:
                     expr: key
@@ -154,12 +152,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/375925648/10006 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/276821233/10006 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -220,7 +217,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1760864760/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/437515527/10000
 0	1
 10	1
 100	1
@@ -532,7 +529,7 @@
 98	1
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1829308600/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1234696603/10000
 0	1
 10	1
 100	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map.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
       Reduce Operator Tree:
         Group By Operator
           aggregations:
@@ -111,7 +110,7 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/903311418/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/794989277/10004 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -174,7 +173,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1813648590/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/464738216/10000
 0	1
 10	1
 100	1
@@ -486,7 +485,7 @@
 98	1
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1471574546/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/989476641/10000
 0	1
 10	1
 100	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out Wed Jul 15 01:52:41 2009
@@ -72,7 +72,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:
@@ -80,19 +79,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-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/648298710/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1950398352/10004 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -147,7 +145,7 @@
   Stage: Stage-4
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/648298710/10005 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1950398352/10005 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -171,19 +169,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-5
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/648298710/10006 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1950398352/10006 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -244,7 +241,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/2050045624/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/53142172/10000
 0	1
 10	1
 100	1
@@ -556,7 +553,7 @@
 98	1
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1488204579/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1788932250/10000
 0	1
 10	1
 100	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out Wed Jul 15 01:52:41 2009
@@ -47,7 +47,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:
@@ -90,7 +89,7 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1042516895/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/511682888/10004 
             Reduce Output Operator
               key expressions:
                     expr: key
@@ -150,7 +149,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1777705235/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2002182053/10000
 0	1
 10	1
 100	1
@@ -462,7 +461,7 @@
 98	1
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1019154159/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/673356891/10000
 0	1
 10	1
 100	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out Wed Jul 15 01:52:41 2009
@@ -72,7 +72,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:
@@ -115,7 +114,7 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/847202273/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/620467689/10004 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -188,7 +187,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/2085147439/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1918642131/10000
 0	1
 10	1
 100	1
@@ -500,7 +499,7 @@
 98	1
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/778831730/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/925610192/10000
 0	val_0	1
 10	val_10	1
 100	val_100	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out Wed Jul 15 01:52:41 2009
@@ -54,12 +54,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/1708160679/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/105591315/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -124,7 +123,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1754915131/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/790975206/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out Wed Jul 15 01:52:41 2009
@@ -54,7 +54,6 @@
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                        name: binary_table
       Reduce Operator Tree:
         Extract
           Limit
@@ -86,7 +85,7 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1060095583/10004 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/190339835/10004 
             Reduce Output Operator
               sort order: 
               tag: -1
@@ -132,7 +131,7 @@
 Output: default/dest2
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1315139116/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1258757679/10000
 86	val_86
 27	val_27
 98	val_98
@@ -145,7 +144,7 @@
 57	val_57
 query: SELECT dest2.* FROM dest2
 Input: default/dest2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1285938692/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1544848437/10000
 86	val_86
 27	val_27
 98	val_98

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input25.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/717433292/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1576345941/10002 
           Union
             Select Operator
               expressions:
@@ -80,7 +79,7 @@
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/717433292/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1576345941/10003 
           Union
             Select Operator
               expressions:
@@ -137,7 +136,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
@@ -151,5 +149,5 @@
 ) subq
 Input: default/tst/d=2009-01-01
 Input: default/tst/d=2009-02-02
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/273314648/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1172948551/10000
 query: drop table tst

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input26.q.out Wed Jul 15 01:52:41 2009
@@ -61,12 +61,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/998416025/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1656753029/10002 
           Union
             Select Operator
               expressions:
@@ -84,7 +83,7 @@
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/998416025/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1656753029/10003 
           Union
             Select Operator
               expressions:
@@ -147,7 +146,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
@@ -160,7 +158,7 @@
   select * from srcpart b where b.ds = '2008-04-08' and b.hr = '14' limit 5
 )subq
 Input: default/srcpart/ds=2008-04-08/hr=11
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/122967309/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1769087452/10000
 0	val_0	2008-04-08	11
 0	val_0	2008-04-08	11
 0	val_0	2008-04-08	11

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.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-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/2087941217/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1327788868/10002 
             Reduce Output Operator
               sort order: 
               tag: -1
@@ -98,7 +97,7 @@
 Output: default/t2
 query: SELECT * FROM T2 SORT BY key, value
 Input: default/t2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1213849877/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1102190511/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out Wed Jul 15 01:52:41 2009
@@ -39,12 +39,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/2049580485/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1567308263/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -73,7 +72,7 @@
 
 query: select * from src sort by key limit 10
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/83498755/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1617449632/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join0.q.out Wed Jul 15 01:52:41 2009
@@ -86,12 +86,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/1881512857/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/760579710/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -134,7 +133,7 @@
   (SELECT * FROM src WHERE src.key < 10) src2
   SORT BY k1, v1, k2, v2
 Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/905222648/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1911587693/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/join13.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join13.q.out Wed Jul 15 01:52:41 2009
@@ -79,7 +79,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
@@ -156,7 +155,7 @@
 (SELECT src.key as c5, src.value as c6 from src) src3
 ON src1.c1 + src2.c3 = src3.c5 AND src3.c5 < 200
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/372904562/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1668670433/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join15.q.out Wed Jul 15 01:52:41 2009
@@ -65,12 +65,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/324026452/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/737821530/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -108,7 +107,7 @@
 
 query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key) SORT BY src1.key, src1.value, src2.key, src2.value
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/394554803/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1955953451/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/join18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join18.q.out Wed Jul 15 01:52:41 2009
@@ -74,7 +74,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
@@ -182,7 +181,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
@@ -202,8 +200,8 @@
  ON (a.key = b.key)
 Input: default/src1
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/724709493/10000
-NULL	NULL		6
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/838858920/10000
+NULL	NULL		7
 0	3	NULL	NULL
 10	1	NULL	NULL
 100	2	NULL	NULL
@@ -221,7 +219,7 @@
 120	2	NULL	NULL
 125	2	NULL	NULL
 126	1	NULL	NULL
-128	3	128	0
+128	3	128	1
 129	2	NULL	NULL
 131	1	NULL	NULL
 133	1	NULL	NULL
@@ -295,7 +293,7 @@
 221	2	NULL	NULL
 222	1	NULL	NULL
 223	2	NULL	NULL
-224	2	224	0
+224	2	224	1
 226	1	NULL	NULL
 228	1	NULL	NULL
 229	2	NULL	NULL
@@ -388,7 +386,7 @@
 366	1	NULL	NULL
 367	2	NULL	NULL
 368	1	NULL	NULL
-369	3	369	0
+369	3	369	1
 37	2	NULL	NULL
 373	1	NULL	NULL
 374	1	NULL	NULL

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join19.q.out Wed Jul 15 01:52:41 2009
@@ -162,7 +162,6 @@
             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
@@ -248,7 +247,6 @@
             table:
                 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                name: binary_table
 
   Stage: Stage-1
     Map Reduce

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join2.q.out Wed Jul 15 01:52:41 2009
@@ -53,7 +53,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
@@ -129,7 +128,7 @@
 Output: default/dest_j2
 query: SELECT dest_j2.* FROM dest_j2
 Input: default/dest_j2
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/47427829/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1158599181/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join20.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:/data/users/pchakka/workspace/oshive/build/ql/tmp/281582968/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/644565255/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -155,7 +154,7 @@
 query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
 SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
 Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/105019591/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2039570057/10000
 NULL	NULL	NULL	NULL	10	val_10
 NULL	NULL	NULL	NULL	11	val_11
 NULL	NULL	NULL	NULL	12	val_12
@@ -337,12 +336,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/1417429723/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/256148947/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -389,7 +387,7 @@
 query: SELECT * FROM src src1 JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key < 15) RIGHT OUTER JOIN src src3 ON (src1.key = src3.key AND src3.key < 20)
 SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
 Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1953761211/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1492340440/10000
 NULL	NULL	NULL	NULL	10	val_10
 NULL	NULL	NULL	NULL	11	val_11
 NULL	NULL	NULL	NULL	12	val_12

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join21.q.out Wed Jul 15 01:52:41 2009
@@ -110,12 +110,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/14709034/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/348166588/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -161,7 +160,7 @@
 
 query: SELECT * FROM src src1 LEFT OUTER JOIN src src2 ON (src1.key = src2.key AND src1.key < 10 AND src2.key > 10) RIGHT OUTER JOIN src src3 ON (src2.key = src3.key AND src3.key < 10) SORT BY src1.key, src1.value, src2.key, src2.value, src3.key, src3.value
 Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/808695063/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/63858627/10000
 NULL	NULL	NULL	NULL	0	val_0
 NULL	NULL	NULL	NULL	0	val_0
 NULL	NULL	NULL	NULL	0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join22.q.out Wed Jul 15 01:52:41 2009
@@ -56,7 +56,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

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join23.q.out Wed Jul 15 01:52:41 2009
@@ -65,12 +65,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/283776935/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/701301764/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0
@@ -108,7 +107,7 @@
 
 query: SELECT *  FROM src src1 JOIN src src2 WHERE src1.key < 10 and src2.key < 10 SORT BY src1.key, src1.value, src2.key, src2.value
 Input: default/src
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/334248421/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1243967728/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/join24.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join24.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join24.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join24.q.out Wed Jul 15 01:52:41 2009
@@ -5,6 +5,6 @@
 Output: default/tst1
 query: SELECT sum(a.cnt)  FROM tst1 a JOIN tst1 b ON a.key = b.key
 Input: default/tst1
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/148610721/785047285.10000
-500.0
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/2016366076/10000
+500
 query: drop table tst1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out Wed Jul 15 01:52:41 2009
@@ -66,12 +66,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/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/457091933/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1458390395/10002 
             Common Join Operator
               condition map:
                    Inner Join 0 to 1
@@ -117,11 +116,11 @@
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
-            file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/457091933/10004 
+            file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1458390395/10004 
               Fetch Operator
                 limit: -1
           Alias -> Map Local Operator Tree:
-            file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/457091933/10004 
+            file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1458390395/10004 
                 Common Join Operator
                   condition map:
                        Inner Join 0 to 1
@@ -171,10 +170,10 @@
           Move Operator
             files:
                 hdfs directory: true
-                destination: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/1060447709/10000
+                destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/633726078/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/457091933/10003 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1458390395/10003 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -256,7 +255,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 dest_j1 
@@ -268,7 +266,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/2107397936/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/275397946/10000
 128	1	3
 146	1	2
 150	1	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out Wed Jul 15 01:52:41 2009
@@ -65,12 +65,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/1203288551/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/570921339/10002 
             Common Join Operator
               condition map:
                    Inner Join 0 to 1
@@ -90,11 +89,11 @@
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
-            file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10004 
+            file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/570921339/10004 
               Fetch Operator
                 limit: -1
           Alias -> Map Local Operator Tree:
-            file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10004 
+            file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/570921339/10004 
                 Common Join Operator
                   condition map:
                        Inner Join 0 to 1
@@ -115,7 +114,7 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/570921339/10003 
           Select Operator
             expressions:
                   expr: _col0
@@ -227,7 +226,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 dest_j1 
@@ -240,7 +238,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1617117942/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/944474467/10000
 128	1
 146	1
 150	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out Wed Jul 15 01:52:41 2009
@@ -31,13 +31,14 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10003
+                directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10003
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
                       columns _col0,_col1,_col3
                       columns.types string,string,string
+                      escape.delim \
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
@@ -59,18 +60,19 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10003
+                    directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10003
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                         properties:
                           columns _col0,_col1,_col3
                           columns.types string,string,string
+                          escape.delim \
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-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/njain/deploy/hive1/tools/ahive1-trunk-apache-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
@@ -85,14 +87,14 @@
                 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/njain/deploy/hive1/tools/ahive1-trunk-apache-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
 
   Stage: Stage-1
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10003 
           Select Operator
             expressions:
                   expr: _col0
@@ -130,7 +132,7 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
-                    directory: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002
+                    directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -144,7 +146,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/njain/deploy/hive1/tools/ahive1-trunk-apache-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:
@@ -196,7 +198,7 @@
                             File Output Operator
                               compressed: false
                               GlobalTableId: 1
-                              directory: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002
+                              directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002
                               table:
                                   input format: org.apache.hadoop.mapred.TextInputFormat
                                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -210,14 +212,14 @@
                                     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/njain/deploy/hive1/tools/ahive1-trunk-apache-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/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10003 
       Path -> Partition:
-        file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10003 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10003 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -225,6 +227,7 @@
               properties:
                 columns _col0,_col1,_col3
                 columns.types string,string,string
+                escape.delim \
 
   Stage: Stage-4
     Conditional Operator
@@ -232,11 +235,11 @@
           Move Operator
             files:
                 hdfs directory: true
-                source: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002
-                destination: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/1729211906/10000
+                source: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002
+                destination: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1885700877/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -252,9 +255,9 @@
                           type: string
             Needs Tagging: false
             Path -> Alias:
-              file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002 
             Path -> Partition:
-              file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/207622849/10002 
+              file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1444018326/10002 
                 Partition
                 
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -269,7 +272,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/njain/deploy/hive1/tools/ahive1-trunk-apache-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:
@@ -277,7 +280,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/1729211906/10000
+                  directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1885700877/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -291,7 +294,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/njain/deploy/hive1/tools/ahive1-trunk-apache-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
 
@@ -299,7 +302,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/1729211906/10000
+          source: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1885700877/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -313,10 +316,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/njain/deploy/hive1/tools/ahive1-trunk-apache-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/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/1729211906/10001
+          tmp directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1885700877/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -329,7 +332,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/njain/deploy/hive1/tools/ahive1-trunk-apache-hive/build/ql/tmp/2032442026/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/149664059/10000
 146	val_146	val_146
 146	val_146	val_146
 146	val_146	val_146

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out?rev=794129&r1=794128&r2=794129&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join33.q.out Wed Jul 15 01:52:41 2009
@@ -30,13 +30,14 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
+                directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1966985224/10002
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
                       columns _col0,_col1,_col3
                       columns.types string,string,string
+                      escape.delim \
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
@@ -58,18 +59,19 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
+                    directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1966985224/10002
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                         properties:
                           columns _col0,_col1,_col3
                           columns.types string,string,string
+                          escape.delim \
       Needs Tagging: false
       Path -> Alias:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/Users/char/Documents/workspace/Hive-460/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
@@ -84,7 +86,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:/Users/char/Documents/workspace/Hive-460/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
 
@@ -116,7 +118,7 @@
                     value expressions:
                           expr: value
                           type: string
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1966985224/10002 
           Select Operator
             expressions:
                   expr: _col0
@@ -141,10 +143,10 @@
                     type: string
       Needs Tagging: true
       Path -> Alias:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002 
+        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/tmp/1966985224/10002 
       Path -> Partition:
-        file:/Users/char/Documents/workspace/Hive-460/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
@@ -163,10 +165,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:/Users/char/Documents/workspace/Hive-460/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:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002 
+        file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/1966985224/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -174,6 +176,7 @@
               properties:
                 columns _col0,_col1,_col3
                 columns.types string,string,string
+                escape.delim \
       Reduce Operator Tree:
         Join Operator
           condition map:
@@ -192,7 +195,7 @@
             File Output Operator
               compressed: false
               GlobalTableId: 1
-              directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10000
+              directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/775185405/10000
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -206,7 +209,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:/Users/char/Documents/workspace/Hive-460/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
 
@@ -214,7 +217,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10000
+          source: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/775185405/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -228,10 +231,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:/Users/char/Documents/workspace/Hive-460/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:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10001
+          tmp directory: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/775185405/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -244,7 +247,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1659514145/10000
+Output: file:/data/users/zshao/tools/522-trunk-apache-hive/build/ql/tmp/406645989/10000
 146	val_146	val_146
 146	val_146	val_146
 146	val_146	val_146