get function

Applies to: check marked yes Databricks SQL check marked yes 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