--! qt:dataset:src
-- SORT_QUERY_RESULTS

CREATE TABLE tmp1_n0(key INT, cnt INT);
CREATE TABLE tmp2_n0(key INT, cnt INT);
CREATE TABLE dest_j1_n13(key INT, value INT, val2 INT);

INSERT OVERWRITE TABLE tmp1_n0
SELECT key, count(1) from src group by key;

INSERT OVERWRITE TABLE tmp2_n0
SELECT key, count(1) from src group by key;
set hive.auto.convert.join=true;
EXPLAIN
INSERT OVERWRITE TABLE dest_j1_n13 
SELECT /*+ MAPJOIN(x) */ x.key, x.cnt, y.cnt
FROM tmp1_n0 x JOIN tmp2_n0 y ON (x.key = y.key);

INSERT OVERWRITE TABLE dest_j1_n13 
SELECT /*+ MAPJOIN(x) */ x.key, x.cnt, y.cnt
FROM tmp1_n0 x JOIN tmp2_n0 y ON (x.key = y.key);

select * from dest_j1_n13;