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

U0100075: GaussDB does not support multiple hash keys

Description

GaussDB does not support multiple hash keys Currently, hash partitioning and list partitioning are used only for single-column partition keys.

Database Type and Version

  • Source database type and version: Oracle versions supported by UGO
  • Target database type and version: GaussDB versions supported by UGO

Syntax Example

CREATE TABLE range_interval
(
 prod_id NUMBER(6),
 time_id TIMESTAMP
)
PARTITION BY HASH(prod_id,time_id) 
(
 PARTITION p1,
 PARTITION p2
);

Suggestion

No solution is available. You are advised to refactor application code or change multi-column partition keys to single-column partition keys.