slice
function
Applies to: Databricks SQL Databricks Runtime
Returns a subset of an array.
Arguments
expr
: AnARRAY
expression.start
: AnINTEGER
expression.length
: AnINTEGER
expression that is greater or equal to 0.
Returns
The result is of the type of expr
.
The function subsets array expr
starting from index start
(array indices start at 1), or starting from the end if start
is negative, with the specified length
.
If the requested array slice does not overlap with the actual length of the array, an empty array is returned.