【无标题】hive 分组排序
数据集:按照id和name分组排序(去重):select a.id, a.name, a.address, a.row_numberfrom( select *, row_number() over (partition by id,name order by name desc) as row_number from dmp_dws_prd.test) a;查询结果如下:最终结果:...
原创
2021-12-19 13:12:04 ·
823 阅读 ·
0 评论