Partial update in Routine Load does not work

[shuang-qin]

CREATE TABLE internal_test__foo_snapshot (
foo_id VARCHAR(36),
event_time DATETIME(3),
event_id VARCHAR(36),
s_attr VARCHAR(2047),
i32_attr INT,
i64_attr BIGINT,
f_attr FLOAT,
d_attr DOUBLE,
e_attr VARCHAR(256),
org_id VARCHAR(36),
receive_time DATETIME(3)
)
ENGINE = OLAP
UNIQUE KEY (foo_id)
DISTRIBUTED BY HASH(foo_id) BUCKETS 10
PROPERTIES (
"replication_num" = "1",
"enable_unique_key_merge_on_write" = "true"
);

[shuang-qin]

CREATE ROUTINE LOAD e2e_snapshot_routine_load_1761919982278
ON internal_test__foo_snapshot
WITH MERGE COLUMNS (
kafka_event_time,
event_id,
foo_id,
s_attr,
i32_attr,
i64_attr,
f_attr,
d_attr,
e_attr,
org_id,
kafka_receive_time,
operation,
event_time = from_unixtime(kafka_event_time),
receive_time = from_unixtime(kafka_receive_time)
)
DELETE ON operation = "DELETE"
PROPERTIES (
"format" = "json",
"max_batch_interval" = "10",
"max_batch_rows" = "200000",
"max_batch_size" = "104857600",
"strict_mode" = "false",
"max_error_number" = "1000",
"max_filter_ratio" = "0.1",
"timezone" = "UTC",
"partial_columns" = "true",
"jsonpaths" = "["$.event_time","$.event_id","$.attributes.foo_id","$.attributes.s_attr","$.attributes.i32_attr","$.attributes.i64_attr","$.attributes.f_attr","$.attributes.d_attr","$.attributes.e_attr","$.org_id","$.receive_time","$.operation"]"
)
FROM KAFKA (
"kafka_broker_list" = "172.30.180.22:29092",
"kafka_topic" = "snapshot",
"property.kafka_default_offsets" = "OFFSET_END",
"property.group.id" = "routine-load-consumer"
);

[shuang-qin]

My configuration is as shown above, thanks.