hadoop - hive 中的第一个()

Question

我有如下数据。所以我想按年份、名称和名称的第一个值分组。

year,name,id
2017,AAA,101
2017,AAA,102
2017,AAA,221
2018,BBB,110
2018,BBB,112
2019,CCC,501
2019,CCC,504

我想得到如下输出

2017,AAA,101
2018,BBB,110
2019,CCC,501

Answer 1

对于您的数据示例，简单的 row_number 将起作用:

select year,name,id
  from
      (
       select year,name,id, 
              row_number() over(partition by year order by id) rn 
         from mytable
      )s
 where rn=1