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)
