--! qt:dataset:src | |
set hive.mapred.mode=nonstrict; | |
-- SORT_QUERY_RESULTS | |
create table join_rc1(key string, value string) stored as RCFile; | |
create table join_rc2(key string, value string) stored as RCFile; | |
insert overwrite table join_rc1 select * from src; | |
insert overwrite table join_rc2 select * from src; | |
explain | |
select join_rc1.key, join_rc2.value | |
FROM join_rc1 JOIN join_rc2 ON join_rc1.key = join_rc2.key; | |
select join_rc1.key, join_rc2.value | |
FROM join_rc1 JOIN join_rc2 ON join_rc1.key = join_rc2.key; | |