【Starrocks 异常解决】-- [routine load] error when primary key size exceed the limit

目录

1、背景

1.1 创建 primary key table 

1.2 load 数据到 tmp 表

2、异常信息

3、解决

---

1、背景

1.1 创建 primary key table 

CREATE TABLE `ext`.`tmp_ods_user_u` (
  `id` string NOT NULL COMMENT "业务主键",
  `create_time` bigint NULL COMMENT "业务创建时间",
  `update_time` bigint NULL COMMENT "业务更新时间",
  `data_time` datetime NULL COMMENT "data_time yyyy-MM-dd HH:mm:ss.SSS"
  
) ENGINE=OLAP 
primary KEY(`id`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`id`) BUCKETS 2 
PROPERTIES (
"compression" = "ZSTD",
"datacache.enable" = "true",
"enable_async_write_back" = "false",
"enable_persistent_index" = "true",
"persistent_index_type" = "CLOUD_NATIVE",
"replication_num" = "2",
"s