Updated on 2025-06-07 GMT+08:00

U0000007: GaussDB Distributed does not support subpartitions

Description

Database Type and Version

  • Source database type and version: all types of the source database with subpartitioned tables
  • Target database type and version: GaussDB Distributed

Syntax Example

This error is reported because UGO does not convert subpartitions by default. The following example is not supported in GaussDB Distributed:

CREATE TABLE subpartition_test (
    id INT,
    purchased DATE
) PARTITION BY RANGE( purchased )
    SUBPARTITION BY HASH( purchased ) (
        PARTITION p0 VALUES LESS THAN ('1990-01-01') (
            SUBPARTITION p0_a,
            SUBPARTITION p0_b
        ),
        PARTITION p1 VALUES LESS THAN ('2000-01-01') (
            SUBPARTITION p1_a,
            SUBPARTITION p1_b
        )
);

Suggestion

Modify Support for sub partition.