hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-5980) MapJoin does not take effect
Date Tue, 27 May 2014 08:45:02 GMT

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

Mime
View raw message