If you are using Hive, follow these instructions to set the location of the hive metastore in the hive-site.xml file:
Navigate to the *<username>*/.pentaho/metastore/pentaho/NamedCluster/Configs/*<user-defined connection name>* directory and open the hive-site.xml file.
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 HDI.