Let us go through the details related to Hive Warehouse Directory.
- A Database in Hive is nothing but HDFS Directory
- A Table in Hive is nothing but HDFS Directory
- A Partition in Hive is nothing but HDFS Directory
- Warehouse Directory is the base directory where directories related to databases, tables go by default.
- It is controlled by
hive.metastore.warehouse.dir. You can get the value by saying
Do not overwrite this property in Hive CLI
- HDFS directory for a database will have .db extension.