ARRAY_MAP

Learn how to use the ARRAY_MAP array function in PlaidCloud Lakehouse. Applies a lambda expression to each element of an array - with syntax and examples.

Applies a lambda expression to each element of an array.

Analyze Syntax

func.array_map(get_column(table, 'arr'), lambda x: x * 2)

Analyze Examples

func.array_map([1, 2, 3], lambda x: x * 2)

┌─────────┐
│ [2,4,6] │
└─────────┘

SQL Syntax

ARRAY_MAP(<arr>, lambda x: x * 2)

SQL Examples

SELECT ARRAY_MAP([1, 2, 3], x -> x * 2);

┌─────────┐
│ [2,4,6] │
└─────────┘