Hive转Oracle存储过程 查询字段包含子查询修改

select a.a,a.b,

(select min(b.b) 

 from b

  where a.a=b.a

)

from a;

改写

select a.a.,a.b

from a

left join (select b.a,min(b.b) from b group by b.a) c

on a.a=c.a