| 写法 | func(x -> 表达式, 数组[, 参数]) |
|---|---|
| 常用 | arrayMap / arrayFilter / arrayReduce / arrayExists / arrayAll / arrayCount |
| 规约 | arrayReduce('sum', arr)、arrayReduce('avg', arr)、arrayReduce('uniq', arr) |
示例
示例
SELECT arrayMap(x -> x * 10, [1, 2, 3]) AS mapped;
SELECT arrayFilter(x -> x % 2 = 0, [1, 2, 3, 4]) AS evens;
SELECT arrayReduce('sum', [1, 2, 3]) AS total;
SELECT arrayExists(x -> x > 3, [1, 2, 3, 4]) AS has_big;lambda 里可以引用外层列（闭包），例如 arrayMap(x -> x + base, arr)，但嵌套层级过深会影响可读性。