Return-Path: 
 <dev-return-36269-apmail-hive-dev-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-dev-archive@www.apache.org
Delivered-To: apmail-hive-dev-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 38B14D346
	for <apmail-hive-dev-archive@www.apache.org>;
 Thu, 19 Jul 2012 07:59:38 +0000 (UTC)
Received: (qmail 67997 invoked by uid 500); 19 Jul 2012 07:59:37 -0000
Delivered-To: apmail-hive-dev-archive@hive.apache.org
Received: (qmail 67678 invoked by uid 500); 19 Jul 2012 07:59:36 -0000
Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@hive.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@hive.apache.org>
List-Post: <mailto:dev@hive.apache.org>
List-Id: <dev.hive.apache.org>
Reply-To: dev@hive.apache.org
Delivered-To: mailing list dev@hive.apache.org
Received: (qmail 67630 invoked by uid 500); 19 Jul 2012 07:59:35 -0000
Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org
Received: (qmail 67622 invoked by uid 99); 19 Jul 2012 07:59:35 -0000
Received: from issues-vm.apache.org (HELO issues-vm) (140.211.11.160)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jul 2012 07:59:35 +0000
Received: from isssues-vm.apache.org (localhost [127.0.0.1])
	by issues-vm (Postfix) with ESMTP id D7758141BF8
	for <hive-dev@hadoop.apache.org>; Thu, 19 Jul 2012 07:59:34 +0000 (UTC)
Date: Thu, 19 Jul 2012 07:59:34 +0000 (UTC)
From: "Navis (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <146390424.74859.1342684774886.JavaMail.jiratomcat@issues-vm>
In-Reply-To: <539802858.21057.1338457585178.JavaMail.jiratomcat@issues-vm>
Subject: [jira] [Updated] (HIVE-3070) Filter on outer join condition removed
 while merging join tree
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


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

Navis updated HIVE-3070:
------------------------

    Affects Version/s: 0.10.0
                       0.9.0
             Assignee: Navis
              Summary: Filter on outer join condition removed while merging join tree  (was: outer join with filter over multiple tables on the same column have bug)
    
> Filter on outer join condition removed while merging join tree
> --------------------------------------------------------------
>
>                 Key: HIVE-3070
>                 URL: https://issues.apache.org/jira/browse/HIVE-3070
>             Project: Hive
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 0.8.1, 0.9.0, 0.10.0
>            Reporter: Zhang Xinyu
>            Assignee: Navis
>
> should the result of query A: 
> select s.aa, s.bb, c.key keyc from (select a.key aa, b.key bb from src a left outer join src b on a.key=b.key) s left outer join src c on s.bb=c.key and s.bb<10 where s.aa<20;
> be the same as query B:
> select a.key keya, b.key keyb, c.key keyc from src a left outer join src b on a.key=b.key left outer join src c on b.key=c.key and b.key<10 where a.key<20;
> ?
> Currently, the result is different, query B gets wrong result!
> In SemanticAnalyzer.java, mergeJoins():
> ArrayList<ArrayList<ASTNode>> filters = target.getFilters();
> for (int i = 0; i < nodeRightAliases.length; i++) {
>   filters.add(node.getFilters().get(i + 1));
> }
> filters in node.getFilters().get(0) are lost.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira