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