Created 07-11-2016 07:57 AM
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
As Laurent says, you need to make this change in Ambari if you are using it to manage your cluster otherwise the value in the file will be overridden. Also when you have made your change be sure to restart the affected services.