[HIVE-13353] SHOW COMPACTIONS should support filtering options

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.3.0, 4.0.0-alpha-2
• Fix Version/s: 4.0.0-alpha-2
• Component/s: Transactions
• Labels: pull-request-available
• Target Version/s: 1.3.0, 4.0.0-alpha-2
• Assignee: KIRTI RUGE
• Reporter: Eugene Koifman
• Created: 24/Mar/16 16:55
• Updated: 27/Feb/24 22:23
• Resolved: 25/Oct/22 07:45

Description

Since we now have historical information in SHOW COMPACTIONS the output can easily become unwieldy. (e.g. 1000 partitions with 3 lines of history each)
this is a significant usability issue
Need to add ability to filter by db/table/partition
Perhaps would also be useful to filter by status

Issue Links

• is a parent of: HIVE-26666 Filter out compactions by id to minimise expense of db operations
• is depended upon by: HIVE-15920 Implement a blocking version of a command to compact
• is related to: HIVE-27222 New functionality to show compactions information for a specific table/partition of a given database
• is related to: HIVE-16084 SHOW COMPACTIONS should display CompactionID
• is required by: HIVE-12353 When Compactor fails it calls CompactionTxnHandler.markedCleaned(). it should not.
• is required by: HIVE-11994 SHOW COMPACTIONS should include meta info about the job
• relates to: HIVE-26580 SHOW COMPACTIONS should support ordering and limiting functionality in filtering options
• relates to: HIVE-11793 SHOW LOCKS with DbTxnManager ignores filter options
• links to: GitHub Pull Request #3608