BASE64_TO_BITMAP
Learn how to use the BASE64_TO_BITMAP bitmap function in PlaidCloud Lakehouse. Converts a base64-encoded string to a bitmap - with syntax and examples.
Bitmap Functions
This section provides reference information for the bitmap functions in PlaidCloud Lakehouse.
BITMAP_AGG
Learn how to use the BITMAP_AGG bitmap function in PlaidCloud Lakehouse. Aggregates integer values into a bitmap - see syntax, examples, and output.
BITMAP_AND
Learn how to use the BITMAP_AND bitmap function in PlaidCloud Lakehouse. Returns the intersection of two bitmaps - see syntax, examples, and output.
BITMAP_ANDNOT
Learn how to use the BITMAP_ANDNOT bitmap function in PlaidCloud Lakehouse. Returns the difference of two bitmaps (elements in first but not second).
BITMAP_CONTAINS
Learn how to use the BITMAP_CONTAINS bitmap function in PlaidCloud Lakehouse. Checks whether a bitmap contains a specific value - with syntax and examples.
BITMAP_COUNT
Learn how to use the BITMAP_COUNT bitmap function in PlaidCloud Lakehouse. Returns the number of set bits in a bitmap - see syntax, examples, and output.
BITMAP_EMPTY
Learn how to use the BITMAP_EMPTY bitmap function in PlaidCloud Lakehouse. Returns an empty bitmap - see syntax, examples, and output.
BITMAP_FROM_BINARY
Learn how to use the BITMAP_FROM_BINARY bitmap function in PlaidCloud Lakehouse. Converts a binary value to a bitmap - see syntax, examples, and output.
BITMAP_FROM_STRING
Learn how to use the BITMAP_FROM_STRING bitmap function in PlaidCloud Lakehouse. Converts a comma-separated string of integers to a bitmap.
BITMAP_HAS_ANY
Learn how to use the BITMAP_HAS_ANY bitmap function in PlaidCloud Lakehouse. Checks whether two bitmaps have any common elements - with syntax and examples.
BITMAP_HASH
Learn how to use the BITMAP_HASH bitmap function in PlaidCloud Lakehouse. Computes a 32-bit hash of a value and returns a bitmap containing that hash.
BITMAP_HASH64
Learn how to use the BITMAP_HASH64 bitmap function in PlaidCloud Lakehouse. Computes a 64-bit hash of a value and returns a bitmap containing that hash.
BITMAP_INTERSECT
Learn how to use the BITMAP_INTERSECT bitmap function in PlaidCloud Lakehouse. Returns the intersection of a set of bitmaps (aggregate).
BITMAP_MAX
Learn how to use the BITMAP_MAX bitmap function in PlaidCloud Lakehouse. Returns the maximum value in a bitmap - see syntax, examples, and output.
BITMAP_MIN
Learn how to use the BITMAP_MIN bitmap function in PlaidCloud Lakehouse. Returns the minimum value in a bitmap - see syntax, examples, and output.
BITMAP_OR
Learn how to use the BITMAP_OR bitmap function in PlaidCloud Lakehouse. Returns the union of two bitmaps - see syntax, examples, and output.
BITMAP_REMOVE
Learn how to use the BITMAP_REMOVE bitmap function in PlaidCloud Lakehouse. Removes a specific value from a bitmap - see syntax, examples, and output.
BITMAP_SUBSET_IN_RANGE
Learn how to use the BITMAP_SUBSET_IN_RANGE bitmap function in PlaidCloud Lakehouse. Returns a subset of a bitmap within a specified range.
BITMAP_SUBSET_LIMIT
Learn how to use the BITMAP_SUBSET_LIMIT bitmap function in PlaidCloud Lakehouse. Returns a subset of a bitmap starting from an offset with a cardinality limit.
BITMAP_TO_ARRAY
Learn how to use the BITMAP_TO_ARRAY bitmap function in PlaidCloud Lakehouse. Converts a bitmap to an array of integers - see syntax, examples, and output.
BITMAP_TO_BASE64
Learn how to use the BITMAP_TO_BASE64 bitmap function in PlaidCloud Lakehouse. Converts a bitmap to a base64-encoded string - with syntax and examples.
BITMAP_TO_BINARY
Learn how to use the BITMAP_TO_BINARY bitmap function in PlaidCloud Lakehouse. Converts a bitmap to a binary value - see syntax, examples, and output.
BITMAP_TO_STRING
Learn how to use the BITMAP_TO_STRING bitmap function in PlaidCloud Lakehouse. Converts a bitmap to a comma-separated string - with syntax and examples.
BITMAP_UNION
Learn how to use the BITMAP_UNION bitmap function in PlaidCloud Lakehouse. Returns the union of a set of bitmaps (aggregate) - with syntax and examples.
BITMAP_UNION_COUNT
Learn how to use the BITMAP_UNION_COUNT bitmap function in PlaidCloud Lakehouse. Returns the count of distinct values in the union of a set of bitmaps.
BITMAP_UNION_INT
Learn how to use the BITMAP_UNION_INT bitmap function in PlaidCloud Lakehouse. Returns the count of distinct integer values (aggregate).
BITMAP_XOR
Learn how to use the BITMAP_XOR bitmap function in PlaidCloud Lakehouse. Returns the symmetric difference of two bitmaps - see syntax, examples, and output.
INTERSECT_COUNT
Use the INTERSECT_COUNT bitmap function in PlaidCloud Lakehouse. Returns the count of elements in the intersection of multiple bitmaps filtered by dimension.
SUB_BITMAP
Learn how to use the SUB_BITMAP bitmap function in PlaidCloud Lakehouse. Returns a sub-bitmap starting from a specified position with a cardinality limit.
SUBDIVIDE_BITMAP
Learn how to use the SUBDIVIDE_BITMAP bitmap function in PlaidCloud Lakehouse. Splits a bitmap into multiple sub-bitmaps of a given size.
TO_BITMAP
Learn how to use the TO_BITMAP bitmap function in PlaidCloud Lakehouse. Converts an integer value to a bitmap containing that single value.
UNNEST_BITMAP
Learn how to use the UNNEST_BITMAP bitmap function in PlaidCloud Lakehouse. Expands a bitmap into a set of rows - see syntax, examples, and output.