Partition Key

A partition key consists of one or more columns. The partition key value and the corresponding partitioning strategy can uniquely identify the partition where a tuple is located. Generally, the partition key value is specified by the PARTITION BY clause during table creation.

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

Range partitioned tables and list partitioned tables support a partition key with up to 16 columns. Other partitioned tables support a one-column partition key only.