json_array_length(json_array text)

Let us now check the json_array_length(json_array text) function with the following query.

Query

default> select json_array_length('[10, 20, 30]') as length;  

Result

The above query will generate the following result.

length 
------------------------------- 
3

The query returns the length of the array. The above array contains 3 elements so, the length is 3.