[
https://issues.apache.org/jira/browse/HIVE-2426?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Charles Chen updated HIVE-2426:
-------------------------------
Attachment: HIVE-2426v2.patch
> 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
> Assignee: Charles Chen
> Attachments: HIVE-2426v2.patch
>
>
> 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
