2016.12.24

Hive查询出存在于一表不存在于另一表中的数据

select new.dim_user_hid from new left joinabon ab.dim_user_hid = new.dim_user_hidwhere ab.dim_user_hid is NULL group by new.dim_user_hid;