Unable to see metastore of Hive in MySQL

Hi @itversity,

Which databases s holding the metastore database for hive in lab?
I just see following schema in mysql:

mysql> show databases;
±-------------------+
| Database |
±-------------------+
| information_schema |
| retail_db |
| retail_export |
| retail_import |
±-------------------+
4 rows in set (0.00 sec)

Any suggestions…

Regards, Raj

@raj_sharma

Were you able to find a solution for this.
I am also looking for the same info.
Thanks in advance.

ok.its all about permission…for our username we dont have visibility to the Hive metastore Database…

To answer your query “Which database is holding the metastore database for hive in lab?”-> the database name itself will be metastore and the table names will be the tables we create using hive DDL.

Watch the below video of Durga Sir for more details.

1 Like