hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From na...@apache.org
Subject svn commit: r784656 [3/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/groupby2_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map.q.out Mon Jun 15 05:43:22 2009
@@ -14,56 +14,62 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src 
-            Group By Operator
-              aggregations:
-                    expr: count(DISTINCT substr(value, 5))
-                    expr: sum(UDFToDouble(substr(value, 5)))
-              keys:
-                    expr: substr(key, 1, 1)
+            Select Operator
+              expressions:
+                    expr: key
                     type: string
-                    expr: substr(value, 5)
+                    expr: value
                     type: string
-              mode: hash
-              Reduce Output Operator
-                key expressions:
-                      expr: 0
-                      type: string
-                      expr: 1
+              Group By Operator
+                aggregations:
+                      expr: count(DISTINCT substr(value, 5))
+                      expr: sum(UDFToDouble(substr(value, 5)))
+                keys:
+                      expr: substr(key, 1, 1)
                       type: string
-                sort order: ++
-                Map-reduce partition columns:
-                      expr: 0
+                      expr: substr(value, 5)
                       type: string
-                tag: -1
-                value expressions:
-                      expr: 2
-                      type: bigint
-                      expr: 3
-                      type: double
+                mode: hash
+                Reduce Output Operator
+                  key expressions:
+                        expr: _col0
+                        type: string
+                        expr: _col1
+                        type: string
+                  sort order: ++
+                  Map-reduce partition columns:
+                        expr: _col0
+                        type: string
+                  tag: -1
+                  value expressions:
+                        expr: _col2
+                        type: bigint
+                        expr: _col3
+                        type: double
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: count(DISTINCT KEY.1)
-                expr: sum(VALUE.1)
+                expr: count(DISTINCT KEY._col1)
+                expr: sum(VALUE._col1)
           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
-                  expr: concat(0, UDFToString(2))
+                  expr: concat(_col0, UDFToString(_col2))
                   type: string
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: string
-                    expr: UDFToInteger(1)
+                    expr: UDFToInteger(_col1)
                     type: int
-                    expr: 2
+                    expr: _col2
                     type: string
               File Output Operator
                 compressed: false
@@ -91,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/929309782/1021734362.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/199337666/10000
 0	1	00.0
 1	71	116414.0
 2	69	225571.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_map_skew.q.out Mon Jun 15 05:43:22 2009
@@ -15,41 +15,47 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src 
-            Group By Operator
-              aggregations:
-                    expr: count(DISTINCT substr(value, 5))
-                    expr: sum(UDFToDouble(substr(value, 5)))
-              keys:
-                    expr: substr(key, 1, 1)
-                    type: string
-                    expr: substr(value, 5)
-                    type: string
-              mode: hash
-              Reduce Output Operator
-                key expressions:
-                      expr: 0
-                      type: string
-                      expr: 1
-                      type: string
-                sort order: ++
-                Map-reduce partition columns:
-                      expr: 0
+            Select Operator
+              expressions:
+                    expr: key
+                    type: string
+                    expr: value
+                    type: string
+              Group By Operator
+                aggregations:
+                      expr: count(DISTINCT substr(value, 5))
+                      expr: sum(UDFToDouble(substr(value, 5)))
+                keys:
+                      expr: substr(key, 1, 1)
                       type: string
-                      expr: 1
+                      expr: substr(value, 5)
                       type: string
-                tag: -1
-                value expressions:
-                      expr: 2
-                      type: bigint
-                      expr: 3
-                      type: double
+                mode: hash
+                Reduce Output Operator
+                  key expressions:
+                        expr: _col0
+                        type: string
+                        expr: _col1
+                        type: string
+                  sort order: ++
+                  Map-reduce partition columns:
+                        expr: _col0
+                        type: string
+                        expr: _col1
+                        type: string
+                  tag: -1
+                  value expressions:
+                        expr: _col2
+                        type: bigint
+                        expr: _col3
+                        type: double
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: count(DISTINCT KEY.1)
-                expr: sum(VALUE.1)
+                expr: count(DISTINCT KEY._col1)
+                expr: sum(VALUE._col1)
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: partial2
           File Output Operator
@@ -63,45 +69,45 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/197258813/105701362.10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1993330559/10002 
             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
-                    expr: 2
+                    expr: _col2
                     type: double
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: count(VALUE.0)
-                expr: sum(VALUE.1)
+                expr: count(VALUE._col0)
+                expr: sum(VALUE._col1)
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: bigint
-                  expr: concat(0, UDFToString(2))
+                  expr: concat(_col0, UDFToString(_col2))
                   type: string
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: string
-                    expr: UDFToInteger(1)
+                    expr: UDFToInteger(_col1)
                     type: int
-                    expr: 2
+                    expr: _col2
                     type: string
               File Output Operator
                 compressed: false
@@ -129,7 +135,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1713198569/54590123.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/994064625/10000
 0	1	00.0
 1	71	116414.0
 2	69	225571.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby2_noskew.q.out Mon Jun 15 05:43:22 2009
@@ -14,41 +14,47 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src 
-            Reduce Output Operator
-              key expressions:
-                    expr: substr(key, 1, 1)
-                    type: string
-                    expr: substr(value, 5)
+            Select Operator
+              expressions:
+                    expr: key
                     type: string
-              sort order: ++
-              Map-reduce partition columns:
-                    expr: substr(key, 1, 1)
+                    expr: value
                     type: string
-              tag: -1
+              Reduce Output Operator
+                key expressions:
+                      expr: substr(key, 1, 1)
+                      type: string
+                      expr: substr(value, 5)
+                      type: string
+                sort order: ++
+                Map-reduce partition columns:
+                      expr: substr(key, 1, 1)
+                      type: string
+                tag: -1
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: count(DISTINCT KEY.1)
-                expr: sum(UDFToDouble(KEY.1))
+                expr: count(DISTINCT KEY._col1)
+                expr: sum(UDFToDouble(KEY._col1))
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: complete
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: bigint
-                  expr: concat(0, UDFToString(2))
+                  expr: concat(_col0, UDFToString(_col2))
                   type: string
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: string
-                    expr: UDFToInteger(1)
+                    expr: UDFToInteger(_col1)
                     type: int
-                    expr: 2
+                    expr: _col2
                     type: string
               File Output Operator
                 compressed: false
@@ -76,7 +82,7 @@
 Output: default/dest_g2
 query: SELECT dest_g2.* FROM dest_g2
 Input: default/dest_g2
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/236352888/719349372.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/578268006/10000
 0	1	00.0
 1	71	116414.0
 2	69	225571.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3.q.out Mon Jun 15 05:43:22 2009
@@ -21,21 +21,21 @@
                     type: string
               Reduce Output Operator
                 key expressions:
-                      expr: substr(0, 5)
+                      expr: substr(value, 5)
                       type: string
                 sort order: +
                 Map-reduce partition columns:
-                      expr: substr(0, 5)
+                      expr: substr(value, 5)
                       type: string
                 tag: -1
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(UDFToDouble(KEY.0))
-                expr: avg(UDFToDouble(KEY.0))
-                expr: avg(DISTINCT UDFToDouble(KEY.0))
-                expr: max(KEY.0)
-                expr: min(KEY.0)
+                expr: sum(UDFToDouble(KEY._col0))
+                expr: avg(UDFToDouble(KEY._col0))
+                expr: avg(DISTINCT UDFToDouble(KEY._col0))
+                expr: max(KEY._col0)
+                expr: min(KEY._col0)
           mode: partial1
           File Output Operator
             compressed: false
@@ -48,53 +48,53 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/270940600/835157322.10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/678591469/10002 
             Reduce Output Operator
               sort order: 
               tag: -1
               value expressions:
-                    expr: 0
+                    expr: _col0
                     type: double
-                    expr: 1
+                    expr: _col1
                     type: string
-                    expr: 2
+                    expr: _col2
                     type: string
-                    expr: 3
+                    expr: _col3
                     type: string
-                    expr: 4
+                    expr: _col4
                     type: string
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
-                expr: avg(VALUE.1)
-                expr: avg(VALUE.2)
-                expr: max(VALUE.3)
-                expr: min(VALUE.4)
+                expr: sum(VALUE._col0)
+                expr: avg(VALUE._col1)
+                expr: avg(VALUE._col2)
+                expr: max(VALUE._col3)
+                expr: min(VALUE._col4)
           mode: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: double
-                  expr: 1
+                  expr: _col1
                   type: double
-                  expr: 2
+                  expr: _col2
                   type: double
-                  expr: 3
+                  expr: _col3
                   type: string
-                  expr: 4
+                  expr: _col4
                   type: string
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: double
-                    expr: 1
+                    expr: _col1
                     type: double
-                    expr: 2
+                    expr: _col2
                     type: double
-                    expr: UDFToDouble(3)
+                    expr: UDFToDouble(_col3)
                     type: double
-                    expr: UDFToDouble(4)
+                    expr: UDFToDouble(_col4)
                     type: double
               File Output Operator
                 compressed: false
@@ -122,5 +122,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/167235948/1313312877.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/295498005/10000
 130091.0	260.182	256.10355987055016	98.0	0.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map.q.out Mon Jun 15 05:43:22 2009
@@ -20,64 +20,64 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: sum(UDFToDouble(substr(0, 5)))
-                      expr: avg(UDFToDouble(substr(0, 5)))
-                      expr: avg(DISTINCT UDFToDouble(substr(0, 5)))
-                      expr: max(substr(0, 5))
-                      expr: min(substr(0, 5))
+                      expr: sum(UDFToDouble(substr(value, 5)))
+                      expr: avg(UDFToDouble(substr(value, 5)))
+                      expr: avg(DISTINCT UDFToDouble(substr(value, 5)))
+                      expr: max(substr(value, 5))
+                      expr: min(substr(value, 5))
                 keys:
-                      expr: substr(0, 5)
+                      expr: substr(value, 5)
                       type: string
                 mode: hash
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   tag: -1
                   value expressions:
-                        expr: 1
+                        expr: _col1
                         type: double
-                        expr: 2
+                        expr: _col2
                         type: string
-                        expr: 3
+                        expr: _col3
                         type: string
-                        expr: 4
+                        expr: _col4
                         type: string
-                        expr: 5
+                        expr: _col5
                         type: string
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
-                expr: avg(VALUE.1)
-                expr: avg(DISTINCT UDFToDouble(KEY.0))
-                expr: max(VALUE.3)
-                expr: min(VALUE.4)
+                expr: sum(VALUE._col0)
+                expr: avg(VALUE._col1)
+                expr: avg(DISTINCT UDFToDouble(KEY._col0))
+                expr: max(VALUE._col3)
+                expr: min(VALUE._col4)
           mode: mergepartial
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: double
-                  expr: 1
+                  expr: _col1
                   type: double
-                  expr: 2
+                  expr: _col2
                   type: double
-                  expr: 3
+                  expr: _col3
                   type: string
-                  expr: 4
+                  expr: _col4
                   type: string
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: double
-                    expr: 1
+                    expr: _col1
                     type: double
-                    expr: 2
+                    expr: _col2
                     type: double
-                    expr: UDFToDouble(3)
+                    expr: UDFToDouble(_col3)
                     type: double
-                    expr: UDFToDouble(4)
+                    expr: UDFToDouble(_col4)
                     type: double
               File Output Operator
                 compressed: false
@@ -105,5 +105,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/97430135/101657566.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/743104446/10000
 130091.0	260.182	256.10355987055016	98.0	0.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_map_skew.q.out Mon Jun 15 05:43:22 2009
@@ -21,43 +21,43 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: sum(UDFToDouble(substr(0, 5)))
-                      expr: avg(UDFToDouble(substr(0, 5)))
-                      expr: avg(DISTINCT UDFToDouble(substr(0, 5)))
-                      expr: max(substr(0, 5))
-                      expr: min(substr(0, 5))
+                      expr: sum(UDFToDouble(substr(value, 5)))
+                      expr: avg(UDFToDouble(substr(value, 5)))
+                      expr: avg(DISTINCT UDFToDouble(substr(value, 5)))
+                      expr: max(substr(value, 5))
+                      expr: min(substr(value, 5))
                 keys:
-                      expr: substr(0, 5)
+                      expr: substr(value, 5)
                       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: double
-                        expr: 2
+                        expr: _col2
                         type: string
-                        expr: 3
+                        expr: _col3
                         type: string
-                        expr: 4
+                        expr: _col4
                         type: string
-                        expr: 5
+                        expr: _col5
                         type: string
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
-                expr: avg(VALUE.1)
-                expr: avg(DISTINCT UDFToDouble(KEY.0))
-                expr: max(VALUE.3)
-                expr: min(VALUE.4)
+                expr: sum(VALUE._col0)
+                expr: avg(VALUE._col1)
+                expr: avg(DISTINCT UDFToDouble(KEY._col0))
+                expr: max(VALUE._col3)
+                expr: min(VALUE._col4)
           mode: partial2
           File Output Operator
             compressed: false
@@ -70,53 +70,53 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/250385923/119575383.10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2099361977/10002 
             Reduce Output Operator
               sort order: 
               tag: -1
               value expressions:
-                    expr: 0
+                    expr: _col0
                     type: double
-                    expr: 1
+                    expr: _col1
                     type: string
-                    expr: 2
+                    expr: _col2
                     type: string
-                    expr: 3
+                    expr: _col3
                     type: string
-                    expr: 4
+                    expr: _col4
                     type: string
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
-                expr: avg(VALUE.1)
-                expr: avg(VALUE.2)
-                expr: max(VALUE.3)
-                expr: min(VALUE.4)
+                expr: sum(VALUE._col0)
+                expr: avg(VALUE._col1)
+                expr: avg(VALUE._col2)
+                expr: max(VALUE._col3)
+                expr: min(VALUE._col4)
           mode: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: double
-                  expr: 1
+                  expr: _col1
                   type: double
-                  expr: 2
+                  expr: _col2
                   type: double
-                  expr: 3
+                  expr: _col3
                   type: string
-                  expr: 4
+                  expr: _col4
                   type: string
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: double
-                    expr: 1
+                    expr: _col1
                     type: double
-                    expr: 2
+                    expr: _col2
                     type: double
-                    expr: UDFToDouble(3)
+                    expr: UDFToDouble(_col3)
                     type: double
-                    expr: UDFToDouble(4)
+                    expr: UDFToDouble(_col4)
                     type: double
               File Output Operator
                 compressed: false
@@ -144,5 +144,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/483439487/1053812433.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2116251071/10000
 130091.0	260.182	256.10355987055016	98.0	0.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby3_noskew.q.out Mon Jun 15 05:43:22 2009
@@ -20,42 +20,42 @@
                     type: string
               Reduce Output Operator
                 key expressions:
-                      expr: substr(0, 5)
+                      expr: substr(value, 5)
                       type: string
                 sort order: +
                 tag: -1
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(UDFToDouble(KEY.0))
-                expr: avg(UDFToDouble(KEY.0))
-                expr: avg(DISTINCT UDFToDouble(KEY.0))
-                expr: max(KEY.0)
-                expr: min(KEY.0)
+                expr: sum(UDFToDouble(KEY._col0))
+                expr: avg(UDFToDouble(KEY._col0))
+                expr: avg(DISTINCT UDFToDouble(KEY._col0))
+                expr: max(KEY._col0)
+                expr: min(KEY._col0)
           mode: complete
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: double
-                  expr: 1
+                  expr: _col1
                   type: double
-                  expr: 2
+                  expr: _col2
                   type: double
-                  expr: 3
+                  expr: _col3
                   type: string
-                  expr: 4
+                  expr: _col4
                   type: string
             Select Operator
               expressions:
-                    expr: 0
+                    expr: _col0
                     type: double
-                    expr: 1
+                    expr: _col1
                     type: double
-                    expr: 2
+                    expr: _col2
                     type: double
-                    expr: UDFToDouble(3)
+                    expr: UDFToDouble(_col3)
                     type: double
-                    expr: UDFToDouble(4)
+                    expr: UDFToDouble(_col4)
                     type: double
               File Output Operator
                 compressed: false
@@ -83,5 +83,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/38046058/1730327.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1207814160/10000
 130091.0	260.182	256.10355987055016	98.0	0.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4.q.out Mon Jun 15 05:43:22 2009
@@ -21,7 +21,7 @@
                     type: string
               Reduce Output Operator
                 key expressions:
-                      expr: substr(0, 1, 1)
+                      expr: substr(key, 1, 1)
                       type: string
                 sort order: +
                 Map-reduce partition columns:
@@ -31,7 +31,7 @@
       Reduce Operator Tree:
         Group By Operator
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: partial1
           File Output Operator
@@ -45,25 +45,25 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/427345693/640920280.10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1557952511/10002 
             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
       Reduce Operator Tree:
         Group By Operator
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
             File Output Operator
               compressed: false
@@ -91,7 +91,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/19444424/1257782123.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1739638303/10000
 0
 1
 2

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map.q.out Mon Jun 15 05:43:22 2009
@@ -22,20 +22,20 @@
                   sort order: 
                   tag: -1
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: bigint
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: count(VALUE.0)
+                expr: count(VALUE._col0)
           mode: mergepartial
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: bigint
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
               File Output Operator
                 compressed: false
@@ -62,5 +62,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/799987544/541652894.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2014035349/10000
 500

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_map_skew.q.out Mon Jun 15 05:43:22 2009
@@ -22,20 +22,20 @@
                   sort order: 
                   tag: -1
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: bigint
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: count(VALUE.0)
+                expr: count(VALUE._col0)
           mode: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: bigint
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
               File Output Operator
                 compressed: false
@@ -62,5 +62,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/4535965/295606977.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1037177910/10000
 500

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby4_noskew.q.out Mon Jun 15 05:43:22 2009
@@ -20,22 +20,22 @@
                     type: string
               Reduce Output Operator
                 key expressions:
-                      expr: substr(0, 1, 1)
+                      expr: substr(key, 1, 1)
                       type: string
                 sort order: +
                 Map-reduce partition columns:
-                      expr: substr(0, 1, 1)
+                      expr: substr(key, 1, 1)
                       type: string
                 tag: -1
       Reduce Operator Tree:
         Group By Operator
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: complete
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
             File Output Operator
               compressed: false
@@ -63,7 +63,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/233964547/872104797.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1842065640/10000
 0
 1
 2

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5.q.out Mon Jun 15 05:43:22 2009
@@ -17,24 +17,30 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src 
-            Reduce Output Operator
-              key expressions:
+            Select Operator
+              expressions:
                     expr: key
                     type: string
-              sort order: +
-              Map-reduce partition columns:
-                    expr: rand()
-                    type: double
-              tag: -1
-              value expressions:
-                    expr: substr(value, 5)
+                    expr: value
                     type: string
+              Reduce Output Operator
+                key expressions:
+                      expr: key
+                      type: string
+                sort order: +
+                Map-reduce partition columns:
+                      expr: rand()
+                      type: double
+                tag: -1
+                value expressions:
+                      expr: substr(value, 5)
+                      type: string
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(UDFToDouble(VALUE.0))
+                expr: sum(UDFToDouble(VALUE._col0))
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: partial1
           File Output Operator
@@ -48,38 +54,38 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/184711117/547495960.10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1808407027/10002 
             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: double
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
+                expr: sum(VALUE._col0)
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: double
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
-                    expr: 1
+                    expr: _col1
                     type: double
               File Output Operator
                 compressed: false
@@ -109,7 +115,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/102051313/48306509.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1816593881/10000
 0	0.0
 10	10.0
 100	200.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map.q.out Mon Jun 15 05:43:22 2009
@@ -19,26 +19,26 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: sum(UDFToDouble(0))
+                      expr: sum(UDFToDouble(key))
                 mode: hash
                 Reduce Output Operator
                   sort order: 
                   tag: -1
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: double
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
+                expr: sum(VALUE._col0)
           mode: mergepartial
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: double
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
               File Output Operator
                 compressed: false
@@ -65,5 +65,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/168289191/1427236440.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/941351690/10000
 130091

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_map_skew.q.out Mon Jun 15 05:43:22 2009
@@ -19,26 +19,26 @@
                     type: string
               Group By Operator
                 aggregations:
-                      expr: sum(UDFToDouble(0))
+                      expr: sum(UDFToDouble(key))
                 mode: hash
                 Reduce Output Operator
                   sort order: 
                   tag: -1
                   value expressions:
-                        expr: 0
+                        expr: _col0
                         type: double
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
+                expr: sum(VALUE._col0)
           mode: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: double
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
               File Output Operator
                 compressed: false
@@ -65,5 +65,5 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207636079/315601969.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1683454230/10000
 130091

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby5_noskew.q.out Mon Jun 15 05:43:22 2009
@@ -16,37 +16,43 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src 
-            Reduce Output Operator
-              key expressions:
-                    expr: key
-                    type: string
-              sort order: +
-              Map-reduce partition columns:
+            Select Operator
+              expressions:
                     expr: key
                     type: string
-              tag: -1
-              value expressions:
-                    expr: substr(value, 5)
+                    expr: value
                     type: string
+              Reduce Output Operator
+                key expressions:
+                      expr: key
+                      type: string
+                sort order: +
+                Map-reduce partition columns:
+                      expr: key
+                      type: string
+                tag: -1
+                value expressions:
+                      expr: substr(value, 5)
+                      type: string
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(UDFToDouble(VALUE.0))
+                expr: sum(UDFToDouble(VALUE._col0))
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: complete
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: double
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
-                    expr: 1
+                    expr: _col1
                     type: double
               File Output Operator
                 compressed: false
@@ -76,7 +82,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1344799541/10680715.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1385587566/10000
 0	0.0
 10	10.0
 100	200.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6.q.out Mon Jun 15 05:43:22 2009
@@ -21,7 +21,7 @@
                     type: string
               Reduce Output Operator
                 key expressions:
-                      expr: substr(0, 5, 1)
+                      expr: substr(value, 5, 1)
                       type: string
                 sort order: +
                 Map-reduce partition columns:
@@ -31,7 +31,7 @@
       Reduce Operator Tree:
         Group By Operator
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: partial1
           File Output Operator
@@ -45,25 +45,25 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/378777975/56851564.10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/925066346/10002 
             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
       Reduce Operator Tree:
         Group By Operator
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
             File Output Operator
               compressed: false
@@ -91,7 +91,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/690607981/10565214.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/308330396/10000
 0
 1
 2

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map.q.out Mon Jun 15 05:43:22 2009
@@ -20,27 +20,27 @@
                     type: string
               Group By Operator
                 keys:
-                      expr: substr(0, 5, 1)
+                      expr: substr(value, 5, 1)
                       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
       Reduce Operator Tree:
         Group By Operator
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: mergepartial
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
             File Output Operator
               compressed: false
@@ -68,7 +68,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/351658209/252380541.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/700640633/10000
 0
 1
 2

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_map_skew.q.out Mon Jun 15 05:43:22 2009
@@ -21,12 +21,12 @@
                     type: string
               Group By Operator
                 keys:
-                      expr: substr(0, 5, 1)
+                      expr: substr(value, 5, 1)
                       type: string
                 mode: hash
                 Reduce Output Operator
                   key expressions:
-                        expr: 0
+                        expr: _col0
                         type: string
                   sort order: +
                   Map-reduce partition columns:
@@ -36,7 +36,7 @@
       Reduce Operator Tree:
         Group By Operator
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: partial2
           File Output Operator
@@ -50,25 +50,25 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/341443584/940777218.10002 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/554277999/10002 
             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
       Reduce Operator Tree:
         Group By Operator
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
             File Output Operator
               compressed: false
@@ -96,7 +96,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1048827/342876636.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/596970169/10000
 0
 1
 2

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby6_noskew.q.out Mon Jun 15 05:43:22 2009
@@ -20,22 +20,22 @@
                     type: string
               Reduce Output Operator
                 key expressions:
-                      expr: substr(0, 5, 1)
+                      expr: substr(value, 5, 1)
                       type: string
                 sort order: +
                 Map-reduce partition columns:
-                      expr: substr(0, 5, 1)
+                      expr: substr(value, 5, 1)
                       type: string
                 tag: -1
       Reduce Operator Tree:
         Group By Operator
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: complete
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
             File Output Operator
               compressed: false
@@ -63,7 +63,7 @@
 Output: default/dest1
 query: SELECT dest1.* FROM dest1
 Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/510632824/360440652.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1924130915/10000
 0
 1
 2

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map.q.out Mon Jun 15 05:43:22 2009
@@ -18,58 +18,70 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src 
-            Group By Operator
-              aggregations:
-                    expr: sum(UDFToDouble(substr(value, 5)))
-              keys:
+            Select Operator
+              expressions:
                     expr: key
                     type: string
-              mode: hash
-              Reduce Output Operator
-                key expressions:
-                      expr: 0
-                      type: string
-                sort order: +
-                Map-reduce partition columns:
-                      expr: 0
+                    expr: value
+                    type: string
+              Group By Operator
+                aggregations:
+                      expr: sum(UDFToDouble(substr(value, 5)))
+                keys:
+                      expr: key
                       type: string
-                tag: -1
-                value expressions:
-                      expr: 1
-                      type: double
-            Group By Operator
-              aggregations:
-                    expr: sum(UDFToDouble(substr(value, 5)))
-              keys:
+                mode: hash
+                Reduce Output Operator
+                  key expressions:
+                        expr: _col0
+                        type: string
+                  sort order: +
+                  Map-reduce partition columns:
+                        expr: _col0
+                        type: string
+                  tag: -1
+                  value expressions:
+                        expr: _col1
+                        type: double
+            Select Operator
+              expressions:
                     expr: key
                     type: string
-              mode: hash
-              File Output Operator
-                compressed: true
-                GlobalTableId: 0
-                table:
-                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
+                    expr: value
+                    type: string
+              Group By Operator
+                aggregations:
+                      expr: sum(UDFToDouble(substr(value, 5)))
+                keys:
+                      expr: key
+                      type: string
+                mode: hash
+                File Output Operator
+                  compressed: true
+                  GlobalTableId: 0
+                  table:
+                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                      name: binary_table
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
+                expr: sum(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: double
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
-                    expr: 1
+                    expr: _col1
                     type: double
               File Output Operator
                 compressed: true
@@ -99,38 +111,38 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/267196387/57369739.10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/809118109/10004 
             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: double
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
+                expr: sum(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: double
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
-                    expr: 1
+                    expr: _col1
                     type: double
               File Output Operator
                 compressed: true
@@ -150,7 +162,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1043668036/332712287.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1257848129/10000
 0	0.0
 10	10.0
 100	200.0
@@ -462,7 +474,7 @@
 98	196.0
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/473793334/1186860826.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/957563514/10000
 0	0.0
 10	10.0
 100	200.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_map_skew.q.out Mon Jun 15 05:43:22 2009
@@ -20,45 +20,57 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src 
-            Group By Operator
-              aggregations:
-                    expr: sum(UDFToDouble(substr(value, 5)))
-              keys:
+            Select Operator
+              expressions:
                     expr: key
                     type: string
-              mode: hash
-              Reduce Output Operator
-                key expressions:
-                      expr: 0
+                    expr: value
+                    type: string
+              Group By Operator
+                aggregations:
+                      expr: sum(UDFToDouble(substr(value, 5)))
+                keys:
+                      expr: key
                       type: string
-                sort order: +
-                Map-reduce partition columns:
-                      expr: rand()
-                      type: double
-                tag: -1
-                value expressions:
-                      expr: 1
-                      type: double
-            Group By Operator
-              aggregations:
-                    expr: sum(UDFToDouble(substr(value, 5)))
-              keys:
+                mode: hash
+                Reduce Output Operator
+                  key expressions:
+                        expr: _col0
+                        type: string
+                  sort order: +
+                  Map-reduce partition columns:
+                        expr: rand()
+                        type: double
+                  tag: -1
+                  value expressions:
+                        expr: _col1
+                        type: double
+            Select Operator
+              expressions:
                     expr: key
                     type: string
-              mode: hash
-              File Output Operator
-                compressed: true
-                GlobalTableId: 0
-                table:
-                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                    name: binary_table
+                    expr: value
+                    type: string
+              Group By Operator
+                aggregations:
+                      expr: sum(UDFToDouble(substr(value, 5)))
+                keys:
+                      expr: key
+                      type: string
+                mode: hash
+                File Output Operator
+                  compressed: true
+                  GlobalTableId: 0
+                  table:
+                      input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                      name: binary_table
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
+                expr: sum(VALUE._col0)
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: partial2
           File Output Operator
@@ -72,38 +84,38 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/517555/87986579.10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/159218052/10004 
             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: double
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
+                expr: sum(VALUE._col0)
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: double
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
-                    expr: 1
+                    expr: _col1
                     type: double
               File Output Operator
                 compressed: true
@@ -133,10 +145,10 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/517555/87986579.10005 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/159218052/10005 
             Reduce Output Operator
               key expressions:
-                    expr: 0
+                    expr: _col0
                     type: string
               sort order: +
               Map-reduce partition columns:
@@ -144,14 +156,14 @@
                     type: double
               tag: -1
               value expressions:
-                    expr: 1
+                    expr: _col1
                     type: double
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
+                expr: sum(VALUE._col0)
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: partial2
           File Output Operator
@@ -165,38 +177,38 @@
   Stage: Stage-4
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/517555/87986579.10006 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/159218052/10006 
             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: double
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(VALUE.0)
+                expr: sum(VALUE._col0)
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: double
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
-                    expr: 1
+                    expr: _col1
                     type: double
               File Output Operator
                 compressed: true
@@ -216,7 +228,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1583075121/447851227.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1882977377/10000
 0	0.0
 10	10.0
 100	200.0
@@ -528,7 +540,7 @@
 98	196.0
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1089426067/5659897.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2022291262/10000
 0	0.0
 10	10.0
 100	200.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby7_noskew.q.out Mon Jun 15 05:43:22 2009
@@ -18,44 +18,56 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src 
-            Reduce Output Operator
-              key expressions:
+            Select Operator
+              expressions:
                     expr: key
                     type: string
-              sort order: +
-              Map-reduce partition columns:
+                    expr: value
+                    type: string
+              Reduce Output Operator
+                key expressions:
+                      expr: key
+                      type: string
+                sort order: +
+                Map-reduce partition columns:
+                      expr: key
+                      type: string
+                tag: -1
+                value expressions:
+                      expr: substr(value, 5)
+                      type: string
+            Select Operator
+              expressions:
                     expr: key
                     type: string
-              tag: -1
-              value expressions:
-                    expr: substr(value, 5)
+                    expr: value
                     type: string
-            File Output Operator
-              compressed: true
-              GlobalTableId: 0
-              table:
-                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
+              File Output Operator
+                compressed: true
+                GlobalTableId: 0
+                table:
+                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                    name: binary_table
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(UDFToDouble(VALUE.0))
+                expr: sum(UDFToDouble(VALUE._col0))
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: complete
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: double
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
-                    expr: 1
+                    expr: _col1
                     type: double
               File Output Operator
                 compressed: true
@@ -85,7 +97,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/81820008/280821152.10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/399458158/10004 
             Reduce Output Operator
               key expressions:
                     expr: key
@@ -101,22 +113,22 @@
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: sum(UDFToDouble(VALUE.0))
+                expr: sum(UDFToDouble(VALUE._col0))
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: complete
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: double
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
-                    expr: 1
+                    expr: _col1
                     type: double
               File Output Operator
                 compressed: true
@@ -136,7 +148,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/347720188/515827693.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/519200565/10000
 0	0.0
 10	10.0
 100	200.0
@@ -448,7 +460,7 @@
 98	196.0
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/241813164/313890379.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/81469507/10000
 0	0.0
 10	10.0
 100	200.0

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8.q.out Mon Jun 15 05:43:22 2009
@@ -11,7 +11,7 @@
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
   Stage-0 depends on stages: Stage-2, Stage-4
-  Stage-3 depends on stages: Stage-1
+  Stage-3 depends on stages: Stage-2
   Stage-4 depends on stages: Stage-3
   Stage-0 depends on stages: Stage-2, Stage-4
 
@@ -20,32 +20,44 @@
     Map Reduce
       Alias -> Map Operator Tree:
         src 
-            Reduce Output Operator
-              key expressions:
+            Select Operator
+              expressions:
                     expr: key
                     type: string
-                    expr: substr(value, 5)
+                    expr: value
                     type: string
-              sort order: ++
-              Map-reduce partition columns:
+              Reduce Output Operator
+                key expressions:
+                      expr: key
+                      type: string
+                      expr: substr(value, 5)
+                      type: string
+                sort order: ++
+                Map-reduce partition columns:
+                      expr: key
+                      type: string
+                      expr: substr(value, 5)
+                      type: string
+                tag: -1
+            Select Operator
+              expressions:
                     expr: key
                     type: string
-                    expr: substr(value, 5)
+                    expr: value
                     type: string
-              tag: -1
-            File Output Operator
-              compressed: false
-              GlobalTableId: 0
-              table:
-                  input format: org.apache.hadoop.mapred.SequenceFileInputFormat
-                  output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
-                  name: binary_table
+              File Output Operator
+                compressed: false
+                GlobalTableId: 0
+                table:
+                    input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+                    name: binary_table
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: count(DISTINCT KEY.1)
+                expr: count(DISTINCT KEY._col1)
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: partial1
           File Output Operator
@@ -59,38 +71,38 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/140111117/49441246.10004 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/691145829/10004 
             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
       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: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: bigint
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
-                    expr: 1
+                    expr: _col1
                     type: bigint
               File Output Operator
                 compressed: false
@@ -120,7 +132,7 @@
   Stage: Stage-3
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/140111117/49441246.10005 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/691145829/10005 
             Reduce Output Operator
               key expressions:
                     expr: key
@@ -137,9 +149,9 @@
       Reduce Operator Tree:
         Group By Operator
           aggregations:
-                expr: count(DISTINCT KEY.1)
+                expr: count(DISTINCT KEY._col1)
           keys:
-                expr: KEY.0
+                expr: KEY._col0
                 type: string
           mode: partial1
           File Output Operator
@@ -153,38 +165,38 @@
   Stage: Stage-4
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/njain/hive2/hive2/build/ql/tmp/140111117/49441246.10006 
+        file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/691145829/10006 
             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
       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: final
           Select Operator
             expressions:
-                  expr: 0
+                  expr: _col0
                   type: string
-                  expr: 1
+                  expr: _col1
                   type: bigint
             Select Operator
               expressions:
-                    expr: UDFToInteger(0)
+                    expr: UDFToInteger(_col0)
                     type: int
-                    expr: 1
+                    expr: _col1
                     type: bigint
               File Output Operator
                 compressed: false
@@ -204,7 +216,7 @@
 Output: default/dest2
 query: SELECT DEST1.* FROM DEST1
 Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1852150935/396027054.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1572497614/10000
 0	1
 10	1
 100	1
@@ -516,7 +528,7 @@
 98	1
 query: SELECT DEST2.* FROM DEST2
 Input: default/dest2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/17802714/1443308332.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/811451790/10000
 0	1
 10	1
 100	1



Mime
View raw message