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.

Computes a 32-bit hash of a value and returns a bitmap containing that hash.

Analyze Syntax

func.bitmap_hash(<value>)

Analyze Examples

func.bitmap_hash('hello')

┌──────────┐
│ (bitmap) │
└──────────┘

SQL Syntax

BITMAP_HASH(<value>)

SQL Examples

SELECT BITMAP_COUNT(BITMAP_HASH('hello'));

┌───┐
│ 1 │
└───┘