Registering PXF JAR Dependencies
You use PXF to access data stored on external systems. Depending upon the external data store, this access may require that you install and/or configure additional components or services for the external data store.
PXF depends on JAR files and other configuration information provided by these additional components. The $GPHOME/pxf/conf/pxf-private.classpath
file identifies PXF internal JAR dependencies. In most cases, PXF manages the pxf-private.classpath
file, adding entries as necessary based on the connectors that you use.
Should you need to add an additional JAR dependency for PXF, for example a JDBC driver JAR file, you must log in to the Greenplum Database master host, copy the JAR file to the PXF user configuration runtime library directory ($PXF_CONF/lib
), sync the PXF configuration to the Greenplum Database cluster, and then restart PXF on each segment host. For example:
$ ssh gpadmin@<gpmaster>
gpadmin@gpmaster$ cp new_dependent_jar.jar $PXF_CONF/lib/
gpadmin@gpmaster$ $GPHOME/pxf/bin/pxf cluster sync
gpadmin@gpmaster$ $GPHOME/pxf/bin/pxf cluster stop
gpadmin@gpmaster$ $GPHOME/pxf/bin/pxf cluster start