Test that views with joins work properly
----------------------------------------
Key: HIVE-2426
URL: https://issues.apache.org/jira/browse/HIVE-2426
Project: Hive
Issue Type: Test
Reporter: Charles Chen
With the testcase
{noformat}
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;
{noformat}
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
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
