How to change pxf-env.sh on HDB system managed by Ambari

Products

• Services Suite

Issue/Introduction

This article provides a method to modify pxf-env.sh on a HDB cluster that is managed by Ambari.

Environment

Cause

There is no interface on the Ambari web interface to modify pxf-env.sh at the moment. As a result, any manual change to this file on servers will be reversed to 'default' after the PXF service is restarted through the Ambari web interface.

To prevent the rollback from happening, the template file of pxf-env.sh should be changed and propagated to all nodes running the PXF service.

An internal JIRA AMBR-516 has been filed to request the feature for changing pxf-env.sh through the Ambari interface. Until the feature is ready, use the procedure below to update pxf-env.sh.

Resolution

Follow the instructions below to update pxf-env.sh on a HDB cluster.

1. Make a change to the template file of pxf-env.sh on the Ambari server node. For example:

/var/lib/ambari-server/resources/common-services/PXF/3.0.0/package/templates/pxf-env.j2

2. Restart the Ambari server service to propagate the change to Ambari agents:

# service ambari-server restart

3. Restart the PXF service on all nodes on the Ambari web console: