ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vitaly Brodetskyi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AMBARI-5350) Ambari should set "hive.optimize.bucketmapjoin.sortedmerge=false" in hive-site.xml
Date Fri, 04 Apr 2014 15:40:20 GMT

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

Mime
View raw message