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

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.5.0
• Fix Version/s: 1.5.1
• Component/s: ambari-server
• Assignee: Dmitry Lysnichenko
• Reporter: Dmitry Lysnichenko
• Created: 04/Apr/14 15:36
• Updated: 04/Apr/14 15:42
• Resolved: 04/Apr/14 15:42

Description

Without the following property:

  <property>
    <name>hive.optimize.bucketmapjoin.sortedmerge</name>
    <value>false</value>
  </property>

Hive/HiveServer2 E2E test Join_10 fails with the following error:

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