Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Wed, 7 Sep 2011 00:23:09 +0000 (UTC)
From: "John Sichi (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: 
 <177498838.22974.1315354989953.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1343122009.9475.1314942309798.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Updated] (HIVE-2426) Test that views with joins work
 properly
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/HIVE-2426?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Sichi updated HIVE-2426:
-----------------------------

    Attachment: HIVE-2426.3.patch

Made a few minor improvements to the overlap handling code and comments.

> 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