Help Center/ GaussDB(DWS)/ Troubleshooting/ Data Import and Export/ Failed to Create a GDS Foreign Table and An Error Is Reported Indicating that ROUNDROBIN Is Not Supported
Updated on 2023-04-18 GMT+08:00

Failed to Create a GDS Foreign Table and An Error Is Reported Indicating that ROUNDROBIN Is Not Supported

Symptom

A GDS foreign table cannot be created and an error is reported indicating that ROUNDROBIN is not supported. The message is as follows:

1
ERROR:  For foreign table ROUNDROBIN distribution type is built-in support.

Possible Causes

By default, a GDS foreign table is created in ROUNDROBIN distribution mode. ROUNDROBIN distribution information cannot be explicitly added during table creation.

Handling Procedure

When creating a GDS foreign table, delete the specified distribution information, that is, delete the specified DISTRIBUTE BY ROUNDROBIN in the statement.