You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Dmitry Lysnichenko (JIRA)" <ji...@apache.org> on 2014/04/04 17:44:15 UTC
[jira] [Resolved] (AMBARI-5350) Ambari should set
"hive.optimize.bucketmapjoin.sortedmerge=false" in hive-site.xml
[ https://issues.apache.org/jira/browse/AMBARI-5350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dmitry Lysnichenko resolved AMBARI-5350.
----------------------------------------
Resolution: Fixed
committed to trunk
> 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)