Primary-key index exceeds the limit. tablet_id: 146088, consumption: 17458787440, limit: 16313400040. Memory stats of top five tablets: 146348(3329M)146364(3329M)146360(3329M)146352(3329M)146356(3329M)
主键表没有分区键吗?建议加个。
有按月分区,目前数据量5亿+,再追加不了,要怎么优化
StarRocks什么版本?
current_version 2.3.0
升级2.3将 enable_persistent_index打开 ALTER TABLE table_name set (“enable_persistent_index” = “true”);
PrimaryKey table using persistent index don’t support varchar(char) as key so far, and key length should be no more than 64 Bytes
就是主键太长了,这个参数不支持超过64bytes的。