SPLIT (Lakehouse v2)

Splits a string by a delimiter and returns an array.

Analyze Syntax

func.split(<str>, <delimiter>)

Analyze Examples

func.split('a,b,c', ',')

┌───────────────┐
│ ['a','b','c']  │
└───────────────┘

SQL Syntax

SPLIT(<str>, <delimiter>)

SQL Examples

SELECT SPLIT('a,b,c', ',');

┌───────────────┐
│ ["a","b","c"]  │
└───────────────┘