【SQL】hive中不支持in/not in(select...) 子查询怎么办，包含/不包含关系

A表中不包含B表中的数据

原代码

select *
from class_a
where age not in (select age
					from class_b
					where city = 'shanghai' )

left join改写：

select *
from class_a a
left join (select age
			 from class_b
			 where city = 'shanghai') b on a.age = b.age
where b.age is null