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
