[ https://issues.apache.org/jira/browse/HIVE-5980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ruish li updated HIVE-5980: --------------------------- Summary: MapJoin does not take effect (was: MapJoin not take effect) > 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.1#6144)