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

Duplicate Key的表数据更新失败

Asked Jan 7 Modified Jan 1, 0001
Viewed 106
3.0

1105 - errCode = 2, detailMessage = Only unique table could be updated.
看了一下文档,说是Duplicate Key的表不支持更新操作,
请问一下,那这种表怎么更新数据呢?

edited Jan 1, 0001
cool_brother1
asked Jan 7
1 Answers

更新需求的话,建议使用unique表。
对于不同表的选择,可以看下这个文档的建议
https://doris.apache.org/zh-CN/docs/table-design/data-model/tips

edited Jan 1, 1970
徐振超@SelectDB7686
answered Jan 7
Related Questions
3.0.6写数据到hive过一段时间报没有权限
doris3.0.6创建外部目录,连接sqlserver数据库,创建语句无报错,目录也创建好了,但目录下无法查到数据库
整库同步中连接器版本问题
1 answers
doris3.0.7切换FE的leader报错ERROR 1105 (HY000): errCode = 2, detailMessage =
1 answers
doris运行报错the report queue size exceeds the limit: 100 current: 101
1 answers
执行SQL报错[INTERNAL_ERROR]Invalid regex expression,java代码可以正常执行
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 中文技术论坛.