[ https://issues.apache.org/jira/browse/HIVE-20504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16606601#comment-16606601 ]
Gopal V commented on HIVE-20504: -------------------------------- That order is fine. In case of LLAP, that works out nicely because of shared hashtables & for the non-LLAP case, the MJ means that all splits going through the same JVM will use the same hashtable (while for BMJ, the next split might be for a different bucket). > Give simple MJ bigger priority than bucketized ones > --------------------------------------------------- > > Key: HIVE-20504 > URL: https://issues.apache.org/jira/browse/HIVE-20504 > Project: Hive > Issue Type: Improvement > Components: Statistics > Reporter: Zoltan Haindrich > Assignee: Zoltan Haindrich > Priority: Major > Attachments: HIVE-20504.01.patch, HIVE-20504.01.patch, > HIVE-20504.01wip01.patch, HIVE-20504.01wip01.patch > > > from the code it seems "standard" mapjoin is one of the last one tried; in > case the table estimated to be bucketed in to 2 - but it's small ; Hive willl > do a bucketmapjoin or dphj...even thru a simple mapjoin could have been an > alternative... > https://github.com/apache/hive/blob/154ca3e3b5eb78cd49a4b3650c750ca731fba7da/ql/src/java/org/apache/hadoop/hive/ql/optimizer/ConvertJoinMapJoin.java#L157 -- This message was sent by Atlassian JIRA (v7.6.3#76005)