[GitHub] [doris] siriume opened a new issue, #13253: [Feature] to_bitmap function support date/datev2.

[GitBox <gi...@apache.org>]

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-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org