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

Mark Grover commented on HIVE-3403:
-----------------------------------

Sorry for joining the party a little late.

Just a thought: we already have a property hive.optimize.bucketmapjoin that 
deals with the same question - whether or not to use BucketizedHiveInputFormat. 
Would it make sense to use the same property? I would go as far as saying, most 
people who would want to auto-convert their joins to bucketed joins would be 
interested in converting their joins to sort-merge bucketed joins (if data is 
sorted per join keys).

What do you think?
                
> 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
>
>
> 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