@Jerry Doyle It is not possible to point to multiple Hive Metastore service or Hiveserver2 to different databases under Ambari managed cluster/Cloudera Managed Servers. One way to achieve this is having non-Ambari managed Hive process with different set of configuration files as below: su hive -l -c 'HIVE_CONF_DIR=/etc/hive1/conf/conf.server /usr/hdp/current/hive-server2/bin/hiveserver2 -hiveconf hive.metastore.uris=" " -hiveconf hive.log.dir=/var/log/hive1 -hiveconf hive.log.file=hiveserver2.log 1>/var/log/hive1/hiveserver2.log 2>/var/log/hive1/hiveserver2.log &' su hive -l -c 'HIVE_CONF_DIR=/etc/hive2/conf/conf.server /usr/hdp/current/hive-server2/bin/hiveserver2 -hiveconf hive.metastore.uris=" " -hiveconf hive.log.dir=/var/log/hive2 -hiveconf hive.log.file=hiveserver2.log 1>/var/log/hive2/hiveserver2.log 2>/var/log/hive2/hiveserver2.log &' ... View more