特牛网址导航

Hive求topN_hive topn-CSDN博客

网友收藏
文章浏览阅读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