--! qt:dataset:src1 | |
--! qt:dataset:src | |
-- SORT_QUERY_RESULTS | |
CREATE TABLE dest_j1_n0(key INT, cnt INT); | |
set hive.auto.convert.join=true; | |
EXPLAIN | |
INSERT OVERWRITE TABLE dest_j1_n0 | |
SELECT /*+ MAPJOIN(x) */ x.key, count(1) FROM src1 x JOIN src y ON (x.key = y.key) group by x.key; | |
INSERT OVERWRITE TABLE dest_j1_n0 | |
SELECT /*+ MAPJOIN(x) */ x.key, count(1) FROM src1 x JOIN src y ON (x.key = y.key) group by x.key; | |
select * from dest_j1_n0; |