Pivotal Greenplum Platform Extension Framework 5.13 Release Notes

Release Date: June 26, 2020

The Pivotal Greenplum Platform Extension Framework (PXF) is included in the Pivotal Greenplum Database distribution. PXF for Redhat/CentOS and Oracle Enterprise Linux is now updated and distributed independently of Greenplum Database starting with PXF version 5.13.0. You may need to download and install the PXF package to obtain the most recent version of this component.

Supported Platforms

The independent PXF distribution is compatible with these operating system platform and Greenplum versions:

OS Version Greenplum Version
RHEL 7.x, CentOS 7.x 5.21.2+, 6.x
RHEL 6.x, CentOS 6.x 5.21.2+
OEL 7.x 6.x
Starting in 6.x, Greenplum does not bundle cURL and instead loads the system-provided library. PXF requires cURL version 7.29.0 or newer. The officially-supported cURL for the CentOS 6.x and Red Hat Enterprise Linux 6.x operating systems is version 7.19.*. Greenplum Database 6 does not support running PXF on CentOS 6.x or RHEL 6.x due to this limitation.

PXF is compatible with these Java and Hadoop component versions:

PXF Version Java Versions Hadoop Versions Hive Server Versions HBase Server Version
5.13 8, 11 2.x, 3.1+ 1.x, 2.x, 3.1+ 1.3.2

New and Changed Features

PXF 5.13.0 includes these new and changed features since PXF 5.12.0:

  • PXF 5.13.0 is the first standalone release of PXF for RedHat/CentOS that is distributed separately from Greenplum Database.

Resolved Issues

PXF 5.13.0 resolves these issues:

Issue # Summary
364 PXF fixes an issue where it did not correctly read from an external table when the LOCATION clause included back-quoted text.
30640 The use of the pxf.service.user.name property was not clear. The PXF pxf-site.xml template file now includes an enhanced description of the property.

Deprecated Features

Deprecated features may be removed in a future major release of PXF. PXF version 5.x deprecates:

  • The PXF_USER_IMPERSONATION, PXF_PRINCIPAL, and PXF_KEYTAB settings in the pxf-env.sh file. You can use the pxf-site.xml file to configure Kerberos and impersonation settings for your new Hadoop server configurations (deprecated since PXF version 5.10.0).
  • The pxf.impersonation.jdbc property setting in the jdbc-site.xml file. You can use the pxf.service.user.impersonation property to configure user impersonation for a new JDBC server configuration (deprecated since PXF version 5.10.0).
  • The HDFS profile names for the Text, Avro, JSON, Parquet, and SequenceFile data formats (deprecated since PXF version 5.0.1). Refer to Connectors, Data Formats, and Profiles in the PXF Hadoop documentation for more information.

Known Issues and Limitations

PXF 5.13.x has these known issues and limitations:

Issue # Description
168957894 The PXF Hive Connector does not support using the Hive* profiles to access Hive transactional tables.
Workaround: Use the PXF JDBC Connector to access Hive.