--! qt:dataset:srcpart | |
set hive.mapred.mode=nonstrict; | |
set hive.cbo.enable=true; | |
-- SORT_QUERY_RESULTS | |
explain | |
select count(*) from srcpart a join srcpart b on a.key = b.key and a.hr = b.hr join srcpart c on a.hr = c.hr and a.key = c.key; | |
select count(*) from srcpart a join srcpart b on a.key = b.key and a.hr = b.hr join srcpart c on a.hr = c.hr and a.key = c.key; |