You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by pr...@apache.org on 2014/11/10 20:30:26 UTC
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
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