[Hive]求两个集合的减集

hive中不支持not in的写法，但是可以通过left outer join来替代

写法如下：

select a.* 
from (
select * 
from rpt_pms_continue 
where category_level_flag='末级类目' 
and cart_tracker_id is not null 
and ds='2015-01-08' 
) a 
left outer join (
select * 
from pms.cross_sale_path 
where ds='2015-01-08' 
and rcmd_algorithm_id in (419,420,580,581,582,650,950,1331,1655,1656,1657,1658,1659,1660,1690,1691,1950,1951)
) b on (a.cart_tracker_id=b.cart_track_id) 
where b.cart_track_id is null;