| --! qt:dataset:src |
| SET hive.vectorized.execution.enabled=false; |
| set hive.mapred.mode=nonstrict; |
| set hive.exec.post.hooks=org.apache.hadoop.hive.ql.hooks.PostExecutePrinter,org.apache.hadoop.hive.ql.hooks.PrintCompletedTasksHook; |
| set hive.auto.convert.join=true; |
| set hive.auto.convert.join.use.nonstaged=true; |
| |
| set hive.auto.convert.join.noconditionaltask.size=100; |
| |
| explain |
| select a.* from src a join src b on a.key=b.key order by key, value limit 40; |
| |
| select a.* from src a join src b on a.key=b.key order by key, value limit 40; |
| |
| explain |
| select a.* from src a join src b on a.key=b.key join src c on a.value=c.value order by a.key, a.value limit 40; |
| |
| select a.* from src a join src b on a.key=b.key join src c on a.value=c.value order by a.key, a.value limit 40; |
| |
| set hive.auto.convert.join.noconditionaltask.size=100; |
| |
| explain |
| select a.* from src a join src b on a.key=b.key join src c on a.value=c.value where a.key>100 order by a.key, a.value limit 40; |
| |
| select a.* from src a join src b on a.key=b.key join src c on a.value=c.value where a.key>100 order by a.key, a.value limit 40; |
| |
| set hive.mapjoin.localtask.max.memory.usage = 0.0001; |
| set hive.mapjoin.check.memory.rows = 2; |
| |
| -- fallback to common join |
| select a.* from src a join src b on a.key=b.key join src c on a.value=c.value where a.key>100 order by a.key, a.value limit 40; |
| |