The partition column could not be aggregated column and unique table's partition column must be key column.
The partition column could not be aggregated column and unique table's partition column must be key column.
主键表 | StarRocks https://docs.starrocks.io/zh/docs/table_design/table_types/primary_key_table/
注意,如果您使用了数据分布策略,由于目前主键表要求主键必须包括分区列和分桶列,假设采用的数据分布策略是将 dt
作为分区列并且 merchant_id
作为哈希分桶列,则主键还需要包括 dt
和 merchant_id
。
Note that if you use data distribution strategies, the Primary Key table currently requires the primary key to include partitioning and bucketing columns. For example, the data distribution strategy uses dt
as the partitioning column and merchant_id
as the hash bucketing column. The primary key also needs to include dt
and merchant_id
.