Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
Applies to: 
Databricks SQL Databricks Runtime 11.3 LTS and above
Returns the element of an arrayExpr at index, starting with 0.
Syntax
get(arrayExpr, index)
Arguments
arrayExpr: An ARRAY expression.index: An INTEGER expression specifying the index in the array.
Returns
The result is of the type of the elements of arrayExpr.
If the index is negative or outside the bounds of the array the resut is NULL.
To return an INVALID_ARRAY_INDEX error instead, use the arrayExpr[index] operator.
Examples
> SELECT element_at(arr, 2), get(arr, 0), get(arr, 2), arr[2] FROM VALUES(array(1, 2, 3)) AS T(arr);
2 1 3 3
> SELECT get(arr, 5), get(arr, -1) FROM VALUES(array(1, 2, 3)) AS T(arr);
NULL NULL