Using Row Numbers to Retrieve First 10 Rows of Each Category in Hive SQL

Transferring Postgres Script to HSQLDB Script: A Step-by-Step Guide