[HIVE-25672] Hive isn't purging older compaction entries from show compaction command

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.1.1
• Component/s: Hive, Metastore, Transactions
• Assignee: Unassigned
• Reporter: Rohan Nimmagadda
• Created: 04/Nov/21 19:48
• Updated: 30/Aug/22 19:00
• Resolved: 30/Aug/22 19:00

Description

Added below properties in hive-site, but it's not enforced to auto purging.

When we run show compaction command it takes forever and returns billions of rows.

Result of show compactions command :

752,450 rows selected (198.066 seconds) 

hive.compactor.history.retention.succeeded": "10",
"hive.compactor.history.retention.failed": "10",          "hive.compactor.history.retention.attempted": "10",          "hive.compactor.history.reaper.interval": "10m"