[jira] [Commented] (AMBARI-5350) Ambari should set "hive.optimize.bucketmapjoin.sortedmerge=false" in hive-site.xml

["Vitaly Brodetskyi (JIRA)" <ji...@apache.org>]

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

Vitaly Brodetskyi commented on AMBARI-5350:
-------------------------------------------

+1

> Ambari should set "hive.optimize.bucketmapjoin.sortedmerge=false" in hive-site.xml
> ----------------------------------------------------------------------------------
>
>                 Key: AMBARI-5350
>                 URL: https://issues.apache.org/jira/browse/AMBARI-5350
>             Project: Ambari
>          Issue Type: Bug
>          Components: controller
>    Affects Versions: 1.5.0
>            Reporter: Dmitry Lysnichenko
>            Assignee: Dmitry Lysnichenko
>             Fix For: 1.5.1
>
>         Attachments: AMBARI-5350.patch
>
>
> Without the following property:
> {code}
>   <property>
>     <name>hive.optimize.bucketmapjoin.sortedmerge</name>
>     <value>false</value>
>   </property>
> {code}
> Hive/HiveServer2 E2E test Join_10 fails with the following error:
> {noformat}
> >>>  insert overwrite table join_10_3 select registration from join_10_1 s join join_10_2 v on (s.name=v.name);
> Error: Error while compiling statement: FAILED: SemanticException [Error 10135]: Sort merge bucketed join could not be performed. If you really want to perform the operation, either set hive.optimize.bucketmapjoin.sortedmerge=false, or set hive.enforce.sortmergebucketmapjoin=false. (state=42000,code=10135)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.2#6252)