Newly created DB's not appear in Hive at /user/hive/warehouse

hive

#1

Hello

I have created DB’s plural and pluralsight and under each DB , created tables. But none of these saved under /user/hive/warehouse. Could you help in identifying this issue. It supposed to be under /user/hive/warehouse.


#2

It need not be under /user/hive/warehouse. Check the property hive.metastore.warehouse.dir using set command - set hive.metastore.warehouse.dir

In Hortonworks clusters it might be set to /apps/hive/warehouse and the lab is built using Hortonworks distribution.