| --! qt:dataset:src |
| |
| |
| create table t1_n121(key string, value string) partitioned by (ds string); |
| create table t2_n71(key string, value string) partitioned by (ds string); |
| |
| insert overwrite table t1_n121 partition (ds='1') |
| select key, value from src; |
| |
| insert overwrite table t1_n121 partition (ds='2') |
| select key, value from src; |
| |
| insert overwrite table t2_n71 partition (ds='1') |
| select key, value from src; |
| |
| set hive.test.mode=true; |
| set hive.mapred.mode=strict; |
| set mapreduce.framework.name=yarn; |
| set mapreduce.jobtracker.address=localhost:58; |
| set hive.exec.mode.local.auto=true; |
| |
| explain |
| select count(1) from t1_n121 join t2_n71 on t1_n121.key=t2_n71.key where t1_n121.ds='1' and t2_n71.ds='1'; |
| |
| select count(1) from t1_n121 join t2_n71 on t1_n121.key=t2_n71.key where t1_n121.ds='1' and t2_n71.ds='1'; |
| |
| set hive.test.mode=false; |
| set mapreduce.framework.name; |
| set mapreduce.jobtracker.address; |
| |
| |
| |