hive 去重

数据：

select distinct id,name,eat from test1;

select max(id),max(name),max(eat) from test1;

select distinct * from test1;

select id,name,eat from (select *,row_number() over(partition by id order by name,eat) as row_id from test1) t where t.row_id = 1;

select id,name,eat from test1 group by id,name,eat;
1 a a
1 a b
2 a a
2 a b