hiveQL求差集

select * from table1 t1 left outer join table2 t2 on t1.id = t2.id where t2.id = null;

select * from 
　　(
　　　　select * from table1 where year=2017 and month=07 and day=01
　　) t1 
left outer join 
　　(
　　　　select * from (select *,row_number() over(partition by id) num from table2 where year=2017 and month=07 and day=01) t where t.num =1) t2 
on t1.id = t2.id where t2.id==null;