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

Doris外部表查询全零时间的记录失败

Asked Nov 4, 2024 Modified Jan 1, 0001
Viewed 88
2.1

MySQL表中存在时间为“0000-00-00 00:00:00”的数据。
image.png
Doris创建外部表后,查询这条数据失败。
image.png

edited Jan 1, 0001
lzwlzw5
asked Nov 4, 2024
1 Answers

https://doris.apache.org/zh-CN/docs/lakehouse/database/mysql#%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98

image.png

edited Jan 1, 1970
zy-kkk691
answered Nov 4, 2024
Related Questions
doris2.1.11读取spark报错
doris2.1.11脚本执行报failed to send brpc when exchange
1 answers
SelectDB Doris 2.1.8-3:CCR 下游集群 20 台 BE 缩容 1 台时 lag 持续增大,取消缩容后恢复
1 answers
jetty 安全漏洞CVE-2026-10050
1 answers
通过spark connector写入数据时,doris.fenodes配置了多个节点,但只有第一个节点生效。
1 answers
Flink Connector 26.3.0 读取 DATETIME 变成 1970 年,切换 25.0.0 后正常
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 中文技术论坛.