hadoop-hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From na...@apache.org
Subject svn commit: r788269 [2/4] - in /hadoop/hive/trunk: ./ ql/src/java/org/apache/hadoop/hive/ql/exec/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/apache/hadoop/hive/ql/parse/ ql/src/java/org/apache/hadoop/hive/ql/plan/ ql/src/test/resu...
Date Thu, 25 Jun 2009 05:50:51 GMT
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join28.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join28.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join28.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join28.q.out Thu Jun 25 05:50:50 2009
@@ -26,8 +26,8 @@
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {key} {value}
-                1 {key} {value}
+                0 {key}
+                1 
               keys:
                 0 
                 1 
@@ -50,8 +50,8 @@
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {key} {value}
-                    1 {key} {value}
+                    0 {key}
+                    1 
                   keys:
                     0 
                     1 
@@ -66,8 +66,11 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1815676421/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2012162302/10002 
           Select Operator
+            expressions:
+                  expr: _col0
+                  type: string
             Select Operator
               expressions:
                     expr: _col0
@@ -77,7 +80,7 @@
                      Inner Join 0 to 1
                 condition expressions:
                   0 {_col0}
-                  1 {key} {value} {ds} {hr}
+                  1 {value}
                 keys:
                   0 
                   1 
@@ -113,7 +116,7 @@
                              Inner Join 0 to 1
                         condition expressions:
                           0 {_col0}
-                          1 {key} {value} {ds} {hr}
+                          1 {value}
                         keys:
                           0 
                           1 
@@ -128,8 +131,13 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1815676421/10003 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2012162302/10003 
           Select Operator
+            expressions:
+                  expr: _col0
+                  type: string
+                  expr: _col5
+                  type: string
             Select Operator
               expressions:
                     expr: _col0
@@ -151,10 +159,10 @@
           Move Operator
             files:
                 hdfs directory: true
-                destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1094740336/10000
+                destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/16485935/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1815676421/10004 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2012162302/10004 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -200,7 +208,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1009140217/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/634729814/10000
 128	val_128
 128	val_128
 128	val_128

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join29.q.out Thu Jun 25 05:50:50 2009
@@ -73,13 +73,13 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1531940851/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1590163898/10002 
             Common Join Operator
               condition map:
                    Inner Join 0 to 1
               condition expressions:
                 0 {_col0} {_col1}
-                1 {_col0} {_col1}
+                1 {_col1}
               keys:
                 0 
                 1 
@@ -93,17 +93,17 @@
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
-            file:/data/users/njain/hive4/hive4/build/ql/tmp/1531940851/10005 
+            file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1590163898/10005 
               Fetch Operator
                 limit: -1
           Alias -> Map Local Operator Tree:
-            file:/data/users/njain/hive4/hive4/build/ql/tmp/1531940851/10005 
+            file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1590163898/10005 
                 Common Join Operator
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
                     0 {_col0} {_col1}
-                    1 {_col0} {_col1}
+                    1 {_col1}
                   keys:
                     0 
                     1 
@@ -118,8 +118,15 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1531940851/10003 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1590163898/10003 
           Select Operator
+            expressions:
+                  expr: _col0
+                  type: string
+                  expr: _col1
+                  type: bigint
+                  expr: _col3
+                  type: bigint
             Select Operator
               expressions:
                     expr: _col0
@@ -151,10 +158,10 @@
           Move Operator
             files:
                 hdfs directory: true
-                destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/512693083/10000
+                destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/959537275/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/njain/hive4/hive4/build/ql/tmp/1531940851/10004 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1590163898/10004 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -248,7 +255,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1489048746/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/948921556/10000
 128	1	3
 146	1	2
 150	1	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join3.q.out Thu Jun 25 05:50:50 2009
@@ -23,11 +23,6 @@
                     expr: key
                     type: string
               tag: 1
-              value expressions:
-                    expr: key
-                    type: string
-                    expr: value
-                    type: string
         src3 
             Reduce Output Operator
               key expressions:
@@ -39,8 +34,6 @@
                     type: string
               tag: 2
               value expressions:
-                    expr: key
-                    type: string
                     expr: value
                     type: string
         src1 
@@ -56,17 +49,15 @@
               value expressions:
                     expr: key
                     type: string
-                    expr: value
-                    type: string
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
                Inner Join 0 to 2
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
-            2 {VALUE._col0} {VALUE._col1}
+            0 {VALUE._col0}
+            1 
+            2 {VALUE._col1}
           Select Operator
             expressions:
                   expr: _col0
@@ -105,7 +96,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/447413355/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1106403218/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join30.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join30.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join30.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join30.q.out Thu Jun 25 05:50:50 2009
@@ -20,8 +20,8 @@
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {key} {value}
-                1 {key} {value}
+                0 {key}
+                1 
               keys:
                 0 
                 1 
@@ -44,8 +44,8 @@
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {key} {value}
-                    1 {key} {value}
+                    0 {key}
+                    1 
                   keys:
                     0 
                     1 
@@ -60,8 +60,11 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1868281911/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1483061275/10002 
           Select Operator
+            expressions:
+                  expr: _col0
+                  type: string
             Select Operator
               expressions:
                     expr: _col0
@@ -132,7 +135,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1393129158/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1361140895/10000
 66	1
 98	2
 128	3

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join31.q.out Thu Jun 25 05:50:50 2009
@@ -70,13 +70,13 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1913053399/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10002 
             Common Join Operator
               condition map:
                    Inner Join 0 to 1
               condition expressions:
                 0 {_col0}
-                1 {_col0}
+                1 
               keys:
                 0 
                 1 
@@ -90,17 +90,17 @@
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
-            file:/data/users/njain/hive4/hive4/build/ql/tmp/1913053399/10004 
+            file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10004 
               Fetch Operator
                 limit: -1
           Alias -> Map Local Operator Tree:
-            file:/data/users/njain/hive4/hive4/build/ql/tmp/1913053399/10004 
+            file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10004 
                 Common Join Operator
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
                     0 {_col0}
-                    1 {_col0}
+                    1 
                   keys:
                     0 
                     1 
@@ -115,8 +115,11 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1913053399/10003 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1203288551/10003 
           Select Operator
+            expressions:
+                  expr: _col0
+                  type: string
             Select Operator
               expressions:
                     expr: _col0
@@ -237,7 +240,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1094372260/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1617117942/10000
 128	1
 146	1
 150	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join32.q.out?rev=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -24,7 +24,7 @@
                    Inner Join 0 to 1
               condition expressions:
                 0 {key} {value}
-                1 {key} {value}
+                1 {value}
               keys:
                 0 
                 1 
@@ -32,13 +32,13 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10004
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
-                      columns _col0,_col1,_col2,_col3
-                      columns.types string,string,string,string
+                      columns _col0,_col1,_col3
+                      columns.types string,string,string
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
@@ -52,7 +52,7 @@
                        Inner Join 0 to 1
                   condition expressions:
                     0 {key} {value}
-                    1 {key} {value}
+                    1 {value}
                   keys:
                     0 
                     1 
@@ -60,18 +60,18 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004
+                    directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10004
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                         properties:
-                          columns _col0,_col1,_col2,_col3
-                          columns.types string,string,string,string
+                          columns _col0,_col1,_col3
+                          columns.types string,string,string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/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
@@ -86,21 +86,28 @@
                 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/pchakka/workspace/oshive/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/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10004 
           Select Operator
+            expressions:
+                  expr: _col0
+                  type: string
+                  expr: _col1
+                  type: string
+                  expr: _col3
+                  type: string
             Common Join Operator
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {_col2} {_col3} {_col0} {_col1}
-                1 {key} {value} {ds} {hr}
+                0 {_col3} {_col0}
+                1 {value}
               keys:
                 0 
                 1 
@@ -108,13 +115,13 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/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
+                      columns _col1,_col2,_col5
+                      columns.types string,string,string
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
@@ -139,8 +146,8 @@
                         condition map:
                              Inner Join 0 to 1
                         condition expressions:
-                          0 {_col2} {_col3} {_col0} {_col1}
-                          1 {key} {value} {ds} {hr}
+                          0 {_col3} {_col0}
+                          1 {value}
                         keys:
                           0 
                           1 
@@ -148,31 +155,38 @@
                         File Output Operator
                           compressed: false
                           GlobalTableId: 0
-                          directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002
+                          directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/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
+                                columns _col1,_col2,_col5
+                                columns.types string,string,string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10004 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10004 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                columns _col0,_col1,_col2,_col3
-                columns.types string,string,string,string
+                columns _col0,_col1,_col3
+                columns.types string,string,string
 
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10002 
           Select Operator
+            expressions:
+                  expr: _col1
+                  type: string
+                  expr: _col2
+                  type: string
+                  expr: _col5
+                  type: string
             Select Operator
               expressions:
                     expr: _col2
@@ -184,7 +198,7 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 1
-                directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10003
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -198,21 +212,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/pchakka/workspace/oshive/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/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10002 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10002 
           Partition
           
               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
+                columns _col1,_col2,_col5
+                columns.types string,string,string
 
   Stage: Stage-5
     Conditional Operator
@@ -220,11 +234,11 @@
           Move Operator
             files:
                 hdfs directory: true
-                source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003
-                destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/186721190/10000
+                source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10003
+                destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/236043717/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10003 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -240,9 +254,9 @@
                           type: string
             Needs Tagging: false
             Path -> Alias:
-              file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10003 
             Path -> Partition:
-              file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1346847963/10003 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1927041156/10003 
                 Partition
                 
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -257,7 +271,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/pchakka/workspace/oshive/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
             Reduce Operator Tree:
@@ -265,7 +279,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/186721190/10000
+                  directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/236043717/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -279,7 +293,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/pchakka/workspace/oshive/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
 
@@ -287,7 +301,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/186721190/10000
+          source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/236043717/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -301,10 +315,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/pchakka/workspace/oshive/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/pchakka/workspace/oshive/build/ql/tmp/186721190/10001
+          tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/236043717/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -317,7 +331,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1483693438/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/38655143/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=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -22,7 +22,7 @@
                    Inner Join 0 to 1
               condition expressions:
                 0 {key} {value}
-                1 {key} {value}
+                1 {value}
               keys:
                 0 
                 1 
@@ -30,13 +30,13 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
-                      columns _col0,_col1,_col2,_col3
-                      columns.types string,string,string,string
+                      columns _col0,_col1,_col3
+                      columns.types string,string,string
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
@@ -50,7 +50,7 @@
                        Inner Join 0 to 1
                   condition expressions:
                     0 {key} {value}
-                    1 {key} {value}
+                    1 {value}
                   keys:
                     0 
                     1 
@@ -58,18 +58,18 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002
+                    directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                         properties:
-                          columns _col0,_col1,_col2,_col3
-                          columns.types string,string,string,string
+                          columns _col0,_col1,_col3
+                          columns.types string,string,string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/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/pchakka/workspace/oshive/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
 
@@ -114,16 +114,17 @@
                           type: string
                     tag: 1
                     value expressions:
-                          expr: key
-                          type: string
                           expr: value
                           type: string
-                          expr: ds
-                          type: string
-                          expr: hr
-                          type: string
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002 
           Select Operator
+            expressions:
+                  expr: _col0
+                  type: string
+                  expr: _col1
+                  type: string
+                  expr: _col3
+                  type: string
             Reduce Output Operator
               key expressions:
                     expr: _col1
@@ -134,20 +135,16 @@
                     type: string
               tag: 0
               value expressions:
-                    expr: _col2
-                    type: string
                     expr: _col3
                     type: string
                     expr: _col0
                     type: string
-                    expr: _col1
-                    type: string
       Needs Tagging: true
       Path -> Alias:
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=11 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/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
@@ -166,24 +163,24 @@
                 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/pchakka/workspace/oshive/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/pchakka/workspace/oshive/build/ql/tmp/1543545927/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1449467605/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                columns _col0,_col1,_col2,_col3
-                columns.types string,string,string,string
+                columns _col0,_col1,_col3
+                columns.types string,string,string
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
-            1 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
+            0 {VALUE._col1} {VALUE._col2}
+            1 {VALUE._col1}
           Select Operator
             expressions:
                   expr: _col2
@@ -195,7 +192,7 @@
             File Output Operator
               compressed: false
               GlobalTableId: 1
-              directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1051890475/10000
+              directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10000
               table:
                   input format: org.apache.hadoop.mapred.TextInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -209,7 +206,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/pchakka/workspace/oshive/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
 
@@ -217,7 +214,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1051890475/10000
+          source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -231,10 +228,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/pchakka/workspace/oshive/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/pchakka/workspace/oshive/build/ql/tmp/1051890475/10001
+          tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500697673/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -247,7 +244,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/306446495/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1659514145/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=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -42,7 +42,7 @@
                       condition map:
                            Inner Join 0 to 1
                       condition expressions:
-                        0 {_col0} {_col1}
+                        0 {_col1}
                         1 {key} {value}
                       keys:
                         0 
@@ -51,13 +51,13 @@
                       File Output Operator
                         compressed: false
                         GlobalTableId: 0
-                        directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
+                        directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10002
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                             properties:
-                              columns _col0,_col1,_col2,_col3
-                              columns.types string,string,string,string
+                              columns _col1,_col2,_col3
+                              columns.types string,string,string
         null-subquery2:subq1-subquery2:x1 
             Filter Operator
               predicate:
@@ -78,7 +78,7 @@
                       condition map:
                            Inner Join 0 to 1
                       condition expressions:
-                        0 {_col0} {_col1}
+                        0 {_col1}
                         1 {key} {value}
                       keys:
                         0 
@@ -87,13 +87,13 @@
                       File Output Operator
                         compressed: false
                         GlobalTableId: 0
-                        directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
+                        directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10002
                         table:
                             input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                             output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                             properties:
-                              columns _col0,_col1,_col2,_col3
-                              columns.types string,string,string,string
+                              columns _col1,_col2,_col3
+                              columns.types string,string,string
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
@@ -106,7 +106,7 @@
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {_col0} {_col1}
+                    0 {_col1}
                     1 {key} {value}
                   keys:
                     0 
@@ -115,18 +115,18 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002
+                    directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10002
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                         properties:
-                          columns _col0,_col1,_col2,_col3
-                          columns.types string,string,string,string
+                          columns _col1,_col2,_col3
+                          columns.types string,string,string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/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
@@ -141,15 +141,22 @@
                 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/pchakka/workspace/oshive/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/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10002 
           Select Operator
+            expressions:
+                  expr: _col1
+                  type: string
+                  expr: _col2
+                  type: string
+                  expr: _col3
+                  type: string
             Select Operator
               expressions:
                     expr: _col2
@@ -161,7 +168,7 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 1
-                directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10003
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -175,21 +182,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/pchakka/workspace/oshive/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/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10002 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                columns _col0,_col1,_col2,_col3
-                columns.types string,string,string,string
+                columns _col1,_col2,_col3
+                columns.types string,string,string
 
   Stage: Stage-5
     Conditional Operator
@@ -197,11 +204,11 @@
           Move Operator
             files:
                 hdfs directory: true
-                source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003
-                destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/3484851/10000
+                source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10003
+                destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1395275171/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10003 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -217,9 +224,9 @@
                           type: string
             Needs Tagging: false
             Path -> Alias:
-              file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10003 
             Path -> Partition:
-              file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1917925981/10003 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798138861/10003 
                 Partition
                 
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -234,7 +241,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/pchakka/workspace/oshive/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
             Reduce Operator Tree:
@@ -242,7 +249,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/3484851/10000
+                  directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1395275171/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -256,7 +263,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/pchakka/workspace/oshive/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
 
@@ -264,7 +271,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/3484851/10000
+          source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1395275171/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -278,10 +285,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/pchakka/workspace/oshive/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/pchakka/workspace/oshive/build/ql/tmp/3484851/10001
+          tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1395275171/10001
 
 
 query: INSERT OVERWRITE TABLE dest_j1
@@ -297,7 +304,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/374627927/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/513374112/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=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -62,9 +62,9 @@
                             type: bigint
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/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
@@ -79,7 +79,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/pchakka/workspace/oshive/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:
@@ -99,7 +99,7 @@
             File Output Operator
               compressed: false
               GlobalTableId: 0
-              directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002
+              directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10002
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -112,13 +112,13 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10002 
           Union
             Common Join Operator
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {_col0} {_col1}
+                0 {_col1}
                 1 {key} {value}
               keys:
                 0 
@@ -127,20 +127,20 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10003
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
-                      columns _col0,_col1,_col2,_col3
-                      columns.types string,bigint,string,string
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005 
+                      columns _col1,_col2,_col3
+                      columns.types bigint,string,string
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10005 
           Union
             Common Join Operator
               condition map:
                    Inner Join 0 to 1
               condition expressions:
-                0 {_col0} {_col1}
+                0 {_col1}
                 1 {key} {value}
               keys:
                 0 
@@ -149,13 +149,13 @@
               File Output Operator
                 compressed: false
                 GlobalTableId: 0
-                directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
+                directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10003
                 table:
                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                     properties:
-                      columns _col0,_col1,_col2,_col3
-                      columns.types string,bigint,string,string
+                      columns _col1,_col2,_col3
+                      columns.types bigint,string,string
       Local Work:
         Map Reduce Local Work
           Alias -> Map Local Tables:
@@ -168,7 +168,7 @@
                   condition map:
                        Inner Join 0 to 1
                   condition expressions:
-                    0 {_col0} {_col1}
+                    0 {_col1}
                     1 {key} {value}
                   keys:
                     0 
@@ -177,19 +177,19 @@
                   File Output Operator
                     compressed: false
                     GlobalTableId: 0
-                    directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003
+                    directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10003
                     table:
                         input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                         output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                         properties:
-                          columns _col0,_col1,_col2,_col3
-                          columns.types string,bigint,string,string
+                          columns _col1,_col2,_col3
+                          columns.types bigint,string,string
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002 
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10005 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10002 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -199,7 +199,7 @@
                 serialization.ddl struct binary_table { string _col0, i64 _col1}
                 serialization.format com.facebook.thrift.protocol.TBinaryProtocol
               name: binary_table
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10005 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -213,8 +213,15 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10003 
           Select Operator
+            expressions:
+                  expr: _col1
+                  type: bigint
+                  expr: _col2
+                  type: string
+                  expr: _col3
+                  type: string
             Select Operator
               expressions:
                     expr: _col2
@@ -234,7 +241,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
-                  directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
+                  directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10004
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -248,21 +255,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/pchakka/workspace/oshive/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/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10003 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10003 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10003 
           Partition
           
               input format: org.apache.hadoop.mapred.SequenceFileInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
               properties:
-                columns _col0,_col1,_col2,_col3
-                columns.types string,bigint,string,string
+                columns _col1,_col2,_col3
+                columns.types bigint,string,string
 
   Stage: Stage-6
     Conditional Operator
@@ -270,11 +277,11 @@
           Move Operator
             files:
                 hdfs directory: true
-                source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004
-                destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/100379931/10000
+                source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10004
+                destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/221309053/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10004 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -290,9 +297,9 @@
                           type: int
             Needs Tagging: false
             Path -> Alias:
-              file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10004 
             Path -> Partition:
-              file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10004 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10004 
                 Partition
                 
                     input format: org.apache.hadoop.mapred.TextInputFormat
@@ -307,7 +314,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/pchakka/workspace/oshive/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
             Reduce Operator Tree:
@@ -315,7 +322,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 0
-                  directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/100379931/10000
+                  directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/221309053/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -329,7 +336,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/pchakka/workspace/oshive/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
 
@@ -337,7 +344,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/100379931/10000
+          source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/221309053/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -351,10 +358,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/pchakka/workspace/oshive/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/pchakka/workspace/oshive/build/ql/tmp/100379931/10001
+          tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/221309053/10001
 
   Stage: Stage-7
     Map Reduce
@@ -393,9 +400,9 @@
                             type: bigint
       Needs Tagging: false
       Path -> Alias:
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/test/data/warehouse/src 
       Path -> Partition:
-        file:/data/users/pchakka/workspace/oshive/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
@@ -410,7 +417,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/pchakka/workspace/oshive/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:
@@ -430,7 +437,7 @@
             File Output Operator
               compressed: false
               GlobalTableId: 0
-              directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1491787652/10005
+              directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1960311627/10005
               table:
                   input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                   output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -454,7 +461,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/2035491366/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1484717471/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=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -35,7 +35,7 @@
                    Inner Join 0 to 1
               condition expressions:
                 0 {key} {cnt}
-                1 {key} {cnt}
+                1 {cnt}
               keys:
                 0 
                 1 
@@ -59,7 +59,7 @@
                        Inner Join 0 to 1
                   condition expressions:
                     0 {key} {cnt}
-                    1 {key} {cnt}
+                    1 {cnt}
                   keys:
                     0 
                     1 
@@ -74,8 +74,15 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/data/users/njain/hive4/hive4/build/ql/tmp/1544683463/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1818872230/10002 
           Select Operator
+            expressions:
+                  expr: _col0
+                  type: int
+                  expr: _col1
+                  type: int
+                  expr: _col3
+                  type: int
             Select Operator
               expressions:
                     expr: _col0
@@ -99,10 +106,10 @@
           Move Operator
             files:
                 hdfs directory: true
-                destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1680197079/10000
+                destination: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/989321268/10000
           Map Reduce
             Alias -> Map Operator Tree:
-              file:/data/users/njain/hive4/hive4/build/ql/tmp/1544683463/10003 
+              file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1818872230/10003 
                   Reduce Output Operator
                     sort order: 
                     Map-reduce partition columns:
@@ -146,7 +153,7 @@
 Output: default/dest_j1
 query: select * from dest_j1 x order by x.key
 Input: default/dest_j1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1167058397/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/798843783/10000
 0	3	3
 2	1	1
 4	1	1

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=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -24,8 +24,6 @@
                     type: string
               tag: 1
               value expressions:
-                    expr: key
-                    type: string
                     expr: value
                     type: string
         src1 
@@ -45,18 +43,16 @@
                 value expressions:
                       expr: key
                       type: string
-                      expr: value
-                      type: string
                       expr: ds
                       type: string
                       expr: hr
                       type: string
       Needs Tagging: true
       Path -> Alias:
-        file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src 
-        file:/data/users/pchakka/workspace/oshive/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/pchakka/workspace/oshive/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
@@ -71,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/pchakka/workspace/oshive/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/pchakka/workspace/oshive/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
@@ -93,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/pchakka/workspace/oshive/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:
@@ -101,8 +97,8 @@
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
-            1 {VALUE._col0} {VALUE._col1}
+            0 {VALUE._col0} {VALUE._col2} {VALUE._col3}
+            1 {VALUE._col1}
           Filter Operator
             predicate:
                 expr: ((_col2 = '2008-04-08') and (_col3 = '12'))
@@ -122,7 +118,7 @@
                 File Output Operator
                   compressed: false
                   GlobalTableId: 1
-                  directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1604556353/10000
+                  directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/856054437/10000
                   table:
                       input format: org.apache.hadoop.mapred.TextInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -136,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/pchakka/workspace/oshive/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
 
@@ -144,7 +140,7 @@
     Move Operator
       tables:
           replace: true
-          source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1604556353/10000
+          source: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/856054437/10000
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -158,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/pchakka/workspace/oshive/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: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1604556353/10001
+          tmp directory: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/856054437/10001
 
 
 query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
@@ -171,7 +167,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/794663470/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2105971410/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=788269&r1=788268&r2=788269&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 Thu Jun 25 05:50:50 2009
@@ -32,18 +32,8 @@
                     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>>
-                    expr: mstringstring
-                    type: map<string,string>
         s1 
             Reduce Output Operator
               key expressions:
@@ -57,23 +47,13 @@
               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>>
-                    expr: mstringstring
-                    type: map<string,string>
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
-            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}
+            0 {VALUE._col0}
+            1 {VALUE._col4}
           Select Operator
             expressions:
                   expr: _col0
@@ -97,7 +77,7 @@
 JOIN src_thrift s2
 ON s1.aint = s2.aint
 Input: default/src_thrift
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1473150956/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1144800345/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/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Thu Jun 25 05:50:50 2009
@@ -56,7 +56,7 @@
 
 query: SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/241519225/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/673778413/10000
 10	val_10
 query: EXPLAIN 
 SELECT x.key, x.value as v1, y.key  FROM SRC x JOIN SRC y ON (x.key = y.key)  where x.key = 20 CLUSTER BY v1
@@ -85,8 +85,6 @@
               value expressions:
                     expr: key
                     type: string
-                    expr: value
-                    type: string
         x 
             Filter Operator
               predicate:
@@ -112,7 +110,7 @@
                Inner Join 0 to 1
           condition expressions:
             0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
+            1 {VALUE._col0}
           Filter Operator
             predicate:
                 expr: (UDFToDouble(_col0) = UDFToDouble(20))
@@ -136,7 +134,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1825740657/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1323731431/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col1
@@ -169,5 +167,5 @@
 
 query: SELECT x.key, x.value as v1, y.key  FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1443480977/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1056466885/10000
 20	val_20	20

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out Thu Jun 25 05:50:50 2009
@@ -83,7 +83,7 @@
                Inner Join 0 to 1
           condition expressions:
             0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
+            1 {VALUE._col0}
           Filter Operator
             predicate:
                 expr: ((((_col0 > '20') and ((_col1 < 'val_50') or (_col0 > '2'))) and ((_col2 > '50') or (_col0 < '50'))) and (_col2 <> '4'))
@@ -110,7 +110,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1901853163/10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1497686794/10002 
             Reduce Output Operator
               key expressions:
                     expr: _col0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join2.q.out Thu Jun 25 05:50:50 2009
@@ -147,15 +147,13 @@
                     value expressions:
                           expr: _col0
                           type: string
-                          expr: _col1
-                          type: string
       Reduce Operator Tree:
         Join Operator
           condition map:
                Inner Join 0 to 1
           condition expressions:
             0 {VALUE._col0} {VALUE._col1} {VALUE._col2} {VALUE._col3}
-            1 {VALUE._col0} {VALUE._col1}
+            1 {VALUE._col0}
           Filter Operator
             predicate:
                 expr: (((((_col2 <> '311') and ((_col3 <> 'val_50') or (_col2 > '1'))) and ((_col0 <> '10') or (_col2 <> '10'))) and (_col0 <> '14')) and (sqrt(UDFToDouble(_col4)) <> UDFToDouble(13)))
@@ -189,7 +187,7 @@
 ON src1.c2 = src3.c6
 WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13)
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1480187717/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/976262349/10000
 0	val_0
 0	val_0
 0	val_0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_join3.q.out Thu Jun 25 05:50:50 2009
@@ -115,7 +115,7 @@
           condition expressions:
             0 {VALUE._col0} {VALUE._col1}
             1 {VALUE._col0} {VALUE._col1}
-            2 {VALUE._col0} {VALUE._col1}
+            2 {VALUE._col0}
           Filter Operator
             predicate:
                 expr: (((((_col0 > '0') and ((_col1 <> 'val_500') or (_col0 > '1'))) and ((_col2 > '10') or (_col0 <> '10'))) and (_col2 <> '4')) and (_col4 <> '1'))
@@ -149,7 +149,7 @@
 ON src1.c1 = src3.c5
 WHERE src1.c1 > '0' and (src1.c2 <> 'val_500' or src1.c1 > '1') and (src2.c3 > '10' or src1.c1 <> '10') and (src2.c3 <> '4') and (src3.c5 <> '1')
 Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1778414382/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1296260582/10000
 100	val_100
 100	val_100
 100	val_100

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out?rev=788269&r1=788268&r2=788269&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_multi_insert.q.out Thu Jun 25 05:50:50 2009
@@ -34,11 +34,6 @@
                     expr: key
                     type: string
               tag: 1
-              value expressions:
-                    expr: key
-                    type: string
-                    expr: value
-                    type: string
         a 
             Reduce Output Operator
               key expressions:
@@ -60,7 +55,7 @@
                Inner Join 0 to 1
           condition expressions:
             0 {VALUE._col0} {VALUE._col1}
-            1 {VALUE._col0} {VALUE._col1}
+            1 
           Filter Operator
             predicate:
                 expr: (UDFToDouble(_col0) < UDFToDouble(100))
@@ -196,7 +191,7 @@
 Output: ../build/ql/test/data/warehouse/mi4.out
 query: SELECT mi1.* FROM mi1
 Input: default/mi1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1767221832/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1556379466/10000
 0	val_0
 0	val_0
 0	val_0
@@ -347,7 +342,7 @@
 98	val_98
 query: SELECT mi2.* FROM mi2
 Input: default/mi2
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/255224107/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1335038556/10000
 100	val_100
 100	val_100
 100	val_100
@@ -561,7 +556,7 @@
 199	val_199
 query: SELECT mi3.* FROM mi3
 Input: default/mi3/ds=2008-04-08/hr=12
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/928924656/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/584372656/10000
 200	2008-04-08	12
 200	2008-04-08	12
 200	2008-04-08	12



Mime
View raw message