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)