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;
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;
本文标题:2016.12.24
本文链接:https://www.haomeiwen.com/subject/okdtottx.html
网友评论