split
function
Applies to: Databricks SQL
Databricks Runtime
Splits str
around occurrences that match regex
and returns an array with a length of at most limit
.
Syntax
split(str, regex [, limit] )
Arguments
str
: ASTRING
expression to be split.regexp
: ASTRING
expression that is a Java regular expression used to splitstr
.limit
: An optionalINTEGER
expression defaulting to 0 (no limit).
Returns
An ARRAY<STRING>
.
If limit
> 0: The resulting array’s length will not be more than limit
, and the resulting array’s last entry will contain all input beyond the last matched regex
.
If limit
<= 0: regex
will be applied as many times as possible, and the resulting array can be of any size.
Examples
> SELECT split('oneAtwoBthreeC', '[ABC]');
[one,two,three,]
> SELECT split('oneAtwoBthreeC', '[ABC]', -1);
[one,two,three,]
> SELECT split('oneAtwoBthreeC', '[ABC]', 2);
[one,twoBthreeC]