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/08/11 04:06:32 UTC
svn commit: r802976 [11/17] - 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/lib/
ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_repeat.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_repeat.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_repeat.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_repeat.q.out Tue Aug 11 02:06:23 2009
@@ -16,6 +16,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: repeat('Facebook', 3)
@@ -47,5 +49,5 @@
repeat("asdf", -1)
FROM src LIMIT 1
Input: default/src
-Output: file:/data/users/njain/hive_commit1/hive_commit1/.ptest_1/build/ql/tmp/1216905646/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1342490934/10000
FacebookFacebookFacebook
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_reverse.q.out Tue Aug 11 02:06:23 2009
@@ -13,6 +13,8 @@
Map Reduce
Alias -> Map Operator Tree:
src1
+ TableScan
+ alias: src1
Select Operator
expressions:
expr: reverse(value)
@@ -33,10 +35,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1099092133/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2139233776/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1419805399/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1684174409/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -73,7 +75,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2026875465/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/38069188/10000
832_lav
113_lav
@@ -107,6 +109,6 @@
query: LOAD DATA LOCAL INPATH '../data/files/kv4.txt' INTO TABLE dest1
query: SELECT count(1) FROM dest1 WHERE reverse(dest1.name) = _UTF-8 0xE993AEE982B5
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1752039615/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/484118/10000
1
query: DROP TABLE dest1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_size.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_size.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_size.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_size.q.out Tue Aug 11 02:06:23 2009
@@ -18,6 +18,8 @@
Map Reduce
Alias -> Map Operator Tree:
src_thrift
+ TableScan
+ alias: src_thrift
Filter Operator
predicate:
expr: (lint is not null and not mstringstring is null)
@@ -58,5 +60,5 @@
WHERE src_thrift.lint IS NOT NULL
AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1
Input: default/src_thrift
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/8998980/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/151376732/10000
3 1 1 -1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_space.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_space.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_space.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_space.q.out Tue Aug 11 02:06:23 2009
@@ -17,6 +17,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: space(10)
@@ -51,7 +53,7 @@
length(space(-100))
FROM src LIMIT 1
Input: default/src
-Output: file:/data/users/njain/hive_commit1/hive_commit1/.ptest_0/build/ql/tmp/1380484174/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1933263714/10000
10 0 1 0 0
query: SELECT
space(10),
@@ -61,5 +63,5 @@
space(-100)
FROM src LIMIT 1
Input: default/src
-Output: file:/data/users/njain/hive_commit1/hive_commit1/.ptest_0/build/ql/tmp/2091099009/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1506040110/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_split.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_split.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_split.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_split.q.out Tue Aug 11 02:06:23 2009
@@ -16,6 +16,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: split('a b c', ' ')
@@ -47,5 +49,5 @@
split(50401020, 0)
FROM src LIMIT 1
Input: default/src
-Output: file:/data/users/njain/hive_commit1/hive_commit1/.ptest_1/build/ql/tmp/136874203/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2093678093/10000
["a","b","c"] ["one","two","three"] [] ["5","4","1","2"]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_when.q.out Tue Aug 11 02:06:23 2009
@@ -37,6 +37,8 @@
Map Reduce
Alias -> Map Operator Tree:
src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: CASE WHEN ((1 = 1)) THEN (2) WHEN ((1 = 3)) THEN (4) ELSE (5) END
@@ -92,5 +94,5 @@
END
FROM src LIMIT 1
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/2013202159/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/93135016/10000
2 9 14 NULL 24 NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union.q.out Tue Aug 11 02:06:23 2009
@@ -20,6 +20,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unioninput-subquery1:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(100))
@@ -50,6 +52,8 @@
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
null-subquery2:unioninput-subquery2:src
+ TableScan
+ alias: src
Filter Operator
predicate:
expr: (UDFToDouble(key) > UDFToDouble(100))
@@ -86,10 +90,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/516261269/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1350073844/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/namit-trunk-apache-hive/.ptest_1/build/ql/tmp/1480105708/10001
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1473634574/10001
Reduce Output Operator
sort order:
Map-reduce partition columns:
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -31,6 +31,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery1:unionsrc-subquery1-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -66,7 +68,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1622224278/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1115593242/10002
Union
Select Operator
expressions:
@@ -90,7 +92,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1622224278/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1115593242/10004
Union
Select Operator
expressions:
@@ -114,7 +116,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1622224278/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1115593242/10005
Union
Select Operator
expressions:
@@ -145,10 +147,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1160998678/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1365326225/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1622224278/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1115593242/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -185,6 +187,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery2:unionsrc-subquery1-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
Group By Operator
aggregations:
@@ -221,6 +225,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s3
+ TableScan
+ alias: s3
Select Operator
Group By Operator
aggregations:
@@ -264,7 +270,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key
Input: default/tmptable
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1108373371/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/994551833/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -23,6 +23,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery1:unionsrc-subquery1-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -58,7 +60,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/399328241/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/204278214/10002
Union
Select Operator
expressions:
@@ -85,7 +87,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/399328241/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/204278214/10003
Union
Select Operator
expressions:
@@ -112,7 +114,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/399328241/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/204278214/10004
Union
Select Operator
expressions:
@@ -166,6 +168,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery2:unionsrc-subquery1-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
Group By Operator
aggregations:
@@ -202,6 +206,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s3
+ TableScan
+ alias: s3
Select Operator
Group By Operator
aggregations:
@@ -245,7 +251,7 @@
UNION ALL
select 'tst3' as key, count(1) as value from src s3) unionsrc group by unionsrc.key
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1673535068/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/225927230/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -31,6 +31,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery1:unionsrc-subquery1-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -66,7 +68,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/183213768/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/317852044/10002
Union
Select Operator
expressions:
@@ -90,7 +92,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/183213768/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/317852044/10004
Union
Select Operator
expressions:
@@ -114,7 +116,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/183213768/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/317852044/10005
Union
Select Operator
expressions:
@@ -145,10 +147,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/987914812/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/847490196/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/183213768/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/317852044/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -185,6 +187,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery2:unionsrc-subquery1-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
Group By Operator
aggregations:
@@ -221,6 +225,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s3
+ TableScan
+ alias: s3
Select Operator
Group By Operator
aggregations:
@@ -266,7 +272,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key
Input: default/tmptable
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/93419450/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/983094247/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
expressions:
expr: key
@@ -37,6 +39,8 @@
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
null-subquery2:unionsrc-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
expressions:
expr: key
@@ -67,7 +71,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: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/362764706/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/49034053/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -20,6 +20,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc-subquery1:s2
+ TableScan
+ alias: s2
Select Operator
expressions:
expr: key
@@ -37,7 +39,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/142260489/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1650267347/10002
Union
Select Operator
expressions:
@@ -64,7 +66,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/142260489/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1650267347/10003
Union
Select Operator
expressions:
@@ -118,6 +120,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -161,7 +165,7 @@
unionsrc group by unionsrc.key
Input: default/src1
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/239114324/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/368749311/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -23,6 +23,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery1:unionsrc-subquery1-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -58,7 +60,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1035950223/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2063466051/10002
Union
Select Operator
expressions:
@@ -85,7 +87,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1035950223/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2063466051/10003
Union
Select Operator
expressions:
@@ -112,7 +114,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1035950223/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2063466051/10004
Union
Select Operator
expressions:
@@ -166,6 +168,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery2:unionsrc-subquery1-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
expressions:
expr: key
@@ -184,6 +188,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s3
+ TableScan
+ alias: s3
Select Operator
expressions:
expr: key
@@ -210,7 +216,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: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/878593490/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1243316410/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -41,6 +41,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-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-subquery2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -62,6 +64,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -83,6 +87,8 @@
expr: _col0
type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -104,6 +110,8 @@
expr: _col0
type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -125,6 +133,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -146,6 +156,8 @@
expr: _col0
type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -167,6 +179,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -188,6 +202,8 @@
expr: _col0
type: bigint
null-subquery2:src-subquery2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -209,6 +225,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -230,6 +248,8 @@
expr: _col0
type: bigint
null-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery1-subquery1-subquery2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -251,6 +271,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -272,6 +294,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -293,6 +317,8 @@
expr: _col0
type: bigint
null-subquery1-subquery2:src-subquery1-subquery2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -314,6 +340,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -335,6 +363,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -356,6 +386,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -377,6 +409,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -398,6 +432,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -419,6 +455,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -440,6 +478,8 @@
expr: _col0
type: bigint
null-subquery1-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery1-subquery2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -461,6 +501,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -482,6 +524,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -503,6 +547,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -524,6 +570,8 @@
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
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -545,6 +593,8 @@
expr: _col0
type: bigint
null-subquery1-subquery1-subquery2:src-subquery1-subquery1-subquery2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -619,5 +669,5 @@
SELECT key, value FROM src UNION ALL
SELECT key, value FROM src) src
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/957620610/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1669450040/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -32,6 +32,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -67,7 +69,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1951605934/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1501890791/10004
Union
Reduce Output Operator
key expressions:
@@ -83,7 +85,7 @@
type: string
expr: _col1
type: string
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1951605934/10007
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1501890791/10007
Union
Reduce Output Operator
key expressions:
@@ -135,7 +137,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1951605934/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1501890791/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -186,7 +188,7 @@
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1951605934/10006
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1501890791/10006
Reduce Output Operator
key expressions:
expr: _col0
@@ -246,6 +248,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
expressions:
expr: key
@@ -271,7 +275,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1791774870/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/618311700/10000
0 1
10 1
100 1
@@ -584,7 +588,7 @@
tst1 1
query: SELECT DEST2.* FROM DEST2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1398773542/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/390182720/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -32,6 +32,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -67,7 +69,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1650219158/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/970285192/10004
Union
Select Operator
expressions:
@@ -101,7 +103,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1650219158/10007
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/970285192/10007
Union
Select Operator
expressions:
@@ -142,10 +144,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1809064941/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1625764510/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1650219158/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/970285192/10005
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -184,10 +186,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1809064941/10002
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1625764510/10002
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1650219158/10006
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/970285192/10006
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -226,6 +228,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
expressions:
expr: key
@@ -251,7 +255,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/83349738/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1040816000/10000
0 val_0
0 val_0
0 val_0
@@ -755,7 +759,7 @@
tst1 500
query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/225770887/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/491493524/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -28,6 +28,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -63,7 +65,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/626825337/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2105547105/10004
Union
Select Operator
expressions:
@@ -109,7 +111,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/626825337/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2105547105/10005
Union
Select Operator
expressions:
@@ -204,6 +206,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
expressions:
expr: key
@@ -229,7 +233,7 @@
Output: default/dest2
query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
Input: default/dest1
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/190751491/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/78068858/10000
0 3
10 1
100 2
@@ -542,7 +546,7 @@
tst1 1
query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
Input: default/dest2
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1215563636/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/240933418/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -15,6 +15,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
expressions:
expr: key
@@ -36,6 +38,8 @@
expr: _col0
type: bigint
null-subquery2:unionsrc-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
expressions:
expr: key
@@ -82,5 +86,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: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/2117179272/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1378537428/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -31,6 +31,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc2-subquery1:s3
+ TableScan
+ alias: s3
Select Operator
Group By Operator
aggregations:
@@ -66,7 +68,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1080405211/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2007188536/10002
Union
Reduce Output Operator
key expressions:
@@ -82,7 +84,7 @@
type: string
expr: _col1
type: string
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1080405211/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2007188536/10003
Union
Reduce Output Operator
key expressions:
@@ -143,6 +145,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc2-subquery2:s4
+ TableScan
+ alias: s4
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(10))
@@ -169,6 +173,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc1-subquery2:s2
+ TableScan
+ alias: s2
Filter Operator
predicate:
expr: (UDFToDouble(key) < UDFToDouble(10))
@@ -194,7 +200,7 @@
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1080405211/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2007188536/10004
Union
File Output Operator
compressed: false
@@ -202,7 +208,7 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1080405211/10006
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/2007188536/10006
Union
File Output Operator
compressed: false
@@ -215,6 +221,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc1-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -262,7 +270,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: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1630032215/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1517739489/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/union21.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union21.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union21.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union21.q.out Tue Aug 11 02:06:23 2009
@@ -26,6 +26,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery2:union_output-subquery1-subquery2:src_thrift
+ TableScan
+ alias: src_thrift
Select Operator
expressions:
expr: astring
@@ -58,6 +60,8 @@
expr: _col1
type: bigint
null-subquery1-subquery1-subquery2:union_output-subquery1-subquery1-subquery2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -90,6 +94,8 @@
expr: _col1
type: bigint
null-subquery1-subquery1-subquery1-subquery1:union_output-subquery1-subquery1-subquery1-subquery1:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: '1'
@@ -122,6 +128,8 @@
expr: _col1
type: bigint
null-subquery2:union_output-subquery2:src_thrift
+ TableScan
+ alias: src_thrift
Select Operator
expressions:
expr: lstring[0]
@@ -154,6 +162,8 @@
expr: _col1
type: bigint
null-subquery1-subquery1-subquery1-subquery2:union_output-subquery1-subquery1-subquery1-subquery2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: reverse(key)
@@ -228,7 +238,7 @@
GROUP BY key
Input: default/src_thrift
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/239888968/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1135321195/10000
NULL 2
0 7
001 2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out?rev=802976&r1=802975&r2=802976&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out Tue Aug 11 02:06:23 2009
@@ -36,6 +36,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:a-subquery2:s2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -70,7 +72,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1900161365/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/831850354/10002
Union
Select Operator
expressions:
@@ -83,7 +85,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1900161365/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/831850354/10003
Union
Select Operator
expressions:
@@ -96,7 +98,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1900161365/10005
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/831850354/10005
Union
Select Operator
expressions:
@@ -109,7 +111,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1900161365/10007
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/831850354/10007
Union
Select Operator
expressions:
@@ -127,6 +129,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery2:a-subquery1-subquery2:s2:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -162,6 +166,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery1-subquery1:a-subquery1-subquery1-subquery1:s1:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -196,7 +202,7 @@
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1900161365/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/831850354/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -222,6 +228,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery1-subquery2:a-subquery1-subquery1-subquery2:s1:src
+ TableScan
+ alias: src
Select Operator
expressions:
expr: key
@@ -256,7 +264,7 @@
Stage: Stage-7
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1900161365/10006
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/831850354/10006
Reduce Output Operator
key expressions:
expr: _col0
@@ -306,7 +314,7 @@
Output: default/union_out
query: select * from union_out cluster by id
Input: default/union_out
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/838109701/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/209669057/10000
1
2
3
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -25,6 +25,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -60,7 +62,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1477953430/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/793944135/10002
Union
Select Operator
expressions:
@@ -84,7 +86,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1477953430/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/793944135/10004
Union
Select Operator
expressions:
@@ -115,10 +117,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/581712304/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1820922097/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1477953430/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/793944135/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -155,6 +157,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
Group By Operator
aggregations:
@@ -196,7 +200,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key
Input: default/tmptable
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1149934925/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1401758833/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -54,7 +56,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1466934742/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/418741638/10002
Union
Select Operator
expressions:
@@ -81,7 +83,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1466934742/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/418741638/10003
Union
Select Operator
expressions:
@@ -135,6 +137,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
Group By Operator
aggregations:
@@ -176,6 +180,6 @@
UNION ALL
select 'tst2' as key, count(1) as value from src s2) unionsrc group by unionsrc.key
Input: default/src
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/1264889595/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1640354803/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -25,6 +25,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -60,7 +62,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1186530/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1191770303/10002
Union
Select Operator
expressions:
@@ -77,7 +79,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1186530/10004
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1191770303/10004
Union
Select Operator
expressions:
@@ -101,10 +103,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/764399533/10000
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1310004866/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1186530/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1191770303/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -141,6 +143,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
expressions:
expr: key
@@ -165,7 +169,7 @@
Output: default/tmptable
query: select * from tmptable x sort by x.key, x.value
Input: default/tmptable
-Output: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/730383736/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/551301266/10000
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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -19,6 +19,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1:unionsrc-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
Group By Operator
aggregations:
@@ -54,7 +56,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1149196999/10002
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1947982246/10002
Union
Select Operator
expressions:
@@ -81,7 +83,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/1149196999/10003
+ file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1947982246/10003
Union
Select Operator
expressions:
@@ -135,6 +137,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery2:unionsrc-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
expressions:
expr: key
@@ -159,7 +163,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: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_0/build/ql/tmp/252887954/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/160103856/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -16,6 +16,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery1:unionsrc-subquery1-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
expressions:
expr: key
@@ -38,6 +40,8 @@
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
null-subquery1-subquery2:unionsrc-subquery1-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
expressions:
expr: key
@@ -60,6 +64,8 @@
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
null-subquery2:unionsrc-subquery2:s3
+ TableScan
+ alias: s3
Select Operator
expressions:
expr: key
@@ -91,7 +97,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: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_1/build/ql/tmp/397719358/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/291748192/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=802976&r1=802975&r2=802976&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 Tue Aug 11 02:06:23 2009
@@ -16,6 +16,8 @@
Map Reduce
Alias -> Map Operator Tree:
null-subquery1-subquery1:unionsrc-subquery1-subquery1:s1
+ TableScan
+ alias: s1
Select Operator
expressions:
expr: key
@@ -37,6 +39,8 @@
expr: _col0
type: bigint
null-subquery1-subquery2:unionsrc-subquery1-subquery2:s2
+ TableScan
+ alias: s2
Select Operator
expressions:
expr: key
@@ -58,6 +62,8 @@
expr: _col0
type: bigint
null-subquery2:unionsrc-subquery2:s3
+ TableScan
+ alias: s3
Select Operator
expressions:
expr: key
@@ -105,5 +111,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: file:/data/users/zshao/tools/670-trunk-apache-hive/.ptest_2/build/ql/tmp/1822308102/10000
+Output: file:/data/users/athusoo/commits/hive_trunk_ws1/build/ql/tmp/1539323963/10000
1500