Kevin Wilfong created HIVE-3673: ----------------------------------- Summary: 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
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