GPDB 6.x fails to connect to gpfdist service using SSL

Products

• VMware Tanzu Greenplum

Issue/Introduction

For Greenplum Database 6.x, a command that accesses an external table that uses the gpfdist protocol fails if the external table does not use an IP address when specifying a host system in the LOCATION clause of the external table definition.

The following error is reported:

ERROR:  connection with gpfdist failed for "gpfdists://host.domain.com:8000/file.csv", effective url: "https://host.domain.com:8000/file.csv": ;  (seg0 slice1 192.168.192.51:6500 pid=8961)

There is no output from the gpfdist process. The Greenplum database does not attempt to connect to the gpfdist service.

Environment

Product Version: 6.10

Resolution

Workaround

Specify the IP address of the host running gpfdist service in the LOCATION of the external table. For example:

CREATE EXTERNAL TABLE table01 ( col01 int, col02 text) 
   LOCATION ( 'gpfdists://10.10.10.10:8000/file.csv') FORMAT 'CSV';

Fix

This issue has been fixed in version 6.11.1.