Hive Warehouse Issue

Hi,

I’m not able to find the database I created in /user/hive/warehouse. But I’m able to use it. Can you please help me with this issue?

Thanks
Sai

Try /apps/hive/warehouse

1 Like

But by default all the databases should be stored in /user/hive/warehouse right?

Not Really. The databases are stored in the path specified in the hive-site.xml under the property hive.metastore.warehouse.dir.
When you download hive then by default, the property points to the path /user/hive/warehouse.
In your case it might be pointing to /apps/hive/warehouse. This is also the case for HDP Sandbox too.

1 Like

Ok… Thank you so much for the info.

The warehouse folder has been deleted.

I can’t access the databases I created on hive while I’m on a pyspark session.
When I do a dfs -ls /apps/hive/warehouse; on a hive session it says the directory does not exist.

Please advise.

Hi @Mandisi_Nxulu,

we had a small issue with the hive. Please refer to this video