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.

 

posted @ 2024-07-22 18:28  papering  阅读(9)  评论(0编辑  收藏  举报