[Enhancement] Support bitmap function: bitmap_distinct

[dinggege1024]

Search before asking

• I had searched in the issues and found no similar issues.

Description

I need bitmap_distinct for data handling.

My requirement is to use the features of Bitmap itself to deduplicate columns and obtain the unique column values.

Current situation(Reasons for dissatisfaction):

        SELECT
            dt
            ,bitmap_to_string(bitmap_union(to_bitmap(user_id)))
        FROM
            mytable
        GROUP BY
            dt

it return one column for user_id

Expected:

        SELECT
            dt
            ,bitmap_distinct(to_bitmap(user_id))
        FROM
            mytable
        GROUP BY
            dt

Solution

Doris Java UDF

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[LemonLiTree]

I think you can solve this problem using explode_bitmap
https://doris.apache.org/zh-CN/docs/dev/sql-manual/sql-functions/table-functions/explode-bitmap

[dinggege1024]

Tks, it works, should add this func into bitmap func docs?

[LemonLiTree]

Actually this is a table functions, I think it is possible to add a case to this document ：https://doris.apache.org/docs/dev/advanced/orthogonal-bitmap-manual/
Would you like to create a PR to supplement?

[dinggege1024]

Actually this is a table functions, I think it is possible to add a case to this document ：https://doris.apache.org/docs/dev/advanced/orthogonal-bitmap-manual/ Would you like to create a PR to supplement?

ok