...
This commands displays information about currently running compaction and recent history (configurable retention period) of compactions. This history display is available since HIVHIVE-12353.
Also see LanguageManual DDL#ShowCompactions for more information on the output of this command and NewConfigurationParametersforTransactions/Compaction History for configuration properties affecting the output of this command. The system retains the last N entries of each type: failed, succeeded, attempted. N is configurable for each type.
...