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/12/04 05:39:52 UTC
svn commit: r887057 [5/6] - in /hadoop/hive/trunk: ./
common/src/java/org/apache/hadoop/hive/conf/ conf/
contrib/src/test/results/clientpositive/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/metadata/ ql/src/java/or...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/subq2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/subq2.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/subq2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/subq2.q.out Fri Dec 4 04:39:37 2009
@@ -34,6 +34,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: key
type: string
@@ -55,6 +56,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -95,13 +97,13 @@
WHERE a.k >= 90
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/632677146/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/944603484/10000
POSTHOOK: query: SELECT a.k, a.c
FROM (SELECT b.key as k, count(1) as c FROM src b GROUP BY b.key) a
WHERE a.k >= 90
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/632677146/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/944603484/10000
100 2
103 2
104 2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_number_format.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_number_format.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_number_format.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udaf_number_format.q.out Fri Dec 4 04:39:37 2009
@@ -33,6 +33,7 @@
expr: avg('a')
expr: variance('a')
expr: std('a')
+ bucketGroup: false
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3
Reduce Output Operator
@@ -54,6 +55,7 @@
expr: avg(VALUE._col1)
expr: variance(VALUE._col2)
expr: std(VALUE._col3)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3
Select Operator
@@ -87,7 +89,7 @@
FROM src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/865310068/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/735631475/10000
POSTHOOK: query: SELECT
sum('a'),
avg('a'),
@@ -96,5 +98,5 @@
FROM src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/865310068/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/735631475/10000
0.0 NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf3.q.out Fri Dec 4 04:39:37 2009
@@ -33,6 +33,7 @@
expr: avg(UDFToInteger(''))
expr: min(UDFToInteger(''))
expr: max(UDFToInteger(''))
+ bucketGroup: false
mode: hash
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Reduce Output Operator
@@ -57,6 +58,7 @@
expr: avg(VALUE._col2)
expr: min(VALUE._col3)
expr: max(VALUE._col4)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0, _col1, _col2, _col3, _col4
Select Operator
@@ -105,9 +107,9 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/730515619/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/675266909/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/730515619/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/675266909/10000
0 NULL NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf8.q.out Fri Dec 4 04:39:37 2009
@@ -49,6 +49,7 @@
expr: avg(c1)
expr: sum(c1)
expr: count(c1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0, _col1, _col2
Reduce Output Operator
@@ -67,6 +68,7 @@
expr: avg(VALUE._col0)
expr: sum(VALUE._col1)
expr: count(VALUE._col2)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0, _col1, _col2
Select Operator
@@ -93,9 +95,9 @@
PREHOOK: query: SELECT avg(c1), sum(c1), count(c1) FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/265711441/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1261922644/10000
POSTHOOK: query: SELECT avg(c1), sum(c1), count(c1) FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/265711441/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1261922644/10000
1.0 1.0 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out?rev=887057&r1=887056&r2=887057&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udtf_explode.q.out Fri Dec 4 04:39:37 2009
@@ -28,7 +28,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/1030905471/10001
+ directory: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2089365960/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -38,9 +38,9 @@
columns.types int
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive_commit1/hive_commit1/build/ql/test/data/warehouse/src [src]
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src [src]
Path -> Partition:
- file:/data/users/njain/hive_commit1/hive_commit1/build/ql/test/data/warehouse/src
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -54,7 +54,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive_commit1/hive_commit1/build/ql/test/data/warehouse/src
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -69,8 +69,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive_commit1/hive_commit1/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1258608973
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
+ transient_lastDdlTime 1258713613
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -116,9 +116,9 @@
type: int
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive_commit1/hive_commit1/build/ql/test/data/warehouse/src [a:src]
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src [a:src]
Path -> Partition:
- file:/data/users/njain/hive_commit1/hive_commit1/build/ql/test/data/warehouse/src
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -132,7 +132,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive_commit1/hive_commit1/build/ql/test/data/warehouse/src
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -147,8 +147,8 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive_commit1/hive_commit1/build/ql/test/data/warehouse/src
- transient_lastDdlTime 1258608973
+ location file:/data/users/heyongqiang/hive-trunk-commit/build/ql/test/data/warehouse/src
+ transient_lastDdlTime 1258713613
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -163,6 +163,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: int
@@ -171,7 +172,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/38030994/10002
+ directory: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1309593257/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -183,7 +184,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/38030994/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1309593257/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -198,9 +199,9 @@
type: bigint
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/38030994/10002 [file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/38030994/10002]
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1309593257/10002 [file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1309593257/10002]
Path -> Partition:
- file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/38030994/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1309593257/10002
Partition
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -219,6 +220,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: int
@@ -234,7 +236,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/38030994/10001
+ directory: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1309593257/10001
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -251,22 +253,22 @@
PREHOOK: query: SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/1652852305/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/99085211/10000
POSTHOOK: query: SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/1652852305/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/99085211/10000
1
2
3
PREHOOK: query: SELECT myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY myCol
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/734444296/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1717351634/10000
POSTHOOK: query: SELECT myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY myCol
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive_commit1/hive_commit1/build/ql/tmp/734444296/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1717351634/10000
1 1
2 1
3 1
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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -55,6 +55,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -67,6 +68,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -86,7 +88,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1143376812/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1780852426/10002
Union
Select Operator
expressions:
@@ -110,7 +112,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1143376812/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1780852426/10004
Union
Select Operator
expressions:
@@ -134,7 +136,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1143376812/10005
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1780852426/10005
Union
Select Operator
expressions:
@@ -165,10 +167,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/21983870/10000
+ destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/478382549/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1143376812/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1780852426/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -211,6 +213,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -223,6 +226,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -249,6 +253,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -261,6 +266,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -299,11 +305,11 @@
PREHOOK: query: select * from tmptable x sort by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@tmptable
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1366944384/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/330519049/10000
POSTHOOK: query: select * from tmptable x sort by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmptable
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1366944384/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/330519049/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -39,6 +39,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -51,6 +52,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -70,7 +72,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/184424474/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1278683815/10002
Union
Select Operator
expressions:
@@ -80,6 +82,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -97,7 +100,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/njain/hive5/hive5/build/ql/tmp/184424474/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1278683815/10003
Union
Select Operator
expressions:
@@ -107,6 +110,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -124,7 +128,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/njain/hive5/hive5/build/ql/tmp/184424474/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1278683815/10004
Union
Select Operator
expressions:
@@ -134,6 +138,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -155,6 +160,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -184,6 +190,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -196,6 +203,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -222,6 +230,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -234,6 +243,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -262,7 +272,7 @@
select 'tst3' as key, count(1) as value from src s3) unionsrc group by unionsrc.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/506166067/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1457775723/10000
POSTHOOK: query: 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
@@ -270,7 +280,7 @@
select 'tst3' as key, count(1) as value from src s3) unionsrc group by unionsrc.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/506166067/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1457775723/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -55,6 +55,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -67,6 +68,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -86,7 +88,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/810798431/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2093381659/10002
Union
Select Operator
expressions:
@@ -110,7 +112,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/njain/hive5/hive5/build/ql/tmp/810798431/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2093381659/10004
Union
Select Operator
expressions:
@@ -134,7 +136,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/njain/hive5/hive5/build/ql/tmp/810798431/10005
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2093381659/10005
Union
Select Operator
expressions:
@@ -165,10 +167,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/246166891/10000
+ destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1932347815/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/810798431/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2093381659/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -211,6 +213,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -223,6 +226,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -249,6 +253,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -261,6 +266,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -303,11 +309,11 @@
PREHOOK: query: select * from tmptable x sort by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@tmptable
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1490799066/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1239089597/10000
POSTHOOK: query: select * from tmptable x sort by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmptable
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1490799066/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1239089597/10000
tst1 500
tst2 25
tst3 1000
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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -48,7 +48,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/29089879/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1040645790/10002
Union
Select Operator
expressions:
@@ -58,6 +58,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -75,7 +76,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/njain/hive5/hive5/build/ql/tmp/29089879/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1040645790/10003
Union
Select Operator
expressions:
@@ -85,6 +86,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -106,6 +108,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -135,6 +138,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -147,6 +151,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -175,7 +180,7 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1661700727/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1877970971/10000
POSTHOOK: query: 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)
@@ -183,7 +188,7 @@
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1661700727/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1877970971/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -39,6 +39,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -51,6 +52,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -70,7 +72,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/318495577/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/709538809/10002
Union
Select Operator
expressions:
@@ -80,6 +82,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -97,7 +100,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/njain/hive5/hive5/build/ql/tmp/318495577/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/709538809/10003
Union
Select Operator
expressions:
@@ -107,6 +110,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -124,7 +128,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/njain/hive5/hive5/build/ql/tmp/318495577/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/709538809/10004
Union
Select Operator
expressions:
@@ -134,6 +138,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -155,6 +160,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -227,7 +233,7 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@src1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/189882705/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1306651084/10000
POSTHOOK: query: 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
@@ -236,7 +242,7 @@
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/189882705/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1306651084/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -88,6 +88,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -111,6 +112,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -134,6 +136,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -157,6 +160,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -180,6 +184,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -203,6 +208,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -226,6 +232,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -249,6 +256,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -272,6 +280,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -295,6 +304,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -318,6 +328,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -341,6 +352,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -364,6 +376,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -387,6 +400,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -410,6 +424,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -433,6 +448,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -456,6 +472,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -479,6 +496,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -502,6 +520,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -525,6 +544,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -548,6 +568,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -571,6 +592,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -594,6 +616,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -617,6 +640,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -640,6 +664,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -652,6 +677,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -703,7 +729,7 @@
SELECT key, value FROM src) src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/548590330/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2070296923/10000
POSTHOOK: query: SELECT count(1) FROM (
SELECT key, value FROM src UNION ALL
SELECT key, value FROM src UNION ALL
@@ -736,5 +762,5 @@
SELECT key, value FROM src) src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/548590330/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2070296923/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -62,6 +62,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -74,6 +75,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -93,7 +95,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1630067253/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176659022/10004
Union
Reduce Output Operator
key expressions:
@@ -109,7 +111,7 @@
type: string
expr: _col1
type: string
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1630067253/10007
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176659022/10007
Union
Reduce Output Operator
key expressions:
@@ -130,6 +132,7 @@
Group By Operator
aggregations:
expr: count(DISTINCT KEY._col0)
+ bucketGroup: false
keys:
expr: VALUE._col0
type: string
@@ -144,6 +147,7 @@
Group By Operator
aggregations:
expr: count(DISTINCT KEY._col0)
+ bucketGroup: false
keys:
expr: VALUE._col0
type: string
@@ -161,7 +165,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1630067253/10005
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176659022/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -178,6 +182,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -212,7 +217,7 @@
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1630067253/10006
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176659022/10006
Reduce Output Operator
key expressions:
expr: _col0
@@ -233,6 +238,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -310,11 +316,11 @@
PREHOOK: query: SELECT DEST1.* FROM DEST1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/432241904/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/601320238/10000
POSTHOOK: query: SELECT DEST1.* FROM DEST1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/432241904/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/601320238/10000
0 1
10 1
100 1
@@ -628,11 +634,11 @@
PREHOOK: query: SELECT DEST2.* FROM DEST2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest2
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/598498403/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/53402192/10000
POSTHOOK: query: SELECT DEST2.* FROM DEST2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest2
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/598498403/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/53402192/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -62,6 +62,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -74,6 +75,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -93,7 +95,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1966021387/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/786428612/10004
Union
Select Operator
expressions:
@@ -127,7 +129,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1966021387/10007
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/786428612/10007
Union
Select Operator
expressions:
@@ -168,10 +170,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/1165077920/10000
+ destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1687435685/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1966021387/10005
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/786428612/10005
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -210,10 +212,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/1165077920/10002
+ destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1687435685/10002
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1966021387/10006
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/786428612/10006
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -290,11 +292,11 @@
PREHOOK: query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/896837060/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1777998074/10000
POSTHOOK: query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/896837060/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1777998074/10000
0 val_0
0 val_0
0 val_0
@@ -799,11 +801,11 @@
PREHOOK: query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest2
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1341838197/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/329932535/10000
POSTHOOK: query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest2
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1341838197/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/329932535/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -58,6 +58,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -70,6 +71,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -89,7 +91,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1895355415/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2044191044/10004
Union
Select Operator
expressions:
@@ -101,6 +103,7 @@
Group By Operator
aggregations:
expr: count(_col1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -135,7 +138,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1895355415/10005
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2044191044/10005
Union
Select Operator
expressions:
@@ -147,6 +150,7 @@
Group By Operator
aggregations:
expr: count(_col1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -185,6 +189,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -268,11 +273,11 @@
PREHOOK: query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/929119397/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1298503578/10000
POSTHOOK: query: SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/929119397/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1298503578/10000
0 3
10 1
100 2
@@ -586,11 +591,11 @@
PREHOOK: query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest2
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/240498256/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1684900199/10000
POSTHOOK: query: SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest2
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/240498256/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1684900199/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -36,6 +36,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -59,6 +60,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -71,6 +73,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -94,10 +97,10 @@
select s2.key as key, s2.value as value from src s2) unionsrc
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1910952008/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/750442478/10000
POSTHOOK: 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
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1910952008/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/750442478/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -51,6 +51,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -63,6 +64,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -82,7 +84,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1865430800/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1384387513/10002
Union
Reduce Output Operator
key expressions:
@@ -98,7 +100,7 @@
type: string
expr: _col1
type: string
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1865430800/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1384387513/10003
Union
Reduce Output Operator
key expressions:
@@ -214,7 +216,7 @@
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1865430800/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1384387513/10004
Union
File Output Operator
compressed: false
@@ -222,7 +224,7 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1865430800/10006
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1384387513/10006
Union
File Output Operator
compressed: false
@@ -241,6 +243,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -253,6 +256,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -285,7 +289,7 @@
ON (unionsrc1.key = unionsrc2.key)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/739233475/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/34973267/10000
POSTHOOK: query: 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
@@ -297,7 +301,7 @@
ON (unionsrc1.key = unionsrc2.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/739233475/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/34973267/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -60,6 +60,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -94,6 +95,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -128,6 +130,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -162,6 +165,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -196,6 +200,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -217,6 +222,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -257,7 +263,7 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@src_thrift
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/661760419/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/507855090/10000
POSTHOOK: query: SELECT key, count(1)
FROM (
SELECT '1' as key from src
@@ -274,7 +280,7 @@
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_thrift
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/661760419/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/507855090/10000
NULL 2
0 7
001 2
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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -47,6 +47,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -59,6 +60,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -78,7 +80,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/543273791/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1683737662/10002
Union
Select Operator
expressions:
@@ -102,7 +104,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/njain/hive5/hive5/build/ql/tmp/543273791/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1683737662/10004
Union
Select Operator
expressions:
@@ -133,10 +135,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/541591404/10000
+ destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1195528608/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/543273791/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1683737662/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -179,6 +181,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -191,6 +194,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -225,11 +229,11 @@
PREHOOK: query: select * from tmptable x sort by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@tmptable
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1853179862/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/882323055/10000
POSTHOOK: query: select * from tmptable x sort by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmptable
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1853179862/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/882323055/10000
tst1 500
tst2 500
PREHOOK: 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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -33,6 +33,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -45,6 +46,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -64,7 +66,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1295550147/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/336715439/10002
Union
Select Operator
expressions:
@@ -74,6 +76,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -91,7 +94,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1295550147/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/336715439/10003
Union
Select Operator
expressions:
@@ -101,6 +104,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -122,6 +126,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -151,6 +156,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -163,6 +169,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -189,12 +196,12 @@
select 'tst2' as key, count(1) as value from src s2) unionsrc group by unionsrc.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1100938364/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2001946443/10000
POSTHOOK: query: 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
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1100938364/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2001946443/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -47,6 +47,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -59,6 +60,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -78,7 +80,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1143232613/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/690960491/10002
Union
Select Operator
expressions:
@@ -95,7 +97,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1143232613/10004
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/690960491/10004
Union
Select Operator
expressions:
@@ -119,10 +121,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/725430727/10000
+ destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/447670167/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1143232613/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/690960491/10003
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -195,11 +197,11 @@
PREHOOK: query: select * from tmptable x sort by x.key, x.value
PREHOOK: type: QUERY
PREHOOK: Input: default@tmptable
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/991182595/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1367097606/10000
POSTHOOK: query: select * from tmptable x sort by x.key, x.value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmptable
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/991182595/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1367097606/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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -33,6 +33,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -45,6 +46,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -64,7 +66,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/51980638/10002
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1090440177/10002
Union
Select Operator
expressions:
@@ -74,6 +76,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -91,7 +94,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/njain/hive5/hive5/build/ql/tmp/51980638/10003
+ file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1090440177/10003
Union
Select Operator
expressions:
@@ -101,6 +104,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
keys:
expr: _col0
type: string
@@ -122,6 +126,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
keys:
expr: KEY._col0
type: string
@@ -172,14 +177,14 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@src1
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/176019229/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2041407066/10000
POSTHOOK: query: 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
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/176019229/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2041407066/10000
10
128 1
146 1
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=887057&r1=887056&r2=887057&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 Fri Dec 4 04:39:37 2009
@@ -38,6 +38,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -61,6 +62,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -84,6 +86,7 @@
Group By Operator
aggregations:
expr: count(1)
+ bucketGroup: false
mode: hash
outputColumnNames: _col0
Reduce Output Operator
@@ -96,6 +99,7 @@
Group By Operator
aggregations:
expr: count(VALUE._col0)
+ bucketGroup: false
mode: mergepartial
outputColumnNames: _col0
Select Operator
@@ -120,11 +124,11 @@
select s3.key as key, s3.value as value from src s3) unionsrc
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1151056714/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/433948146/10000
POSTHOOK: 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 UNION ALL
select s3.key as key, s3.value as value from src s3) unionsrc
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1151056714/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/433948146/10000
1500