Installing Java for PXF

A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 5.x documentation.

PXF is a Java service. It requires a Java 1.8 installation on each Greenplum Database host.

If an appropriate version of Java is already installed on each Greenplum Database host, you need not perform the procedure in this topic.

Prerequisites

Ensure that you have access to, or superuser permissions to install, Java version 1.8 on each Greenplum Database host.

Procedure

Perform the following procedure to install Java on the master, standby master, and on each segment host in your Greenplum Database cluster. You will use the gpssh utility where possible to run a command on multiple hosts.

  1. Log in to your Greenplum Database master node:

    $ ssh gpadmin@<gpmaster>
    
  2. Create a text file that lists your Greenplum Database standby master host and segment hosts, one host name per line. For example, a file named gphostfile may include:

    mstandby
    seghost1
    seghost2
    seghost3
    
  3. Install Java on the master, standby master, and on each Greenplum Database segment host, and then set up the Java environment on each host.

    1. Install the Java package. For example, to install Java version 1.8:

      gpadmin@gpmaster$ sudo yum -y install java-1.8.0-openjdk-1.8.0*
      gpadmin@gpmaster$ gpssh -e -v -f gphostfile sudo yum -y install java-1.8.0-openjdk-1.8.0*
      
    2. Identify the Java base install directory. Update the gpadmin user’s .bashrc file on each host to include this $JAVA_HOME setting if it is not already present. For example:

      gpadmin@gpmaster$ echo 'export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.x86_64/jre' >> /home/gpadmin/.bashrc
      gpadmin@gpmaster$ gpssh -e -v -f gphostfile "echo 'export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.x86_64/jre' >> /home/gpadmin/.bashrc"