[ https://issues.apache.org/jira/browse/HIVE-2426?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John Sichi updated HIVE-2426: ----------------------------- Resolution: Fixed Hadoop Flags: [Reviewed] Status: Resolved (was: Patch Available) +1, passed tests, committed to trunk. Thanks Charles! > 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 > Fix For: 0.9.0 > > Attachments: HIVE-2426.3.patch, 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