Functions/Lists & arrays/list_sum
Lists & arrays Macro

list_sum()

Arguments & returns

list_sum(l)

Macro
Overload link l Returns
#01 unknown unknown

Definition

list_aggr(l, 'sum')

In other engines

Apache Spark

ARRAY_SUM(ARRAY(1, 2))
In DuckDB
LIST_SUM([1, 2])

SQLGlot example ↗

Used in larger rewrites 1

These examples use list_sum as one part of a larger SQL translation.

Snowflakeregexp_instr()

SELECT REGEXP_INSTR(subject, pattern)
In DuckDB
SELECT CASE WHEN subject IS NULL OR pattern IS NULL THEN NULL WHEN pattern = '' THEN 0 WHEN LENGTH(REGEXP_EXTRACT_ALL(subject, pattern)) < 1 THEN 0 ELSE 1 + COALESCE(LIST_SUM(LIST_TRANSFORM(STRING_SPLIT_REGEX(subject, pattern)[1:1], x -> LENGTH(x))), 0) + COALESCE(LIST_SUM(LIST_TRANSFORM(REGEXP_EXTRACT_ALL(subject, pattern)[1:1 - 1], x -> LENGTH(x))), 0) + 0 END

SQLGlot example ↗