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.

Returns the minimum value in a bitmap.

Analyze Syntax

func.bitmap_min(<bitmap>)

Analyze Examples

func.bitmap_min(get_column(table, 'bm'))

┌───┐
 1 
└───┘

SQL Syntax

BITMAP_MIN(<bitmap>)

SQL Examples

SELECT BITMAP_MIN(BITMAP_FROM_STRING('1,50,100'));

┌───┐
 1 
└───┘