Apache Doris 中文技术论坛
Questions Tags Users Badges

pk表insert之后 查询会出现2条数据互相切换

Asked Oct 13 Modified Jan 1, 0001
Viewed 32
2.1

doris-2.1.10

create table : UNIQUE KEY(aaaid)
seq: "function_column.sequence_col" = "update_time"

sql插入:

INSERT INTO companyInfo ( DORIS_DELETE_SIGN,aaaid,orgtype,credate_time,update_time ) VALUES
( 1,'156107564734','91','2025-06-30 16:08:04','2025-09-23 18:10:12' )
,( 0,'156107564734','91','2025-06-30 16:08:04','2025-10-11 11:28:40.563' )

多次查询会出现上面2条数据里面随机返回一条

edited Jan 1, 0001
Jay16
asked Oct 13
1 Answers

你可以了解一下doris的删除原理
https://doris.apache.org/zh-CN/docs/2.1/data-operate/update/update-overview#23-%E5%88%A0%E9%99%A4%E6%9C%BA%E5%88%B6-doris_delete_sign-%E5%B7%A5%E4%BD%9C%E6%B5%81%E7%A8%8B

edited Jan 1, 1970
徐振超@SelectDB7931
answered Oct 15
Related Questions
fe节点加入集群时报错
1 answers
大佬们求助,授予角色可以创建catalog的权限报错
1 answers
关于catalog_paimon环境下如何启用paimonNativeReadSplits?
1 answers
不同doris集群如何同步数据?
1 answers
bitmap类型设置默认值后,数据导入报错can not cast from origin type bitmap to target type=varchar(65533)
1 answers
doris2.1.8,相同的sql,不同账期但数据量差异,大小表join,有时候会自动join reorder导致OOM
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2025 Apache Doris 中文技术论坛.