hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From prasan...@apache.org
Subject svn commit: r1637959 - in /hive/trunk/ql/src/test: queries/clientpositive/orc_merge_incompat1.q results/clientpositive/orc_merge_incompat1.q.out results/clientpositive/tez/orc_merge_incompat1.q.out
Date Mon, 10 Nov 2014 19:30:26 GMT
Author: prasanthj
Date: Mon Nov 10 19:30:26 2014
New Revision: 1637959

URL: http://svn.apache.org/r1637959
Log:
HIVE-8801: Make orc_merge_incompat1.q deterministic across platforms (Prasanth J reviewed
by Gunther Hagleitner)

Modified:
    hive/trunk/ql/src/test/queries/clientpositive/orc_merge_incompat1.q
    hive/trunk/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out
    hive/trunk/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out

Modified: hive/trunk/ql/src/test/queries/clientpositive/orc_merge_incompat1.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/orc_merge_incompat1.q?rev=1637959&r1=1637958&r2=1637959&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/orc_merge_incompat1.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/orc_merge_incompat1.q Mon Nov 10 19:30:26
2014
@@ -19,6 +19,7 @@ insert into table orc_merge5b select use
 set hive.exec.orc.write.format=0.11;
 insert into table orc_merge5b select userid,string1,subtype,decimal1,ts from orc_merge5 where
userid<=13;
 insert into table orc_merge5b select userid,string1,subtype,decimal1,ts from orc_merge5 where
userid<=13;
+insert into table orc_merge5b select userid,string1,subtype,decimal1,ts from orc_merge5 where
userid<=13;
 
 -- 5 files total
 analyze table orc_merge5b compute statistics noscan;

Modified: hive/trunk/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out?rev=1637959&r1=1637958&r2=1637959&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out Mon Nov 10 19:30:26
2014
@@ -138,6 +138,19 @@ POSTHOOK: Lineage: orc_merge5b.string1 S
 POSTHOOK: Lineage: orc_merge5b.subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype,
type:double, comment:null), ]
 POSTHOOK: Lineage: orc_merge5b.ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp,
comment:null), ]
 POSTHOOK: Lineage: orc_merge5b.userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid,
type:bigint, comment:null), ]
+PREHOOK: query: insert into table orc_merge5b select userid,string1,subtype,decimal1,ts from
orc_merge5 where userid<=13
+PREHOOK: type: QUERY
+PREHOOK: Input: default@orc_merge5
+PREHOOK: Output: default@orc_merge5b
+POSTHOOK: query: insert into table orc_merge5b select userid,string1,subtype,decimal1,ts
from orc_merge5 where userid<=13
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@orc_merge5
+POSTHOOK: Output: default@orc_merge5b
+POSTHOOK: Lineage: orc_merge5b.decimal1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:decimal1,
type:decimal(10,0), comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.string1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:string1,
type:string, comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype,
type:double, comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp,
comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid,
type:bigint, comment:null), ]
 PREHOOK: query: -- 5 files total
 analyze table orc_merge5b compute statistics noscan
 PREHOOK: type: QUERY
@@ -148,7 +161,7 @@ analyze table orc_merge5b compute statis
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_merge5b
 POSTHOOK: Output: default@orc_merge5b
-Found 5 items
+Found 6 items
 #### A masked pattern was here ####
 PREHOOK: query: select * from orc_merge5b
 PREHOOK: type: QUERY
@@ -163,6 +176,8 @@ POSTHOOK: Input: default@orc_merge5b
 13	bar	80.0	2	1969-12-31 16:00:05
 13	bar	80.0	2	1969-12-31 16:00:05
 13	bar	80.0	2	1969-12-31 16:00:05
+13	bar	80.0	2	1969-12-31 16:00:05
+2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
@@ -173,6 +188,7 @@ POSTHOOK: Input: default@orc_merge5b
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
+5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: alter table orc_merge5b concatenate
 PREHOOK: type: ALTER_TABLE_MERGE
 PREHOOK: Input: default@orc_merge5b
@@ -191,7 +207,7 @@ analyze table orc_merge5b compute statis
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_merge5b
 POSTHOOK: Output: default@orc_merge5b
-Found 3 items
+Found 4 items
 #### A masked pattern was here ####
 PREHOOK: query: select * from orc_merge5b
 PREHOOK: type: QUERY
@@ -206,6 +222,8 @@ POSTHOOK: Input: default@orc_merge5b
 13	bar	80.0	2	1969-12-31 16:00:05
 13	bar	80.0	2	1969-12-31 16:00:05
 13	bar	80.0	2	1969-12-31 16:00:05
+13	bar	80.0	2	1969-12-31 16:00:05
+2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
@@ -216,3 +234,4 @@ POSTHOOK: Input: default@orc_merge5b
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
+5	eat	0.8	6	1969-12-31 16:00:20

Modified: hive/trunk/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out?rev=1637959&r1=1637958&r2=1637959&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out Mon Nov 10
19:30:26 2014
@@ -145,6 +145,19 @@ POSTHOOK: Lineage: orc_merge5b.string1 S
 POSTHOOK: Lineage: orc_merge5b.subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype,
type:double, comment:null), ]
 POSTHOOK: Lineage: orc_merge5b.ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp,
comment:null), ]
 POSTHOOK: Lineage: orc_merge5b.userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid,
type:bigint, comment:null), ]
+PREHOOK: query: insert into table orc_merge5b select userid,string1,subtype,decimal1,ts from
orc_merge5 where userid<=13
+PREHOOK: type: QUERY
+PREHOOK: Input: default@orc_merge5
+PREHOOK: Output: default@orc_merge5b
+POSTHOOK: query: insert into table orc_merge5b select userid,string1,subtype,decimal1,ts
from orc_merge5 where userid<=13
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@orc_merge5
+POSTHOOK: Output: default@orc_merge5b
+POSTHOOK: Lineage: orc_merge5b.decimal1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:decimal1,
type:decimal(10,0), comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.string1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:string1,
type:string, comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype,
type:double, comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp,
comment:null), ]
+POSTHOOK: Lineage: orc_merge5b.userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid,
type:bigint, comment:null), ]
 PREHOOK: query: -- 5 files total
 analyze table orc_merge5b compute statistics noscan
 PREHOOK: type: QUERY
@@ -155,7 +168,7 @@ analyze table orc_merge5b compute statis
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_merge5b
 POSTHOOK: Output: default@orc_merge5b
-Found 5 items
+Found 6 items
 #### A masked pattern was here ####
 PREHOOK: query: select * from orc_merge5b
 PREHOOK: type: QUERY
@@ -170,6 +183,8 @@ POSTHOOK: Input: default@orc_merge5b
 13	bar	80.0	2	1969-12-31 16:00:05
 13	bar	80.0	2	1969-12-31 16:00:05
 13	bar	80.0	2	1969-12-31 16:00:05
+13	bar	80.0	2	1969-12-31 16:00:05
+2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
@@ -180,6 +195,7 @@ POSTHOOK: Input: default@orc_merge5b
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
+5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: alter table orc_merge5b concatenate
 PREHOOK: type: ALTER_TABLE_MERGE
 PREHOOK: Input: default@orc_merge5b
@@ -198,7 +214,7 @@ analyze table orc_merge5b compute statis
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_merge5b
 POSTHOOK: Output: default@orc_merge5b
-Found 3 items
+Found 4 items
 #### A masked pattern was here ####
 PREHOOK: query: select * from orc_merge5b
 PREHOOK: type: QUERY
@@ -213,6 +229,8 @@ POSTHOOK: Input: default@orc_merge5b
 13	bar	80.0	2	1969-12-31 16:00:05
 13	bar	80.0	2	1969-12-31 16:00:05
 13	bar	80.0	2	1969-12-31 16:00:05
+13	bar	80.0	2	1969-12-31 16:00:05
+2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
@@ -223,3 +241,4 @@ POSTHOOK: Input: default@orc_merge5b
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
+5	eat	0.8	6	1969-12-31 16:00:20



Mime
View raw message