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/08/14 09:48:09 UTC

svn commit: r804106 [5/24] - in /hadoop/hive/trunk: ./ contrib/src/java/org/apache/hadoop/hive/contrib/udaf/ contrib/src/java/org/apache/hadoop/hive/contrib/udaf/example/ contrib/src/java/org/apache/hadoop/hive/contrib/udf/ contrib/src/java/org/apache/...

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=804106&r1=804105&r2=804106&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 Fri Aug 14 07:48:02 2009
@@ -27,14 +27,14 @@
                 0 {key} {value}
                 1 {value}
               keys:
-                0 
-                1 
+                0 [Column[key]]
+                1 [Column[key]]
               outputColumnNames: _col0, _col1, _col3
               Position of Big Table: 1
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/919843627/10003
+                directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10003
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -59,14 +59,14 @@
                     0 {key} {value}
                     1 {value}
                   keys:
-                    0 
-                    1 
+                    0 [Column[key]]
+                    1 [Column[key]]
                   outputColumnNames: _col0, _col1, _col3
                   Position of Big Table: 1
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/919843627/10003
+                    directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10003
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -76,9 +76,9 @@
                           escape.delim \
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/src [y]
       Path -> Partition:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -93,14 +93,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/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/athusoo/commits/hive_trunk_ws1/build/ql/tmp/919843627/10003 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10003 
           Select Operator
             expressions:
                   expr: _col0
@@ -117,8 +117,8 @@
                 0 {_col3} {_col0}
                 1 {value}
               keys:
-                0 
-                1 
+                0 [Column[_col1]]
+                1 [Column[value]]
               outputColumnNames: _col1, _col2, _col5
               Position of Big Table: 0
               Select Operator
@@ -142,7 +142,7 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 1
-                    directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/919843627/10002
+                    directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10002
                     table:
                         input format: org.apache.hadoop.mapred.TextInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -156,7 +156,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                          location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
                         serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                         name: dest_j1
       Local Work:
@@ -172,7 +172,7 @@
                 Filter Operator
                   isSamplingPred: false
                   predicate:
-                      expr: ((ds = '2008-04-08') and (UDFToDouble(hr) = UDFToDouble(11)))
+                      expr: ((ds = '2008-04-08') and (hr = 11))
                       type: boolean
                   Filter Operator
                     isSamplingPred: false
@@ -182,7 +182,7 @@
                     Filter Operator
                       isSamplingPred: false
                       predicate:
-                          expr: (UDFToDouble(hr) = UDFToDouble(11))
+                          expr: (hr = 11)
                           type: boolean
                       Common Join Operator
                         condition map:
@@ -191,8 +191,8 @@
                           0 {_col3} {_col0}
                           1 {value}
                         keys:
-                          0 
-                          1 
+                          0 [Column[_col1]]
+                          1 [Column[value]]
                         outputColumnNames: _col1, _col2, _col5
                         Position of Big Table: 0
                         Select Operator
@@ -216,7 +216,7 @@
                             File Output Operator
                               compressed: false
                               GlobalTableId: 1
-                              directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/919843627/10002
+                              directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10002
                               table:
                                   input format: org.apache.hadoop.mapred.TextInputFormat
                                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -230,14 +230,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                                    location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/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/athusoo/commits/hive_trunk_ws1/build/ql/tmp/919843627/10003 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10003 [file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10003]
       Path -> Partition:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/919843627/10003 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10003 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -253,11 +253,11 @@
           Move Operator
             files:
                 hdfs directory: true
-                source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/919843627/10002
-                destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/448925002/10000
+                source: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10002
+                destination: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1409237542/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/919843627/10002 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10002 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -273,9 +273,9 @@
                           type: string
             Needs Tagging: false
             Path -> Alias:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/919843627/10002 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10002 [file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10002]
             Path -> Partition:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/919843627/10002 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/116040832/10002 
                 Partition
                 
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -290,7 +290,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                      location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     name: dest_j1
             Reduce Operator Tree:
@@ -298,7 +298,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/448925002/10000
+                  directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1409237542/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -311,7 +311,7 @@
                         bucket_count -1
                         serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
-                        location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                        location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
                         file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: dest_j1
@@ -320,7 +320,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/448925002/10000
+          source: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1409237542/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -334,10 +334,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: dest_j1
-          tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/448925002/10001
+          tmp directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1409237542/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -350,7 +350,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1275139268/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1095097887/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=804106&r1=804105&r2=804106&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 Fri Aug 14 07:48:02 2009
@@ -26,14 +26,14 @@
                 0 {key} {value}
                 1 {value}
               keys:
-                0 
-                1 
+                0 [Column[key]]
+                1 [Column[key]]
               outputColumnNames: _col0, _col1, _col3
               Position of Big Table: 1
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/402402296/10002
+                directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/120906005/10002
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -58,14 +58,14 @@
                     0 {key} {value}
                     1 {value}
                   keys:
-                    0 
-                    1 
+                    0 [Column[key]]
+                    1 [Column[key]]
                   outputColumnNames: _col0, _col1, _col3
                   Position of Big Table: 1
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/402402296/10002
+                    directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/120906005/10002
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -75,9 +75,9 @@
                           escape.delim \
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src [y]
       Path -> Partition:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -92,7 +92,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/src
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
 
@@ -105,7 +105,7 @@
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: ((ds = '2008-04-08') and (UDFToDouble(hr) = UDFToDouble(11)))
+                  expr: ((ds = '2008-04-08') and (hr = 11))
                   type: boolean
               Filter Operator
                 isSamplingPred: false
@@ -115,7 +115,7 @@
                 Filter Operator
                   isSamplingPred: false
                   predicate:
-                      expr: (UDFToDouble(hr) = UDFToDouble(11))
+                      expr: (hr = 11)
                       type: boolean
                   Reduce Output Operator
                     key expressions:
@@ -129,7 +129,7 @@
                     value expressions:
                           expr: value
                           type: string
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/402402296/10002 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/120906005/10002 
           Select Operator
             expressions:
                   expr: _col0
@@ -155,10 +155,10 @@
                     type: string
       Needs Tagging: true
       Path -> Alias:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/402402296/10002 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [z]
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/120906005/10002 [file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/120906005/10002]
       Path -> Partition:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
           Partition
             partition values:
               ds 2008-04-08
@@ -177,10 +177,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/402402296/10002 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/120906005/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -209,7 +209,7 @@
             File Output Operator
               compressed: false
               GlobalTableId: 1
-              directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/190123379/10000
+              directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/201991762/10000
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -223,7 +223,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                    location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/dest_j1
                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                   name: dest_j1
 
@@ -231,7 +231,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/190123379/10000
+          source: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/201991762/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -245,10 +245,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/test/data/warehouse/dest_j1
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: dest_j1
-          tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/190123379/10001
+          tmp directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/201991762/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -261,7 +261,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/798519490/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/763923239/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/join34.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join34.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join34.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join34.q.out Fri Aug 14 07:48:02 2009
@@ -27,12 +27,12 @@
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: (UDFToDouble(key) < UDFToDouble(20))
+                  expr: (key < 20)
                   type: boolean
               Filter Operator
                 isSamplingPred: false
                 predicate:
-                    expr: (UDFToDouble(key) < UDFToDouble(20))
+                    expr: (key < 20)
                     type: boolean
                 Select Operator
                   expressions:
@@ -49,8 +49,8 @@
                         0 {_col1}
                         1 {key} {value}
                       keys:
-                        0 
-                        1 
+                        0 [Column[_col0]]
+                        1 [Column[key]]
                       outputColumnNames: _col1, _col2, _col3
                       Position of Big Table: 0
                       Select Operator
@@ -74,7 +74,7 @@
                           File Output Operator
                             compressed: false
                             GlobalTableId: 1
-                            directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/890087702/10002
+                            directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1095475977/10002
                             table:
                                 input format: org.apache.hadoop.mapred.TextInputFormat
                                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -88,7 +88,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                                  location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest_j1
                                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                                 name: dest_j1
         null-subquery2:subq1-subquery2:x1 
@@ -97,12 +97,12 @@
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: (UDFToDouble(key) > UDFToDouble(100))
+                  expr: (key > 100)
                   type: boolean
               Filter Operator
                 isSamplingPred: false
                 predicate:
-                    expr: (UDFToDouble(key) > UDFToDouble(100))
+                    expr: (key > 100)
                     type: boolean
                 Select Operator
                   expressions:
@@ -119,8 +119,8 @@
                         0 {_col1}
                         1 {key} {value}
                       keys:
-                        0 
-                        1 
+                        0 [Column[_col0]]
+                        1 [Column[key]]
                       outputColumnNames: _col1, _col2, _col3
                       Position of Big Table: 0
                       Select Operator
@@ -144,7 +144,7 @@
                           File Output Operator
                             compressed: false
                             GlobalTableId: 1
-                            directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/890087702/10002
+                            directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1095475977/10002
                             table:
                                 input format: org.apache.hadoop.mapred.TextInputFormat
                                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -158,7 +158,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                                  location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest_j1
                                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                                 name: dest_j1
       Local Work:
@@ -178,8 +178,8 @@
                     0 {_col1}
                     1 {key} {value}
                   keys:
-                    0 
-                    1 
+                    0 [Column[_col0]]
+                    1 [Column[key]]
                   outputColumnNames: _col1, _col2, _col3
                   Position of Big Table: 0
                   Select Operator
@@ -203,7 +203,7 @@
                       File Output Operator
                         compressed: false
                         GlobalTableId: 1
-                        directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/890087702/10002
+                        directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1095475977/10002
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -217,14 +217,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                              location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src [null-subquery1:subq1-subquery1:x, null-subquery2:subq1-subquery2:x1]
       Path -> Partition:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -239,7 +239,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/src
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
 
@@ -249,11 +249,11 @@
           Move Operator
             files:
                 hdfs directory: true
-                source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/890087702/10002
-                destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1815358435/10000
+                source: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1095475977/10002
+                destination: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/2029959349/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/890087702/10002 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1095475977/10002 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -269,9 +269,9 @@
                           type: string
             Needs Tagging: false
             Path -> Alias:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/890087702/10002 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1095475977/10002 [file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1095475977/10002]
             Path -> Partition:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/890087702/10002 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/1095475977/10002 
                 Partition
                 
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -286,7 +286,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                      location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest_j1
                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     name: dest_j1
             Reduce Operator Tree:
@@ -294,7 +294,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1815358435/10000
+                  directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/2029959349/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -307,7 +307,7 @@
                         bucket_count -1
                         serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
-                        location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                        location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest_j1
                         file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: dest_j1
@@ -316,7 +316,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1815358435/10000
+          source: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/2029959349/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -330,10 +330,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/test/data/warehouse/dest_j1
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: dest_j1
-          tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1815358435/10001
+          tmp directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/2029959349/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -349,7 +349,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/847132688/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/2065460678/10000
 128		val_128
 128		val_128
 128		val_128

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=804106&r1=804105&r2=804106&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 Fri Aug 14 07:48:02 2009
@@ -32,12 +32,12 @@
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: (UDFToDouble(key) < UDFToDouble(20))
+                  expr: (key < 20)
                   type: boolean
               Filter Operator
                 isSamplingPred: false
                 predicate:
-                    expr: (UDFToDouble(key) < UDFToDouble(20))
+                    expr: (key < 20)
                     type: boolean
                 Select Operator
                   expressions:
@@ -66,9 +66,9 @@
                             type: bigint
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/src [null-subquery1:subq1-subquery1:x]
       Path -> Partition:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -83,7 +83,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/src
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
       Reduce Operator Tree:
@@ -105,7 +105,7 @@
             File Output Operator
               compressed: false
               GlobalTableId: 0
-              directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10002
+              directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10002
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -117,7 +117,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10002 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10002 
           Union
             Common Join Operator
               condition map:
@@ -126,8 +126,8 @@
                 0 {_col1}
                 1 {key} {value}
               keys:
-                0 
-                1 
+                0 [Column[_col0]]
+                1 [Column[key]]
               outputColumnNames: _col1, _col2, _col3
               Position of Big Table: 0
               Select Operator
@@ -160,7 +160,7 @@
                     File Output Operator
                       compressed: false
                       GlobalTableId: 1
-                      directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003
+                      directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10003
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -174,10 +174,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                            location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                           name: dest_j1
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10004 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10004 
           Union
             Common Join Operator
               condition map:
@@ -186,8 +186,8 @@
                 0 {_col1}
                 1 {key} {value}
               keys:
-                0 
-                1 
+                0 [Column[_col0]]
+                1 [Column[key]]
               outputColumnNames: _col1, _col2, _col3
               Position of Big Table: 0
               Select Operator
@@ -220,7 +220,7 @@
                     File Output Operator
                       compressed: false
                       GlobalTableId: 1
-                      directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003
+                      directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10003
                       table:
                           input format: org.apache.hadoop.mapred.TextInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -234,7 +234,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                            location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
                           serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                           name: dest_j1
       Local Work:
@@ -254,8 +254,8 @@
                     0 {_col1}
                     1 {key} {value}
                   keys:
-                    0 
-                    1 
+                    0 [Column[_col0]]
+                    1 [Column[key]]
                   outputColumnNames: _col1, _col2, _col3
                   Position of Big Table: 0
                   Select Operator
@@ -288,7 +288,7 @@
                         File Output Operator
                           compressed: false
                           GlobalTableId: 1
-                          directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003
+                          directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10003
                           table:
                               input format: org.apache.hadoop.mapred.TextInputFormat
                               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -302,15 +302,15 @@
                                 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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/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/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10002 
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10004 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10002 [file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10002]
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10004 [file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10004]
       Path -> Partition:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10002 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -319,7 +319,7 @@
                 columns _col0,_col1
                 columns.types string,bigint
                 escape.delim \
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10004 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10004 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -335,11 +335,11 @@
           Move Operator
             files:
                 hdfs directory: true
-                source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003
-                destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1251033308/10000
+                source: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10003
+                destination: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/429216624/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10003 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -355,9 +355,9 @@
                           type: int
             Needs Tagging: false
             Path -> Alias:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10003 [file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10003]
             Path -> Partition:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10003 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10003 
                 Partition
                 
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -372,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                      location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     name: dest_j1
             Reduce Operator Tree:
@@ -380,7 +380,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1251033308/10000
+                  directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/429216624/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -393,7 +393,7 @@
                         bucket_count -1
                         serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
-                        location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                        location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
                         file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: dest_j1
@@ -402,7 +402,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1251033308/10000
+          source: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/429216624/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -416,10 +416,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: dest_j1
-          tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1251033308/10001
+          tmp directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/429216624/10001
 
   Stage: Stage-6
     Map Reduce
@@ -430,12 +430,12 @@
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: (UDFToDouble(key) > UDFToDouble(100))
+                  expr: (key > 100)
                   type: boolean
               Filter Operator
                 isSamplingPred: false
                 predicate:
-                    expr: (UDFToDouble(key) > UDFToDouble(100))
+                    expr: (key > 100)
                     type: boolean
                 Select Operator
                   expressions:
@@ -464,9 +464,9 @@
                             type: bigint
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/src [null-subquery2:subq1-subquery2:x1]
       Path -> Partition:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -481,7 +481,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/src
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/src
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
       Reduce Operator Tree:
@@ -503,7 +503,7 @@
             File Output Operator
               compressed: false
               GlobalTableId: 0
-              directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1727048194/10004
+              directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/795699336/10004
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -526,7 +526,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1156663841/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/392273807/10000
 128		3
 146	val_146	2
 150	val_150	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join36.q.out Fri Aug 14 07:48:02 2009
@@ -38,8 +38,8 @@
                 0 {key} {cnt}
                 1 {cnt}
               keys:
-                0 
-                1 
+                0 [Column[key]]
+                1 [Column[key]]
               outputColumnNames: _col0, _col1, _col3
               Position of Big Table: 1
               Select Operator
@@ -85,8 +85,8 @@
                     0 {key} {cnt}
                     1 {cnt}
                   keys:
-                    0 
-                    1 
+                    0 [Column[key]]
+                    1 [Column[key]]
                   outputColumnNames: _col0, _col1, _col3
                   Position of Big Table: 1
                   Select Operator
@@ -122,10 +122,10 @@
           Move Operator
             files:
                 hdfs directory: true
-                destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/576445655/10000
+                destination: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/1012006682/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1356744320/10002 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/697544308/10002 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -169,7 +169,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/631598409/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/1124582882/10000
 0	3	3
 2	1	1
 4	1	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join4.q.out Fri Aug 14 07:48:02 2009
@@ -29,11 +29,11 @@
             alias: src1
             Filter Operator
               predicate:
-                  expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+                  expr: ((key > 10) and (key < 20))
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+                    expr: ((key > 10) and (key < 20))
                     type: boolean
                 Select Operator
                   expressions:
@@ -61,11 +61,11 @@
             alias: src2
             Filter Operator
               predicate:
-                  expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+                  expr: ((key > 15) and (key < 25))
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+                    expr: ((key > 15) and (key < 25))
                     type: boolean
                 Select Operator
                   expressions:
@@ -166,7 +166,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1353187421/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/2044738575/10000
 11	val_11	NULL	NULL
 12	val_12	NULL	NULL
 12	val_12	NULL	NULL

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join5.q.out Fri Aug 14 07:48:02 2009
@@ -29,11 +29,11 @@
             alias: src1
             Filter Operator
               predicate:
-                  expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+                  expr: ((key > 10) and (key < 20))
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+                    expr: ((key > 10) and (key < 20))
                     type: boolean
                 Select Operator
                   expressions:
@@ -61,11 +61,11 @@
             alias: src2
             Filter Operator
               predicate:
-                  expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+                  expr: ((key > 15) and (key < 25))
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+                    expr: ((key > 15) and (key < 25))
                     type: boolean
                 Select Operator
                   expressions:
@@ -166,7 +166,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/771875621/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1525120145/10000
 17	val_17	17	val_17
 18	val_18	18	val_18
 18	val_18	18	val_18

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join6.q.out Fri Aug 14 07:48:02 2009
@@ -29,11 +29,11 @@
             alias: src1
             Filter Operator
               predicate:
-                  expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+                  expr: ((key > 10) and (key < 20))
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+                    expr: ((key > 10) and (key < 20))
                     type: boolean
                 Select Operator
                   expressions:
@@ -61,11 +61,11 @@
             alias: src2
             Filter Operator
               predicate:
-                  expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+                  expr: ((key > 15) and (key < 25))
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+                    expr: ((key > 15) and (key < 25))
                     type: boolean
                 Select Operator
                   expressions:
@@ -166,7 +166,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1349249596/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_2/build/ql/tmp/35651409/10000
 11	val_11	NULL	NULL
 12	val_12	NULL	NULL
 12	val_12	NULL	NULL

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out Fri Aug 14 07:48:02 2009
@@ -34,11 +34,11 @@
             alias: src1
             Filter Operator
               predicate:
-                  expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+                  expr: ((key > 10) and (key < 20))
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+                    expr: ((key > 10) and (key < 20))
                     type: boolean
                 Select Operator
                   expressions:
@@ -66,11 +66,11 @@
             alias: src2
             Filter Operator
               predicate:
-                  expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+                  expr: ((key > 15) and (key < 25))
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+                    expr: ((key > 15) and (key < 25))
                     type: boolean
                 Select Operator
                   expressions:
@@ -98,11 +98,11 @@
             alias: src3
             Filter Operator
               predicate:
-                  expr: ((UDFToDouble(key) > UDFToDouble(20)) and (UDFToDouble(key) < UDFToDouble(25)))
+                  expr: ((key > 20) and (key < 25))
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: ((UDFToDouble(key) > UDFToDouble(20)) and (UDFToDouble(key) < UDFToDouble(25)))
+                    expr: ((key > 20) and (key < 25))
                     type: boolean
                 Select Operator
                   expressions:
@@ -222,7 +222,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1132812808/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_0/build/ql/tmp/350263108/10000
 11	val_11	NULL	NULL	NULL	NULL
 12	val_12	NULL	NULL	NULL	NULL
 12	val_12	NULL	NULL	NULL	NULL

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out Fri Aug 14 07:48:02 2009
@@ -29,11 +29,11 @@
             alias: src1
             Filter Operator
               predicate:
-                  expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+                  expr: ((key > 10) and (key < 20))
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+                    expr: ((key > 10) and (key < 20))
                     type: boolean
                 Select Operator
                   expressions:
@@ -61,11 +61,11 @@
             alias: src2
             Filter Operator
               predicate:
-                  expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+                  expr: ((key > 15) and (key < 25))
                   type: boolean
               Filter Operator
                 predicate:
-                    expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+                    expr: ((key > 15) and (key < 25))
                     type: boolean
                 Select Operator
                   expressions:
@@ -170,7 +170,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/214964657/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/2034601866/10000
 11	val_11	NULL	NULL
 12	val_12	NULL	NULL
 12	val_12	NULL	NULL

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out?rev=804106&r1=804105&r2=804106&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_map_ppr.q.out Fri Aug 14 07:48:02 2009
@@ -23,7 +23,7 @@
             Filter Operator
               isSamplingPred: false
               predicate:
-                  expr: ((ds = '2008-04-08') and (UDFToDouble(hr) = UDFToDouble(11)))
+                  expr: ((ds = '2008-04-08') and (hr = 11))
                   type: boolean
               Common Join Operator
                 condition map:
@@ -34,9 +34,9 @@
                   1 {value}
                   2 {value} {ds} {hr}
                 keys:
-                  0 
-                  1 
-                  2 
+                  0 [Column[key]]
+                  1 [Column[key]]
+                  2 [Column[key]]
                 outputColumnNames: _col0, _col3, _col5, _col6, _col7
                 Position of Big Table: 2
                 Select Operator
@@ -55,7 +55,7 @@
                   Filter Operator
                     isSamplingPred: false
                     predicate:
-                        expr: ((_col6 = '2008-04-08') and (UDFToDouble(_col7) = UDFToDouble(11)))
+                        expr: ((_col6 = '2008-04-08') and (_col7 = 11))
                         type: boolean
                     Select Operator
                       expressions:
@@ -69,7 +69,7 @@
                       File Output Operator
                         compressed: false
                         GlobalTableId: 1
-                        directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002
+                        directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/523022753/10002
                         table:
                             input format: org.apache.hadoop.mapred.TextInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -83,7 +83,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                              location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
                             serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                             name: dest_j1
       Local Work:
@@ -108,9 +108,9 @@
                     1 {value}
                     2 {value} {ds} {hr}
                   keys:
-                    0 
-                    1 
-                    2 
+                    0 [Column[key]]
+                    1 [Column[key]]
+                    2 [Column[key]]
                   outputColumnNames: _col0, _col3, _col5, _col6, _col7
                   Position of Big Table: 2
                   Select Operator
@@ -129,7 +129,7 @@
                     Filter Operator
                       isSamplingPred: false
                       predicate:
-                          expr: ((_col6 = '2008-04-08') and (UDFToDouble(_col7) = UDFToDouble(11)))
+                          expr: ((_col6 = '2008-04-08') and (_col7 = 11))
                           type: boolean
                       Select Operator
                         expressions:
@@ -143,7 +143,7 @@
                         File Output Operator
                           compressed: false
                           GlobalTableId: 1
-                          directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002
+                          directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/523022753/10002
                           table:
                               input format: org.apache.hadoop.mapred.TextInputFormat
                               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -157,7 +157,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
                               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                               name: dest_j1
             x 
@@ -172,9 +172,9 @@
                     1 {value}
                     2 {value} {ds} {hr}
                   keys:
-                    0 
-                    1 
-                    2 
+                    0 [Column[key]]
+                    1 [Column[key]]
+                    2 [Column[key]]
                   outputColumnNames: _col0, _col3, _col5, _col6, _col7
                   Position of Big Table: 2
                   Select Operator
@@ -193,7 +193,7 @@
                     Filter Operator
                       isSamplingPred: false
                       predicate:
-                          expr: ((_col6 = '2008-04-08') and (UDFToDouble(_col7) = UDFToDouble(11)))
+                          expr: ((_col6 = '2008-04-08') and (_col7 = 11))
                           type: boolean
                       Select Operator
                         expressions:
@@ -207,7 +207,7 @@
                         File Output Operator
                           compressed: false
                           GlobalTableId: 1
-                          directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002
+                          directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/523022753/10002
                           table:
                               input format: org.apache.hadoop.mapred.TextInputFormat
                               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -221,14 +221,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 [z]
       Path -> Partition:
-        file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+        file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
           Partition
             partition values:
               ds 2008-04-08
@@ -247,7 +247,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/srcpart
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
 
@@ -257,11 +257,11 @@
           Move Operator
             files:
                 hdfs directory: true
-                source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002
-                destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2009479673/10000
+                source: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/523022753/10002
+                destination: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/627855363/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/523022753/10002 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -277,9 +277,9 @@
                           type: string
             Needs Tagging: false
             Path -> Alias:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/523022753/10002 [file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/523022753/10002]
             Path -> Partition:
-              file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1816268167/10002 
+              file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/523022753/10002 
                 Partition
                 
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -294,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                      location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     name: dest_j1
             Reduce Operator Tree:
@@ -302,7 +302,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2009479673/10000
+                  directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/627855363/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -315,7 +315,7 @@
                         bucket_count -1
                         serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                         file.inputformat org.apache.hadoop.mapred.TextInputFormat
-                        location file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                        location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
                         file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: dest_j1
@@ -324,7 +324,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2009479673/10000
+          source: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/627855363/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -338,10 +338,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/athusoo/commits/hive_trunk_ws1/build/ql/test/data/warehouse/dest_j1
+                location file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/test/data/warehouse/dest_j1
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: dest_j1
-          tmp directory: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2009479673/10001
+          tmp directory: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/627855363/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -355,7 +355,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/494281575/10000
+Output: file:/data/users/zshao/tools/699-trunk-apache-hive/.ptest_1/build/ql/tmp/1625644055/10000
 128	val_128	val_128
 128	val_128	val_128
 128	val_128	val_128