ποΈ 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.
