SparkJoin

left join where on
Join大致包括三个要素：Join方式、Join条件以及过滤条件。其中过滤条件也可以通过AND语句放在Join条件中。
on是在生成连接表的起作用的，where是生成连接表之后对连接表再进行过滤
inner join
left outer join
right outer join
full outer join
left semi join
left anti join

insert into poi_hn_edit_0826_diff2 (address,longitude,latitude,hn_level,poi_id_mapping)
select a.address,a.longitude,a.latitude,a.hn_level,a.poi_id_mapping from
tmp_address_0908 a left join poi_hn_edit_0826 b on a.address = b.address and b.del_flag=0
where b.address is null ;

https://www.cnblogs.com/shendeng23/p/15240788.html