hive实现自增列

select 
row_number() over(order by 1) as id,
a.* from dp_ipo_tmp.tmp_ipo_yekuai_118_2018q4_06 a where Finterest_date <= '2018-12-31'
代码line2所示，即为添加的自增id列

select row_number() over(partition by 1 order by 1) as rn, Score

from Scores

这就体现了row_number() over 这个窗口分析函数的灵活性，partition by 1 把每一条记录都当做一个分区，然后在对每一条记录进行从1开始编号

 

参考：

https://blog.youkuaiyun.com/qq403580298/article/details/86692161

https://www.jianshu.com/p/afc97c00696b