You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by pr...@apache.org on 2009/05/13 05:47:38 UTC
svn commit: r774183 [2/2] - in /hadoop/hive/trunk: ./
cli/src/java/org/apache/hadoop/hive/cli/
ql/src/test/results/clientnegative/ ql/src/test/results/clientpositive/
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=774183&r1=774182&r2=774183&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 Wed May 13 03:47:37 2009
@@ -1,4 +1,6 @@
-query: explain
+query: -- union case: both subqueries are a map-only jobs, same input, followed by filesink
+
+explain
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
ABSTRACT SYNTAX TREE:
@@ -61,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/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1992052322/24152217.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/289566941/188295561.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=774183&r1=774182&r2=774183&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 Wed May 13 03:47:37 2009
@@ -1,4 +1,6 @@
-query: explain
+query: -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink
+
+explain
select unionsrc.key, count(1) FROM (select s2.key as key, s2.value as value from src1 s2
UNION ALL
select 'tst1' as key, cast(count(1) as string) as value from src s1)
@@ -35,7 +37,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/408002969/2251170.10002
+ /data/users/njain/hive5/hive5/build/ql/tmp/446944973/349659273.10002
Union
Group By Operator
aggregations:
@@ -56,7 +58,7 @@
value expressions:
expr: 1
type: bigint
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/408002969/2251170.10003
+ /data/users/njain/hive5/hive5/build/ql/tmp/446944973/349659273.10003
Union
Group By Operator
aggregations:
@@ -143,7 +145,7 @@
unionsrc group by unionsrc.key
Input: default/src1
Input: default/src
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/22399937/103465306.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/410052586/217398417.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=774183&r1=774182&r2=774183&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 Wed May 13 03:47:37 2009
@@ -1,4 +1,6 @@
-query: explain
+query: -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink
+
+explain
select unionsrc.key, count(1) FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
UNION ALL
select s2.key as key, s2.value as value from src1 s2
@@ -54,7 +56,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/1766444/227040434.10002
+ /data/users/njain/hive5/hive5/build/ql/tmp/403607265/202607985.10002
Union
Group By Operator
aggregations:
@@ -75,7 +77,7 @@
value expressions:
expr: 1
type: bigint
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/1766444/227040434.10003
+ /data/users/njain/hive5/hive5/build/ql/tmp/403607265/202607985.10003
Union
Group By Operator
aggregations:
@@ -96,7 +98,7 @@
value expressions:
expr: 1
type: bigint
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/1766444/227040434.10004
+ /data/users/njain/hive5/hive5/build/ql/tmp/403607265/202607985.10004
Union
Group By Operator
aggregations:
@@ -186,7 +188,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/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/587819082/617717160.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/17726363/27194480.10000
20
128 2
146 2
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=774183&r1=774182&r2=774183&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 Wed May 13 03:47:37 2009
@@ -2,7 +2,9 @@
query: drop table DEST2
query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE
query: CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE
-query: explain
+query: -- union case:map-reduce sub-queries followed by multi-table insert
+
+explain
FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
UNION ALL
select s2.key as key, s2.value as value from src s2) unionsrc
@@ -61,7 +63,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/130091110/149823007.10004
+ /data/users/njain/hive5/hive5/build/ql/tmp/594528383/398601416.10004
Union
Group By Operator
aggregations:
@@ -104,7 +106,7 @@
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
name: binary_table
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/130091110/149823007.10006
+ /data/users/njain/hive5/hive5/build/ql/tmp/594528383/398601416.10006
Union
Group By Operator
aggregations:
@@ -189,7 +191,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/130091110/149823007.10005
+ /data/users/njain/hive5/hive5/build/ql/tmp/594528383/398601416.10005
Reduce Output Operator
key expressions:
expr: 0
@@ -264,7 +266,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/415341533/530713652.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/846588920/478082672.10000
0 1
10 1
100 1
@@ -577,7 +579,7 @@
tst1 0
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1221535477/121161713.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/513377833/130813712.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=774183&r1=774182&r2=774183&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 Wed May 13 03:47:37 2009
@@ -2,7 +2,9 @@
query: drop table DEST2
query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE
query: CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE
-query: explain
+query: -- union case:map-reduce sub-queries followed by multi-table insert
+
+explain
FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
UNION ALL
select s2.key as key, s2.value as value from src s2) unionsrc
@@ -57,7 +59,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/926628627/699992620.10004
+ /data/users/njain/hive5/hive5/build/ql/tmp/85855690/436135691.10004
Union
Select Operator
expressions:
@@ -89,7 +91,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/926628627/699992620.10005
+ /data/users/njain/hive5/hive5/build/ql/tmp/85855690/436135691.10005
Union
Select Operator
expressions:
@@ -167,7 +169,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/347590244/841189198.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/513833791/435534847.10000
0 val_0
0 val_0
0 val_0
@@ -671,7 +673,7 @@
tst1 500
query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
Input: default/dest2
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/162660494/315114355.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/220258302/955456541.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=774183&r1=774182&r2=774183&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 Wed May 13 03:47:37 2009
@@ -2,7 +2,9 @@
query: drop table DEST2
query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE
query: CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE
-query: explain
+query: -- union case:map-reduce sub-queries followed by multi-table insert
+
+explain
FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
UNION ALL
select s2.key as key, s2.value as value from src s2) unionsrc
@@ -57,7 +59,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/254461326/1118368198.10004
+ /data/users/njain/hive5/hive5/build/ql/tmp/72371652/101013737.10004
Union
Group By Operator
aggregations:
@@ -94,7 +96,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/254461326/1118368198.10005
+ /data/users/njain/hive5/hive5/build/ql/tmp/72371652/101013737.10005
Union
Group By Operator
aggregations:
@@ -199,7 +201,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
Input: default/dest1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/467532129/948299768.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/118273074/1158900774.10000
0 3
10 1
100 2
@@ -512,7 +514,7 @@
tst1 1
query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
Input: default/dest2
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/168132316/261490647.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/159391428/263926633.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/union2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union2.q.out?rev=774183&r1=774182&r2=774183&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union2.q.out Wed May 13 03:47:37 2009
@@ -1,4 +1,6 @@
-query: explain
+query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
+
+explain
select count(1) 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
ABSTRACT SYNTAX TREE:
@@ -72,5 +74,5 @@
query: select count(1) 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/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/403137725/387325757.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/3487986/87097312.10000
1000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out?rev=774183&r1=774182&r2=774183&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out Wed May 13 03:47:37 2009
@@ -1,4 +1,6 @@
-query: explain
+query: -- union :map-reduce sub-queries followed by join
+
+explain
SELECT unionsrc1.key, unionsrc1.value, unionsrc2.key, unionsrc2.value
FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
UNION ALL
@@ -62,7 +64,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/172458251/1663645008.10002
+ /data/users/njain/hive5/hive5/build/ql/tmp/1191284995/1420085103.10002
Union
Reduce Output Operator
key expressions:
@@ -78,7 +80,7 @@
type: string
expr: 1
type: string
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/172458251/1663645008.10003
+ /data/users/njain/hive5/hive5/build/ql/tmp/1191284995/1420085103.10003
Union
Reduce Output Operator
key expressions:
@@ -180,7 +182,7 @@
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/172458251/1663645008.10004
+ /data/users/njain/hive5/hive5/build/ql/tmp/1191284995/1420085103.10004
Union
File Output Operator
compressed: false
@@ -189,7 +191,7 @@
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
name: binary_table
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/172458251/1663645008.10006
+ /data/users/njain/hive5/hive5/build/ql/tmp/1191284995/1420085103.10006
Union
File Output Operator
compressed: false
@@ -248,7 +250,7 @@
select s4.key as key, s4.value as value from src s4 where s4.key < 10) unionsrc2
ON (unionsrc1.key = unionsrc2.key)
Input: default/src
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1381661483/387712250.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/25295607/330570384.10000
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out?rev=774183&r1=774182&r2=774183&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out Wed May 13 03:47:37 2009
@@ -1,4 +1,6 @@
-query: drop table tmptable
+query: -- union case: both subqueries are map-reduce jobs on same input, followed by filesink
+
+drop table tmptable
query: create table tmptable(key string, value int)
query: explain
insert overwrite table tmptable
@@ -54,7 +56,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/371236334/463237113.10002
+ /data/users/njain/hive5/hive5/build/ql/tmp/895788847/820785077.10002
Union
Select Operator
expressions:
@@ -76,7 +78,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/371236334/463237113.10003
+ /data/users/njain/hive5/hive5/build/ql/tmp/895788847/820785077.10003
Union
Select Operator
expressions:
@@ -152,7 +154,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key
Input: default/tmptable
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/100441451/111422539.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/343973554/1495273603.10000
tst1 500
tst2 500
query: drop table tmptable
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out?rev=774183&r1=774182&r2=774183&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out Wed May 13 03:47:37 2009
@@ -1,4 +1,6 @@
-query: explain
+query: -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink
+
+explain
select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src s1
UNION ALL
select 'tst2' as key, count(1) as value from src s2) unionsrc group by unionsrc.key
@@ -50,7 +52,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/1649113926/399998151.10002
+ /data/users/njain/hive5/hive5/build/ql/tmp/446100647/396265268.10002
Union
Group By Operator
aggregations:
@@ -71,7 +73,7 @@
value expressions:
expr: 1
type: bigint
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/1649113926/399998151.10003
+ /data/users/njain/hive5/hive5/build/ql/tmp/446100647/396265268.10003
Union
Group By Operator
aggregations:
@@ -156,6 +158,6 @@
UNION ALL
select 'tst2' as key, count(1) as value from src s2) unionsrc group by unionsrc.key
Input: default/src
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1203907479/249233034.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/140939267/753633250.10000
tst1 1
tst2 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union6.q.out?rev=774183&r1=774182&r2=774183&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union6.q.out Wed May 13 03:47:37 2009
@@ -1,4 +1,6 @@
-query: drop table tmptable
+query: -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by filesink
+
+drop table tmptable
query: create table tmptable(key string, value string)
query: explain
insert overwrite table tmptable
@@ -54,7 +56,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/521174997/29191949.10002
+ /data/users/njain/hive5/hive5/build/ql/tmp/1396512145/100703742.10002
Union
Select Operator
expressions:
@@ -70,7 +72,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/521174997/29191949.10003
+ /data/users/njain/hive5/hive5/build/ql/tmp/1396512145/100703742.10003
Union
Select Operator
expressions:
@@ -125,7 +127,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key
Input: default/tmptable
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1147707423/406168765.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/569550431/1373104.10000
val_193
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union7.q.out?rev=774183&r1=774182&r2=774183&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union7.q.out Wed May 13 03:47:37 2009
@@ -1,4 +1,6 @@
-query: explain
+query: -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink
+
+explain
select unionsrc.key, count(1) FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
UNION ALL
select s2.key as key, s2.value as value from src1 s2) unionsrc group by unionsrc.key
@@ -50,7 +52,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/255905982/946698378.10002
+ /data/users/njain/hive5/hive5/build/ql/tmp/92765504/90887772.10002
Union
Group By Operator
aggregations:
@@ -71,7 +73,7 @@
value expressions:
expr: 1
type: bigint
- /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/255905982/946698378.10003
+ /data/users/njain/hive5/hive5/build/ql/tmp/92765504/90887772.10003
Union
Group By Operator
aggregations:
@@ -141,7 +143,7 @@
select s2.key as key, s2.value as value from src1 s2) unionsrc group by unionsrc.key
Input: default/src
Input: default/src1
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/584323767/101489285.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/37845718/185211382.10000
10
128 1
146 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union8.q.out?rev=774183&r1=774182&r2=774183&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union8.q.out Wed May 13 03:47:37 2009
@@ -1,4 +1,6 @@
-query: explain
+query: -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by filesink
+
+explain
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 UNION ALL
select s3.key as key, s3.value as value from src s3) unionsrc
@@ -83,7 +85,7 @@
select s2.key as key, s2.value as value from src s2 UNION ALL
select s3.key as key, s3.value as value from src s3) unionsrc
Input: default/src
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/158356330/11376793.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/245637407/70399042.10000
238 val_238
238 val_238
238 val_238
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union9.q.out?rev=774183&r1=774182&r2=774183&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union9.q.out Wed May 13 03:47:37 2009
@@ -1,4 +1,6 @@
-query: explain
+query: -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by reducesink
+
+explain
select count(1) 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 UNION ALL
select s3.key as key, s3.value as value from src s3) unionsrc
@@ -92,5 +94,5 @@
select s2.key as key, s2.value as value from src s2 UNION ALL
select s3.key as key, s3.value as value from src s3) unionsrc
Input: default/src
-Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/371390513/112754866.10000
+Output: /data/users/njain/hive5/hive5/ql/../build/ql/tmp/280070880/627311455.10000
1500