Get top N records of group by, with Facebook PrestoDB against Hive

a.sql

SELECT * FROM (
    SELECT *, RANK() OVER (PARTITION BY day, month ORDER BY hits DESC) AS row_number FROM (
        SELECT country AS value, COUNT(*) AS hits, day, month
        FROM hits_table
        WHERE year = 2017
        GROUP BY country, month, day
        HAVING COUNT(*) > 1000
        ORDER BY month, day, COUNT(*) DESC
    )
)
WHERE row_number <= 10