Best Practices for Configuring HAWQ Parameters

The configuration parameters for HAWQ are maintained in the $GPHOME/etc/hawq-site.xml file. This file resides on all HAWQ instances and can be modified either via Ambari or by using the HAWQ command line interface. Use a consistent strategy (Ambari or command line interface) to maintain the contents of hawq-site.xml.

For Ambari-managed clusters, always use Ambari for configuring hawq-site.xml parameters; restarting or reconfiguring HAWQ via Ambari will overwrite any configuration changes to hawq-site.xml made outside the Ambari interface.

If you manage your cluster using command line tools instead of Ambari, use a consistent hawq-site.xml file to configure your entire cluster.

Note: Do not configure HAWQ parameters through the postgresql.conf file. Use only hawq-site.xml to configure your HAWQ cluster. Any parameters defined in hawq-site.xml will overwrite parameters in postgresql.conf.