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

【已解决】字段a是int类型,做bitmap索引,通过查询条件 where a<>'' ,导致所有数据都查询不到

Asked Mar 25, 2024 Modified Apr 17, 2024
Viewed 36
query 2.0

image.png
image.png

image.png
image.png

edited Apr 17, 2024
huifeideyu25
asked Mar 25, 2024
2 Answers

【解决方法】(引用楼主评论)

将过滤条件修改为 length(commandcode) >= 1

edited Jan 1, 1970
椰子Echo@SelectDB1061
answered Apr 17, 2024

doris是什么版本, commandcode is not null有数据吗?

edited Jan 1, 1970
黄海军@SelectDB4948
answered Mar 26, 2024
Related Questions
doris的group commit使用问题
1 answers
Doris SQL解析慢
1 answers
桶数设置为6,12后,性能还比不上桶为10
1 answers
不考虑数据同步,doris直接跨集群实例查询有哪些方法?
1 answers
实验版本DICT_GET方法预计在什么版本上线
1 answers
异步物化视图刷新失败,提示“errCode = 2, detailMessage = (10.56.88.77)[CANCELLED]failed to open DeltaWriter 90250840: not enough streams 1/2”

Terms of service Privacy policy

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