建表语句：
create table example_db.dim_user_payment(
uid bigint
,last_pay_time date REPLACE DEFAULT “1970-01-01”
,last_login_time date REPLACE DEFAULT “1970-01-01”
,login_bit bitmap BITMAP_UNION NULL COMMENT “”
,payment_bit bitmap BITMAP_UNION NULL COMMENT “”
)ENGINE=OLAP
AGGREGATE KEY (uid)
DISTRIBUTED BY HASH(uid) BUCKETS 2
PROPERTIES (
“replication_num” = “1”
);
插入字段
insert into dim_user_payment values (3,2021-06-17,2021-06-17,to_bitmap(157),to_bitmap(157))
查询语句
select bitmap_union_count(login_bit) from example_db.dim_user_payment;
错误详情
SQL 错误 [1064] [42000]: errCode = 2, detailMessage = there is no scanNode Backend
查其他字段都没事，一涉及bitmap字段就会报这个错