ErrorReason{code=errCode = 2, msg='failed to create task: errCode = 2, detailMessage = unknown reference column, column="__DORIS_DELETE_SIGN__", reference="__DORIS_DELETE_SIGN__"}

[dcy652701]

ErrorReason{code=errCode = 2, msg='failed to create task: errCode = 2, detailMessage = unknown reference column, column="DORIS_DELETE_SIGN", reference="DORIS_DELETE_SIGN"}

I have enabled batch delete.The document said the table will add a hidden column DELETE_SIGN ,but my table added a hidden column called DORIS_DELETE_SIGN.It has a prifex "__DORIS"，and I failed to create a ROUTINE LOAD with message above information from the beginning.

[dcy652701]

my table:
CREATE TABLE tablename(
id int(11),
couponCode varchar(60),
couponNo varchar(60),
phone varchar(15),
userId int(11),
)UNIQUE KEY (id,couponCode)
DISTRIBUTED BY HASH(id,couponCode) BUCKETS 15
PROPERTIES("replication_num" = "3",
"enable_batch_delete_by_default" = "true");

my ROUTINE LOAD:
CREATE ROUTINE LOAD loverent_oss.discount_use_not ON discount_use_not
WITH MERGE
COLUMNS(id, couponCode, couponNo, phone, userId),
DELETE ON delete_sign=true
PROPERTIES
(
"desired_concurrent_number"="3",
"max_batch_interval" = "6",
"max_batch_rows" = "300000",
"max_batch_size" = "209715200",
"strict_mode" = "false",
"format" = "json"
)
FROM KAFKA
(
"kafka_broker_list" = "192.168.1.161:9092,192.168.1.162:9092,192.168.1.163:9092",
"kafka_topic" = "test"
);

[dcy652701]

Sorry I realize that condition "delete_sign=true" on "DELETE ON" is not defined in table.First column "delete_sign" need to be defined in table.