gp_restore/gpdbrestore Error "Protocal ""gpfdist" does not exist."

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

While creating an external table using the statement below, restore fails due to extra space in LOCATION:

create external table test_ext (c1 int ) LOCATION ('gpfdist://127.0.4/aaa/test.csv ') format 'CSV';

 

Please pay attention to above DDL: There is a space after 'test.csv'. The external table can be created, gpdump/gpcrondump can also succeed, however, gp_restore/gpdbrestore will fail.

From the restore log, we will see error messages like:

protocal ""gpfdist" does not exist.

Environment

Cause

There is an additional character like SPACE in the LOCATION clause of CREATE EXTERNAL TABLE DDL statement like in the DDL mentioned above. If SPACE is removed from the DDL, then restore will succeed.

 

Resolution

Drop and recreate the external table after removing any unnecessary characters in DDL.