Extended vs Formatted Table Properties – Hive

When it comes to verifying the table information, Hive offers two choices for checking its specifics. One is “Extended,” and the other is “Formatted.” Both do the same thing and provide almost identical results, but ‘Formatted’ is better because it delivers the information in a properly formatted manner.

Let’s check it out.
DESCRIBE EXTENDED <TableName>
DESCRIBE FORMATTED <TableName>

Example:
DESCRIBE EXTENDED StatePop
DESCRIBE FORMATTED StatePop

Review the results:

This slideshow requires JavaScript.

Hope you find this article helpful.