question List hive tables based on storage format in Support Questions

List hive tables based on storage format

npdell — Fri, 16 Sep 2022 10:22:01 GMT

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

Re: List hive tables based on storage format

Harsh J — Thu, 02 Jun 2016 23:49:18 GMT

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

npdell — Mon, 25 Jul 2016 09:16:52 GMT

Thx Harsh , i will explore