You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by he...@apache.org on 2012/02/01 20:51:02 UTC
svn commit: r1239286 - in /hive/trunk/ql/src/test:
queries/clientpositive/union31.q results/clientpositive/union31.q.out
Author: heyongqiang
Date: Wed Feb 1 19:51:01 2012
New Revision: 1239286
URL: http://svn.apache.org/viewvc?rev=1239286&view=rev
Log:
HIVE-2772 [jira] make union31.q deterministic
(Namit Jain via Yongqiang He)
Summary:
https://issues.apache.org/jira/browse/HIVE-2772
HIVE-2772
Test Plan: EMPTY
Reviewers: JIRA, ashutoshc
Reviewed By: ashutoshc
CC: ashutoshc
Differential Revision: https://reviews.facebook.net/D1557
Modified:
hive/trunk/ql/src/test/queries/clientpositive/union31.q
hive/trunk/ql/src/test/results/clientpositive/union31.q.out
Modified: hive/trunk/ql/src/test/queries/clientpositive/union31.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/union31.q?rev=1239286&r1=1239285&r2=1239286&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/union31.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/union31.q Wed Feb 1 19:51:01 2012
@@ -29,8 +29,8 @@ insert overwrite table t3
insert overwrite table t4
select value, count(1) group by value;
-select * from t3;
-select * from t4;
+select * from t3 order by key;
+select * from t4 order by value;
create table t5(c1 string, cnt int);
create table t6(c1 string, cnt int);
@@ -58,8 +58,8 @@ insert overwrite table t5
insert overwrite table t6
select c1, sum(cnt) group by c1;
-select * from t5;
-select * from t6;
+select * from t5 order by c1;
+select * from t6 order by c1;
drop table t1;
drop table t2;
@@ -93,5 +93,5 @@ insert overwrite table t7
insert overwrite table t8
select c1, count(1) group by c1;
-select * from t7;
-select * from t8;
+select * from t7 order by c1;
+select * from t8 order by c1;
Modified: hive/trunk/ql/src/test/results/clientpositive/union31.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union31.q.out?rev=1239286&r1=1239285&r2=1239286&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union31.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union31.q.out Wed Feb 1 19:51:01 2012
@@ -67,7 +67,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- null-subquery1:x-subquery1:t1
+ null-subquery1:x-subquery1:t1
TableScan
alias: t1
Select Operator
@@ -124,7 +124,7 @@ STAGE PLANS:
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- null-subquery2:x-subquery2:t2
+ null-subquery2:x-subquery2:t2
TableScan
alias: t2
Select Operator
@@ -322,11 +322,11 @@ POSTHOOK: Lineage: t3.cnt EXPRESSION [(t
POSTHOOK: Lineage: t3.key EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: t4.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t4.value EXPRESSION [(t2)t2.FieldSchema(name:value, type:string, comment:null), (t1)t1.FieldSchema(name:value, type:string, comment:null), ]
-PREHOOK: query: select * from t3
+PREHOOK: query: select * from t3 order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@t3
#### A masked pattern was here ####
-POSTHOOK: query: select * from t3
+POSTHOOK: query: select * from t3 order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
@@ -334,17 +334,17 @@ POSTHOOK: Lineage: t3.cnt EXPRESSION [(t
POSTHOOK: Lineage: t3.key EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: t4.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t4.value EXPRESSION [(t2)t2.FieldSchema(name:value, type:string, comment:null), (t1)t1.FieldSchema(name:value, type:string, comment:null), ]
-0 6
-2 2
-4 2
-5 6
-8 2
-9 2
-PREHOOK: query: select * from t4
+0 6
+2 2
+4 2
+5 6
+8 2
+9 2
+PREHOOK: query: select * from t4 order by value
PREHOOK: type: QUERY
PREHOOK: Input: default@t4
#### A masked pattern was here ####
-POSTHOOK: query: select * from t4
+POSTHOOK: query: select * from t4 order by value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t4
#### A masked pattern was here ####
@@ -352,12 +352,12 @@ POSTHOOK: Lineage: t3.cnt EXPRESSION [(t
POSTHOOK: Lineage: t3.key EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: t4.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t4.value EXPRESSION [(t2)t2.FieldSchema(name:value, type:string, comment:null), (t1)t1.FieldSchema(name:value, type:string, comment:null), ]
-val_0 6
-val_2 2
-val_4 2
-val_5 6
-val_8 2
-val_9 2
+val_0 6
+val_2 2
+val_4 2
+val_5 6
+val_8 2
+val_9 2
PREHOOK: query: create table t5(c1 string, cnt int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table t5(c1 string, cnt int)
@@ -420,7 +420,7 @@ STAGE PLANS:
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- null-subquery2:x-subquery2:t2
+ null-subquery2:x-subquery2:t2
TableScan
alias: t2
Select Operator
@@ -614,7 +614,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- null-subquery1:x-subquery1:t1
+ null-subquery1:x-subquery1:t1
TableScan
alias: t1
Select Operator
@@ -706,11 +706,11 @@ POSTHOOK: Lineage: t5.c1 EXPRESSION [(t2
POSTHOOK: Lineage: t5.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t6.c1 EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: t6.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
-PREHOOK: query: select * from t5
+PREHOOK: query: select * from t5 order by c1
PREHOOK: type: QUERY
PREHOOK: Input: default@t5
#### A masked pattern was here ####
-POSTHOOK: query: select * from t5
+POSTHOOK: query: select * from t5 order by c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t5
#### A masked pattern was here ####
@@ -722,17 +722,17 @@ POSTHOOK: Lineage: t5.c1 EXPRESSION [(t2
POSTHOOK: Lineage: t5.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t6.c1 EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: t6.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
-0 6
-2 2
-4 2
-5 6
-8 2
-9 2
-PREHOOK: query: select * from t6
+0 6
+2 2
+4 2
+5 6
+8 2
+9 2
+PREHOOK: query: select * from t6 order by c1
PREHOOK: type: QUERY
PREHOOK: Input: default@t6
#### A masked pattern was here ####
-POSTHOOK: query: select * from t6
+POSTHOOK: query: select * from t6 order by c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t6
#### A masked pattern was here ####
@@ -744,12 +744,12 @@ POSTHOOK: Lineage: t5.c1 EXPRESSION [(t2
POSTHOOK: Lineage: t5.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t6.c1 EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: t6.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
-0 6
-2 2
-4 2
-5 6
-8 2
-9 2
+0 6
+2 2
+4 2
+5 6
+8 2
+9 2
PREHOOK: query: drop table t1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@t1
@@ -885,7 +885,7 @@ STAGE PLANS:
Stage: Stage-6
Map Reduce
Alias -> Map Operator Tree:
- null-subquery1:x-subquery1:t1
+ null-subquery1:x-subquery1:t1
TableScan
alias: t1
Select Operator
@@ -961,7 +961,7 @@ STAGE PLANS:
value expressions:
expr: 1
type: int
- null-subquery2:x-subquery2:t2
+ null-subquery2:x-subquery2:t2
TableScan
alias: t2
Select Operator
@@ -1123,11 +1123,11 @@ POSTHOOK: Lineage: t7.c1 EXPRESSION [(t2
POSTHOOK: Lineage: t7.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t8.c1 EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: t8.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
-PREHOOK: query: select * from t7
+PREHOOK: query: select * from t7 order by c1
PREHOOK: type: QUERY
PREHOOK: Input: default@t7
#### A masked pattern was here ####
-POSTHOOK: query: select * from t7
+POSTHOOK: query: select * from t7 order by c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t7
#### A masked pattern was here ####
@@ -1143,17 +1143,17 @@ POSTHOOK: Lineage: t7.c1 EXPRESSION [(t2
POSTHOOK: Lineage: t7.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t8.c1 EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: t8.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
-0 2
-2 2
-4 2
-5 2
-8 2
-9 2
-PREHOOK: query: select * from t8
+0 2
+2 2
+4 2
+5 2
+8 2
+9 2
+PREHOOK: query: select * from t8 order by c1
PREHOOK: type: QUERY
PREHOOK: Input: default@t8
#### A masked pattern was here ####
-POSTHOOK: query: select * from t8
+POSTHOOK: query: select * from t8 order by c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t8
#### A masked pattern was here ####
@@ -1169,9 +1169,9 @@ POSTHOOK: Lineage: t7.c1 EXPRESSION [(t2
POSTHOOK: Lineage: t7.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t8.c1 EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: t8.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
-0 2
-2 2
-4 2
-5 2
-8 2
-9 2
+0 2
+2 2
+4 2
+5 2
+8 2
+9 2