How do I filter the compactions results provided by show compactions command in hive?

[#1]

I mean It is returning huge amount of rows.. not able to filter them?

[#2]

I am also not able to understand, whether compaction is enabled on my table or not?

Does anyone know how to filter the output of show compactions query.

[#3]

Here is a URL, written by David W. Streever

https://www.streever.com/post/2019/filter-hive-compactions/

Spoiler

It's not official steps. All the ‘extras’ you create against the metastore DB can/may break with the next release. This isn’t a supported method of accessing metadata.