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 2010/01/16 07:46:07 UTC
svn commit: r899891 [15/31] - in /hadoop/hive/trunk: ./
common/src/java/org/apache/hadoop/hive/conf/ conf/
ql/src/java/org/apache/hadoop/hive/ql/
ql/src/java/org/apache/hadoop/hive/ql/exec/
ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/ ql/src...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out?rev=899891&r1=899890&r2=899891&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_case_column_pruning.q.out Sat Jan 16 06:44:01 2010
@@ -64,6 +64,7 @@
condition expressions:
0 {VALUE._col0}
1
+ handleSkewJoin: false
outputColumnNames: _col0
Select Operator
expressions:
@@ -80,7 +81,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/483718410/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/54439940/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -115,7 +116,7 @@
ORDER BY key LIMIT 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1574907719/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/901846595/10000
POSTHOOK: query: SELECT CASE a.key
WHEN '1' THEN 2
WHEN '3' THEN 4
@@ -126,7 +127,7 @@
ORDER BY key LIMIT 10
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/1574907719/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/901846595/10000
5
5
5
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out?rev=899891&r1=899890&r2=899891&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/udf_length.q.out Sat Jan 16 06:44:01 2010
@@ -25,8 +25,10 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-4 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-4
+ Stage-4 depends on stages: Stage-1 , consists of Stage-3, Stage-2
+ Stage-3
+ Stage-0 depends on stages: Stage-3, Stage-2
+ Stage-2
STAGE PLANS:
Stage: Stage-1
@@ -51,33 +53,12 @@
Stage: Stage-4
Conditional Operator
- list of dependent Tasks:
- Move Operator
- files:
- hdfs directory: true
- destination: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1622212784/10000
- Map Reduce
- Alias -> Map Operator Tree:
- file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/92165457/10002
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: len
- type: int
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dest1
+
+ Stage: Stage-3
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1477901975/10000
Stage: Stage-0
Move Operator
@@ -89,6 +70,30 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2112708901/10002
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: len
+ type: int
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+
PREHOOK: query: FROM src1 INSERT OVERWRITE TABLE dest1 SELECT length(src1.value)
PREHOOK: type: QUERY
@@ -101,11 +106,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2077609609/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1063857688/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/2077609609/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1063857688/10000
7
0
7
@@ -186,11 +191,11 @@
PREHOOK: query: SELECT length(dest1.name) FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/394449121/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/249846152/10000
POSTHOOK: query: SELECT length(dest1.name) FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/394449121/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/249846152/10000
2
PREHOOK: query: DROP TABLE dest1
PREHOOK: type: DROPTABLE
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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -25,8 +25,10 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-4 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-4
+ Stage-4 depends on stages: Stage-1 , consists of Stage-3, Stage-2
+ Stage-3
+ Stage-0 depends on stages: Stage-3, Stage-2
+ Stage-2
STAGE PLANS:
Stage: Stage-1
@@ -51,33 +53,12 @@
Stage: Stage-4
Conditional Operator
- list of dependent Tasks:
- Move Operator
- files:
- hdfs directory: true
- destination: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/520090506/10000
- Map Reduce
- Alias -> Map Operator Tree:
- file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/468564432/10002
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: len
- type: string
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dest1
+
+ Stage: Stage-3
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/472117671/10000
Stage: Stage-0
Move Operator
@@ -89,6 +70,30 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1252154601/10002
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: len
+ type: string
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+
PREHOOK: query: FROM src1 INSERT OVERWRITE TABLE dest1 SELECT reverse(src1.value)
PREHOOK: type: QUERY
@@ -101,11 +106,11 @@
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/255390900/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/186785883/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/255390900/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/186785883/10000
832_lav
113_lav
@@ -155,11 +160,11 @@
PREHOOK: query: SELECT count(1) FROM dest1 WHERE reverse(dest1.name) = _UTF-8 0xE993AEE982B5
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1130378645/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1359492114/10000
POSTHOOK: query: SELECT count(1) FROM dest1 WHERE reverse(dest1.name) = _UTF-8 0xE993AEE982B5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1130378645/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1359492114/10000
1
PREHOOK: query: DROP TABLE dest1
PREHOOK: type: DROPTABLE
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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -23,8 +23,10 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
- Stage-4 depends on stages: Stage-1
- Stage-0 depends on stages: Stage-4
+ Stage-4 depends on stages: Stage-1 , consists of Stage-3, Stage-2
+ Stage-3
+ Stage-0 depends on stages: Stage-3, Stage-2
+ Stage-2
STAGE PLANS:
Stage: Stage-1
@@ -97,33 +99,12 @@
Stage: Stage-4
Conditional Operator
- list of dependent Tasks:
- Move Operator
- files:
- hdfs directory: true
- destination: file:/data/users/njain/hive5/hive5/build/ql/tmp/580876099/10000
- Map Reduce
- Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/925373364/10001
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
+ Stage: Stage-3
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/36512839/10000
Stage: Stage-0
Move Operator
@@ -131,6 +112,30 @@
hdfs directory: true
destination: ../build/ql/test/data/warehouse/union.out
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1711864656/10001
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+
PREHOOK: query: FROM (
FROM src select src.key, src.value WHERE src.key < 100
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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -33,16 +33,12 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-6, Stage-7
- Stage-5 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-5
+ Stage-5 depends on stages: Stage-2 , consists of Stage-4, Stage-3
+ Stage-4
+ Stage-0 depends on stages: Stage-4, Stage-3
+ Stage-3
Stage-6 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-6, Stage-7
- Stage-5 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-5
Stage-7 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-6, Stage-7
- Stage-5 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-5
STAGE PLANS:
Stage: Stage-1
@@ -88,7 +84,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1780852426/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/201780527/10002
Union
Select Operator
expressions:
@@ -112,7 +108,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1780852426/10004
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/201780527/10004
Union
Select Operator
expressions:
@@ -136,7 +132,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1780852426/10005
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/201780527/10005
Union
Select Operator
expressions:
@@ -163,35 +159,12 @@
Stage: Stage-5
Conditional Operator
- list of dependent Tasks:
- Move Operator
- files:
- hdfs directory: true
- destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/478382549/10000
- Map Reduce
- Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1780852426/10003
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: key
- type: string
- expr: value
- type: int
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: tmptable
+
+ Stage: Stage-4
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/48152402/10000
Stage: Stage-0
Move Operator
@@ -203,6 +176,32 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
+ Stage: Stage-3
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/201780527/10003
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: int
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
+
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
@@ -305,11 +304,11 @@
PREHOOK: query: select * from tmptable x sort by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@tmptable
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/330519049/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1819535514/10000
POSTHOOK: query: select * from tmptable x sort by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmptable
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/330519049/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1819535514/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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -23,9 +23,7 @@
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-3, Stage-4
Stage-3 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-3, Stage-4
Stage-4 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-3, Stage-4
Stage-0 is a root stage
STAGE PLANS:
@@ -72,7 +70,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1278683815/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1097598026/10002
Union
Select Operator
expressions:
@@ -100,7 +98,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1278683815/10003
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1097598026/10003
Union
Select Operator
expressions:
@@ -128,7 +126,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1278683815/10004
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1097598026/10004
Union
Select Operator
expressions:
@@ -272,7 +270,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/heyongqiang/hive-trunk-commit/build/ql/tmp/1457775723/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1882920278/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
@@ -280,7 +278,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/heyongqiang/hive-trunk-commit/build/ql/tmp/1457775723/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1882920278/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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -33,16 +33,12 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-6, Stage-7
- Stage-5 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-5
+ Stage-5 depends on stages: Stage-2 , consists of Stage-4, Stage-3
+ Stage-4
+ Stage-0 depends on stages: Stage-4, Stage-3
+ Stage-3
Stage-6 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-6, Stage-7
- Stage-5 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-5
Stage-7 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-6, Stage-7
- Stage-5 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-5
STAGE PLANS:
Stage: Stage-1
@@ -88,7 +84,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2093381659/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1908722862/10002
Union
Select Operator
expressions:
@@ -112,7 +108,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2093381659/10004
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1908722862/10004
Union
Select Operator
expressions:
@@ -136,7 +132,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2093381659/10005
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1908722862/10005
Union
Select Operator
expressions:
@@ -163,35 +159,12 @@
Stage: Stage-5
Conditional Operator
- list of dependent Tasks:
- Move Operator
- files:
- hdfs directory: true
- destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1932347815/10000
- Map Reduce
- Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2093381659/10003
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: key
- type: string
- expr: value
- type: int
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: tmptable
+
+ Stage: Stage-4
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1028672484/10000
Stage: Stage-0
Move Operator
@@ -203,6 +176,32 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
+ Stage: Stage-3
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1908722862/10003
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: int
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
+
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
@@ -309,11 +308,11 @@
PREHOOK: query: select * from tmptable x sort by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@tmptable
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1239089597/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/65730204/10000
POSTHOOK: query: select * from tmptable x sort by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmptable
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1239089597/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/65730204/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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -21,7 +21,6 @@
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-3
Stage-3 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-3
Stage-0 is a root stage
STAGE PLANS:
@@ -48,7 +47,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1040645790/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1033881589/10002
Union
Select Operator
expressions:
@@ -76,7 +75,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1040645790/10003
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1033881589/10003
Union
Select Operator
expressions:
@@ -180,7 +179,7 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@src1
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1877970971/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/156140549/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)
@@ -188,7 +187,7 @@
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src1
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1877970971/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/156140549/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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -23,9 +23,7 @@
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-3, Stage-4
Stage-3 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-3, Stage-4
Stage-4 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-3, Stage-4
Stage-0 is a root stage
STAGE PLANS:
@@ -72,7 +70,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/709538809/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/84207211/10002
Union
Select Operator
expressions:
@@ -100,7 +98,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/709538809/10003
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/84207211/10003
Union
Select Operator
expressions:
@@ -128,7 +126,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/709538809/10004
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/84207211/10004
Union
Select Operator
expressions:
@@ -233,7 +231,7 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@src1
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1306651084/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/586655480/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
@@ -242,7 +240,7 @@
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1306651084/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/586655480/10000
20
128 2
146 2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union17.q.out?rev=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -45,11 +45,6 @@
Stage-5 depends on stages: Stage-3
Stage-1 depends on stages: Stage-5
Stage-6 is a root stage
- Stage-3 depends on stages: Stage-2, Stage-6
- Stage-4 depends on stages: Stage-3
- Stage-0 depends on stages: Stage-4
- Stage-5 depends on stages: Stage-3
- Stage-1 depends on stages: Stage-5
STAGE PLANS:
Stage: Stage-2
@@ -95,7 +90,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176659022/10004
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/658847227/10004
Union
Reduce Output Operator
key expressions:
@@ -111,7 +106,7 @@
type: string
expr: _col1
type: string
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176659022/10007
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/658847227/10007
Union
Reduce Output Operator
key expressions:
@@ -165,7 +160,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176659022/10005
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/658847227/10005
Reduce Output Operator
key expressions:
expr: _col0
@@ -217,7 +212,7 @@
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1176659022/10006
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/658847227/10006
Reduce Output Operator
key expressions:
expr: _col0
@@ -316,11 +311,11 @@
PREHOOK: query: SELECT DEST1.* FROM DEST1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/601320238/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/132652809/10000
POSTHOOK: query: SELECT DEST1.* FROM DEST1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/601320238/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/132652809/10000
0 1
10 1
100 1
@@ -634,11 +629,11 @@
PREHOOK: query: SELECT DEST2.* FROM DEST2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest2
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/53402192/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/21838102/10000
POSTHOOK: query: SELECT DEST2.* FROM DEST2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest2
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/53402192/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/21838102/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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -40,16 +40,15 @@
STAGE DEPENDENCIES:
Stage-2 is a root stage
Stage-3 depends on stages: Stage-2, Stage-10
- Stage-6 depends on stages: Stage-3
- Stage-0 depends on stages: Stage-6
- Stage-9 depends on stages: Stage-3
- Stage-1 depends on stages: Stage-9
+ Stage-6 depends on stages: Stage-3 , consists of Stage-5, Stage-4
+ Stage-5
+ Stage-0 depends on stages: Stage-5, Stage-4
+ Stage-4
+ Stage-9 depends on stages: Stage-3 , consists of Stage-8, Stage-7
+ Stage-8
+ Stage-1 depends on stages: Stage-8, Stage-7
+ Stage-7
Stage-10 is a root stage
- Stage-3 depends on stages: Stage-2, Stage-10
- Stage-6 depends on stages: Stage-3
- Stage-0 depends on stages: Stage-6
- Stage-9 depends on stages: Stage-3
- Stage-1 depends on stages: Stage-9
STAGE PLANS:
Stage: Stage-2
@@ -95,7 +94,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/786428612/10004
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/741093659/10004
Union
Select Operator
expressions:
@@ -129,7 +128,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/786428612/10007
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/741093659/10007
Union
Select Operator
expressions:
@@ -166,35 +165,12 @@
Stage: Stage-6
Conditional Operator
- list of dependent Tasks:
- Move Operator
- files:
- hdfs directory: true
- destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1687435685/10000
- Map Reduce
- Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/786428612/10005
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dest1
+
+ Stage: Stage-5
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/599903239/10000
Stage: Stage-0
Move Operator
@@ -206,39 +182,40 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+ Stage: Stage-4
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/741093659/10005
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
+
Stage: Stage-9
Conditional Operator
- list of dependent Tasks:
- Move Operator
- files:
- hdfs directory: true
- destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1687435685/10002
- Map Reduce
- Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/786428612/10006
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: key
- type: string
- expr: val1
- type: string
- expr: val2
- type: string
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dest2
+
+ Stage: Stage-8
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/599903239/10002
Stage: Stage-1
Move Operator
@@ -250,6 +227,34 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
+ Stage: Stage-7
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/741093659/10006
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: key
+ type: string
+ expr: val1
+ type: string
+ expr: val2
+ type: string
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest2
+
Stage: Stage-10
Map Reduce
Alias -> Map Operator Tree:
@@ -292,11 +297,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/heyongqiang/hive-trunk-commit/build/ql/tmp/1777998074/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1342633477/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/heyongqiang/hive-trunk-commit/build/ql/tmp/1777998074/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1342633477/10000
0 val_0
0 val_0
0 val_0
@@ -801,11 +806,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/heyongqiang/hive-trunk-commit/build/ql/tmp/329932535/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1450263550/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/heyongqiang/hive-trunk-commit/build/ql/tmp/329932535/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/1450263550/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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -43,9 +43,6 @@
Stage-0 depends on stages: Stage-3
Stage-1 depends on stages: Stage-3
Stage-4 is a root stage
- Stage-3 depends on stages: Stage-2, Stage-4
- Stage-0 depends on stages: Stage-3
- Stage-1 depends on stages: Stage-3
STAGE PLANS:
Stage: Stage-2
@@ -91,7 +88,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2044191044/10004
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1088795587/10004
Union
Select Operator
expressions:
@@ -138,7 +135,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2044191044/10005
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1088795587/10005
Union
Select Operator
expressions:
@@ -273,11 +270,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/heyongqiang/hive-trunk-commit/build/ql/tmp/1298503578/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/597577682/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/heyongqiang/hive-trunk-commit/build/ql/tmp/1298503578/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/597577682/10000
0 3
10 1
100 2
@@ -591,11 +588,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/heyongqiang/hive-trunk-commit/build/ql/tmp/1684900199/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1198732652/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/heyongqiang/hive-trunk-commit/build/ql/tmp/1684900199/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1198732652/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/union20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union20.q.out?rev=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -31,13 +31,9 @@
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-3, Stage-5
Stage-3 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-3, Stage-5
Stage-4 is a root stage
Stage-5 depends on stages: Stage-4, Stage-6
- Stage-2 depends on stages: Stage-1, Stage-3, Stage-5
Stage-6 is a root stage
- Stage-5 depends on stages: Stage-4, Stage-6
- Stage-2 depends on stages: Stage-1, Stage-3, Stage-5
Stage-0 is a root stage
STAGE PLANS:
@@ -84,7 +80,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1384387513/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/147338598/10002
Union
Reduce Output Operator
key expressions:
@@ -100,7 +96,7 @@
type: string
expr: _col1
type: string
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1384387513/10003
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/147338598/10003
Union
Reduce Output Operator
key expressions:
@@ -138,6 +134,7 @@
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {VALUE._col0} {VALUE._col1}
+ handleSkewJoin: false
outputColumnNames: _col0, _col1, _col2, _col3
Select Operator
expressions:
@@ -216,7 +213,7 @@
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1384387513/10004
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/147338598/10004
Union
File Output Operator
compressed: false
@@ -224,7 +221,7 @@
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1384387513/10006
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/147338598/10006
Union
File Output Operator
compressed: false
@@ -289,7 +286,7 @@
ON (unionsrc1.key = unionsrc2.key)
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/34973267/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/882907634/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
@@ -301,7 +298,7 @@
ON (unionsrc1.key = unionsrc2.key)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/34973267/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/882907634/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/union22.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union22.q.out?rev=899891&r1=899890&r2=899891&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union22.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union22.q.out Sat Jan 16 06:44:01 2010
@@ -93,6 +93,7 @@
condition expressions:
0 {k1} {k2}
1 {_col3} {_col4}
+ handleSkewJoin: false
keys:
0 [Column[k1]]
1 [Column[_col1]]
@@ -101,7 +102,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/120436027/10002
+ directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2007294374/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -144,6 +145,7 @@
condition expressions:
0 {k1} {k2}
1 {_col3} {_col4}
+ handleSkewJoin: false
keys:
0 [Column[k1]]
1 [Column[_col1]]
@@ -152,7 +154,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/120436027/10002
+ directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2007294374/10002
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
@@ -162,9 +164,9 @@
escape.delim \
Needs Tagging: false
Path -> Alias:
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22/ds=1 [null-subquery2:subq-subquery2:a]
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dst_union22/ds=1 [null-subquery2:subq-subquery2:a]
Path -> Partition:
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22/ds=1
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dst_union22/ds=1
Partition
base file name: ds=1
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -182,8 +184,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/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22
- transient_lastDdlTime 1262138554
+ location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dst_union22
+ transient_lastDdlTime 1263596343
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -199,8 +201,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/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22
- transient_lastDdlTime 1262138554
+ location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dst_union22
+ transient_lastDdlTime 1263596343
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dst_union22
name: dst_union22
@@ -208,7 +210,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/120436027/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2007294374/10002
Select Operator
expressions:
expr: _col0
@@ -251,7 +253,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/714388471/10000
+ directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/844330966/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -266,8 +268,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/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22
- transient_lastDdlTime 1262138554
+ location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dst_union22
+ transient_lastDdlTime 1263596343
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dst_union22
null-subquery1:subq-subquery1:dst_union22_delta
@@ -309,7 +311,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/714388471/10000
+ directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/844330966/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -324,16 +326,16 @@
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/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22
- transient_lastDdlTime 1262138554
+ location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dst_union22
+ transient_lastDdlTime 1263596343
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dst_union22
Needs Tagging: false
Path -> Alias:
- file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/120436027/10002 [file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/120436027/10002]
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta/ds=1 [null-subquery1:subq-subquery1:dst_union22_delta]
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2007294374/10002 [file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2007294374/10002]
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dst_union22_delta/ds=1 [null-subquery1:subq-subquery1:dst_union22_delta]
Path -> Partition:
- file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/120436027/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2007294374/10002
Partition
base file name: 10002
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -349,7 +351,7 @@
columns _col0,_col1,_col8,_col9
columns.types string,string,string,string
escape.delim \
- file:/data/users/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta/ds=1
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dst_union22_delta/ds=1
Partition
base file name: ds=1
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -367,8 +369,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/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta
- transient_lastDdlTime 1262138554
+ location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dst_union22_delta
+ transient_lastDdlTime 1263596343
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -384,8 +386,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/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22_delta
- transient_lastDdlTime 1262138554
+ location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dst_union22_delta
+ transient_lastDdlTime 1263596343
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dst_union22_delta
name: dst_union22_delta
@@ -396,7 +398,7 @@
partition:
ds 2
replace: true
- source: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/714388471/10000
+ source: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/844330966/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -411,11 +413,11 @@
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/jsichi/open/hive-trunk/build/ql/test/data/warehouse/dst_union22
- transient_lastDdlTime 1262138554
+ location file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/test/data/warehouse/dst_union22
+ transient_lastDdlTime 1263596343
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dst_union22
- tmp directory: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/714388471/10001
+ tmp directory: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/844330966/10001
PREHOOK: query: insert overwrite table dst_union22 partition (ds='2')
@@ -451,11 +453,11 @@
PREHOOK: query: select * from dst_union22 where ds = '2' order by k1
PREHOOK: type: QUERY
PREHOOK: Input: default@dst_union22@ds=2
-PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1090043259/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1808125050/10000
POSTHOOK: query: select * from dst_union22 where ds = '2' order by k1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dst_union22@ds=2
-POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1090043259/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1808125050/10000
0 val_0 0 val_0 2
0 val_0 0 val_0 2
0 val_0 0 val_0 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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -41,13 +41,10 @@
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-3, Stage-5, Stage-7
Stage-3 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-3, Stage-5, Stage-7
Stage-4 is a root stage
Stage-5 depends on stages: Stage-4
- Stage-2 depends on stages: Stage-1, Stage-3, Stage-5, Stage-7
Stage-6 is a root stage
Stage-7 depends on stages: Stage-6
- Stage-2 depends on stages: Stage-1, Stage-3, Stage-5, Stage-7
Stage-0 is a root stage
STAGE PLANS:
@@ -91,7 +88,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1712800093/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2013565127/10002
Union
Select Operator
expressions:
@@ -104,7 +101,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1712800093/10003
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2013565127/10003
Union
Select Operator
expressions:
@@ -117,7 +114,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1712800093/10005
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2013565127/10005
Union
Select Operator
expressions:
@@ -130,7 +127,7 @@
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1712800093/10007
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2013565127/10007
Union
Select Operator
expressions:
@@ -221,7 +218,7 @@
Stage: Stage-5
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1712800093/10004
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2013565127/10004
Reduce Output Operator
key expressions:
expr: _col0
@@ -283,7 +280,7 @@
Stage: Stage-7
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive5/hive5/build/ql/tmp/1712800093/10006
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/2013565127/10006
Reduce Output Operator
key expressions:
expr: _col0
@@ -362,11 +359,11 @@
PREHOOK: query: select * from union_out cluster by id
PREHOOK: type: QUERY
PREHOOK: Input: default@union_out
-PREHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/532213129/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/63213254/10000
POSTHOOK: query: select * from union_out cluster by id
POSTHOOK: type: QUERY
POSTHOOK: Input: default@union_out
-POSTHOOK: Output: file:/data/users/njain/hive5/hive5/build/ql/tmp/532213129/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/63213254/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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -29,12 +29,11 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-6
- Stage-5 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-5
+ Stage-5 depends on stages: Stage-2 , consists of Stage-4, Stage-3
+ Stage-4
+ Stage-0 depends on stages: Stage-4, Stage-3
+ Stage-3
Stage-6 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-6
- Stage-5 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-5
STAGE PLANS:
Stage: Stage-1
@@ -80,7 +79,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1683737662/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/742643465/10002
Union
Select Operator
expressions:
@@ -104,7 +103,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1683737662/10004
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/742643465/10004
Union
Select Operator
expressions:
@@ -131,35 +130,12 @@
Stage: Stage-5
Conditional Operator
- list of dependent Tasks:
- Move Operator
- files:
- hdfs directory: true
- destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1195528608/10000
- Map Reduce
- Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1683737662/10003
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: key
- type: string
- expr: value
- type: int
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: tmptable
+
+ Stage: Stage-4
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/377727473/10000
Stage: Stage-0
Move Operator
@@ -171,6 +147,32 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
+ Stage: Stage-3
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/742643465/10003
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: int
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
+
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
@@ -229,11 +231,11 @@
PREHOOK: query: select * from tmptable x sort by x.key
PREHOOK: type: QUERY
PREHOOK: Input: default@tmptable
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/882323055/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/726784985/10000
POSTHOOK: query: select * from tmptable x sort by x.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmptable
-POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/882323055/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/726784985/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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -19,7 +19,6 @@
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-3
Stage-3 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-3
Stage-0 is a root stage
STAGE PLANS:
@@ -66,7 +65,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/336715439/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/2029325579/10002
Union
Select Operator
expressions:
@@ -94,7 +93,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/336715439/10003
+ file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/2029325579/10003
Union
Select Operator
expressions:
@@ -196,12 +195,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/heyongqiang/hive-trunk-commit/build/ql/tmp/2001946443/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/757963901/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/heyongqiang/hive-trunk-commit/build/ql/tmp/2001946443/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_0/build/ql/tmp/757963901/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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -29,12 +29,11 @@
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-6
- Stage-5 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-5
+ Stage-5 depends on stages: Stage-2 , consists of Stage-4, Stage-3
+ Stage-4
+ Stage-0 depends on stages: Stage-4, Stage-3
+ Stage-3
Stage-6 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-6
- Stage-5 depends on stages: Stage-2
- Stage-0 depends on stages: Stage-5
STAGE PLANS:
Stage: Stage-1
@@ -80,7 +79,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/690960491/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1465614368/10002
Union
Select Operator
expressions:
@@ -97,7 +96,7 @@
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/690960491/10004
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1465614368/10004
Union
Select Operator
expressions:
@@ -117,35 +116,12 @@
Stage: Stage-5
Conditional Operator
- list of dependent Tasks:
- Move Operator
- files:
- hdfs directory: true
- destination: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/447670167/10000
- Map Reduce
- Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/690960491/10003
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Operator Tree:
- Extract
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: tmptable
+
+ Stage: Stage-4
+ Move Operator
+ files:
+ hdfs directory: true
+ destination: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1081681753/10000
Stage: Stage-0
Move Operator
@@ -157,6 +133,32 @@
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: tmptable
+ Stage: Stage-3
+ Map Reduce
+ Alias -> Map Operator Tree:
+ file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1465614368/10003
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Operator Tree:
+ Extract
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: tmptable
+
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
@@ -197,11 +199,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/heyongqiang/hive-trunk-commit/build/ql/tmp/1367097606/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1370886727/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/heyongqiang/hive-trunk-commit/build/ql/tmp/1367097606/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_1/build/ql/tmp/1370886727/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=899891&r1=899890&r2=899891&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 Sat Jan 16 06:44:01 2010
@@ -19,7 +19,6 @@
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-3
Stage-3 is a root stage
- Stage-2 depends on stages: Stage-1, Stage-3
Stage-0 is a root stage
STAGE PLANS:
@@ -66,7 +65,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1090440177/10002
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1840690240/10002
Union
Select Operator
expressions:
@@ -94,7 +93,7 @@
value expressions:
expr: _col1
type: bigint
- file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/1090440177/10003
+ file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/1840690240/10003
Union
Select Operator
expressions:
@@ -177,14 +176,14 @@
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Input: default@src1
-PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk-commit/build/ql/tmp/2041407066/10000
+PREHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/992567198/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/heyongqiang/hive-trunk-commit/build/ql/tmp/2041407066/10000
+POSTHOOK: Output: file:/data/users/heyongqiang/hive-trunk/.ptest_2/build/ql/tmp/992567198/10000
10
128 1
146 1