- row_number
row_number排序为标准顺序排序,排序后序号按照行号依次递增。select id,row_number() over(order by id) as number from table1; id number a 1 b 2 b 3 b 4 c 5 c 6
- dense_rank
dense_rank排序中大小一致的元素序号一样,然后按照元素降序依次降序排序。select id,dense_rank() over(order by id) as number from table1; id number a 1 b 2 b 2 b 2 c 3 c 3
- rank
rank排序大小一致的元素序号一样,但是会按照行号依次降序排序。select id,rank() over(order by id) as number from table1; id number a 1 b 2 b 2 b 2 c 5 c 5
Hive row_number,dense_rank,rank三个函数的区别
最新推荐文章于 2024-06-17 10:06:14 发布