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

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

Asked Mar 25, 2024 Modified Apr 17, 2024
Viewed 93
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@SelectDB1111
answered Apr 17, 2024

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

edited Jan 1, 1970
黄海军@SelectDB5218
answered Mar 26, 2024
Related Questions
Doris3.1.4并发查询速度变慢
1 answers
ranger新增的表权限,在doris中不生效,doris版本 Version : doris-4.1.3-rc02
1 answers
max_by会不会忽略null值
1 answers
排序查询冷却到远程存储的数据报错
1 answers
Doris4.0.5版本有没有可以用低权执行select语句的curl接口
1 answers
3.0.8版本查hive外表报错:[INTERNAL_ERROR][E6] Parameters start = 0, length = 1, are out of bound
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 中文技术论坛.