BITMAP_AND
Learn how to use the BITMAP_AND bitmap function in PlaidCloud Lakehouse. Performs a bitwise AND operation on the two bitmaps. Includes syntax and examples.
Bitmap Functions
This section provides reference information for the bitmap functions in PlaidCloud Lakehouse.
BITMAP_AND_COUNT
Learn how to use the BITMAP_AND_COUNT bitmap function in PlaidCloud Lakehouse. Counts the number of bits set to 1 in the bitmap by performing a logical AND...
BITMAP_AND_NOT
Learn how to use BITMAP_AND_NOT in PlaidCloud Lakehouse. Alias for the BITMAP_NOT bitmap function. Includes detailed syntax, examples, and usage reference.
BITMAP_CARDINALITY
Learn how to use BITMAP_CARDINALITY in PlaidCloud Lakehouse. Alias for the BITMAP_COUNT bitmap function. Reference with syntax and examples.
BITMAP_CONTAINS
Learn how to use the BITMAP_CONTAINS bitmap function in PlaidCloud Lakehouse. Checks if the bitmap contains a specific value. Includes syntax and examples.
BITMAP_COUNT
Learn how to use the BITMAP_COUNT bitmap function in PlaidCloud Lakehouse. Counts the number of bits set to 1 in the bitmap. Includes syntax and examples.
BITMAP_HAS_ALL
Learn how to use the BITMAP_HAS_ALL bitmap function in PlaidCloud Lakehouse. Checks if the first bitmap contains all the bits in the second bitmap.
BITMAP_HAS_ANY
Learn how to use the BITMAP_HAS_ANY bitmap function in PlaidCloud Lakehouse. Checks if the first bitmap has any bit matching the bits in the second bitmap.
BITMAP_INTERSECT
Learn how to use the BITMAP_INTERSECT bitmap function in PlaidCloud Lakehouse. Counts the number of bits set to 1 in the bitmap by performing a logical...
BITMAP_MAX
Learn how to use the BITMAP_MAX bitmap function in PlaidCloud Lakehouse. Gets the maximum value in the bitmap. Includes syntax and examples.
BITMAP_MIN
Learn how to use the BITMAP_MIN bitmap function in PlaidCloud Lakehouse. Gets the minimum value in the bitmap. Includes syntax and examples.
BITMAP_NOT
Learn how to use the BITMAP_NOT bitmap function in PlaidCloud Lakehouse. Generates a new bitmap with elements from the first bitmap that are not in the...
BITMAP_NOT_COUNT
Learn how to use the BITMAP_NOT_COUNT bitmap function in PlaidCloud Lakehouse. Counts the number of bits set to 0 in the bitmap by performing a logical NOT...
BITMAP_OR
Learn how to use the BITMAP_OR bitmap function in PlaidCloud Lakehouse. Performs a bitwise OR operation on the two bitmaps. Includes syntax and examples.
BITMAP_OR_COUNT
Learn how to use the BITMAP_OR_COUNT bitmap function in PlaidCloud Lakehouse. Counts the number of bits set to 1 in the bitmap by performing a logical OR...
BITMAP_SUBSET_IN_RANGE
Learn how to use the BITMAP_SUBSET_IN_RANGE bitmap function in PlaidCloud Lakehouse. Generates a sub-bitmap of the source bitmap within a specified range.
BITMAP_SUBSET_LIMIT
Learn how to use the BITMAP_SUBSET_LIMIT bitmap function in PlaidCloud Lakehouse. Generates a sub-bitmap of the source bitmap, beginning with a range from...
BITMAP_UNION
Learn how to use the BITMAP_UNION bitmap function in PlaidCloud Lakehouse. Counts the number of bits set to 1 in the bitmap by performing a logical UNION...
BITMAP_XOR
Learn how to use the BITMAP_XOR bitmap function in PlaidCloud Lakehouse. Performs a bitwise XOR (exclusive OR) operation on the two bitmaps.
BITMAP_XOR_COUNT
Learn how to use the BITMAP_XOR_COUNT bitmap function in PlaidCloud Lakehouse. Counts the number of bits set to 1 in the bitmap by performing a logical XOR...
INTERSECT_COUNT
Learn how to use the INTERSECT_COUNT bitmap function in PlaidCloud Lakehouse. Counts the number of intersecting bits between two bitmap columns.
SUB_BITMAP
Learn how to use the SUB_BITMAP bitmap function in PlaidCloud Lakehouse. Generates a sub-bitmap of the source bitmap, beginning from the start index, with a...