Support Questions
Find answers, ask questions, and share your expertise

Hi All , Please help me to find the location of hive-site.xml file in hortonworks . My requirement is i want to change the default file location using hive.metastore.warehouse.dir property. Thanks Abhishek

Solved Go to solution

Hi All , Please help me to find the location of hive-site.xml file in hortonworks . My requirement is i want to change the default file location using hive.metastore.warehouse.dir property. Thanks Abhishek

Explorer
 
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Hi All , Please help me to find the location of hive-site.xml file in hortonworks . My requirement is i want to change the default file location using hive.metastore.warehouse.dir property. Thanks Abhishek

Guru

@Abhishek Srivastava

You can find hive-site.xml in /etc/hive/conf/, but if you're using Ambari to manage your cluster then do the modification in Ambari so it can deploy it to every host.

View solution in original post

3 REPLIES 3

Re: Hi All , Please help me to find the location of hive-site.xml file in hortonworks . My requirement is i want to change the default file location using hive.metastore.warehouse.dir property. Thanks Abhishek

Guru

@Abhishek Srivastava

You can find hive-site.xml in /etc/hive/conf/, but if you're using Ambari to manage your cluster then do the modification in Ambari so it can deploy it to every host.

View solution in original post

Re: Hi All , Please help me to find the location of hive-site.xml file in hortonworks . My requirement is i want to change the default file location using hive.metastore.warehouse.dir property. Thanks Abhishek

Explorer

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

Re: Hi All , Please help me to find the location of hive-site.xml file in hortonworks . My requirement is i want to change the default file location using hive.metastore.warehouse.dir property. Thanks Abhishek

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.