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

Conditional Filtering and Aggregation in Pandas DataFrame