You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "ruish li (JIRA)" <ji...@apache.org> on 2013/12/07 14:33:35 UTC

[jira] [Created] (HIVE-5980) MapJoin not take effect

ruish li created HIVE-5980:
------------------------------

             Summary: MapJoin not take effect
                 Key: HIVE-5980
                 URL: https://issues.apache.org/jira/browse/HIVE-5980
             Project: Hive
          Issue Type: Bug
          Components: CLI
    Affects Versions: 0.12.0
            Reporter: ruish li
            Priority: Trivial


step1:
  hive-site.xml 
 <property>
  <name>hive.auto.convert.join</name>
  <value>true</value>
 </property>
step2: set the parameter in console: 
 cli:  set hive.auto.convert.join=false;
step3:  	execute sql, mapjoin Does not take effect	
   select /*+ mapjoin(t2)*/ * from t1 join t2 on t1.f=t2.f;
step4: explain sql,  we can see that the join does not conver to mapjoin
   select /*+ mapjoin(t2)*/ * from t1 join t2 on t1.f=t2.f;
   



--
This message was sent by Atlassian JIRA
(v6.1#6144)