HIVESQL按照某字段先分区，分区内部排序，再取内部的第一条数据

with tmp as (select *,ROW_NUMBER() OVER (PARTITION BY name ORDER BY level1,level2) as num from table )select * from tmp where num=1