Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Objects/ Checking Whether the Source Table Contains Column Types that Cannot Be Used as Distribution Keys
Updated on 2022-09-21 GMT+08:00

Checking Whether the Source Table Contains Column Types that Cannot Be Used as Distribution Keys

PostgreSQL to GaussDB(DWS) Synchronization

Table 1 Checking whether the source table contains column types that cannot be used as distribution keys

Check Item

Whether the source table contains column types that cannot be used as distribution keys

Description

The source table cannot contain column types used as distribution keys. Otherwise, the synchronization may fail.

Failure Cause and Handling Suggestion

Failure cause: The source table contains column types that cannot be used as distribution keys.

Handling suggestion: Select another table that can be migrated.