json_array_length function

Applies to: Databricks SQL Databricks Runtime 8.0 and above

Returns the number of elements in the outermost JSON array.

Syntax

json_array_length(jsonArray)

Arguments

• jsonArray: A JSON array.

Returns

An INTEGER.

The function returns NULL if jsonArray is not a valid JSON string or NULL.

Examples

> SELECT json_array_length('[1,2,3,4]');
 4

> SELECT json_array_length('[1,2,3,{"f1":1,"f2":[5,6]},4]');
 5

> SELECT json_array_length('[1,2');
 NULL

Related functions

• json_object_keys function

• : operator

• json_array_length function

• json_tuple table-valued generator function

• from_json function

• get_json_object function

• schema_of_json function

• to_json function