Thanks @Laurent Edel I have updated the value as follows <property> <name>hive.metastore.warehouse.dir</name> <value>/user/hive/warehouse</value> </property> But still Database object is created in the default path as shown /apps/hive/warehouse Regards Abhishek ... View more