[ https://issues.apache.org/jira/browse/FLINK-24959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ZhuoYu Chen updated FLINK-24959: -------------------------------- Description: BITMAP_AND :{color:#333333}Computes the intersection of two input bitmaps and returns the new bitmap {color} select bitmap_count(bitmap_and(to_bitmap(1), to_bitmap(2))) cnt; {color:#333333} {color} {color:#333333}{{TO_BITMAP:input for the value of 0 ~ 18446744073709551615 unsigned bigint in the range, the output for the bitmap containing the element. This function is mainly used for stream load task to import integer fields into the bitmap field of the table}} {color} {code:java} select bitmap_count(to_bitmap(10)); {code} {color:#30323e}BITMAP_ANDNOT:Computes the set (difference set) that is in A but not in B.{color} {code:java} select bitmap_to_string(bitmap_andnot(bitmap_from_string('1, 3'), bitmap_from_string('2'))) cnt; {code} Bitmap functions related to join operations, etc was: bitmap_and :{color:#333333}Computes the intersection of two input bitmaps and returns the new bitmap{color} {color:#30323e}bitmap_andnot:{color:#333333}Computes the set (difference set) that is in A but not in B.{color}{color} {color:#30323e}{color:#333333}Bitmap functions related to join operations, etc{color}{color} > Add a BitMap function to FlinkSQL > --------------------------------- > > Key: FLINK-24959 > URL: https://issues.apache.org/jira/browse/FLINK-24959 > Project: Flink > Issue Type: New Feature > Components: Table SQL / API > Affects Versions: 1.15.0 > Reporter: ZhuoYu Chen > Priority: Minor > > BITMAP_AND :{color:#333333}Computes the intersection of two input bitmaps and > returns the new bitmap > {color} > select bitmap_count(bitmap_and(to_bitmap(1), to_bitmap(2))) cnt; > {color:#333333} {color} > {color:#333333}{{TO_BITMAP:input for the value of 0 ~ 18446744073709551615 > unsigned bigint in the range, the output for the bitmap containing the > element. This function is mainly used for stream load task to import integer > fields into the bitmap field of the table}} > {color} > {code:java} > select bitmap_count(to_bitmap(10)); {code} > {color:#30323e}BITMAP_ANDNOT:Computes the set (difference set) that is in A > but not in B.{color} > {code:java} > select bitmap_to_string(bitmap_andnot(bitmap_from_string('1, 3'), > bitmap_from_string('2'))) cnt; {code} > Bitmap functions related to join operations, etc -- This message was sent by Atlassian Jira (v8.20.1#820001)