Override default Hive Database Path

[#1]

Hi All,

I was trying to create a hive database by specifying a different location. The query got executed successfully, but I don't see the database in the specified location. Am I missing anything here?

PFA for the screenshots.

[#2 · Accepted solution]

I found that this is how hive works when I provide (override the default ) the path.

It will use the specified path assuming the path subdirectory ex: /user/hive/warehouse/, "warehouse" folder in this case as the main DB folder and it will create all the tables underneath.

[#3]

when we override the path, it won't create any <dbname>.db folder, assuming that the specified path it self is the db /main folder for the mentioned database.