topic Re: Regarding Database location in dbfs in Warehousing & Analytics

Regarding Database location in dbfs

Pavan3 — Wed, 02 Oct 2024 13:00:58 GMT

Hi,

I have used "SET spark.sql.warehouse.dir" which creates the directory by default.Then I have created the database by command "CREATE DATABASE IF NOT EXISTS database_name;",but when I used "DESCRIBE DATABASE database_name" I could not find the location of database created.Even I tried using "%fs ls dbfs:/",I could not find the directory of database.

Please let me know If anyone knows the solution to find the location.

Re: Regarding Database location in dbfs

filipniziol — Wed, 02 Oct 2024 15:34:08 GMT

Hi @Pavan3 ,
If running DESCRIBE DATABASE the location is empty, then was created in the default CATALOG directory.

What you can do is to create any table in that database and run DESCRIBE DETAIL on that table:

Hope it helps

Re: Regarding Database location in dbfs

Pavan3 — Sat, 05 Oct 2024 19:14:47 GMT

Hi filipniziol,

Thanks for your reply.

I can see the database in Catalog.But, I want to see that the database is created in the location "dbfs:/user/hive/warehouse" folder which was created by default using "SET spark.sql.warehouse.dir " command.

Thank you,

Pavan.