siriume opened a new issue, #13253: URL: https://github.com/apache/doris/issues/13253
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Description to_bitmap function on only support int type, Please support date/datev2 type. ### Use case case 1: ```sql create table id_date_bitmap ( `id` int(11) NOT NULL COMMENT 'id', `date` bitmap BITMAP_UNION COMMENT 'date' )ENGINE=OLAP AGGREGATE KEY(`id`) COMMENT "bitmap test" DISTRIBUTED BY HASH(`id`) BUCKETS 4; insert into id_date_bitmap select id,account_id,to_bitmap(`date`) `date` from xxxx where `cost` > 0; ``` case 2: ```sql create table tb_account ( `id` int(11) NOT NULL COMMENT 'id', `account_id` varchar(90) NOT NULL COMMENT 'account_id', `date` date COMMENT 'date' )ENGINE=OLAP AGGREGATE KEY(`id`, `account_id`) COMMENT "bitmap test" DISTRIBUTED BY HASH(`id`) BUCKETS 4; create materialized view tb_account_id as select id, bitmap_union(to_bitmap(`date`)) from id_date_bitmap group by id; create materialized view tb_account_account_id as select account_id, bitmap_union(to_bitmap(`date`)) from id_date_bitmap group by account_id; ``` ### Related issues _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
