Edit Hive site XML file

If you are using Hive, follow these instructions to set the location of the hive metastore in the hive-site.xml file:

1. Navigate to the location where you have saved the previously edited site configuration files and open the hive-site.xml file.

2. Add the following values:

Parameter	Value
hive.metastore.uris	Set this to the location of your hive metastore if it differs from what is on your instance of CDP.
hive.server2.enable.impersonation	Add this property if you are using impersonation for security.```xmlhive.server2.enable.impersonationtrue </td></tr><tr><td> hive.server2.enable.doAs </td><td> Add this property if you are using impersonation for security.xml &#x3C;property> &#x3C;name>hive.server2.enable.doAs&#x3C;/name> &#x3C;value>true&#x3C;/value> &#x3C;/property> </code></pre></td></tr><tr><td><strong>tez.lib.uris</strong></td><td><p>Add this property if you are using Hive3 on Tez.xmltez.lib.uris/user/tez/0.9.1.7.1.4.0-203/tez.tar.gz</td></tr></tbody></table>3. Save and close the file.

Note: You will have to edit the named connection and upload the edited site configuration file in order for this change to take effect.