hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2426) Test that views with joins work properly
Date Thu, 08 Sep 2011 00:10:10 GMT

    [ https://issues.apache.org/jira/browse/HIVE-2426?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13099674#comment-13099674
] 

Hudson commented on HIVE-2426:
------------------------------

Integrated in Hive-trunk-h0.21 #940 (See [https://builds.apache.org/job/Hive-trunk-h0.21/940/])
    HIVE-2426. Test that views with joins work properly.
(Charles Chen via jvs)

jvs : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1166293
Files : 
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/UnparseTranslator.java
* /hive/trunk/ql/src/test/queries/clientpositive/join_view.q
* /hive/trunk/ql/src/test/results/clientpositive/join_view.q.out


> 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

        

Mime
View raw message