Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
get_array_length function
Returns the length of the specified array. The GET_ARRAY_LENGTH function returns the length of a SUPER array given an object or array path.
Syntax
get_array_length( super_expr )
Arguments
- super_expr
-
A valid SUPER expression of array form.
Return type
The get_array_length function returns a BIGINT.
Example
The following example shows a get_array_length function.
SELECT GET_ARRAY_LENGTH(ARRAY(1,2,3,4,5,6,7,8,9,10)); get_array_length ---------------------- 10 (1 row)