SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Only value columns of unique table could be updated.

[Alicenhg]

Spring Cloud encountered this error when integrating with Doris using JPA, as an ID field was created in the Doris entity object, triggering a save operation error

SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Only value columns of unique table could be updated.

[yagagagaga]

Only unique table supports update.

[jiangxiaoqiang]

I defined the uniq key using two columns, but could not update.

CREATE TABLE `member_access` (
  `member_id` bigint(20) not NULL COMMENT '推荐人id',
  `access_date` date not NULL COMMENT '访问日期',
  `id` bigint(20) not NULL COMMENT 'id'
) ENGINE=OLAP
UNIQUE KEY(`member_id`,`access_date`)
COMMENT '会员访问'
DISTRIBUTED BY HASH(`member_id`, `access_date`) BUCKETS AUTO
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"bloom_filter_columns" = "member_id",
"is_being_synced" = "false",
"storage_format" = "V2",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false"
);

[ixzc]

please provide error information