[ 
https://issues.apache.org/jira/browse/HIVE-4042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13596381#comment-13596381
 ] 

Ashutosh Chauhan commented on HIVE-4042:
----------------------------------------

For the first query you have, my understanding is with this patch (which 
removes map-join hints), this will result in two regular Joins which will both 
get converted to map-join (if they satisfy requirements). Problem is this still 
results in 2 Map-only jobs, instead it should have resulted in 1 Map-only job 
with both joins happening in same mapper. Prior to HIVE-3784 i.e., on 0.10, 
above query  would result in 1 MR job. 
So, to get back the desired behavior of 0.10, {{ 
hive.auto.convert.join.noconditionaltask}} needs to be true.
                
> ignore mapjoin hint
> -------------------
>
>                 Key: HIVE-4042
>                 URL: https://issues.apache.org/jira/browse/HIVE-4042
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.4042.1.patch, hive.4042.2.patch, hive.4042.3.patch, 
> hive.4042.4.patch, hive.4042.5.patch, hive.4042.6.patch, hive.4042.7.patch, 
> hive.4042.8.patch
>
>
> After HIVE-3784, in a production environment, it can become difficult to
> deploy since a lot of production queries can break.

--
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

Reply via email to