[
https://issues.apache.org/jira/browse/HIVE-3891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13589253#comment-13589253
]
Namit Jain commented on HIVE-3891:
----------------------------------
[~vikram.dixit], I am confused.
Look at line 965 of auto_sortmerge_join_1.q.out, it is a SMB.
Going in more detail: (line 486-492)
Stage-5 is a root stage , consists of Stage-6, Stage-7, Stage-1
Stage-6 has a backup stage: Stage-1
Stage-3 depends on stages: Stage-6
Stage-7 has a backup stage: Stage-1
Stage-4 depends on stages: Stage-7
Stage-1
Stage-0 is a root stage
Stage6 and 7 are mapjoin jobs, whereas Stage1 is a SMB join.
This is the purpose of this jira. If a mapjoin can be performed, that
gets priority over SMB join.
> physical optimizer changes for auto sort-merge join
> ---------------------------------------------------
>
> Key: HIVE-3891
> URL: https://issues.apache.org/jira/browse/HIVE-3891
> Project: Hive
> Issue Type: Bug
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3891.1.patch, hive.3891.2.patch, hive.3891.3.patch,
> hive.3891.4.patch, hive.3891.5.patch, hive.3891.6.patch, hive.3891.7.patch
>
>
--
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
