3. Modify WebHCat Configuration Files

Use the following instructions to modify the WebHCat config files:

Extract the WebHCat configuration files to a temporary directory.
The files are located in the configuration_files/webhcat directory where you decompressed the companion files.

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>

<property>
<name>templeton.controller.map.mem</name>
<value>1600</value>
<description>Total virtual memory available to map tasks.</description>
</property>

<property>
 <name>hive.metastore.warehouse.dir</name>
 <value>/path/to/warehouse/dir</value>
</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