Search code examples
hadoophivemetastore

Hive tables meta details needed

select * from information_schema.columns;

In MySQL gives me the dbname, table name and column details of a MySQL db.

Can I get the same details in hive from any tables?

Solution

  • If you have configured your metastore in mysql .Then there are tables in the metastore database named DBS, COLUMNS_V2 which will have metadata of all hive DBs and tables .