get function

Returns the element of an arrayExpr at index, starting with 0.

Applies to: check marked yes Databricks SQL preview check marked yes Databricks Runtime 11.3 and above

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