Pivotal Knowledge Base

Follow

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

Environment 

  • Pivotal Greenplum Database (GPDB) 4.3.x
  • Operating System- All supported

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

Resolution

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

Comments

Powered by Zendesk