hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1598678 [28/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/subquery_in_having.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_in_having.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_in_having.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_in_having.q.out Fri May 30 17:37:05
2014
@@ -1,4 +1,6 @@
-PREHOOK: query: -- data setup
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- data setup
 CREATE TABLE part( 
     p_partkey INT,
     p_name STRING,
@@ -12,7 +14,9 @@ CREATE TABLE part( 
 )
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
-POSTHOOK: query: -- data setup
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- data setup
 CREATE TABLE part( 
     p_partkey INT,
     p_name STRING,
@@ -186,11 +190,11 @@ STAGE PLANS:
       Processor Tree:
         ListSink
 
-PREHOOK: query: select s1.key, count(*) from src s1 where s1.key > '9' group by s1.key
order by s1.key
+PREHOOK: query: select s1.key, count(*) from src s1 where s1.key > '9' group by s1.key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
-POSTHOOK: query: select s1.key, count(*) from src s1 where s1.key > '9' group by s1.key
order by s1.key
+POSTHOOK: query: select s1.key, count(*) from src s1 where s1.key > '9' group by s1.key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -204,7 +208,6 @@ PREHOOK: query: select key, count(*) 
 from src 
 group by key
 having count(*) in (select count(*) from src s1 where s1.key = '90' group by s1.key )
-order by key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -212,7 +215,6 @@ POSTHOOK: query: select key, count(*) 
 from src 
 group by key
 having count(*) in (select count(*) from src s1 where s1.key = '90' group by s1.key )
-order by key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -567,7 +569,6 @@ having b.key in ( select a.key
                 from src a
                 where a.value > 'val_9' and a.value = min(b.value)
                 )
-order by b.key
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
@@ -579,7 +580,6 @@ having b.key in ( select a.key
                 from src a
                 where a.value > 'val_9' and a.value = min(b.value)
                 )
-order by b.key
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out Fri May 30 17:37:05
2014
@@ -1,4 +1,6 @@
-PREHOOK: query: -- exists test
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- exists test
 create view cv1 as 
 select * 
 from src b 
@@ -8,7 +10,9 @@ where exists
   where b.value = a.value  and a.key = b.key and a.value > 'val_9')
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@src
-POSTHOOK: query: -- exists test
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- exists test
 create view cv1 as 
 select * 
 from src b 
@@ -20,13 +24,13 @@ POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@cv1
 PREHOOK: query: select * 
-from cv1 where cv1.key in (select key from cv1 c where c.key > '95') order by key
+from cv1 where cv1.key in (select key from cv1 c where c.key > '95')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@cv1
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
 POSTHOOK: query: select * 
-from cv1 where cv1.key in (select key from cv1 c where c.key > '95') order by key
+from cv1 where cv1.key in (select key from cv1 c where c.key > '95')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@cv1
 POSTHOOK: Input: default@src
@@ -59,16 +63,16 @@ where b.key not in
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@cv2
-Warning: Shuffle Join JOIN[42][tables = [b, sq_1_notin_nullcheck]] in Stage 'Stage-6:MAPRED'
is a cross product
+Warning: Shuffle Join JOIN[42][tables = [b, sq_1_notin_nullcheck]] in Stage 'Stage-5:MAPRED'
is a cross product
 Warning: Shuffle Join JOIN[18][tables = [b, sq_1_notin_nullcheck]] in Stage 'Stage-1:MAPRED'
is a cross product
 PREHOOK: query: select * 
-from cv2 where cv2.key in (select key from cv2 c where c.key < '11') order by key
+from cv2 where cv2.key in (select key from cv2 c where c.key < '11')
 PREHOOK: type: QUERY
 PREHOOK: Input: default@cv2
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
 POSTHOOK: query: select * 
-from cv2 where cv2.key in (select key from cv2 c where c.key < '11') order by key
+from cv2 where cv2.key in (select key from cv2 c where c.key < '11')
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@cv2
 POSTHOOK: Input: default@src
@@ -103,12 +107,12 @@ having count(*) in (select count(*) from
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@cv3
-PREHOOK: query: select * from cv3 order by key
+PREHOOK: query: select * from cv3
 PREHOOK: type: QUERY
 PREHOOK: Input: default@cv3
 PREHOOK: Input: default@src
 #### A masked pattern was here ####
-POSTHOOK: query: select * from cv3 order by key
+POSTHOOK: query: select * from cv3
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@cv3
 POSTHOOK: Input: default@src
@@ -130,7 +134,7 @@ POSTHOOK: Input: default@src
 PREHOOK: query: -- join of subquery views
 select *
 from cv3
-where cv3.key in (select key from cv1) order by key
+where cv3.key in (select key from cv1)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@cv1
 PREHOOK: Input: default@cv3
@@ -139,7 +143,7 @@ PREHOOK: Input: default@src
 POSTHOOK: query: -- join of subquery views
 select *
 from cv3
-where cv3.key in (select key from cv1) order by key
+where cv3.key in (select key from cv1)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@cv1
 POSTHOOK: Input: default@cv3

Modified: hive/trunk/ql/src/test/results/clientpositive/tez/bucket2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/bucket2.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/bucket2.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/tez/bucket2.q.out
Fri May 30 17:37:05 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/tez/bucket3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/bucket3.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/bucket3.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/tez/bucket3.q.out
Fri May 30 17:37:05 2014 differ

Modified: hive/trunk/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out Fri
May 30 17:37:05 2014
@@ -1,9 +1,13 @@
-PREHOOK: query: CREATE TABLE src1_rot13_iof(key STRING, value STRING) 
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE src1_rot13_iof(key STRING, value STRING)
   STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.udf.Rot13InputFormat'
             OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.udf.Rot13OutputFormat'
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
-POSTHOOK: query: CREATE TABLE src1_rot13_iof(key STRING, value STRING) 
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE src1_rot13_iof(key STRING, value STRING)
   STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.udf.Rot13InputFormat'
             OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.udf.Rot13OutputFormat'
 POSTHOOK: type: CREATETABLE
@@ -19,11 +23,11 @@ key                 	string             
 value               	string              	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: SELECT * FROM src1 ORDER BY key, value
+PREHOOK: query: SELECT * FROM src1
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM src1 ORDER BY key, value
+POSTHOOK: query: SELECT * FROM src1
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src1
 #### A masked pattern was here ####
@@ -62,11 +66,11 @@ POSTHOOK: Input: default@src1
 POSTHOOK: Output: default@src1_rot13_iof
 POSTHOOK: Lineage: src1_rot13_iof.key SIMPLE [(src1)src1.FieldSchema(name:key, type:string,
comment:default), ]
 POSTHOOK: Lineage: src1_rot13_iof.value SIMPLE [(src1)src1.FieldSchema(name:value, type:string,
comment:default), ]
-PREHOOK: query: SELECT * FROM src1_rot13_iof ORDER BY key, value
+PREHOOK: query: SELECT * FROM src1_rot13_iof
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src1_rot13_iof
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM src1_rot13_iof ORDER BY key, value
+POSTHOOK: query: SELECT * FROM src1_rot13_iof
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src1_rot13_iof
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/tez/insert1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert1.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert1.q.out Fri May 30 17:37:05 2014
@@ -1,7 +1,11 @@
-PREHOOK: query: create table insert1(key int, value string) stored as textfile
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table insert1(key int, value string) stored as textfile
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
-POSTHOOK: query: create table insert1(key int, value string) stored as textfile
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table insert1(key int, value string) stored as textfile
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@insert1
@@ -256,10 +260,10 @@ POSTHOOK: type: QUERY
 STAGE DEPENDENCIES:
   Stage-2 is a root stage
   Stage-3 depends on stages: Stage-2
-  Stage-1 depends on stages: Stage-3
-  Stage-4 depends on stages: Stage-1
   Stage-0 depends on stages: Stage-3
-  Stage-5 depends on stages: Stage-0
+  Stage-4 depends on stages: Stage-0
+  Stage-1 depends on stages: Stage-3
+  Stage-5 depends on stages: Stage-1
 
 STAGE PLANS:
   Stage: Stage-2
@@ -305,28 +309,28 @@ STAGE PLANS:
   Stage: Stage-3
     Dependency Collection
 
-  Stage: Stage-1
+  Stage: Stage-0
     Move Operator
       tables:
-          replace: true
+          replace: false
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-              name: x.insert1
+              name: default.insert1
 
   Stage: Stage-4
     Stats-Aggr Operator
 
-  Stage: Stage-0
+  Stage: Stage-1
     Move Operator
       tables:
-          replace: false
+          replace: true
           table:
               input format: org.apache.hadoop.mapred.TextInputFormat
               output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
               serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-              name: default.insert1
+              name: x.insert1
 
   Stage: Stage-5
     Stats-Aggr Operator
@@ -366,11 +370,11 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: db2@result
 POSTHOOK: Lineage: result.col1 SIMPLE []
-PREHOOK: query: SELECT * FROM result order by col1
+PREHOOK: query: SELECT * FROM result
 PREHOOK: type: QUERY
 PREHOOK: Input: db2@result
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM result order by col1
+POSTHOOK: query: SELECT * FROM result
 POSTHOOK: type: QUERY
 POSTHOOK: Input: db2@result
 #### A masked pattern was here ####
@@ -409,11 +413,11 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: db1@result
 POSTHOOK: Lineage: result.col1 SIMPLE []
-PREHOOK: query: SELECT * FROM db1.result order by col1
+PREHOOK: query: SELECT * FROM db1.result
 PREHOOK: type: QUERY
 PREHOOK: Input: db1@result
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM db1.result order by col1
+POSTHOOK: query: SELECT * FROM db1.result
 POSTHOOK: type: QUERY
 POSTHOOK: Input: db1@result
 #### A masked pattern was here ####

Modified: hive/trunk/ql/src/test/results/clientpositive/tez/leftsemijoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/leftsemijoin.q.out?rev=1598678&r1=1598677&r2=1598678&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/leftsemijoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/leftsemijoin.q.out Fri May 30 17:37:05
2014
@@ -1,6 +1,10 @@
-PREHOOK: query: drop table sales
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+drop table sales
 PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table sales
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+drop table sales
 POSTHOOK: type: DROPTABLE
 PREHOOK: query: drop table things
 PREHOOK: type: DROPTABLE
@@ -50,23 +54,23 @@ POSTHOOK: type: LOAD
 #### A masked pattern was here ####
 POSTHOOK: Output: default@things
 POSTHOOK: Output: default@things@ds=2011-10-24
-PREHOOK: query: SELECT name,id FROM sales ORDER BY name ASC, id ASC
+PREHOOK: query: SELECT name,id FROM sales
 PREHOOK: type: QUERY
 PREHOOK: Input: default@sales
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT name,id FROM sales ORDER BY name ASC, id ASC
+POSTHOOK: query: SELECT name,id FROM sales
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@sales
 #### A masked pattern was here ####
 Hank	2
 Joe	2
-PREHOOK: query: SELECT id,name FROM things ORDER BY id ASC, name ASC
+PREHOOK: query: SELECT id,name FROM things
 PREHOOK: type: QUERY
 PREHOOK: Input: default@things
 PREHOOK: Input: default@things@ds=2011-10-23
 PREHOOK: Input: default@things@ds=2011-10-24
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT id,name FROM things ORDER BY id ASC, name ASC
+POSTHOOK: query: SELECT id,name FROM things
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@things
 POSTHOOK: Input: default@things@ds=2011-10-23
@@ -74,14 +78,14 @@ POSTHOOK: Input: default@things@ds=2011-
 #### A masked pattern was here ####
 2	Tie
 2	Tie
-PREHOOK: query: SELECT name,id FROM sales LEFT SEMI JOIN things ON (sales.id = things.id)
ORDER BY name ASC, id ASC
+PREHOOK: query: SELECT name,id FROM sales LEFT SEMI JOIN things ON (sales.id = things.id)
 PREHOOK: type: QUERY
 PREHOOK: Input: default@sales
 PREHOOK: Input: default@things
 PREHOOK: Input: default@things@ds=2011-10-23
 PREHOOK: Input: default@things@ds=2011-10-24
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT name,id FROM sales LEFT SEMI JOIN things ON (sales.id = things.id)
ORDER BY name ASC, id ASC
+POSTHOOK: query: SELECT name,id FROM sales LEFT SEMI JOIN things ON (sales.id = things.id)
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@sales
 POSTHOOK: Input: default@things



Mime
View raw message