用hive实现怎么搞

[Runnerycq]

select a.id,b.name from a where a.id not in (select b.id from b) 用hive实现怎么搞

[郗晓勇]

http://goobbe.com/questions/4386440/how-to-write-subquery-in-select-statement-in-hive

[请说重点]

select t.a_id,t.name from (select a.id a_id,b.id b_id,b.name from a left join b where a.id = b.id ) t where t.b_id is null