hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From na...@apache.org
Subject svn commit: r1438934 - in /hive/trunk/ql/src/test: queries/clientpositive/join_filters_overlap.q results/clientpositive/join_filters_overlap.q.out
Date Sat, 26 Jan 2013 18:22:24 GMT
Author: namit
Date: Sat Jan 26 18:22:24 2013
New Revision: 1438934

URL: http://svn.apache.org/viewvc?rev=1438934&view=rev
Log:
HIVE-3923 join_filters_overlap.q fails on 0.23
(Sushanth Sowmyan via namit)


Modified:
    hive/trunk/ql/src/test/queries/clientpositive/join_filters_overlap.q
    hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out

Modified: hive/trunk/ql/src/test/queries/clientpositive/join_filters_overlap.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/join_filters_overlap.q?rev=1438934&r1=1438933&r2=1438934&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/join_filters_overlap.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/join_filters_overlap.q Sat Jan 26 18:22:24
2013
@@ -5,17 +5,17 @@ create table a as SELECT 100 as key, a.v
 -- overlap on a
 explain extended select * from a left outer join a b on (a.key=b.key AND a.value=50 AND b.value=50)
left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60);
 select * from a left outer join a b on (a.key=b.key AND a.value=50 AND b.value=50) left outer
join a c on (a.key=c.key AND a.value=60 AND c.value=60);
-select /*+ MAPJOIN(b,c)*/ * from a left outer join a b on (a.key=b.key AND a.value=50 AND
b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60);
+select /*+ MAPJOIN(b,c)*/ * from a left outer join a b on (a.key=b.key AND a.value=50 AND
b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60) order by a.key
ASC, a.value ASC;
 
 -- overlap on b
 explain extended select * from a right outer join a b on (a.key=b.key AND a.value=50 AND
b.value=50) left outer join a c on (b.key=c.key AND b.value=60 AND c.value=60);
 select * from a right outer join a b on (a.key=b.key AND a.value=50 AND b.value=50) left
outer join a c on (b.key=c.key AND b.value=60 AND c.value=60);
-select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key AND a.value=50 AND
b.value=50) left outer join a c on (b.key=c.key AND b.value=60 AND c.value=60);
+select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key AND a.value=50 AND
b.value=50) left outer join a c on (b.key=c.key AND b.value=60 AND c.value=60) order by b.key
ASC, b.value ASC;
 
 -- overlap on b with two filters for each
 explain extended select * from a right outer join a b on (a.key=b.key AND a.value=50 AND
b.value=50 AND b.value>10) left outer join a c on (b.key=c.key AND b.value=60 AND b.value>20
AND c.value=60);
 select * from a right outer join a b on (a.key=b.key AND a.value=50 AND b.value=50 AND b.value>10)
left outer join a c on (b.key=c.key AND b.value=60 AND b.value>20 AND c.value=60);
-select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key AND a.value=50 AND
b.value=50 AND b.value>10) left outer join a c on (b.key=c.key AND b.value=60 AND b.value>20
AND c.value=60);
+select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key AND a.value=50 AND
b.value=50 AND b.value>10) left outer join a c on (b.key=c.key AND b.value=60 AND b.value>20
AND c.value=60) order by b.key ASC, b.value ASC;
 
 -- overlap on a, b
 explain extended select * from a full outer join a b on (a.key=b.key AND a.value=50 AND b.value=50)
left outer join a c on (b.key=c.key AND b.value=60 AND c.value=60) left outer join a d on
(a.key=d.key AND a.value=40 AND d.value=40);
@@ -24,4 +24,4 @@ select * from a full outer join a b on (
 -- triple overlap on a
 explain extended select * from a left outer join a b on (a.key=b.key AND a.value=50 AND b.value=50)
left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60) left outer join a d on
(a.key=d.key AND a.value=40 AND d.value=40);
 select * from a left outer join a b on (a.key=b.key AND a.value=50 AND b.value=50) left outer
join a c on (a.key=c.key AND a.value=60 AND c.value=60) left outer join a d on (a.key=d.key
AND a.value=40 AND d.value=40);
-select /*+ MAPJOIN(b,c, d)*/ * from a left outer join a b on (a.key=b.key AND a.value=50
AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60) left outer
join a d on (a.key=d.key AND a.value=40 AND d.value=40);
+select /*+ MAPJOIN(b,c, d)*/ * from a left outer join a b on (a.key=b.key AND a.value=50
AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60) left outer
join a d on (a.key=d.key AND a.value=40 AND d.value=40) order by a.key ASC, a.value ASC;

Modified: hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out?rev=1438934&r1=1438933&r2=1438934&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out Sat Jan 26 18:22:24
2013
@@ -204,11 +204,11 @@ POSTHOOK: Input: default@a
 100	40	NULL	NULL	NULL	NULL
 100	50	100	50	NULL	NULL
 100	60	NULL	NULL	100	60
-PREHOOK: query: select /*+ MAPJOIN(b,c)*/ * from a left outer join a b on (a.key=b.key AND
a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60)
+PREHOOK: query: select /*+ MAPJOIN(b,c)*/ * from a left outer join a b on (a.key=b.key AND
a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60)
order by a.key ASC, a.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@a
 #### A masked pattern was here ####
-POSTHOOK: query: select /*+ MAPJOIN(b,c)*/ * from a left outer join a b on (a.key=b.key AND
a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60)
+POSTHOOK: query: select /*+ MAPJOIN(b,c)*/ * from a left outer join a b on (a.key=b.key AND
a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60)
order by a.key ASC, a.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@a
 #### A masked pattern was here ####
@@ -410,11 +410,11 @@ POSTHOOK: Input: default@a
 NULL	NULL	100	40	NULL	NULL
 100	50	100	50	NULL	NULL
 NULL	NULL	100	60	100	60
-PREHOOK: query: select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key AND
a.value=50 AND b.value=50) left outer join a c on (b.key=c.key AND b.value=60 AND c.value=60)
+PREHOOK: query: select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key AND
a.value=50 AND b.value=50) left outer join a c on (b.key=c.key AND b.value=60 AND c.value=60)
order by b.key ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@a
 #### A masked pattern was here ####
-POSTHOOK: query: select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key
AND a.value=50 AND b.value=50) left outer join a c on (b.key=c.key AND b.value=60 AND c.value=60)
+POSTHOOK: query: select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key
AND a.value=50 AND b.value=50) left outer join a c on (b.key=c.key AND b.value=60 AND c.value=60)
order by b.key ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@a
 #### A masked pattern was here ####
@@ -616,11 +616,11 @@ POSTHOOK: Input: default@a
 NULL	NULL	100	40	NULL	NULL
 100	50	100	50	NULL	NULL
 NULL	NULL	100	60	100	60
-PREHOOK: query: select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key AND
a.value=50 AND b.value=50 AND b.value>10) left outer join a c on (b.key=c.key AND b.value=60
AND b.value>20 AND c.value=60)
+PREHOOK: query: select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key AND
a.value=50 AND b.value=50 AND b.value>10) left outer join a c on (b.key=c.key AND b.value=60
AND b.value>20 AND c.value=60) order by b.key ASC, b.value ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@a
 #### A masked pattern was here ####
-POSTHOOK: query: select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key
AND a.value=50 AND b.value=50 AND b.value>10) left outer join a c on (b.key=c.key AND b.value=60
AND b.value>20 AND c.value=60)
+POSTHOOK: query: select /*+ MAPJOIN(a,c)*/ * from a right outer join a b on (a.key=b.key
AND a.value=50 AND b.value=50 AND b.value>10) left outer join a c on (b.key=c.key AND b.value=60
AND b.value>20 AND c.value=60) order by b.key ASC, b.value ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@a
 #### A masked pattern was here ####
@@ -1085,11 +1085,11 @@ POSTHOOK: Input: default@a
 100	40	NULL	NULL	NULL	NULL	100	40
 100	50	100	50	NULL	NULL	NULL	NULL
 100	60	NULL	NULL	100	60	NULL	NULL
-PREHOOK: query: select /*+ MAPJOIN(b,c, d)*/ * from a left outer join a b on (a.key=b.key
AND a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60)
left outer join a d on (a.key=d.key AND a.value=40 AND d.value=40)
+PREHOOK: query: select /*+ MAPJOIN(b,c, d)*/ * from a left outer join a b on (a.key=b.key
AND a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60)
left outer join a d on (a.key=d.key AND a.value=40 AND d.value=40) order by a.key ASC, a.value
ASC
 PREHOOK: type: QUERY
 PREHOOK: Input: default@a
 #### A masked pattern was here ####
-POSTHOOK: query: select /*+ MAPJOIN(b,c, d)*/ * from a left outer join a b on (a.key=b.key
AND a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60)
left outer join a d on (a.key=d.key AND a.value=40 AND d.value=40)
+POSTHOOK: query: select /*+ MAPJOIN(b,c, d)*/ * from a left outer join a b on (a.key=b.key
AND a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60)
left outer join a d on (a.key=d.key AND a.value=40 AND d.value=40) order by a.key ASC, a.value
ASC
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@a
 #### A masked pattern was here ####



Mime
View raw message