Issues when using an unsupported datatype for the PXF filter Pushdown

Products

• VMware Tanzu Greenplum

Issue/Introduction

The PXF filter Pushdown supports the following data types as documented here: About PXF Filter Pushdown

INT2, INT4, INT8
CHAR, TEXT
FLOAT
NUMERIC (not available with the S3 connector when using S3 Select)
BOOL
DATE, TIMESTAMP

Using an unsupported data type, such as varchar, for the Pushdown filter can cause issues such as slowness or other issues when accessing the data.

Environment

Product Version: 6.9

Resolution

Workaround

In such cases where unsupported varchar data type is used for pushdown, the workaround is to change the data type to text since it supports the predicate Pushdown.