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

Namit Jain commented on HIVE-3403:
----------------------------------

[~mgrover], typically we have erred on the side on having more configurable 
parameters in hive, rather than over-loading a parameter.
There is no correct answer for this, but I would prefer to have an additional 
conf. Moreover, hive.optimize.bucketmapjoin, only converts map-joins to
bucketized map joins, whenever possible. However, here, the user is not giving 
any hints, and we are converting the query to use sort-merge joins.
                
> user should not specify mapjoin to perform sort-merge bucketed join
> -------------------------------------------------------------------
>
>                 Key: HIVE-3403
>                 URL: https://issues.apache.org/jira/browse/HIVE-3403
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.3403.1.patch, hive.3403.2.patch, hive.3403.3.patch, 
> hive.3403.4.patch
>
>
> Currently, in order to perform a sort merge bucketed join, the user needs
> to set hive.optimize.bucketmapjoin.sortedmerge to true, and also specify the 
> mapjoin hint.
> The user should not specify any hints.

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