SPLIT

​

Syntax

​

Scalar

split(value, pattern [, limit])

​

Arguments

​

Returns

• Type: ARRAY<STRING>
• Possible values: The split parts.
• NULL behavior: Returns NULL for NULL value/pattern or explicit NULL limit.
• Shape: One element per part, bounded by a positive limit.
• Ordering: String encounter order.

​

Properties

​

Usage notes

• Omitted/nonpositive limit retains trailing empty parts. Empty pattern splits into Unicode characters.

​

Examples

​

Typical behavior

SELECT split('a,b,c', ',', 2) AS limited, split('a,b,', ',') AS "trailing";

​

Split without a limit

SELECT split('a,b,c', ',') AS result;

​

Limitations

• Invalid regex and nonconstant limit raise errors.