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 value:

   Parameter	Value
   hive.metastore.uris	Set this to the location of your hive metastore if it differs from what is on the cluster.

3. Save and close the file.

See Hive for further configuration information when using Hive with Spark on AEL.