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

["Dmitry Lysnichenko (JIRA)" <ji...@apache.org>]

Dmitry Lysnichenko created AMBARI-5350:
------------------------------------------

             Summary: 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


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)