[
https://issues.apache.org/jira/browse/HIVE-4502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13679262#comment-13679262
]
Navis commented on HIVE-4502:
-----------------------------
Sorry to all. I've seen this assigned to Vikram days ago and completely forgot.
It's my bad to have missed the changed result of auto_sortmerge_join_6.q. And
I've looked into this today. It seemed another bug in trunk which does not
handle joining plan in some particular order. For example,
{noformat}
set hive.auto.convert.sortmerge.join=true;
set hive.optimize.bucketmapjoin = true;
set hive.optimize.bucketmapjoin.sortedmerge = true;
set hive.auto.convert.join=true;
set hive.auto.convert.join.noconditionaltask=true;
set hive.auto.convert.join.noconditionaltask.size=200;
set hive.auto.convert.sortmerge.join.to.mapjoin=false;
select * FROM tbl1 a JOIN tbl2 b ON a.key = b.key join src c on c.value =
a.value;
{noformat}
The above query is from auto_sortmerge_join_6.q and works well. But if we
change alias 'c' to 'd', it will fail. The former makes MAPJOIN first and JOIN
later but the latter makes JOIN first and MAPJOIN later, making strange plan
which does not work. I should fix that, too.
> NPE - subquery smb joins fails
> ------------------------------
>
> Key: HIVE-4502
> URL: https://issues.apache.org/jira/browse/HIVE-4502
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.11.0
> Reporter: Vikram Dixit K
> Assignee: Navis
> Attachments: HIVE-4502.D10695.1.patch, smb_mapjoin_25.q,
> smb_mapjoin_25.q
>
>
> Found this issue while running some SMB joins. Attaching test case that
> causes this error.
--
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
