[ 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