Questions Tags Users Badges

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

Asked Mar 25, 2024 Modified Apr 17, 2024

Viewed 84

query 2.0

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

3.0.8版本查hive外表报错：[INTERNAL_ERROR][E6] Parameters start = 0, length = 1, are out of bound

doris查询 CATALOG hive 数据，全量查询和分区分批查询总和数据量不一致

doris 4.0.5疑似page cache bug

SQL Error [1105] [HY000]: errCode =2, detailMessage= type UNSUPPORTED is unsupported for Nereids