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

Partitioning Policy

A partitioning policy is specified by the syntax of the PARTITION BY statement when DDL statements are used to create tables. A partitioning policy describes the mapping between data in a partitioned table and partition routes. 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) (…)