This draft documentation may be incomplete or inaccurate, and is subject to change until this release is generally available (GA).

Using Greenplum utilities

You can use the Greenplum client to customize connections in DataFlow.

Follow these steps to install the Greenplum client:

  1. Download the appropriate installer package for your platform from the following site.

    The package name has the following form: pacgreenplum-loaders-<version>-PLATFORM.bin.zip.

    https://network.pivotal.io/products/pivotal-gpdb#/releases/837931/file_groups/3218
  2. Select the Greenplum Client for RHEL 7 or RHEL 8, depending on your RHEL version.

    This downloads the RPM file.

  3. Install the Greenplum client using yum. This command installs the utility on the path /usr/local/greenplum-db-clients-<version>.

    RHEL 7
    #sudo yum install greenplum-db-clients-<version>-rhel7-x86_64.rpm
    RHEL 8
    #sudo yum install greenplum-db-clients-<version>-rhel8-x86_64.rpm
  4. To access gpfdist and gpload commands from DataFlow, create symlinks in the /usr/bin path.

    #sudo ln -s /usr/local/greenplum-db-clients-<version>/bin/gpload /usr/bin/gpload
    
    #sudo ln -s /usr/local/greenplum-db-clients-<version>/bin/gpfdist /usr/bin/gpfdist
  5. Verify the installation by running the gpfdist command.

    #gpfdist
  6. Restart the DataFlow service.

    #tscli --adv service restart dataflow
Make sure the server configuration parameter gp_external_grant_privileges is set to ON for the user running gpload. Also, make sure that port 9015 is opened on the TS cluster.


Was this page helpful?