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/04/08 02:19:13 UTC
svn commit: r1585631 [10/13] - in /hive/trunk/ql/src/test:
queries/clientpositive/ results/clientpositive/ results/clientpositive/tez/
Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_in.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_in.q.out?rev=1585631&r1=1585630&r2=1585631&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_in.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_in.q.out Tue Apr 8 00:19:11 2014
@@ -172,12 +172,14 @@ STAGE PLANS:
PREHOOK: query: select *
from src
where src.key in (select key from src s1 where s1.key > '9')
+order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: select *
from src
where src.key in (select key from src s1 where s1.key > '9')
+order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -284,6 +286,7 @@ where b.key in
from src a
where b.value = a.value and a.key > '9'
)
+order by b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -294,6 +297,7 @@ where b.key in
from src a
where b.value = a.value and a.key > '9'
)
+order by b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -454,6 +458,7 @@ part where part.p_size in
from (select p_size, rank() over(partition by p_mfgr order by p_size) as r from part) a
where r <= 2
)
+order by p_name
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
@@ -464,11 +469,12 @@ part where part.p_size in
from (select p_size, rank() over(partition by p_mfgr order by p_size) as r from part) a
where r <= 2
)
+order by p_name
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-almond antique salmon chartreuse burlywood 6
almond antique medium spring khaki 6
+almond antique salmon chartreuse burlywood 6
PREHOOK: query: -- agg, corr
explain
select p_mfgr, p_name, p_size
@@ -616,6 +622,7 @@ from part b where b.p_size in
from (select p_mfgr, p_size, rank() over(partition by p_mfgr order by p_size) as r from part) a
where r <= 2 and b.p_mfgr = a.p_mfgr
)
+order by p_mfgr, p_name, p_size
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
@@ -625,15 +632,16 @@ from part b where b.p_size in
from (select p_mfgr, p_size, rank() over(partition by p_mfgr order by p_size) as r from part) a
where r <= 2 and b.p_mfgr = a.p_mfgr
)
+order by p_mfgr, p_name, p_size
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#3 almond antique misty red olive 1
Manufacturer#1 almond antique burnished rose metallic 2
Manufacturer#1 almond antique burnished rose metallic 2
Manufacturer#2 almond aquamarine midnight light salmon 2
-Manufacturer#5 almond antique sky peru orange 2
+Manufacturer#3 almond antique misty red olive 1
Manufacturer#4 almond aquamarine yellow dodger mint 7
+Manufacturer#5 almond antique sky peru orange 2
PREHOOK: query: -- distinct, corr
explain
select *
@@ -758,6 +766,7 @@ where b.key in
from src a
where b.value = a.value and a.key > '9'
)
+order by b.key
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
@@ -768,6 +777,7 @@ where b.key in
from src a
where b.value = a.value and a.key > '9'
)
+order by b.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -787,6 +797,7 @@ select p_mfgr, p_name, p_size
from part
where part.p_size in
(select first_value(p_size) over(partition by p_mfgr order by p_size) from part)
+order by p_mfgr, p_name, p_size
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
@@ -795,15 +806,16 @@ select p_mfgr, p_name, p_size
from part
where part.p_size in
(select first_value(p_size) over(partition by p_mfgr order by p_size) from part)
+order by p_mfgr, p_name, p_size
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
-Manufacturer#3 almond antique misty red olive 1
Manufacturer#1 almond antique burnished rose metallic 2
Manufacturer#1 almond antique burnished rose metallic 2
-Manufacturer#5 almond antique sky peru orange 2
Manufacturer#2 almond aquamarine midnight light salmon 2
+Manufacturer#3 almond antique misty red olive 1
Manufacturer#4 almond aquamarine yellow dodger mint 7
+Manufacturer#5 almond antique sky peru orange 2
PREHOOK: query: -- non agg, non corr, with join in Parent Query
explain
select p.p_partkey, li.l_suppkey
@@ -959,6 +971,7 @@ PREHOOK: query: select p.p_partkey, li.l
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR')
+order by p.p_partkey, li.l_suppkey
PREHOOK: type: QUERY
PREHOOK: Input: default@lineitem
#### A masked pattern was here ####
@@ -966,24 +979,26 @@ POSTHOOK: query: select p.p_partkey, li.
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR')
+order by p.p_partkey, li.l_suppkey
POSTHOOK: type: QUERY
POSTHOOK: Input: default@lineitem
#### A masked pattern was here ####
-155190 7706
+2320 9821
4297 1798
-108570 8571
-82704 7721
+40216 217
61336 8855
-2320 9821
+64128 9141
+82704 7721
+108570 8571
115118 7630
115209 7721
-64128 9141
-40216 217
+155190 7706
PREHOOK: query: -- non agg, corr, with join in Parent Query
select p.p_partkey, li.l_suppkey
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber)
+order by p.p_partkey, li.l_suppkey
PREHOOK: type: QUERY
PREHOOK: Input: default@lineitem
#### A masked pattern was here ####
@@ -992,6 +1007,7 @@ select p.p_partkey, li.l_suppkey
from (select distinct l_partkey as p_partkey from lineitem) p join lineitem li on p.p_partkey = li.l_partkey
where li.l_linenumber = 1 and
li.l_orderkey in (select l_orderkey from lineitem where l_shipmode = 'AIR' and l_linenumber = li.l_linenumber)
+order by p.p_partkey, li.l_suppkey
POSTHOOK: type: QUERY
POSTHOOK: Input: default@lineitem
#### A masked pattern was here ####
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=1585631&r1=1585630&r2=1585631&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 Tue Apr 8 00:19:11 2014
@@ -184,11 +184,11 @@ STAGE PLANS:
Fetch Operator
limit: -1
-PREHOOK: query: select s1.key, count(*) from src s1 where s1.key > '9' group by s1.key
+PREHOOK: query: select s1.key, count(*) from src s1 where s1.key > '9' group by s1.key order 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
+POSTHOOK: query: select s1.key, count(*) from src s1 where s1.key > '9' group by s1.key order by s1.key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
@@ -202,6 +202,7 @@ 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 ####
@@ -209,40 +210,41 @@ 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 ####
-409 3
+0 3
+119 3
+128 3
+167 3
187 3
-403 3
-396 3
-384 3
+193 3
+199 3
+208 3
+273 3
+298 3
+311 3
+316 3
+318 3
+327 3
+35 3
369 3
+384 3
+396 3
+403 3
+409 3
+417 3
+430 3
+431 3
+438 3
+454 3
+466 3
+480 3
498 3
5 3
-35 3
-327 3
-167 3
-318 3
-316 3
-311 3
-298 3
70 3
90 3
-128 3
-273 3
-208 3
-199 3
-193 3
-0 3
-119 3
-480 3
-466 3
-454 3
-438 3
-431 3
-430 3
-417 3
PREHOOK: query: -- non agg, corr
explain
select key, value, count(*)
@@ -559,6 +561,7 @@ 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 ####
@@ -570,6 +573,7 @@ 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=1585631&r1=1585630&r2=1585631&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 Tue Apr 8 00:19:11 2014
@@ -20,13 +20,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')
+from cv1 where cv1.key in (select key from cv1 c where c.key > '95') order by key
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')
+from cv1 where cv1.key in (select key from cv1 c where c.key > '95') order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@cv1
POSTHOOK: Input: default@src
@@ -59,16 +59,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-5:MAPRED' is a cross product
+Warning: Shuffle Join JOIN[42][tables = [b, sq_1_notin_nullcheck]] in Stage 'Stage-6: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')
+from cv2 where cv2.key in (select key from cv2 c where c.key < '11') order by key
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')
+from cv2 where cv2.key in (select key from cv2 c where c.key < '11') order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@cv2
POSTHOOK: Input: default@src
@@ -103,34 +103,34 @@ having count(*) in (select count(*) from
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
POSTHOOK: Output: default@cv3
-PREHOOK: query: select * from cv3
+PREHOOK: query: select * from cv3 order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@cv3
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: select * from cv3
+POSTHOOK: query: select * from cv3 order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@cv3
POSTHOOK: Input: default@src
#### A masked pattern was here ####
80 val_80 1
82 val_82 1
+83 val_83 2
+84 val_84 2
85 val_85 1
86 val_86 1
87 val_87 1
9 val_9 1
+90 val_90 3
92 val_92 1
+95 val_95 2
96 val_96 1
-83 val_83 2
-84 val_84 2
97 val_97 2
-95 val_95 2
98 val_98 2
-90 val_90 3
PREHOOK: query: -- join of subquery views
select *
from cv3
-where cv3.key in (select key from cv1)
+where cv3.key in (select key from cv1) order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@cv1
PREHOOK: Input: default@cv3
@@ -139,7 +139,7 @@ PREHOOK: Input: default@src
POSTHOOK: query: -- join of subquery views
select *
from cv3
-where cv3.key in (select key from cv1)
+where cv3.key in (select key from cv1) order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@cv1
POSTHOOK: Input: default@cv3