hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Charles Chen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-2426) Test that views with joins work properly
Date Fri, 02 Sep 2011 05:45:09 GMT
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

        

Mime
View raw message