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 [11/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/o...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union10.q.out Mon Jun 15 05:43:22 2009
@@ -37,18 +37,18 @@
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: 'tst1'
type: string
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -61,19 +61,19 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive5/hive5/build/ql/tmp/28088060/1127108958.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/440029246/10002
Union
Select Operator
expressions:
- 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
File Output Operator
compressed: false
@@ -83,19 +83,19 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- /data/users/njain/hive5/hive5/build/ql/tmp/28088060/1127108958.10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/440029246/10003
Union
Select Operator
expressions:
- 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
File Output Operator
compressed: false
@@ -105,19 +105,19 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- /data/users/njain/hive5/hive5/build/ql/tmp/28088060/1127108958.10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/440029246/10004
Union
Select Operator
expressions:
- 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
File Output Operator
compressed: false
@@ -151,18 +151,18 @@
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: 'tst2'
type: string
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -185,18 +185,18 @@
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: 'tst3'
type: string
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -217,7 +217,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key
Input: default/tmptable
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/1213068626/1117023264.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/473439287/10000
tst1 500
tst2 500
tst3 500
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union11.q.out Mon Jun 15 05:43:22 2009
@@ -32,18 +32,18 @@
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: 'tst1'
type: string
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -56,82 +56,94 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive5/hive5/build/ql/tmp/10111128/61373547.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1039026532/10002
Union
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
+ Select Operator
+ expressions:
+ expr: _col0
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)
+ keys:
+ expr: _col0
type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
- /data/users/njain/hive5/hive5/build/ql/tmp/10111128/61373547.10003
+ 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
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1039026532/10003
Union
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
+ Select Operator
+ expressions:
+ expr: _col0
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)
+ keys:
+ expr: _col0
type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
- /data/users/njain/hive5/hive5/build/ql/tmp/10111128/61373547.10004
+ 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
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1039026532/10004
Union
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
+ Select Operator
+ expressions:
+ expr: _col0
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)
+ keys:
+ expr: _col0
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
File Output Operator
compressed: false
@@ -153,18 +165,18 @@
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: 'tst2'
type: string
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -187,18 +199,18 @@
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: 'tst3'
type: string
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -219,7 +231,7 @@
UNION ALL
select 'tst3' as key, count(1) as value from src s3) unionsrc group by unionsrc.key
Input: default/src
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/275601658/682160651.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1124432682/10000
tst1 1
tst2 1
tst3 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union12.q.out Mon Jun 15 05:43:22 2009
@@ -37,18 +37,18 @@
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: 'tst1'
type: string
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -61,19 +61,19 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive5/hive5/build/ql/tmp/57759680/470566404.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/289651574/10002
Union
Select Operator
expressions:
- 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
File Output Operator
compressed: false
@@ -83,19 +83,19 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- /data/users/njain/hive5/hive5/build/ql/tmp/57759680/470566404.10003
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/289651574/10003
Union
Select Operator
expressions:
- 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
File Output Operator
compressed: false
@@ -105,19 +105,19 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- /data/users/njain/hive5/hive5/build/ql/tmp/57759680/470566404.10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/289651574/10004
Union
Select Operator
expressions:
- 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
File Output Operator
compressed: false
@@ -151,18 +151,18 @@
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: 'tst2'
type: string
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -185,18 +185,18 @@
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: 'tst3'
type: string
- expr: 0
+ expr: _col0
type: bigint
File Output Operator
compressed: false
@@ -219,7 +219,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key
Input: default/tmptable
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/270230554/696358836.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/714730334/10000
tst1 500
tst2 25
tst3 1000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union13.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union13.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union13.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union13.q.out Mon Jun 15 05:43:22 2009
@@ -24,9 +24,9 @@
Union
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -44,9 +44,9 @@
Union
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -63,7 +63,7 @@
query: select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from src s1 UNION ALL
select s2.key as key, s2.value as value from src s2) unionsrc
Input: default/src
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/289566941/188295561.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/302836026/10000
238 val_238
238 val_238
86 val_86
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union14.q.out Mon Jun 15 05:43:22 2009
@@ -37,61 +37,69 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive5/hive5/build/ql/tmp/446944973/349659273.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/427160604/10002
Union
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
+ Select Operator
+ expressions:
+ expr: _col0
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)
+ keys:
+ expr: _col0
type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
- /data/users/njain/hive5/hive5/build/ql/tmp/446944973/349659273.10003
+ 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
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/427160604/10003
Union
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
+ Select Operator
+ expressions:
+ expr: _col0
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)
+ keys:
+ expr: _col0
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
File Output Operator
compressed: false
@@ -113,18 +121,18 @@
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: 'tst1'
type: string
- expr: UDFToString(0)
+ expr: UDFToString(_col0)
type: string
File Output Operator
compressed: false
@@ -145,7 +153,7 @@
unionsrc group by unionsrc.key
Input: default/src1
Input: default/src
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/410052586/217398417.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/332041097/10000
10
128 1
146 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union15.q.out Mon Jun 15 05:43:22 2009
@@ -32,18 +32,18 @@
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: 'tst1'
type: string
- expr: UDFToString(0)
+ expr: UDFToString(_col0)
type: string
File Output Operator
compressed: false
@@ -56,82 +56,94 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive5/hive5/build/ql/tmp/403607265/202607985.10002
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500235306/10002
Union
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
- type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
- /data/users/njain/hive5/hive5/build/ql/tmp/403607265/202607985.10003
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: _col0
+ type: string
+ 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
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500235306/10003
Union
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
- type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
- /data/users/njain/hive5/hive5/build/ql/tmp/403607265/202607985.10004
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: _col0
+ type: string
+ 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
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/500235306/10004
Union
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
- type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
- type: string
- tag: -1
- value expressions:
- expr: 1
- type: bigint
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: _col0
+ type: string
+ 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
File Output Operator
compressed: false
@@ -188,7 +200,7 @@
select s3.key as key, s3.value as value from src1 s3) unionsrc group by unionsrc.key
Input: default/src
Input: default/src1
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/17726363/27194480.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/439174720/10000
20
128 2
146 2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union16.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union16.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union16.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union16.q.out Mon Jun 15 05:43:22 2009
@@ -48,16 +48,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -66,16 +67,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -84,16 +86,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -102,16 +105,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -120,16 +124,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -138,16 +143,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -156,16 +162,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery2:src-subquery2:src
Select Operator
expressions:
@@ -174,16 +181,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -192,16 +200,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -210,16 +219,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -228,16 +238,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -246,16 +257,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery2:src-subquery1-subquery2:src
Select Operator
expressions:
@@ -264,16 +276,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -282,16 +295,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -300,16 +314,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -318,16 +333,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -336,16 +352,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1:src
Select Operator
expressions:
@@ -354,16 +371,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -372,16 +390,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -390,16 +409,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -408,16 +428,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -426,16 +447,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -444,16 +466,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -462,16 +485,17 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
null-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery2:src
Select Operator
expressions:
@@ -480,24 +504,25 @@
expr: value
type: string
Union
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: 0
- type: bigint
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ 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
@@ -542,5 +567,5 @@
SELECT key, value FROM src UNION ALL
SELECT key, value FROM src) src
Input: default/src
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/378068546/1140440760.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1260154385/10000
12500
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out Mon Jun 15 05:43:22 2009
@@ -39,18 +39,18 @@
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: 'tst1'
type: string
- expr: UDFToString(0)
+ expr: UDFToString(_col0)
type: string
File Output Operator
compressed: false
@@ -63,105 +63,129 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/228745454/662810932.10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/569861702/10004
Union
- Group By Operator
- aggregations:
- expr: count(DISTINCT substr(1, 5))
- keys:
- expr: 0
- type: string
- expr: substr(1, 5)
- type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- expr: 1
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(_col1, 5))
+ keys:
+ expr: _col0
type: string
- sort order: ++
- Map-reduce partition columns:
- expr: 0
+ expr: substr(_col1, 5)
type: string
- tag: -1
- value expressions:
- expr: 2
- type: bigint
- Group By Operator
- aggregations:
- expr: count(DISTINCT substr(1, 5))
- keys:
- expr: 0
- type: string
- expr: 1
+ 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
+ Select Operator
+ expressions:
+ expr: _col0
type: string
- expr: substr(1, 5)
+ expr: _col1
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
- /data/users/njain/hive2/hive2/build/ql/tmp/228745454/662810932.10006
- Union
- Group By Operator
- aggregations:
- expr: count(DISTINCT substr(1, 5))
- keys:
- expr: 0
- type: string
- expr: substr(1, 5)
- type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(_col1, 5))
+ keys:
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- sort order: ++
- Map-reduce partition columns:
- expr: 0
+ expr: substr(_col1, 5)
type: string
- tag: -1
- value expressions:
- expr: 2
- type: bigint
- Group By Operator
- aggregations:
- expr: count(DISTINCT substr(1, 5))
- keys:
- expr: 0
+ 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
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/569861702/10006
+ Union
+ Select Operator
+ expressions:
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: substr(1, 5)
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(_col1, 5))
+ keys:
+ expr: _col0
+ type: string
+ expr: substr(_col1, 5)
+ type: string
+ 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
+ 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
+ expr: _col1
+ type: string
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT substr(_col1, 5))
+ keys:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ expr: substr(_col1, 5)
+ 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
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: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: bigint
File Output Operator
compressed: false
@@ -191,42 +215,42 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive2/hive2/build/ql/tmp/228745454/662810932.10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/569861702/10005
Reduce Output Operator
key expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: string
sort order: +++
Map-reduce partition columns:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
tag: -1
value expressions:
- expr: 3
+ expr: _col3
type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
- expr: count(DISTINCT KEY.2)
+ expr: count(DISTINCT KEY._col2)
keys:
- expr: KEY.0
+ expr: KEY._col0
type: string
- expr: KEY.1
+ expr: KEY._col1
type: string
mode: mergepartial
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 2
+ expr: _col2
type: bigint
File Output Operator
compressed: false
@@ -266,7 +290,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/749088409/416496611.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1363205104/10000
0 1
10 1
100 1
@@ -579,7 +603,7 @@
tst1 0
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: /data/users/njain/hive2/hive2/ql/../build/ql/tmp/1754259258/1425212586.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1413222401/10000
0 val_0 1
10 val_10 1
100 val_100 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union18.q.out Mon Jun 15 05:43:22 2009
@@ -35,18 +35,18 @@
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: 'tst1'
type: string
- expr: UDFToString(0)
+ expr: UDFToString(_col0)
type: string
File Output Operator
compressed: false
@@ -59,13 +59,13 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive5/hive5/build/ql/tmp/85855690/436135691.10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2017071553/10004
Union
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -77,11 +77,11 @@
name: dest1
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -91,13 +91,13 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- /data/users/njain/hive5/hive5/build/ql/tmp/85855690/436135691.10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2017071553/10005
Union
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -109,11 +109,11 @@
name: dest1
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -169,7 +169,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
Input: default/dest1
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/513833791/435534847.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1996050090/10000
0 val_0
0 val_0
0 val_0
@@ -673,7 +673,7 @@
tst1 500
query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
Input: default/dest2
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/220258302/955456541.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2108309784/10000
0 val_0 val_0
0 val_0 val_0
0 val_0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.q.out?rev=784656&r1=784655&r2=784656&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union19.q.out Mon Jun 15 05:43:22 2009
@@ -35,18 +35,18 @@
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: 'tst1'
type: string
- expr: UDFToString(0)
+ expr: UDFToString(_col0)
type: string
File Output Operator
compressed: false
@@ -59,34 +59,40 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/njain/hive5/hive5/build/ql/tmp/72371652/101013737.10004
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1903045669/10004
Union
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
- type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ Group By Operator
+ aggregations:
+ expr: count(_col1)
+ keys:
+ expr: _col0
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
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -96,34 +102,40 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- /data/users/njain/hive5/hive5/build/ql/tmp/72371652/101013737.10005
+ file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1903045669/10005
Union
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
- expr: 0
- type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: 0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: 0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ Group By Operator
+ aggregations:
+ expr: count(_col1)
+ keys:
+ expr: _col0
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
Select Operator
expressions:
- expr: 0
+ expr: _col0
type: string
- expr: 1
+ expr: _col1
type: string
- expr: 1
+ expr: _col1
type: string
File Output Operator
compressed: false
@@ -136,16 +148,16 @@
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
@@ -201,7 +213,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
Input: default/dest1
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/118273074/1158900774.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/680471893/10000
0 3
10 1
100 2
@@ -514,7 +526,7 @@
tst1 1
query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
Input: default/dest2
-Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/159391428/263926633.10000
+Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/974291291/10000
0 val_0 val_0
0 val_0 val_0
0 val_0 val_0