3. Modify WebHCat Config Files

Use the following instructions to modify the WebHCat config files:

Extract the WebHCat configuration files
From the downloaded scripts.zip file, extract the files in configuration_files/webhcat directory to a temporary location.

Modify the configuration files

In the temporary directory, locate the following files and modify the properties based on your environment.

Search for TODO in the files for the properties to replace. See Define Environment Parameters for more information.

Edit the webhcat-site.xml and modify the following properties:

<property>     
 <name>templeton.hive.properties</name>     
 <value>hive.metastore.local=false, hive.metastore.uris=thrift://$metastore.server.full.hostname:9083,hive.metastore.sasl.enabled=no,hive.metastore.execute.setugi=true</value>
 <description>Properties to set when running Hive.</description>
</property>

<property>     
 <name>templeton.zookeeper.hosts</name>     
 <value>$zookeeper1.full.hostname:2181,$zookeeper1.full.hostname:2181,..</value>
 <description>ZooKeeper servers, as comma separated HOST:PORT pairs.</description>
</property>

Set up the WebHCat configuration files.
1. Delete any existing WebHCat configuration files:
```
 rm -rf  $WEBHCAT_CONF_DIR/* 
```
2. Copy all the config files to $WEBHCAT_CONF_DIR and set appropriate permissions:
```
chown -R $WEBHCAT_USER:$HADOOP_GROUP $WEBHCAT_CONF_DIR
chmod -R 755 $WEBHCAT_CONF_DIR
```
  where:
  - $WEBHCAT_CONF_DIR is the directory to store theWebHCat configuration files. For example, /etc/hcatalog/conf/webhcat.
  - $WEBHCAT_USER is the user owning the WebHCat services. For example, hcat.
  - $HADOOP_GROUP is a common group shared by services. For example, hadoop.

Legal notices