You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by na...@apache.org on 2009/06/15 07:43:29 UTC
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...
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