[HIVE-26563] Add extra columns in Show Compactions output and sort the output

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: Transactions
• Target Version/s: 3.0.0
• Assignee: KIRTI RUGE
• Reporter: KIRTI RUGE
• Created: 26/Sep/22 09:38
• Updated: 21/Oct/22 07:20

Description

SHOW COMPACTIONS need reformatting in below aspects:

1.Need to add all below columns     

  host information, duration, next_txn_id, txn_id, commit_time, highest_write_id, cleaner       start, tbl_properties

2. Sort the output in a way it should display a moist recent element at the start(either completed or in progress)

Issue Links

• relates to: HIVE-26580 SHOW COMPACTIONS should support ordering and limiting functionality in filtering options