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 [8/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/mapreduce2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce2.q.out Mon Jun 15 05:43:22 2009
@@ -53,13 +53,13 @@
Extract
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: UDFToInteger(1)
+ expr: UDFToInteger(_col1)
type: int
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -90,7 +90,7 @@
Output: default/dest1
query: SELECT * FROM (SELECT dest1.* FROM dest1 DISTRIBUTE BY key SORT BY key, ten, one, value) T
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/21517063/428269906.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/784757508/10000
0 0 0 val_0
0 0 0 val_0
0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce3.q.out Mon Jun 15 05:43:22 2009
@@ -53,13 +53,13 @@
Extract
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: UDFToInteger(1)
+ expr: UDFToInteger(_col1)
type: int
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -90,7 +90,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/122478505/180989797.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/66680643/10000
0 0 0 val_0
0 0 0 val_0
0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce4.q.out Mon Jun 15 05:43:22 2009
@@ -59,13 +59,13 @@
Extract
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: UDFToInteger(1)
+ expr: UDFToInteger(_col1)
type: int
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -97,7 +97,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/608149359/217174258.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/8701971/10000
90 9 0 val_90
90 9 0 val_90
90 9 0 val_90
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce5.q.out Mon Jun 15 05:43:22 2009
@@ -29,37 +29,37 @@
type: string
Reduce Output Operator
key expressions:
- expr: 1
+ expr: _col1
type: int
- expr: 2
+ expr: _col2
type: int
sort order: -+
Map-reduce partition columns:
- expr: 3
+ expr: _col3
type: string
- expr: 0
+ expr: _col0
type: string
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: int
- expr: 2
+ expr: _col2
type: int
- expr: 3
+ expr: _col3
type: string
Reduce Operator Tree:
Extract
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: int
- expr: 2
+ expr: _col2
type: int
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -90,7 +90,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/38926801/280803016.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1149070891/10000
490 49 0 val_490
491 49 1 val_491
492 49 2 val_492
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce6.q.out Mon Jun 15 05:43:22 2009
@@ -29,37 +29,37 @@
type: string
Reduce Output Operator
key expressions:
- expr: 1
+ expr: _col1
type: int
- expr: 2
+ expr: _col2
type: int
sort order: -+
Map-reduce partition columns:
- expr: 3
+ expr: _col3
type: string
- expr: 0
+ expr: _col0
type: string
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: int
- expr: 2
+ expr: _col2
type: int
- expr: 3
+ expr: _col3
type: string
Reduce Operator Tree:
Extract
Select Operator
expressions:
- expr: UDFToInteger(0)
+ expr: UDFToInteger(_col0)
type: int
- expr: 1
+ expr: _col1
type: int
- expr: 2
+ expr: _col2
type: int
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -90,7 +90,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/589725073/176567235.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2144690037/10000
490 49 0 val_490
491 49 1 val_491
492 49 2 val_492
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce7.q.out Mon Jun 15 05:43:22 2009
@@ -61,17 +61,17 @@
Extract
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: UDFToInteger(3)
+ expr: UDFToInteger(_col3)
type: int
- expr: UDFToInteger(4)
+ expr: UDFToInteger(_col4)
type: int
- expr: 5
+ expr: _col5
type: string
File Output Operator
compressed: false
@@ -102,7 +102,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/211040223/672345730.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/842155825/10000
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/mapreduce8.q.out Mon Jun 15 05:43:22 2009
@@ -65,17 +65,17 @@
Extract
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: UDFToInteger(2)
+ expr: UDFToInteger(_col2)
type: int
- expr: UDFToInteger(3)
+ expr: UDFToInteger(_col3)
type: int
- expr: UDFToInteger(4)
+ expr: UDFToInteger(_col4)
type: int
- expr: 5
+ expr: _col5
type: string
File Output Operator
compressed: false
@@ -107,7 +107,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/903115095/320438958.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1993582864/10000
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
0 val_0 0 0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out Mon Jun 15 05:43:22 2009
@@ -33,21 +33,21 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Filter Operator
predicate:
- expr: ((UDFToDouble(0) < UDFToDouble(10)) and (UDFToDouble(2) < UDFToDouble(10)))
+ expr: ((UDFToDouble(_col0) < UDFToDouble(10)) and (UDFToDouble(_col2) < UDFToDouble(10)))
type: boolean
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
File Output Operator
compressed: false
@@ -60,27 +60,27 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/18695058/1281735652.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1772065220/10002
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
sort order: ++++
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
- expr: 3
+ expr: _col3
type: string
Reduce Operator Tree:
Extract
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out Mon Jun 15 05:43:22 2009
@@ -20,11 +20,11 @@
type: string
Filter Operator
predicate:
- expr: (UDFToDouble(1) < UDFToDouble(100))
+ expr: (UDFToDouble(_col1) < UDFToDouble(100))
type: boolean
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
File Output Operator
compressed: false
@@ -40,7 +40,7 @@
query: SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100
Input: default/src
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/4961385/1570794008.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1484515504/10000
val_86
val_27
val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out Mon Jun 15 05:43:22 2009
@@ -14,56 +14,56 @@
Map Reduce
Alias -> Map Operator Tree:
src
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) < UDFToDouble(100))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
Group By Operator
aggregations:
expr: count(1)
keys:
- expr: 0
+ expr: key
type: string
mode: hash
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: -1
value expressions:
- expr: 1
+ expr: _col1
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: mergepartial
Select Operator
expressions:
expr: '1234'
type: string
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: UDFToInteger(1)
+ expr: UDFToInteger(_col1)
type: int
- expr: UDFToDouble(2)
+ expr: UDFToDouble(_col2)
type: double
File Output Operator
compressed: false
@@ -91,7 +91,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/518865147/140769590.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/632604195/10000
1234 0 3.0
1234 10 1.0
1234 11 1.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out Mon Jun 15 05:43:22 2009
@@ -14,56 +14,56 @@
Map Reduce
Alias -> Map Operator Tree:
src
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) < UDFToDouble(100))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
Group By Operator
aggregations:
expr: count(1)
keys:
- expr: 0
+ expr: key
type: string
mode: hash
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: -1
value expressions:
- expr: 1
+ expr: _col1
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: mergepartial
Select Operator
expressions:
expr: '1234'
type: string
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: UDFToInteger(1)
+ expr: UDFToInteger(_col1)
type: int
- expr: UDFToDouble(2)
+ expr: UDFToDouble(_col2)
type: double
File Output Operator
compressed: false
@@ -91,7 +91,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/73789711/581555617.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1744225611/10000
1234 0 3.0
1234 10 1.0
1234 11 1.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out Mon Jun 15 05:43:22 2009
@@ -12,14 +12,11 @@
Map Reduce
Alias -> Map Operator Tree:
x
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) > UDFToDouble(9999))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
Group By Operator
aggregations:
expr: count(1)
@@ -28,16 +25,16 @@
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
File Output Operator
compressed: false
@@ -53,7 +50,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/336665491/172016340.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/147597218/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -69,14 +66,11 @@
Map Reduce
Alias -> Map Operator Tree:
x
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) > UDFToDouble(9999))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
Group By Operator
aggregations:
expr: count(1)
@@ -85,16 +79,16 @@
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
File Output Operator
compressed: false
@@ -110,7 +104,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/11054297/1508397372.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/533131483/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -127,27 +121,21 @@
Map Reduce
Alias -> Map Operator Tree:
x
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) > UDFToDouble(9999))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
Reduce Output Operator
sort order:
Map-reduce partition columns:
expr: rand()
type: double
tag: -1
- value expressions:
- expr: 1
- type: int
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
mode: partial1
File Output Operator
compressed: false
@@ -160,21 +148,21 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/321579646/257985577.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1010806267/10002
Reduce Output Operator
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
File Output Operator
compressed: false
@@ -190,7 +178,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/453183166/223236193.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1089737871/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -206,28 +194,22 @@
Map Reduce
Alias -> Map Operator Tree:
x
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) > UDFToDouble(9999))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
Reduce Output Operator
sort order:
tag: -1
- value expressions:
- expr: 1
- type: int
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
mode: complete
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -243,5 +225,5 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/42852040/39442442.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1646500951/10000
0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out Mon Jun 15 05:43:22 2009
@@ -13,24 +13,24 @@
Map Reduce
Alias -> Map Operator Tree:
x
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) > UDFToDouble(9999))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
Group By Operator
aggregations:
expr: count(1)
keys:
- expr: 0
+ expr: key
type: string
mode: hash
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
@@ -38,14 +38,14 @@
type: double
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: partial2
File Output Operator
@@ -59,32 +59,32 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/954380749/814314853.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/903786028/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
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
File Output Operator
compressed: false
@@ -100,7 +100,7 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/544902187/1182185840.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1972021465/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -115,46 +115,46 @@
Map Reduce
Alias -> Map Operator Tree:
x
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) > UDFToDouble(9999))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
Group By Operator
aggregations:
expr: count(1)
keys:
- expr: 0
+ expr: key
type: string
mode: hash
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: -1
value expressions:
- expr: 1
+ expr: _col1
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -170,7 +170,7 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/454735660/1100830875.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2003513478/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -186,32 +186,29 @@
Map Reduce
Alias -> Map Operator Tree:
x
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) > UDFToDouble(9999))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: key
type: string
sort order: +
Map-reduce partition columns:
expr: rand()
type: double
tag: -1
- value expressions:
- expr: 1
- type: int
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: partial1
File Output Operator
@@ -225,32 +222,32 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/262117174/340946941.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/955037671/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
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
File Output Operator
compressed: false
@@ -266,7 +263,7 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/59460558/421529989.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1033844732/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -281,39 +278,36 @@
Map Reduce
Alias -> Map Operator Tree:
x
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(0) > UDFToDouble(9999))
- type: boolean
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: key
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: key
type: string
tag: -1
- value expressions:
- expr: 1
- type: int
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: complete
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -329,4 +323,4 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1455104846/1180542256.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1589261457/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup3.q.out Mon Jun 15 05:43:22 2009
@@ -25,16 +25,16 @@
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
File Output Operator
compressed: false
@@ -51,7 +51,7 @@
query: select count(1) from tstparttbl
Input: default/tstparttbl/ds=2008-04-08
Input: default/tstparttbl/ds=2008-04-09
-Output: file:/Users/pchakka/workspace/oshive/build/ql/tmp/1242360371/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/869080729/10000
500
query: DROP TABLE tstparttbl2
query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
@@ -80,16 +80,16 @@
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
File Output Operator
compressed: false
@@ -106,7 +106,7 @@
query: select count(1) from tstparttbl2
Input: default/tstparttbl2/ds=2008-04-08
Input: default/tstparttbl2/ds=2008-04-09
-Output: file:/Users/pchakka/workspace/oshive/build/ql/tmp/361074813/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/317850076/10000
0
query: DROP TABLE tstparttbl
query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
@@ -135,16 +135,16 @@
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
File Output Operator
compressed: false
@@ -161,7 +161,7 @@
query: select count(1) from tstparttbl
Input: default/tstparttbl/ds=2008-04-08
Input: default/tstparttbl/ds=2008-04-09
-Output: file:/Users/pchakka/workspace/oshive/build/ql/tmp/813815719/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1944930089/10000
500
query: DROP TABLE tstparttbl2
query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
@@ -190,16 +190,16 @@
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
File Output Operator
compressed: false
@@ -216,7 +216,7 @@
query: select count(1) from tstparttbl2
Input: default/tstparttbl2/ds=2008-04-08
Input: default/tstparttbl2/ds=2008-04-09
-Output: file:/Users/pchakka/workspace/oshive/build/ql/tmp/18671157/10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/768347306/10000
0
query: DROP TABLE tstparttbl
query: DROP TABLE tstparttbl2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out Mon Jun 15 05:43:22 2009
@@ -17,33 +17,37 @@
predicate:
expr: (UDFToDouble(key) = UDFToDouble(9999))
type: boolean
- Group By Operator
- aggregations:
- expr: count(1)
- expr: count(DISTINCT value)
- keys:
+ Select Operator
+ expressions:
expr: value
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ expr: count(DISTINCT value)
+ keys:
+ expr: value
type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
- expr: 2
- type: bigint
+ 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: bigint
+ expr: _col2
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
- expr: count(DISTINCT KEY.0)
+ expr: count(VALUE._col0)
+ expr: count(DISTINCT KEY._col0)
mode: partial2
File Output Operator
compressed: false
@@ -56,26 +60,26 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/239528358/1642297313.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1897268457/10002
Reduce Output Operator
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: bigint
- expr: 1
+ expr: _col1
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
- expr: count(VALUE.1)
+ expr: count(VALUE._col0)
+ expr: count(VALUE._col1)
mode: final
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: bigint
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -91,7 +95,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/325692617/1828692774.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1722609002/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -111,36 +115,40 @@
predicate:
expr: (UDFToDouble(key) = UDFToDouble(9999))
type: boolean
- Group By Operator
- aggregations:
- expr: count(1)
- expr: count(DISTINCT value)
- keys:
+ Select Operator
+ expressions:
expr: value
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ expr: count(DISTINCT value)
+ keys:
+ expr: value
type: string
- sort order: +
- tag: -1
- value expressions:
- expr: 1
- type: bigint
- expr: 2
- type: bigint
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
+ expr: _col2
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
- expr: count(DISTINCT KEY.0)
+ expr: count(VALUE._col0)
+ expr: count(DISTINCT KEY._col0)
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: bigint
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -156,7 +164,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/335823350/278031676.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/767488780/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -177,23 +185,24 @@
predicate:
expr: (UDFToDouble(key) = UDFToDouble(9999))
type: boolean
- Reduce Output Operator
- key expressions:
- expr: value
- type: string
- sort order: +
- Map-reduce partition columns:
+ Select Operator
+ expressions:
expr: value
type: string
- tag: -1
- value expressions:
- expr: 1
- type: int
+ Reduce Output Operator
+ key expressions:
+ expr: value
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: value
+ type: string
+ tag: -1
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
- expr: count(DISTINCT KEY.0)
+ expr: count(VALUE._col0)
+ expr: count(DISTINCT KEY._col0)
mode: partial1
File Output Operator
compressed: false
@@ -206,26 +215,26 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/1692279252/140064107.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/366816975/10002
Reduce Output Operator
sort order:
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: bigint
- expr: 1
+ expr: _col1
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
- expr: count(VALUE.1)
+ expr: count(VALUE._col0)
+ expr: count(VALUE._col1)
mode: final
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: bigint
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -241,7 +250,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/610656938/142519338.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/449391495/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -261,26 +270,27 @@
predicate:
expr: (UDFToDouble(key) = UDFToDouble(9999))
type: boolean
- Reduce Output Operator
- key expressions:
+ Select Operator
+ expressions:
expr: value
type: string
- sort order: +
- tag: -1
- value expressions:
- expr: 1
- type: int
+ Reduce Output Operator
+ key expressions:
+ expr: value
+ type: string
+ sort order: +
+ tag: -1
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
- expr: count(DISTINCT KEY.0)
+ expr: count(VALUE._col0)
+ expr: count(DISTINCT KEY._col0)
mode: complete
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: bigint
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -296,5 +306,5 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/196703351/357121241.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1178763568/10000
0 0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullscript.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullscript.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullscript.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullscript.q.out Mon Jun 15 05:43:22 2009
@@ -20,21 +20,17 @@
expressions:
expr: key
type: string
- Select Operator
- expressions:
- expr: 0
- type: string
- Transform Operator
- command: /bin/cat
- output info:
+ Transform Operator
+ command: /bin/cat
+ output info:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
@@ -43,7 +39,7 @@
query: select transform(key) using '/bin/cat' as key1 from nullscript
Input: default/nullscript
-Output: /mnt/vol/devrs005.snc1/rmurthy/hadoop_tools/trunk-trunk-apache-hive/ql/../build/ql/tmp/681152477/759590347.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/318391745/10000
238
86
311
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/order.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/order.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/order.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/order.q.out Mon Jun 15 05:43:22 2009
@@ -20,14 +20,14 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Extract
@@ -46,7 +46,7 @@
query: SELECT x.* FROM SRC x ORDER BY key limit 10
Input: default/src
-Output: /Users/char/Documents/workspace/Hive-Clean/ql/../build/ql/tmp/169430346/424548918.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/931476963/10000
0 val_0
0 val_0
0 val_0
@@ -79,14 +79,14 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: -
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Extract
@@ -105,7 +105,7 @@
query: SELECT x.* FROM SRC x ORDER BY key desc limit 10
Input: default/src
-Output: /Users/char/Documents/workspace/Hive-Clean/ql/../build/ql/tmp/791961436/10045799.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1878611335/10000
98 val_98
98 val_98
97 val_97
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/order2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/order2.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/order2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/order2.q.out Mon Jun 15 05:43:22 2009
@@ -22,27 +22,27 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Extract
Limit
Filter Operator
predicate:
- expr: (UDFToDouble(0) < UDFToDouble(10))
+ expr: (UDFToDouble(_col0) < UDFToDouble(10))
type: boolean
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -60,7 +60,7 @@
(SELECT x.* FROM SRC x ORDER BY key limit 10) subq
where subq.key < 10
Input: default/src
-Output: /Users/char/Documents/workspace/Hive-Clean/ql/../build/ql/tmp/33430474/546318754.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1232262908/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd1.q.out Mon Jun 15 05:43:22 2009
@@ -16,24 +16,20 @@
predicate:
expr: (key > '2')
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (0 > '2')
- type: boolean
- Select Operator
- expressions:
- expr: 0
- type: string
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ Filter Operator
+ predicate:
+ expr: (key > '2')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator
@@ -42,7 +38,7 @@
query: SELECT src.key as c3 from src where src.key > '2'
Input: default/src
-Output: /Users/pchakka/workspace/oshive/ql/../build/ql/tmp/589686678/45664239.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/529404035/10000
238
86
311
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_clusterby.q.out Mon Jun 15 05:43:22 2009
@@ -28,17 +28,17 @@
type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Extract
@@ -56,7 +56,7 @@
query: SELECT * FROM SRC x where x.key = 10 CLUSTER BY x.key
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/80401547/562924.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/241519225/10000
10 val_10
query: EXPLAIN
SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
@@ -73,22 +73,20 @@
Map Reduce
Alias -> Map Operator Tree:
y
- Select Operator
- expressions:
+ Reduce Output Operator
+ key expressions:
expr: key
type: string
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: 1
- value expressions:
- expr: 0
- type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
x
Filter Operator
predicate:
@@ -113,19 +111,19 @@
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Filter Operator
predicate:
- expr: (UDFToDouble(0) = UDFToDouble(20))
+ expr: (UDFToDouble(_col0) = UDFToDouble(20))
type: boolean
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
File Output Operator
compressed: false
@@ -138,22 +136,22 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/457076061/909404116.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1825740657/10002
Reduce Output Operator
key expressions:
- expr: 1
+ expr: _col1
type: string
sort order: +
Map-reduce partition columns:
- expr: 1
+ expr: _col1
type: string
tag: -1
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
Reduce Operator Tree:
Extract
@@ -171,5 +169,5 @@
query: SELECT x.key, x.value as v1, y.key FROM SRC x JOIN SRC y ON (x.key = y.key) where x.key = 20 CLUSTER BY v1
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/605916181/859821975.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1443480977/10000
20 val_20 20
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_constant_expr.q.out Mon Jun 15 05:43:22 2009
@@ -16,32 +16,28 @@
src1
Select Operator
expressions:
- expr: key
- type: string
+ expr: (UDFToDouble(4) + null)
+ type: double
+ expr: (UDFToDouble(key) - null)
+ type: double
+ expr: (null + null)
+ type: double
Select Operator
expressions:
- expr: (UDFToDouble(4) + null)
+ expr: _col0
type: double
- expr: (UDFToDouble(0) - null)
+ expr: UDFToInteger(_col1)
+ type: int
+ expr: _col2
type: double
- expr: (null + null)
- type: double
- Select Operator
- expressions:
- expr: 0
- type: double
- expr: UDFToInteger(1)
- type: int
- expr: 2
- type: double
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: ppd_constant_expr
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: ppd_constant_expr
Stage: Stage-0
Move Operator
@@ -60,7 +56,7 @@
Output: default/ppd_constant_expr
query: SELECT ppd_constant_expr.* FROM ppd_constant_expr
Input: default/ppd_constant_expr
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/254664389/264213010.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1781694301/10000
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby.q.out Mon Jun 15 05:43:22 2009
@@ -23,46 +23,52 @@
predicate:
expr: (value > 'val_10')
type: boolean
- Group By Operator
- aggregations:
- expr: count(key)
- keys:
+ Select Operator
+ expressions:
+ expr: key
+ type: string
expr: value
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
+ Group By Operator
+ aggregations:
+ expr: count(key)
+ keys:
+ expr: value
type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
+ 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: 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: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
Filter Operator
predicate:
- expr: ((0 > 'val_200') and ((UDFToDouble(1) > UDFToDouble(30)) or (0 < 'val_400')))
+ expr: ((_col0 > 'val_200') and ((UDFToDouble(_col1) > UDFToDouble(30)) or (_col0 < 'val_400')))
type: boolean
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
File Output Operator
compressed: false
@@ -81,7 +87,7 @@
(SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1
WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400')
Input: default/src
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/149093602/149899687.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1156603404/10000
val_201
val_202
val_203
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby2.q.out Mon Jun 15 05:43:22 2009
@@ -25,87 +25,99 @@
predicate:
expr: (value > 'val_10')
type: boolean
- Group By Operator
- aggregations:
- expr: count(key)
- keys:
+ Select Operator
+ expressions:
+ expr: key
+ type: string
expr: value
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
+ Group By Operator
+ aggregations:
+ expr: count(key)
+ keys:
+ expr: value
type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
+ 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: 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: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
Filter Operator
predicate:
- expr: ((0 > 'val_200') and ((UDFToDouble(1) > UDFToDouble(30)) or (0 < 'val_400')))
+ expr: ((_col0 > 'val_200') and ((UDFToDouble(_col1) > UDFToDouble(30)) or (_col0 < 'val_400')))
type: boolean
- Group By Operator
- aggregations:
- expr: max(0)
- keys:
- expr: 1
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
type: bigint
- mode: hash
- 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
+ Group By Operator
+ aggregations:
+ expr: max(_col0)
+ keys:
+ expr: _col1
+ type: bigint
+ mode: hash
+ 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
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/204855157/1634833894.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1551152352/10002
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: bigint
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: bigint
tag: -1
value expressions:
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: max(VALUE.0)
+ expr: max(VALUE._col0)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: bigint
mode: mergepartial
Select Operator
expressions:
- expr: 1
+ expr: _col1
type: string
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -125,7 +137,7 @@
WHERE src1.c1 > 'val_200' AND (src1.c2 > 30 OR src1.c1 < 'val_400')
GROUP BY src1.c2
Input: default/src
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/326957820/25191908.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/455848953/10000
val_4 1
val_399 2
val_396 3
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ppd_gby_join.q.out Mon Jun 15 05:43:22 2009
@@ -32,21 +32,17 @@
expressions:
expr: key
type: string
- expr: value
- type: string
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 1
value expressions:
- expr: 0
- type: string
- expr: 1
+ expr: _col0
type: string
src1:src
Filter Operator
@@ -65,77 +61,81 @@
type: string
Filter Operator
predicate:
- expr: (0 < '400')
+ expr: (_col0 < '400')
type: boolean
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
sort order: +
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
tag: 0
value expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE.0} {VALUE.1}
- 1 {VALUE.0} {VALUE.1}
+ 0 {VALUE._col0} {VALUE._col1}
+ 1 {VALUE._col0} {VALUE._col1}
Filter Operator
predicate:
- expr: ((((0 > '20') and ((1 < 'val_50') or (0 > '2'))) and ((2 > '50') or (0 < '50'))) and (2 <> '4'))
+ expr: ((((_col0 > '20') and ((_col1 < 'val_50') or (_col0 > '2'))) and ((_col2 > '50') or (_col0 < '50'))) and (_col2 <> '4'))
type: boolean
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
+ Select Operator
+ expressions:
+ expr: _col0
type: string
- mode: hash
- 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
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: _col0
+ type: string
+ mode: hash
+ 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
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/72319358/439262016.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1901853163/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
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(VALUE.0)
+ expr: count(VALUE._col0)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false