Updated on 2025-05-29 GMT+08:00

Partitioning Policy

Partitioning policies describe the mapping between data and partition routes in a partitioned table. The PARTITION BY syntax in the DDL statement is used to specify the partitioning policies during table creation.

Common partitioning types include condition-based range partitioning, hash partitioning based on hash functions, and list partitioning based on data enumeration.

CREATE TABLE table_name (…) PARTITION BY partition_strategy (partition_key) (…)