hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1598678 [26/31] - in /hive/trunk: cli/src/java/org/apache/hadoop/hive/cli/ common/src/java/org/apache/hadoop/hive/common/io/ itests/util/src/main/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache...
Date Fri, 30 May 2014 17:37:15 GMT
Modified: hive/trunk/ql/src/test/results/clientpositive/orc_split_elimination.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_split_elimination.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/orc_split_elimination.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/orc_split_elimination.q.out Fri May 30 17:37:05
2014
@@ -1,7 +1,11 @@
-PREHOOK: query: create table orc_split_elim (userid bigint, string1 string, subtype double,
decimal1 decimal, ts timestamp) stored as orc
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table orc_split_elim (userid bigint, string1 string, subtype double, decimal1 decimal,
ts timestamp) stored as orc
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
-POSTHOOK: query: create table orc_split_elim (userid bigint, string1 string, subtype double,
decimal1 decimal, ts timestamp) stored as orc
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table orc_split_elim (userid bigint, string1 string, subtype double, decimal1 decimal,
ts timestamp) stored as orc
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@orc_split_elim
@@ -130,134 +134,134 @@ POSTHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 0
 PREHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 POSTHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 2	foo	0.8	1	1969-12-31 16:00:00
 PREHOOK: query: -- 1 mapper
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 POSTHOOK: query: -- 1 mapper
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=2
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 2	foo	0.8	1	1969-12-31 16:00:00
 PREHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 POSTHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 2	foo	0.8	1	1969-12-31 16:00:00
 5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: -- 2 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 POSTHOOK: query: -- 2 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=5
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 2	foo	0.8	1	1969-12-31 16:00:00
 5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 POSTHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
+13	bar	80.0	2	1969-12-31 16:00:05
 2	foo	0.8	1	1969-12-31 16:00:00
 5	eat	0.8	6	1969-12-31 16:00:20
-13	bar	80.0	2	1969-12-31 16:00:05
 PREHOOK: query: -- 3 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 POSTHOOK: query: -- 3 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=13
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
+13	bar	80.0	2	1969-12-31 16:00:05
 2	foo	0.8	1	1969-12-31 16:00:00
 5	eat	0.8	6	1969-12-31 16:00:20
-13	bar	80.0	2	1969-12-31 16:00:05
 PREHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 POSTHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
-2	foo	0.8	1	1969-12-31 16:00:00
-5	eat	0.8	6	1969-12-31 16:00:20
 13	bar	80.0	2	1969-12-31 16:00:05
+2	foo	0.8	1	1969-12-31 16:00:00
 29	cat	8.0	3	1969-12-31 16:00:10
+5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: -- 4 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 POSTHOOK: query: -- 4 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=29
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
-2	foo	0.8	1	1969-12-31 16:00:00
-5	eat	0.8	6	1969-12-31 16:00:20
 13	bar	80.0	2	1969-12-31 16:00:05
+2	foo	0.8	1	1969-12-31 16:00:00
 29	cat	8.0	3	1969-12-31 16:00:10
+5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 POSTHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
-2	foo	0.8	1	1969-12-31 16:00:00
-5	eat	0.8	6	1969-12-31 16:00:20
 13	bar	80.0	2	1969-12-31 16:00:05
+2	foo	0.8	1	1969-12-31 16:00:00
 29	cat	8.0	3	1969-12-31 16:00:10
+5	eat	0.8	6	1969-12-31 16:00:20
 70	dog	1.8	4	1969-12-31 16:00:15
 PREHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
 POSTHOOK: query: -- 5 mappers
-select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70 order by
userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim where userid<=70
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim
 #### A masked pattern was here ####
-2	foo	0.8	1	1969-12-31 16:00:00
-5	eat	0.8	6	1969-12-31 16:00:20
 13	bar	80.0	2	1969-12-31 16:00:05
+2	foo	0.8	1	1969-12-31 16:00:00
 29	cat	8.0	3	1969-12-31 16:00:10
+5	eat	0.8	6	1969-12-31 16:00:20
 70	dog	1.8	4	1969-12-31 16:00:15
 PREHOOK: query: -- partitioned table
 create table orc_split_elim_part (userid bigint, string1 string, subtype double, decimal1
decimal, ts timestamp) partitioned by (country string, year int) stored as orc
@@ -299,14 +303,14 @@ POSTHOOK: type: LOAD
 #### A masked pattern was here ####
 POSTHOOK: Output: default@orc_split_elim_part@country=us/year=2001
 PREHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us'order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001
 #### A masked pattern was here ####
 POSTHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us'order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us'
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
@@ -315,14 +319,14 @@ POSTHOOK: Input: default@orc_split_elim_
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 PREHOOK: query: -- 2 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001
 #### A masked pattern was here ####
 POSTHOOK: query: -- 2 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us'
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
@@ -331,14 +335,14 @@ POSTHOOK: Input: default@orc_split_elim_
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 PREHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and (year=2000 or year=2001) order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and (year=2000 or year=2001)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001
 #### A masked pattern was here ####
 POSTHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and (year=2000 or year=2001) order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and (year=2000 or year=2001)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
@@ -347,14 +351,14 @@ POSTHOOK: Input: default@orc_split_elim_
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 PREHOOK: query: -- 2 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and (year=2000 or year=2001) order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and (year=2000 or year=2001)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001
 #### A masked pattern was here ####
 POSTHOOK: query: -- 2 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and (year=2000 or year=2001) order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and (year=2000 or year=2001)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
@@ -363,40 +367,40 @@ POSTHOOK: Input: default@orc_split_elim_
 2	foo	0.8	1	1969-12-31 16:00:00
 2	foo	0.8	1	1969-12-31 16:00:00
 PREHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and year=2000 order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and year=2000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 #### A masked pattern was here ####
 POSTHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and year=2000 order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and year=2000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 #### A masked pattern was here ####
 2	foo	0.8	1	1969-12-31 16:00:00
 PREHOOK: query: -- 1 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and year=2000 order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and year=2000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 #### A masked pattern was here ####
 POSTHOOK: query: -- 1 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and year=2000 order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=2 and
country='us' and year=2000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 #### A masked pattern was here ####
 2	foo	0.8	1	1969-12-31 16:00:00
 PREHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001
 #### A masked pattern was here ####
 POSTHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us'
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
@@ -407,14 +411,14 @@ POSTHOOK: Input: default@orc_split_elim_
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: -- 4 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001
 #### A masked pattern was here ####
 POSTHOOK: query: -- 4 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us'
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
@@ -425,14 +429,14 @@ POSTHOOK: Input: default@orc_split_elim_
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and (year=2000 or year=2001) order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and (year=2000 or year=2001)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001
 #### A masked pattern was here ####
 POSTHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and (year=2000 or year=2001) order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and (year=2000 or year=2001)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
@@ -443,14 +447,14 @@ POSTHOOK: Input: default@orc_split_elim_
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: -- 4 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and (year=2000 or year=2001) order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and (year=2000 or year=2001)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2001
 #### A masked pattern was here ####
 POSTHOOK: query: -- 4 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and (year=2000 or year=2001) order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and (year=2000 or year=2001)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
@@ -461,13 +465,13 @@ POSTHOOK: Input: default@orc_split_elim_
 5	eat	0.8	6	1969-12-31 16:00:20
 5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and year=2000 order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and year=2000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 #### A masked pattern was here ####
 POSTHOOK: query: -- 10 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and year=2000 order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and year=2000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
@@ -475,13 +479,13 @@ POSTHOOK: Input: default@orc_split_elim_
 2	foo	0.8	1	1969-12-31 16:00:00
 5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: -- 2 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and year=2000 order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and year=2000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 PREHOOK: Input: default@orc_split_elim_part@country=us/year=2000
 #### A masked pattern was here ####
 POSTHOOK: query: -- 2 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and year=2000 order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=5 and
country='us' and year=2000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 POSTHOOK: Input: default@orc_split_elim_part@country=us/year=2000
@@ -489,38 +493,38 @@ POSTHOOK: Input: default@orc_split_elim_
 2	foo	0.8	1	1969-12-31 16:00:00
 5	eat	0.8	6	1969-12-31 16:00:20
 PREHOOK: query: -- 0 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and
country='in' order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and
country='in'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 #### A masked pattern was here ####
 POSTHOOK: query: -- 0 mapper - no split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and
country='in' order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and
country='in'
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 #### A masked pattern was here ####
-PREHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where
userid<=70 and country='us' and year=2002 order by userid
+PREHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where
userid<=70 and country='us' and year=2002
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 #### A masked pattern was here ####
-POSTHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where
userid<=70 and country='us' and year=2002 order by userid
+POSTHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where
userid<=70 and country='us' and year=2002
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 #### A masked pattern was here ####
 PREHOOK: query: -- 0 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and
country='in' order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and
country='in'
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 #### A masked pattern was here ####
 POSTHOOK: query: -- 0 mapper - split elimination
-select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and
country='in' order by userid
+select userid,string1,subtype,decimal1,ts from orc_split_elim_part where userid<=70 and
country='in'
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 #### A masked pattern was here ####
-PREHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where
userid<=70 and country='us' and year=2002 order by userid
+PREHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where
userid<=70 and country='us' and year=2002
 PREHOOK: type: QUERY
 PREHOOK: Input: default@orc_split_elim_part
 #### A masked pattern was here ####
-POSTHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where
userid<=70 and country='us' and year=2002 order by userid
+POSTHOOK: query: select userid,string1,subtype,decimal1,ts from orc_split_elim_part where
userid<=70 and country='us' and year=2002
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@orc_split_elim_part
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/parallel.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/parallel.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/parallel.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/parallel.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: create table if not exists src_a like src
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table if not exists src_a like src
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
-POSTHOOK: query: create table if not exists src_a like src
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table if not exists src_a like src
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@src_a
@@ -159,11 +163,11 @@ POSTHOOK: Lineage: src_a.key SIMPLE [(sr
 POSTHOOK: Lineage: src_a.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default),
]
 POSTHOOK: Lineage: src_b.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: src_b.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default),
]
-PREHOOK: query: select * from src_a order by key, value
+PREHOOK: query: select * from src_a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src_a
 #### A masked pattern was here ####
-POSTHOOK: query: select * from src_a order by key, value
+POSTHOOK: query: select * from src_a
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src_a
 #### A masked pattern was here ####
@@ -476,11 +480,11 @@ POSTHOOK: Input: default@src_a
 96	val_96
 97	val_97
 98	val_98
-PREHOOK: query: select * from src_b order by key, value
+PREHOOK: query: select * from src_b
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src_b
 #### A masked pattern was here ####
-POSTHOOK: query: select * from src_b order by key, value
+POSTHOOK: query: select * from src_b
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src_b
 #### A masked pattern was here ####
@@ -811,11 +815,11 @@ POSTHOOK: Lineage: src_a.key SIMPLE [(sr
 POSTHOOK: Lineage: src_a.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default),
]
 POSTHOOK: Lineage: src_b.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default),
]
 POSTHOOK: Lineage: src_b.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default),
]
-PREHOOK: query: select * from src_a order by key, value
+PREHOOK: query: select * from src_a
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src_a
 #### A masked pattern was here ####
-POSTHOOK: query: select * from src_a order by key, value
+POSTHOOK: query: select * from src_a
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src_a
 #### A masked pattern was here ####
@@ -1128,11 +1132,11 @@ POSTHOOK: Input: default@src_a
 96	val_96
 97	val_97
 98	val_98
-PREHOOK: query: select * from src_b order by key, value
+PREHOOK: query: select * from src_b
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src_b
 #### A masked pattern was here ####
-POSTHOOK: query: select * from src_b order by key, value
+POSTHOOK: query: select * from src_b
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src_b
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/parquet_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/parquet_partitioned.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/parquet_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/parquet_partitioned.q.out Fri May 30 17:37:05
2014
@@ -1,6 +1,10 @@
-PREHOOK: query: DROP TABLE parquet_partitioned_staging
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+DROP TABLE parquet_partitioned_staging
 PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE parquet_partitioned_staging
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+DROP TABLE parquet_partitioned_staging
 POSTHOOK: type: DROPTABLE
 PREHOOK: query: DROP TABLE parquet_partitioned
 PREHOOK: type: DROPTABLE
@@ -106,13 +110,13 @@ POSTHOOK: Lineage: parquet_partitioned P
 POSTHOOK: Lineage: parquet_partitioned PARTITION(part=part1).str SIMPLE [(parquet_partitioned_staging)parquet_partitioned_staging.FieldSchema(name:str,
type:string, comment:null), ]
 POSTHOOK: Lineage: parquet_partitioned PARTITION(part=part2).id SIMPLE [(parquet_partitioned_staging)parquet_partitioned_staging.FieldSchema(name:id,
type:int, comment:null), ]
 POSTHOOK: Lineage: parquet_partitioned PARTITION(part=part2).str SIMPLE [(parquet_partitioned_staging)parquet_partitioned_staging.FieldSchema(name:str,
type:string, comment:null), ]
-PREHOOK: query: SELECT * FROM parquet_partitioned ORDER BY id, str
+PREHOOK: query: SELECT * FROM parquet_partitioned
 PREHOOK: type: QUERY
 PREHOOK: Input: default@parquet_partitioned
 PREHOOK: Input: default@parquet_partitioned@part=part1
 PREHOOK: Input: default@parquet_partitioned@part=part2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM parquet_partitioned ORDER BY id, str
+POSTHOOK: query: SELECT * FROM parquet_partitioned
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@parquet_partitioned
 POSTHOOK: Input: default@parquet_partitioned@part=part1
@@ -135,13 +139,13 @@ POSTHOOK: Input: default@parquet_partiti
 #### A masked pattern was here ####
 part1	1
 part2	2
-PREHOOK: query: SELECT * FROM parquet_partitioned ORDER BY id, str
+PREHOOK: query: SELECT * FROM parquet_partitioned
 PREHOOK: type: QUERY
 PREHOOK: Input: default@parquet_partitioned
 PREHOOK: Input: default@parquet_partitioned@part=part1
 PREHOOK: Input: default@parquet_partitioned@part=part2
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM parquet_partitioned ORDER BY id, str
+POSTHOOK: query: SELECT * FROM parquet_partitioned
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@parquet_partitioned
 POSTHOOK: Input: default@parquet_partitioned@part=part1



Mime
View raw message