Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 6 Nov 2012 10:50:13 +0000 (UTC)
From: "Namit Jain (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <960087483.73949.1352199013314.JavaMail.jiratomcat@arcas>
In-Reply-To: <819998108.71085.1352156412161.JavaMail.jiratomcat@arcas>
Subject: [jira] [Updated] (HIVE-3673) Sort merge join not used when join
 columns have different names
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Namit Jain updated HIVE-3673:
-----------------------------

       Resolution: Fixed
    Fix Version/s: 0.10.0
     Hadoop Flags: Reviewed
           Status: Resolved  (was: Patch Available)

Committed. Thanks Kevin
                
> Sort merge join not used when join columns have different names
> ---------------------------------------------------------------
>
>                 Key: HIVE-3673
>                 URL: https://issues.apache.org/jira/browse/HIVE-3673
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.10.0
>            Reporter: Kevin Wilfong
>            Assignee: Kevin Wilfong
>             Fix For: 0.10.0
>
>         Attachments: HIVE-3673.1.patch.txt, HIVE-3673.2.patch.txt
>
>
> If two tables are joined on columns with different names, the sort merge join optimization is not applied.  E.g.
> SELECT /*+ MAPJOIN(b) */ * FROM t1 a JOIN t2 b ON a.key = b.value;
> This will not use sort merge join even if t1 and t2 are bucketed and sorted by key, value respectively.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira