Support Questions
Find answers, ask questions, and share your expertise

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

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

New Contributor

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

2 REPLIES 2

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

Expert Contributor

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.

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

Cloudera Employee

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.