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

查询结果和插入结果不一致

Asked Sep 10, 2024 Modified Sep 10, 2024
Viewed 62
2.0

image.png查询的结果是39594.75,yb_type22222=1没有生效,导致全部数据插入
image.png
image.png
不应该出现null的

edited Sep 10, 2024
sdhzwc8
asked Sep 10, 2024
2 Answers

目前通过 case when paytype is null then '0' else '1' end as yb_type 绕过去,待复现案例,后面继续跟进,有进展会同步到论坛

edited Jan 1, 1970
徐振超@SelectDB8021
answered Sep 10, 2024

执行这个再插入看看呢:
set glbal enable_nereids_dml=true

edited Jan 1, 1970
黄海军@SelectDB5208
answered Sep 11, 2024
Related Questions
fe节点空指针,两个be节点只有一个存活
1 answers
求助:be频繁重启,目前推测由于arm内存管理,能否分析帮忙具体报错和提供解决措施?
doris单表分区数量限制
1 answers
EXPORT 导出cvs 数据为空 导出为\N 怎么修改这个设置
1 answers
【求助】升级到2.1.8版本后,从S3导入数据变慢
1 answers
storage policy删除以后,日志一直报could not find storage_policy
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 中文技术论坛.