Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

List hive tables based on storage format

Solved Go to solution

List hive tables based on storage format

Explorer

Is it possible to list hive tables based on the storage format? We want to implement a standard format for tables; before that we want to list down existing tables based on storage and identify which are not in standard format

1 ACCEPTED SOLUTION

Accepted Solutions

Re: List hive tables based on storage format

Master Guru
There's no direct way to filter that out via a simple statement.

You can either use JDBC to fetch catalog data and iterate through the descriptors, or run iterative "DESCRIBE (FORMATTED|EXTENDED) <TABLENAME>" and grep out the Storage and Format related information.

If this is a one-off, you can also explore querying the underlying HMS DB, but do not make something persistently reliant on that as the schema is subject to change between releases.
2 REPLIES 2

Re: List hive tables based on storage format

Master Guru
There's no direct way to filter that out via a simple statement.

You can either use JDBC to fetch catalog data and iterate through the descriptors, or run iterative "DESCRIBE (FORMATTED|EXTENDED) <TABLENAME>" and grep out the Storage and Format related information.

If this is a one-off, you can also explore querying the underlying HMS DB, but do not make something persistently reliant on that as the schema is subject to change between releases.

Re: List hive tables based on storage format

Explorer
Thx Harsh , i will explore