SELECT page_id, user_id, clicks
FROM (
SELECT page_id, user_id, rank(page_id) as rank, clicks FROM (
SELECT page_id, user_id, clicks FROM mytable
DISTRIBUTE BY page_id
SORT BY page_id, clicks desc
) a ) b
WHERE rank < 5
ORDER BY page_id, rank
Hive如何在GROUP BY 后,获取每个GROUP的Top N
最新推荐文章于 2024-03-05 19:27:33 发布