Skip to main content

ARRAY_TRANSFORM

Returns an array that is the result of applying the lambda function to each element of the input array.

Syntax

ARRAY_TRANSFORM( <array>, <lambda> )

Examples

SELECT ARRAY_TRANSFORM([1, 2, 3], x -> x + 1);

┌──────────────────────────────────────────┐
│ array_transform([1, 2, 3], x -> (x + 1))
├──────────────────────────────────────────┤
[2,3,4]
└──────────────────────────────────────────┘
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today