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 value:
Parameter
Value
hive.metastore.uris
Set this to the location of your hive metastore.
Save and close the file.
See Hive for further configuration information when using Hive with Spark on AEL.