Apache Hive Performance Tuning
Also available as:

Add a Hive proxy

To prevent network connection or notification problems, you must add a hive user proxy for HiveServer Interactive service to access the Hive Metastore.

  1. In Ambari, select Services > HDFS > Configs > Advanced.
  2. In Custom core-site, add the FQDNs of the HiveServer Interactive host or hosts to the value of hadoop.proxyuser.hive.hosts.
  3. Save the changes.