How to create a Hive Database and store it in HDFS

Question

Hi. I want to create a hive database in HDFS. But when I use the Hive command to create a database, it is getting created in the default path. How can I change this to store the database in HDFS?

Answer 1

You will have to exclusively mention the HDFS path while creating the database to store it in HDFS. For that, you have to use the LOCATION keyword. For example:

CREATE DATABASE employee LOCATION <hdfs_path>;