| --! qt:dataset:src |
| -- SORT_QUERY_RESULTS |
| |
| CREATE TABLE dest_j1_n8(key STRING, value STRING, key1 string, val2 STRING) STORED AS TEXTFILE; |
| set hive.auto.convert.join=true; |
| |
| explain |
| INSERT OVERWRITE TABLE dest_j1_n8 |
| SELECT /*+ MAPJOIN(y) */ x.key, x.value, y.key, y.value |
| FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key); |
| |
| |
| INSERT OVERWRITE TABLE dest_j1_n8 |
| SELECT /*+ MAPJOIN(y) */ x.key, x.value, y.key, y.value |
| FROM src x left outer JOIN (select * from src where key <= 100) y ON (x.key = y.key); |
| |
| select * from dest_j1_n8; |
| |
| |
| |