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

修改列的默认值报错 Can not change default value,是不支持嘛?

Asked Sep 24, 2025 Modified Jan 1, 0001
Viewed 42
2.1

修改列 默认值报错:
ALTER TABLE ods.swap_info MODIFY COLUMN dur int DEFAULT '30'

SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = Can not change default value

试过DUPLICATE KEY模型、UNIQUE KEY模型,都报错。

edited Jan 1, 0001
东方红17
asked Sep 24, 2025
1 Answers

不支持修改默认值

edited Jan 1, 1970
阿渊@SelectDB (没回帖直接加我主页微信)9470
answered Sep 24, 2025
Related Questions
doris存算一体架构中,对表进行冷热分层后,数据放在远程存储cos上面,发现磁盘暴涨的同时cos的读请求量很大。
1 answers
fe报错:write lock timeout
1 answers
Doris BE节点启动后60秒自动重启
1 answers
doris remote udf rpc请求批量处理问题
1 answers
java jdbc操作事务失败
1 answers
doris 通过catalog 同步hive数据报错
1 answers

Terms of service Privacy policy

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