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 *<username>*/.pentaho/metastore/pentaho/NamedCluster/Configs/*<user-defined connection name>* directory 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 <property> <name>hive.server2.enable.doAs</name> <value>true</value> </property>
tez.lib.uris	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.