hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From na...@apache.org
Subject svn commit: r784656 [7/30] - in /hadoop/hive/trunk: ./ common/src/java/org/apache/hadoop/hive/conf/ 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/or...
Date Mon, 15 Jun 2009 05:43:29 GMT
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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -31,12 +31,12 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10005
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10003
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
-                      columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                      columns _col0,_col1,_col2,_col3
                       columns.types string,string,string,string
       Local Work:
         Map Reduce Local Work
@@ -59,18 +59,18 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10005
+                    directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10003
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                         properties:
-                          columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                          columns _col0,_col1,_col2,_col3
                           columns.types string,string,string,string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -85,21 +85,21 @@
                 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/hive2/hive2/build/ql/test/data/warehouse/src
+                location file:/Users/char/Documents/workspace/Hive-460/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/hive2/hive2/build/ql/tmp/652574121/10005 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10003 
           Select Operator
             Common Join Operator
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {2} {3} {0} {1}
-                1 {0} {1} {2}
+                0 {_col2} {_col3} {_col0} {_col1}
+                1 {key} {value} {ds} {hr}
               keys:
                 0 
                 1 
@@ -107,13 +107,13 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10004
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10002
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
-                      columns temporarycol0,temporarycol1,temporarycol2,temporarycol3,temporarycol4,temporarycol5,temporarycol6
-                      columns.types string,string,string,string,string,string,string
+                      columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7
+                      columns.types string,string,string,string,string,string,string,string
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
@@ -122,72 +122,64 @@
                 limit: -1
           Alias -> Map Local Operator Tree:
             z 
-                Select Operator
-                  expressions:
-                        expr: value
-                        type: string
-                        expr: hr
-                        type: string
-                        expr: ds
-                        type: string
+                Filter Operator
+                  predicate:
+                      expr: (ds = '2008-04-08')
+                      type: boolean
                   Filter Operator
                     predicate:
-                        expr: (2 = '2008-04-08')
+                        expr: (UDFToDouble(hr) = UDFToDouble(11))
                         type: boolean
-                    Filter Operator
-                      predicate:
-                          expr: (UDFToDouble(1) = UDFToDouble(11))
-                          type: boolean
-                      Common Join Operator
-                        condition map:
-                             Inner Join 0 to 1
-                        condition expressions:
-                          0 {2} {3} {0} {1}
-                          1 {0} {1} {2}
-                        keys:
-                          0 
-                          1 
-                        Position of Big Table: 0
-                        File Output Operator
-                          compressed: false
-                          GlobalTableId: 0
-                          directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10004
-                          table:
-                              input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                              output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                              properties:
-                                columns temporarycol0,temporarycol1,temporarycol2,temporarycol3,temporarycol4,temporarycol5,temporarycol6
-                                columns.types string,string,string,string,string,string,string
+                    Common Join Operator
+                      condition map:
+                           Inner Join 0 to 1
+                      condition expressions:
+                        0 {_col2} {_col3} {_col0} {_col1}
+                        1 {key} {value} {ds} {hr}
+                      keys:
+                        0 
+                        1 
+                      Position of Big Table: 0
+                      File Output Operator
+                        compressed: false
+                        GlobalTableId: 0
+                        directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10002
+                        table:
+                            input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                            output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                            properties:
+                              columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7
+                              columns.types string,string,string,string,string,string,string,string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10005 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10003 
       Path -> Partition:
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10005 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10003 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                columns _col0,_col1,_col2,_col3
                 columns.types string,string,string,string
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10002 
           Select Operator
             Select Operator
               expressions:
-                    expr: 2
+                    expr: _col2
                     type: string
-                    expr: 4
+                    expr: _col5
                     type: string
-                    expr: 1
+                    expr: _col1
                     type: string
               File Output Operator
                 compressed: false
                 GlobalTableId: 1
-                directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/88943465/10002
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1448849776/10000
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -201,27 +193,27 @@
                       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/hive2/hive2/build/ql/test/data/warehouse/dest_j1
+                      location file:/Users/char/Documents/workspace/Hive-460/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/hive2/hive2/build/ql/tmp/652574121/10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10002 
       Path -> Partition:
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/652574121/10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1684107982/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                columns temporarycol0,temporarycol1,temporarycol2,temporarycol3,temporarycol4,temporarycol5,temporarycol6
-                columns.types string,string,string,string,string,string,string
+                columns _col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7
+                columns.types string,string,string,string,string,string,string,string
 
   Stage: Stage-0
     Move Operator
       tables:
             replace: true
-            source: file:/data/users/njain/hive2/hive2/build/ql/tmp/88943465/10002
+            source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1448849776/10000
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -235,10 +227,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/hive2/hive2/build/ql/test/data/warehouse/dest_j1
+                  location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 name: dest_j1
-            tmp directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/88943465/10003
+            tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1448849776/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -251,7 +243,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/njain/hive2/hive2/build/ql/tmp/1264508144/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1210500588/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -30,12 +30,12 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/872232858/10004
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/409684435/10002
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
-                      columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                      columns _col0,_col1,_col2,_col3
                       columns.types string,string,string,string
       Local Work:
         Map Reduce Local Work
@@ -58,18 +58,18 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/872232858/10004
+                    directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/409684435/10002
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                         properties:
-                          columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                          columns _col0,_col1,_col2,_col3
                           columns.types string,string,string,string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -84,7 +84,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/hive2/hive2/build/ql/test/data/warehouse/src
+                location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
 
@@ -92,64 +92,58 @@
     Map Reduce
       Alias -> Map Operator Tree:
         z 
-            Select Operator
-              expressions:
-                    expr: value
-                    type: string
-                    expr: hr
-                    type: string
-                    expr: ds
-                    type: string
+            Filter Operator
+              predicate:
+                  expr: (ds = '2008-04-08')
+                  type: boolean
               Filter Operator
                 predicate:
-                    expr: (2 = '2008-04-08')
+                    expr: (UDFToDouble(hr) = UDFToDouble(11))
                     type: boolean
-                Filter Operator
-                  predicate:
-                      expr: (UDFToDouble(1) = UDFToDouble(11))
-                      type: boolean
-                  Reduce Output Operator
-                    key expressions:
-                          expr: 0
-                          type: string
-                    sort order: +
-                    Map-reduce partition columns:
-                          expr: 0
-                          type: string
-                    tag: 1
-                    value expressions:
-                          expr: 0
-                          type: string
-                          expr: 1
-                          type: string
-                          expr: 2
-                          type: string
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/872232858/10004 
+                Reduce Output Operator
+                  key expressions:
+                        expr: value
+                        type: string
+                  sort order: +
+                  Map-reduce partition columns:
+                        expr: value
+                        type: string
+                  tag: 1
+                  value expressions:
+                        expr: key
+                        type: string
+                        expr: value
+                        type: string
+                        expr: ds
+                        type: string
+                        expr: hr
+                        type: string
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/409684435/10002 
           Select Operator
             Reduce Output Operator
               key expressions:
-                    expr: 1
+                    expr: _col1
                     type: string
               sort order: +
               Map-reduce partition columns:
-                    expr: 1
+                    expr: _col1
                     type: string
               tag: 0
               value expressions:
-                    expr: 2
+                    expr: _col2
                     type: string
-                    expr: 3
+                    expr: _col3
                     type: string
-                    expr: 0
+                    expr: _col0
                     type: string
-                    expr: 1
+                    expr: _col1
                     type: string
       Needs Tagging: true
       Path -> Alias:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/872232858/10004 
+        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/409684435/10002 
       Path -> Partition:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
           Partition
             partition values:
               ds 2008-04-08
@@ -168,36 +162,36 @@
                 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/hive2/hive2/build/ql/test/data/warehouse/srcpart
+                location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/872232858/10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/409684435/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                columns _col0,_col1,_col2,_col3
                 columns.types string,string,string,string
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE.0} {VALUE.1} {VALUE.2} {VALUE.3}
-            1 {VALUE.0} {VALUE.1} {VALUE.2}
+            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
           Select Operator
             expressions:
-                  expr: 2
+                  expr: _col2
                   type: string
-                  expr: 4
+                  expr: _col5
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: string
             File Output Operator
               compressed: false
               GlobalTableId: 1
-              directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/181195113/10002
+              directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1859464866/10000
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -211,7 +205,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/hive2/hive2/build/ql/test/data/warehouse/dest_j1
+                    location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
                   serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                   name: dest_j1
 
@@ -219,7 +213,7 @@
     Move Operator
       tables:
             replace: true
-            source: file:/data/users/njain/hive2/hive2/build/ql/tmp/181195113/10002
+            source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1859464866/10000
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -233,10 +227,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/hive2/hive2/build/ql/test/data/warehouse/dest_j1
+                  location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 name: dest_j1
-            tmp directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/181195113/10003
+            tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1859464866/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -249,7 +243,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/njain/hive2/hive2/build/ql/tmp/700555840/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1895295754/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -37,7 +37,7 @@
                     condition map:
                          Inner Join 0 to 1
                     condition expressions:
-                      0 {0} {1}
+                      0 {_col0} {_col1}
                       1 {key} {value}
                     keys:
                       0 
@@ -46,12 +46,12 @@
                     File Output Operator
                       compressed: false
                       GlobalTableId: 0
-                      directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/1235944960/10002
+                      directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002
                       table:
                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                           properties:
-                            columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                            columns _col0,_col1,_col2,_col3
                             columns.types string,string,string,string
         null-subquery2:subq1-subquery2:x1 
             Filter Operator
@@ -69,7 +69,7 @@
                     condition map:
                          Inner Join 0 to 1
                     condition expressions:
-                      0 {0} {1}
+                      0 {_col0} {_col1}
                       1 {key} {value}
                     keys:
                       0 
@@ -78,12 +78,12 @@
                     File Output Operator
                       compressed: false
                       GlobalTableId: 0
-                      directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/1235944960/10002
+                      directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002
                       table:
                           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                           output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                           properties:
-                            columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                            columns _col0,_col1,_col2,_col3
                             columns.types string,string,string,string
       Local Work:
         Map Reduce Local Work
@@ -97,7 +97,7 @@
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {0} {1}
+                    0 {_col0} {_col1}
                     1 {key} {value}
                   keys:
                     0 
@@ -106,18 +106,18 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/1235944960/10002
+                    directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                         properties:
-                          columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                          columns _col0,_col1,_col2,_col3
                           columns.types string,string,string,string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -132,27 +132,27 @@
                 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/hive2/hive2/build/ql/test/data/warehouse/src
+                location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/1235944960/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002 
           Select Operator
             Select Operator
               expressions:
-                    expr: 2
+                    expr: _col2
                     type: string
-                    expr: 3
+                    expr: _col3
                     type: string
-                    expr: 1
+                    expr: _col1
                     type: string
               File Output Operator
                 compressed: false
                 GlobalTableId: 1
-                directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/1664619970/10000
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/907897578/10000
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -166,27 +166,27 @@
                       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/hive2/hive2/build/ql/test/data/warehouse/dest_j1
+                      location file:/Users/char/Documents/workspace/Hive-460/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/hive2/hive2/build/ql/tmp/1235944960/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002 
       Path -> Partition:
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/1235944960/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/785300879/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                columns _col0,_col1,_col2,_col3
                 columns.types string,string,string,string
 
   Stage: Stage-0
     Move Operator
       tables:
             replace: true
-            source: file:/data/users/njain/hive2/hive2/build/ql/tmp/1664619970/10000
+            source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/907897578/10000
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -200,10 +200,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/hive2/hive2/build/ql/test/data/warehouse/dest_j1
+                  location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 name: dest_j1
-            tmp directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/1664619970/10001
+            tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/907897578/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -219,7 +219,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/njain/hive2/hive2/build/ql/tmp/2142624697/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1160963373/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -27,38 +27,38 @@
     Map Reduce
       Alias -> Map Operator Tree:
         null-subquery1:subq1-subquery1:x 
-            Select Operator
-              expressions:
-                    expr: key
-                    type: string
-              Filter Operator
-                predicate:
-                    expr: (UDFToDouble(0) < UDFToDouble(20))
-                    type: boolean
+            Filter Operator
+              predicate:
+                  expr: (UDFToDouble(key) < UDFToDouble(20))
+                  type: boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
                 Group By Operator
                   aggregations:
                         expr: count(1)
                   keys:
-                        expr: 0
+                        expr: key
                         type: string
                   mode: hash
                   Reduce Output Operator
                     key expressions:
-                          expr: 0
+                          expr: _col0
                           type: string
                     sort order: +
                     Map-reduce partition columns:
-                          expr: 0
+                          expr: _col0
                           type: string
                     tag: -1
                     value expressions:
-                          expr: 1
+                          expr: _col1
                           type: bigint
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -73,46 +73,46 @@
                 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/hive2/hive2/build/ql/test/data/warehouse/src
+                location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: count(VALUE.0)
+                expr: count(VALUE._col0)
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: mergepartial
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: bigint
             File Output Operator
               compressed: false
               GlobalTableId: 0
-              directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10004
+              directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                   properties:
                     name binary_table
-                    serialization.ddl struct binary_table { string temporarycol0, i64 temporarycol1}
+                    serialization.ddl struct binary_table { string _col0, i64 _col1}
                     serialization.format com.facebook.thrift.protocol.TBinaryProtocol
                   name: binary_table
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002 
           Union
             Common Join Operator
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {0} {1}
+                0 {_col0} {_col1}
                 1 {key} {value}
               keys:
                 0 
@@ -121,20 +121,20 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10005
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
-                      columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                      columns _col0,_col1,_col2,_col3
                       columns.types string,bigint,string,string
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10006 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004 
           Union
             Common Join Operator
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {0} {1}
+                0 {_col0} {_col1}
                 1 {key} {value}
               keys:
                 0 
@@ -143,12 +143,12 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10005
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
-                      columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                      columns _col0,_col1,_col2,_col3
                       columns.types string,bigint,string,string
       Local Work:
         Map Reduce Local Work
@@ -162,7 +162,7 @@
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {0} {1}
+                    0 {_col0} {_col1}
                     1 {key} {value}
                   keys:
                     0 
@@ -171,64 +171,64 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10005
+                    directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                         properties:
-                          columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                          columns _col0,_col1,_col2,_col3
                           columns.types string,bigint,string,string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10004 
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10006 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004 
       Path -> Partition:
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
                 name binary_table
-                serialization.ddl struct binary_table { string temporarycol0, i64 temporarycol1}
+                serialization.ddl struct binary_table { string _col0, i64 _col1}
                 serialization.format com.facebook.thrift.protocol.TBinaryProtocol
               name: binary_table
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10006 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
                 name binary_table
-                serialization.ddl struct binary_table { string temporarycol0, i64 temporarycol1}
+                serialization.ddl struct binary_table { string _col0, i64 _col1}
                 serialization.format com.facebook.thrift.protocol.TBinaryProtocol
               name: binary_table
 
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10005 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003 
           Select Operator
             Select Operator
               expressions:
-                    expr: 2
+                    expr: _col2
                     type: string
-                    expr: 3
+                    expr: _col3
                     type: string
-                    expr: 1
+                    expr: _col1
                     type: bigint
               Select Operator
                 expressions:
-                      expr: 0
+                      expr: _col0
                       type: string
-                      expr: 1
+                      expr: _col1
                       type: string
-                      expr: UDFToInteger(2)
+                      expr: UDFToInteger(_col2)
                       type: int
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
-                  directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/933155217/10002
+                  directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/366087396/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -242,27 +242,27 @@
                         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/hive2/hive2/build/ql/test/data/warehouse/dest_j1
+                        location file:/Users/char/Documents/workspace/Hive-460/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/hive2/hive2/build/ql/tmp/226015867/10005 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003 
       Path -> Partition:
-        file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10005 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10003 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                columns temporarycol0,temporarycol1,temporarycol2,temporarycol3
+                columns _col0,_col1,_col2,_col3
                 columns.types string,bigint,string,string
 
   Stage: Stage-0
     Move Operator
       tables:
             replace: true
-            source: file:/data/users/njain/hive2/hive2/build/ql/tmp/933155217/10002
+            source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/366087396/10000
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -276,47 +276,47 @@
                   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/hive2/hive2/build/ql/test/data/warehouse/dest_j1
+                  location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest_j1
                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 name: dest_j1
-            tmp directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/933155217/10003
+            tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/366087396/10001
 
   Stage: Stage-4
     Map Reduce
       Alias -> Map Operator Tree:
         null-subquery2:subq1-subquery2:x1 
-            Select Operator
-              expressions:
-                    expr: key
-                    type: string
-              Filter Operator
-                predicate:
-                    expr: (UDFToDouble(0) > UDFToDouble(100))
-                    type: boolean
+            Filter Operator
+              predicate:
+                  expr: (UDFToDouble(key) > UDFToDouble(100))
+                  type: boolean
+              Select Operator
+                expressions:
+                      expr: key
+                      type: string
                 Group By Operator
                   aggregations:
                         expr: count(1)
                   keys:
-                        expr: 0
+                        expr: key
                         type: string
                   mode: hash
                   Reduce Output Operator
                     key expressions:
-                          expr: 0
+                          expr: _col0
                           type: string
                     sort order: +
                     Map-reduce partition columns:
-                          expr: 0
+                          expr: _col0
                           type: string
                     tag: -1
                     value expressions:
-                          expr: 1
+                          expr: _col1
                           type: bigint
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/njain/hive2/hive2/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -331,33 +331,33 @@
                 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/hive2/hive2/build/ql/test/data/warehouse/src
+                location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: count(VALUE.0)
+                expr: count(VALUE._col0)
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: mergepartial
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: bigint
             File Output Operator
               compressed: false
               GlobalTableId: 0
-              directory: file:/data/users/njain/hive2/hive2/build/ql/tmp/226015867/10006
+              directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/168430726/10004
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                   properties:
                     name binary_table
-                    serialization.ddl struct binary_table { string temporarycol0, i64 temporarycol1}
+                    serialization.ddl struct binary_table { string _col0, i64 _col1}
                     serialization.format com.facebook.thrift.protocol.TBinaryProtocol
                   name: binary_table
 
@@ -375,7 +375,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/njain/hive2/hive2/build/ql/tmp/247016879/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1938414388/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -73,15 +73,15 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive1/hive1/build/ql/tmp/1050118775/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/596423728/10002 
           Select Operator
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: int
-                    expr: 1
+                    expr: _col1
                     type: int
-                    expr: 3
+                    expr: _col3
                     type: int
               File Output Operator
                 compressed: false
@@ -111,7 +111,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/njain/hive1/hive1/build/ql/tmp/912828284/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/976050144/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -37,17 +37,17 @@
                       type: string
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
-                        expr: 0
+                        expr: _col0
                         type: string
                   tag: 0
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
-                        expr: 1
+                        expr: _col1
                         type: string
         c:b:src2 
             Filter Operator
@@ -62,54 +62,54 @@
                       type: string
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
-                        expr: 0
+                        expr: _col0
                         type: string
                   tag: 1
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
-                        expr: 1
+                        expr: _col1
                         type: string
       Reduce Operator Tree:
         Join Operator
           condition map:
                Left Outer Join0 to 1
           condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
+            0 {VALUE._col0} {VALUE._col1}
+            1 {VALUE._col0} {VALUE._col1}
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: string
-                  expr: 2
+                  expr: _col2
                   type: string
-                  expr: 3
+                  expr: _col3
                   type: string
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: string
-                    expr: 1
+                    expr: _col1
                     type: string
-                    expr: 2
+                    expr: _col2
                     type: string
-                    expr: 3
+                    expr: _col3
                     type: string
               Select Operator
                 expressions:
-                      expr: UDFToInteger(0)
+                      expr: UDFToInteger(_col0)
                       type: int
-                      expr: 1
+                      expr: _col1
                       type: string
-                      expr: UDFToInteger(2)
+                      expr: UDFToInteger(_col2)
                       type: int
-                      expr: 3
+                      expr: _col3
                       type: string
                 File Output Operator
                   compressed: false
@@ -148,7 +148,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/897019709/831036263.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/432444875/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -37,17 +37,17 @@
                       type: string
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
-                        expr: 0
+                        expr: _col0
                         type: string
                   tag: 0
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
-                        expr: 1
+                        expr: _col1
                         type: string
         c:b:src2 
             Filter Operator
@@ -62,54 +62,54 @@
                       type: string
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
-                        expr: 0
+                        expr: _col0
                         type: string
                   tag: 1
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
-                        expr: 1
+                        expr: _col1
                         type: string
       Reduce Operator Tree:
         Join Operator
           condition map:
                Right Outer Join0 to 1
           condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
+            0 {VALUE._col0} {VALUE._col1}
+            1 {VALUE._col0} {VALUE._col1}
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: string
-                  expr: 2
+                  expr: _col2
                   type: string
-                  expr: 3
+                  expr: _col3
                   type: string
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: string
-                    expr: 1
+                    expr: _col1
                     type: string
-                    expr: 2
+                    expr: _col2
                     type: string
-                    expr: 3
+                    expr: _col3
                     type: string
               Select Operator
                 expressions:
-                      expr: UDFToInteger(0)
+                      expr: UDFToInteger(_col0)
                       type: int
-                      expr: 1
+                      expr: _col1
                       type: string
-                      expr: UDFToInteger(2)
+                      expr: UDFToInteger(_col2)
                       type: int
-                      expr: 3
+                      expr: _col3
                       type: string
                 File Output Operator
                   compressed: false
@@ -148,7 +148,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/229545052/1184877063.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/253563009/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -37,17 +37,17 @@
                       type: string
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
-                        expr: 0
+                        expr: _col0
                         type: string
                   tag: 0
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
-                        expr: 1
+                        expr: _col1
                         type: string
         c:b:src2 
             Filter Operator
@@ -62,54 +62,54 @@
                       type: string
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
-                        expr: 0
+                        expr: _col0
                         type: string
                   tag: 1
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
-                        expr: 1
+                        expr: _col1
                         type: string
       Reduce Operator Tree:
         Join Operator
           condition map:
                Outer Join 0 to 1
           condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
+            0 {VALUE._col0} {VALUE._col1}
+            1 {VALUE._col0} {VALUE._col1}
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: string
-                  expr: 2
+                  expr: _col2
                   type: string
-                  expr: 3
+                  expr: _col3
                   type: string
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: string
-                    expr: 1
+                    expr: _col1
                     type: string
-                    expr: 2
+                    expr: _col2
                     type: string
-                    expr: 3
+                    expr: _col3
                     type: string
               Select Operator
                 expressions:
-                      expr: UDFToInteger(0)
+                      expr: UDFToInteger(_col0)
                       type: int
-                      expr: 1
+                      expr: _col1
                       type: string
-                      expr: UDFToInteger(2)
+                      expr: UDFToInteger(_col2)
                       type: int
-                      expr: 3
+                      expr: _col3
                       type: string
                 File Output Operator
                   compressed: false
@@ -148,7 +148,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/674683169/66863860.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1692074558/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -42,17 +42,17 @@
                       type: string
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
-                        expr: 0
+                        expr: _col0
                         type: string
                   tag: 0
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
-                        expr: 1
+                        expr: _col1
                         type: string
         c:b:src2 
             Filter Operator
@@ -67,17 +67,17 @@
                       type: string
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
-                        expr: 0
+                        expr: _col0
                         type: string
                   tag: 1
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
-                        expr: 1
+                        expr: _col1
                         type: string
         c:c:src3 
             Filter Operator
@@ -92,17 +92,17 @@
                       type: string
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
-                        expr: 0
+                        expr: _col0
                         type: string
                   tag: 2
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
-                        expr: 1
+                        expr: _col1
                         type: string
       Reduce Operator Tree:
         Join Operator
@@ -110,50 +110,50 @@
                Outer Join 0 to 1
                Left Outer Join0 to 2
           condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
-            2 {VALUE.0} {VALUE.1}
+            0 {VALUE._col0} {VALUE._col1}
+            1 {VALUE._col0} {VALUE._col1}
+            2 {VALUE._col0} {VALUE._col1}
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: string
-                  expr: 2
+                  expr: _col2
                   type: string
-                  expr: 3
+                  expr: _col3
                   type: string
-                  expr: 4
+                  expr: _col4
                   type: string
-                  expr: 5
+                  expr: _col5
                   type: string
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: string
-                    expr: 1
+                    expr: _col1
                     type: string
-                    expr: 2
+                    expr: _col2
                     type: string
-                    expr: 3
+                    expr: _col3
                     type: string
-                    expr: 4
+                    expr: _col4
                     type: string
-                    expr: 5
+                    expr: _col5
                     type: string
               Select Operator
                 expressions:
-                      expr: UDFToInteger(0)
+                      expr: UDFToInteger(_col0)
                       type: int
-                      expr: 1
+                      expr: _col1
                       type: string
-                      expr: UDFToInteger(2)
+                      expr: UDFToInteger(_col2)
                       type: int
-                      expr: 3
+                      expr: _col3
                       type: string
-                      expr: UDFToInteger(4)
+                      expr: UDFToInteger(_col4)
                       type: int
-                      expr: 5
+                      expr: _col5
                       type: string
                 File Output Operator
                   compressed: false
@@ -197,7 +197,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/934204295/128575675.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2100931525/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=784656&r1=784655&r2=784656&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 Mon Jun 15 05:43:22 2009
@@ -37,17 +37,17 @@
                       type: string
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
-                        expr: 0
+                        expr: _col0
                         type: string
                   tag: 0
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
-                        expr: 1
+                        expr: _col1
                         type: string
         c:b:src2 
             Filter Operator
@@ -62,58 +62,58 @@
                       type: string
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
-                        expr: 0
+                        expr: _col0
                         type: string
                   tag: 1
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
-                        expr: 1
+                        expr: _col1
                         type: string
       Reduce Operator Tree:
         Join Operator
           condition map:
                Left Outer Join0 to 1
           condition expressions:
-            0 {VALUE.0} {VALUE.1}
-            1 {VALUE.0} {VALUE.1}
+            0 {VALUE._col0} {VALUE._col1}
+            1 {VALUE._col0} {VALUE._col1}
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: string
-                  expr: 2
+                  expr: _col2
                   type: string
-                  expr: 3
+                  expr: _col3
                   type: string
             Filter Operator
               predicate:
-                  expr: (2 is null and 0 is not null)
+                  expr: (_col2 is null and _col0 is not null)
                   type: boolean
               Select Operator
                 expressions:
-                      expr: 0
+                      expr: _col0
                       type: string
-                      expr: 1
+                      expr: _col1
                       type: string
-                      expr: 2
+                      expr: _col2
                       type: string
-                      expr: 3
+                      expr: _col3
                       type: string
                 Select Operator
                   expressions:
-                        expr: UDFToInteger(0)
+                        expr: UDFToInteger(_col0)
                         type: int
-                        expr: 1
+                        expr: _col1
                         type: string
-                        expr: UDFToInteger(2)
+                        expr: UDFToInteger(_col2)
                         type: int
-                        expr: 3
+                        expr: _col3
                         type: string
                   File Output Operator
                     compressed: false
@@ -152,7 +152,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/106779552/293157937.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1676684235/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/join9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out Mon Jun 15 05:43:22 2009
@@ -29,36 +29,30 @@
                     expr: value
                     type: string
         src1 
-            Select Operator
-              expressions:
+            Reduce Output Operator
+              key expressions:
+                    expr: key
+                    type: string
+              sort order: +
+              Map-reduce partition columns:
                     expr: key
                     type: string
+              tag: 0
+              value expressions:
+                    expr: key
+                    type: string
+                    expr: value
+                    type: string
                     expr: ds
                     type: string
                     expr: hr
                     type: string
-              Reduce Output Operator
-                key expressions:
-                      expr: 0
-                      type: string
-                sort order: +
-                Map-reduce partition columns:
-                      expr: 0
-                      type: string
-                tag: 0
-                value expressions:
-                      expr: 0
-                      type: string
-                      expr: 1
-                      type: string
-                      expr: 2
-                      type: string
       Needs Tagging: true
       Path -> Alias:
-        file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/src 
-        file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
       Path -> Partition:
-        file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
           Partition
           
               input format: org.apache.hadoop.mapred.TextInputFormat
@@ -73,10 +67,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_ws8/build/ql/test/data/warehouse/src
+                location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: src
-        file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12 
           Partition
             partition values:
               ds 2008-04-08
@@ -95,7 +89,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_ws8/build/ql/test/data/warehouse/srcpart
+                location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
               name: srcpart
       Reduce Operator Tree:
@@ -103,28 +97,28 @@
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE.0} {VALUE.1} {VALUE.2}
-            1 {VALUE.0} {VALUE.1}
+            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+            1 {VALUE._col0} {VALUE._col1}
           Filter Operator
             predicate:
-                expr: ((1 = '2008-04-08') and (2 = '12'))
+                expr: ((_col2 = '2008-04-08') and (_col3 = '12'))
                 type: boolean
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: string
-                    expr: 4
+                    expr: _col5
                     type: string
               Select Operator
                 expressions:
-                      expr: UDFToInteger(0)
+                      expr: UDFToInteger(_col0)
                       type: int
-                      expr: 1
+                      expr: _col1
                       type: string
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
-                  directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/93836917.10000.insclause-0
+                  directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1807871128/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -138,7 +132,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_ws8/build/ql/test/data/warehouse/dest1
+                        location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: dest1
 
@@ -146,7 +140,7 @@
     Move Operator
       tables:
             replace: true
-            source: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/93836917.10000.insclause-0
+            source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1807871128/10000
             table:
                 input format: org.apache.hadoop.mapred.TextInputFormat
                 output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -160,10 +154,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_ws8/build/ql/test/data/warehouse/dest1
+                  location file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/dest1
                 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                 name: dest1
-            tmp directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/93836917.10001
+            tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1807871128/10001
 
 
 query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
@@ -173,7 +167,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/280910510/328815293.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2004673341/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join_thrift.q.out Mon Jun 15 05:43:22 2009
@@ -22,55 +22,63 @@
     Map Reduce
       Alias -> Map Operator Tree:
         s2 
-            Select Operator
-              expressions:
+            Reduce Output Operator
+              key expressions:
                     expr: aint
                     type: int
+              sort order: +
+              Map-reduce partition columns:
+                    expr: aint
+                    type: int
+              tag: 1
+              value expressions:
+                    expr: aint
+                    type: int
+                    expr: astring
+                    type: string
+                    expr: lint
+                    type: array<int>
+                    expr: lstring
+                    type: array<string>
                     expr: lintstring
                     type: array<struct<myint:int,mystring:string,underscore_int:int>>
-              Reduce Output Operator
-                key expressions:
-                      expr: 0
-                      type: int
-                sort order: +
-                Map-reduce partition columns:
-                      expr: 0
-                      type: int
-                tag: 1
-                value expressions:
-                      expr: 0
-                      type: int
-                      expr: 1
-                      type: array<struct<myint:int,mystring:string,underscore_int:int>>
+                    expr: mstringstring
+                    type: map<string,string>
         s1 
-            Select Operator
-              expressions:
+            Reduce Output Operator
+              key expressions:
+                    expr: aint
+                    type: int
+              sort order: +
+              Map-reduce partition columns:
+                    expr: aint
+                    type: int
+              tag: 0
+              value expressions:
                     expr: aint
                     type: int
-              Reduce Output Operator
-                key expressions:
-                      expr: 0
-                      type: int
-                sort order: +
-                Map-reduce partition columns:
-                      expr: 0
-                      type: int
-                tag: 0
-                value expressions:
-                      expr: 0
-                      type: int
+                    expr: astring
+                    type: string
+                    expr: lint
+                    type: array<int>
+                    expr: lstring
+                    type: array<string>
+                    expr: lintstring
+                    type: array<struct<myint:int,mystring:string,underscore_int:int>>
+                    expr: mstringstring
+                    type: map<string,string>
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE.0}
-            1 {VALUE.0} {VALUE.1}
+            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5}
+            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3} {VALUE._col4} {VALUE._col5}
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: int
-                  expr: 2
+                  expr: _col10
                   type: array<struct<myint:int,mystring:string,underscore_int:int>>
             File Output Operator
               compressed: false
@@ -89,7 +97,7 @@
 JOIN src_thrift s2
 ON s1.aint = s2.aint
 Input: default/src_thrift
-Output: /data/users/zshao/tools/495-trunk-apache-hive/ql/../build/ql/tmp/1611059524/151199080.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1473150956/10000
 -1952710710	[{"myint":25,"mystring":"125","underscore_int":5}]
 -1461153973	[{"myint":49,"mystring":"343","underscore_int":7}]
 -751827638	[{"myint":4,"mystring":"8","underscore_int":2}]

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce1.q.out Mon Jun 15 05:43:22 2009
@@ -59,13 +59,13 @@
         Extract
           Select Operator
             expressions:
-                  expr: UDFToInteger(0)
+                  expr: UDFToInteger(_col0)
                   type: int
-                  expr: UDFToInteger(1)
+                  expr: UDFToInteger(_col1)
                   type: int
-                  expr: UDFToInteger(2)
+                  expr: UDFToInteger(_col2)
                   type: int
-                  expr: 3
+                  expr: _col3
                   type: string
             File Output Operator
               compressed: false
@@ -97,7 +97,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/215905920/1186087609.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1089837380/10000
 0	0	0	val_0
 0	0	0	val_0
 0	0	0	val_0



Mime
View raw message