Pivotal Knowledge Base

Follow

gp_restore/gpdbrestore Error: "Protocal ""gpfdist" Does Not Exist."

Environment 

 Product  Version
 Pivotal Greenplum   4.3.x
 OS  All

Symptom

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.

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 the SPACE is removed from the DDL, then restore will succeed.

Workaround

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

Comments

Powered by Zendesk