How to get metadata of hive tables, columns, views, constraint keys and comment columns?

hadoop, hive

Solution

if you have Hue available you can go to Metastore Tables from the top menu Data Browsers. There you can find metadata for all schemas available for you. From Hive you can try: `USE DB_NAME;` `DESCRIBE FORMATTED TABLE_NAME;` or `DESCRIBE EXTENDED TABLE_NAME;`

Problem

Original source