- 链接地址:https://blog.csdn.net/a308601801/article/details/112005198
- 链接标题:Hive求topN_hive topn-CSDN博客
- 所属网站:blog.csdn.net
- 被收藏次数:2806
文章浏览阅读977次,点赞2次,收藏2次。select t2.* from( select pid,uid,cnt,row_number() over (partition by pid order by cnt desc ) as rank from ( select pid,uid,count(uid) as cnt from visit2 group by pid,uid order by pid,cnt desc ) as t1 ) as t2where t2.r._hive topn
版权声明:本文发布于特牛网址导航 内容均来源于互联网 如有侵权联系删除
标签:hive topn