| dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/bmjpathfilter; |
| |
| create table t1_n99 (dt string) location '${system:test.tmp.dir}/bmjpathfilter/t1'; |
| Create table t2_n62 (dt string) stored as orc; |
| dfs -touchz ${system:test.tmp.dir}/bmjpathfilter/t1/_SUCCESS; |
| |
| SET hive.input.format=org.apache.hadoop.hive.ql.io.BucketizedHiveInputFormat; |
| SET hive.optimize.bucketmapjoin=true; |
| |
| SELECT /*+ MAPJOIN(b) */ a.dt FROM t1_n99 a JOIN t2_n62 b ON (a.dt = b.dt); |
| |
| SET hive.optimize.bucketmapjoin=false; |
| set hive.input.format=org.apache.hadoop.hive.ql.io.CombineHiveInputFormat; |
| |
| dfs -rmr ${system:test.tmp.dir}/bmjpathfilter; |