You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2014/05/27 10:45:02 UTC
[jira] [Updated] (HIVE-5980) MapJoin does not take effect
[ https://issues.apache.org/jira/browse/HIVE-5980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis updated HIVE-5980:
------------------------
Release Note: From hive-0.11.0, hive.ignore.mapjoin.hint=true by default. (was: From hive-0.12.0, hive.ignore.mapjoin.hint=true by default.)
> MapJoin does 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
> Labels: patch
>
> 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.2#6252)