- Pivotal Greenplum Database (GPDB) 4.3.x
- Operating System- All supported
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.
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.
Drop and recreate the external table after removing any unnecessary characters in DDL.