[HIVE-2426] Test that views with joins work properly

• Type: Test
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Hadoop Flags: Reviewed
• Assignee: Charles Chen
• Reporter: Charles Chen
• Created: 02/Sep/11 05:43
• Updated: 02/May/13 02:29
• Resolved: 07/Sep/11 18:14

Description

With the testcase

drop table invites;
drop table invites2;
create table invites (foo int, bar string) partitioned by (ds string);
create table invites2 (foo int, bar string) partitioned by (ds string);

set hive.mapred.mode=strict;

-- test join views: see HIVE-1989

create view v as select invites.bar, invites2.foo, invites2.ds from invites join invites2 on invites.ds=invites2.ds;

explain select * from v where ds='2011-09-01';

drop view v;
drop table invites;
drop table invites2;

We should not have the partition pruner complain about invites.ds not having a predicate because the predicate invites2.ds='2011-09-01' will be inferred with the ppd transitivity optimization

Issue Links

• depends upon: HIVE-1989 recognize transitivity of predicates on join keys