array_size function

Applies to: Databricks SQL Databricks Runtime

Returns the number of elements in array.

Syntax

array_size(array)

Arguments

• array: An ARRAY expression.

Returns

An INTEGER.

Examples

SQL

> SELECT array_size(array(1, NULL, 3, NULL));
  4

> SELECT array_size(array());
  0

Related

• array function
• element_at function