base64_to_bitmap
Before you import bitmap data into StarRocks, you need to serialize the data and encode the data as a Base64 string.
bitmap_agg
Aggregates values (excluding NULLs) in a column into a bitmap (multiple rows into one row).
bitmap_and
Calculates the intersection of two input bitmaps and returns the new bitmap.
bitmap_andnot
Returns bitmap values that exist in `lhs` but do not exist in `rhs`, and returns the new bitmap.
bitmap_contains
Calculates whether the input value is in the bitmap column, and returns a Boolean value.
bitmap_count
Returns the 1-bit count for the input bitmap.
bitmap_empty
Returns an empty bitmap.
bitmap_from_binary
Converts a binary string with a specific format to a bitmap.
bitmap_from_string
Converts a string into a BITMAP.
bitmap_has_any
Calculates whether there are intersecting elements between two Bitmap columns, and the return value is Boolean value.
bitmap_hash
Calculates a 32-bit hash value for any type of input and return the bitmap containing the hash value.
bitmap_hash64
Calculates a 64-bit hash value for any type of input and returns a bitmap containing the hash value.
bitmap_intersect
Aggregation function, used to calculate the bitmap intersection after grouping.
bitmap_max
Obtains the maximum value of a bitmap.
bitmap_min
Obtains the minimum value of a bitmap.
bitmap_or
Calculates the union of two input bitmaps and return a new bitmap.
bitmap_remove
Removes `input` from the Bitmap value `lhs` and returns a result set.
bitmap_subset_in_range
Intercepts elements from a Bitmap value within the range of `start_range` and `end_range` (exclusive).
bitmap_subset_limit
Intercepts a specified number of elements from a BITMAP value with element value starting from `start range`.
bitmap_to_array
Converts a BITMAP into a BIGINT array.
bitmap_to_base64
Converts a bitmap to a Base64-encoded string.
bitmap_to_binary
Converts Bitmap values to a Binary string.
bitmap_to_string
Converts an input bitmap into a string that is separated by commas (,).
bitmap_union
Calculates the bitmap union of a set of values after grouping.
bitmap_union_count
Returns the union of a set of bitmap values and returns the cardinality of the union.
bitmap_union_int
Count the number of different values ββin columns of type TINYINT, SMALLINT and INT, return the sum of COUNT (DISTINCT expr) same.
bitmap_xor
Calculates the set consisting elements unique to `lhs` and `rhs`.
intersect_count
A function to find the intersection size (number of same elements) of two Bitmap values, without requiring the data distribution to be orthogonal.
sub_bitmap
Intercepts `len` elements from a BITMAP value `src` starting from the position specified by `offset`.
subdivide_bitmap
Splits a large bitmap into multiple sub-bitmaps.
to_bitmap
The input is unsigned bigint with the value ranging from 0 to 18446744073709551615, and the output is bitmap containing this element.
unnest_bitmap
unnest_bitmap is a table function that takes a bitmap and converts elements in that bitmap into multiple rows of a table.