Doris-Unique模型标记删除

指定sequence_type类型

目前只支持bigint和date两种

ALTER TABLE ods.ods_esc_system_oct_buyer_one_sale_goods      ENABLE FEATURE "SEQUENCE_LOAD" WITH PROPERTIES ("function_column.sequence_type" = "bigint");

显示隐藏列

SET show_hidden_columns='true';

查看标记删除功能有没生效，当出现有__DORIS_DELETE_SIGN__列，即为生效

若要将数据标记删除，则将__DORIS_DELETE_SIGN__列赋值为1即可

insert into test.`doris_delete_test`
(a
,b
,c
,__DORIS_DELETE_SIGN__
)
select 
"1"
,"3"
,"3"
,"1"  __DORIS_DELETE_SIGN__