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

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

Asked Sep 10, 2024 Modified Sep 10, 2024
Viewed 57
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
徐振超@SelectDB7056
answered Sep 10, 2024

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

edited Jan 1, 1970
黄海军@SelectDB4903
answered Sep 11, 2024
Related Questions
bdb过大,3FE因为其中一台机器故障导致fe启动不了,选定了一个fe作为master重新租了集群
1 answers
官方镜像gdb使用报错
1 answers
left join 报错
1 answers
doris2.0.15 unique表部分更新出现副本数据不一致
1 answers
doris 2.0.4 某tablet持续base compaction失败重试
1 answers
执行insert into select语句,偶发be与fe连接错误,[THRIFT_RPC_ERROR]Couldn't open transport for 10.1.0.23:9020 (open() timed out)
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 中文技术论坛.