[jira] [Updated] (HIVE-20504) Give simple MJ bigger priority than bucketized ones

["Zoltan Haindrich (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-20504?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zoltan Haindrich updated HIVE-20504:
------------------------------------
    Resolution: Won't Fix
        Status: Resolved  (was: Patch Available)

this was addressed a bit differently; IIRC there was a bug in selecting BMJ when it was not entirely applicable...

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