Hive metastore location

Lab Support
#1

While I can find table datasets in the path /apps/hive/warehouse, where can I find the Hive metastore for the tables? I do not see my table in Hive DB in MYSql.

#2

Hi @Roshan_Mahapatra,

Please access the meta store tables in Hue

Hope this helps.

Thanks

#3

Thank you. While I am able to see metastore data in Hue, but I am not finding several databases that are available in Hive. For e.g., I had created a database named rkmsample, but I do not see it in Hue. Please let me know if I am missing something.

#4

Hi Abhinavsingh

As hue in cloudxlab deprecated, could you please help me to find the location for MYSQL database ‘metastore’ in hive?, thanks in advance