Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
New Contributor

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

2 REPLIES 2

avatar
Super Collaborator

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.

avatar
Expert Contributor

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.