Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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?


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.

Cloudera Employee

Here is a URL, written by David W. Streever

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.


Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.