This is the documentation for CDH 4.7.1.
Documentation for other versions is available at Cloudera Documentation.

Configuration Change on Hosts Used with HCatalog

You must update /etc/hive/conf/hive-site.xml on all hosts where WebHCat will run, as well as all hosts where Pig or MapReduce will be used with HCatalog, so that Metastore clients know where to find the Metastore.

Add or edit the hive.metastore.uris property as follows:

<property>
  <name>hive.metastore.uris</name>
  <value>thrift://<hostname>:9083</value>
</property>

where <hostname> is the host where the HCatalog server components are running, for example hive.examples.com.