pyspark.sql.functions.json_array_length

pyspark.sql.functions.json_array_length(col: ColumnOrName) → pyspark.sql.column.Column

Returns the number of elements in the outermost JSON array. NULL is returned in case of any other valid JSON string, NULL or an invalid JSON.

New in version 3.5.0.

Parameters

col: :class:`~pyspark.sql.Column` or str

target column to compute on.

Returns

Column

length of json array.

Examples

>>> df = spark.createDataFrame([(None,), ('[1, 2, 3]',), ('[]',)], ['data'])
>>> df.select(json_array_length(df.data).alias('r')).collect()
[Row(r=None), Row(r=3), Row(r=0)]

previous

pyspark.sql.functions.to_json

next

pyspark.sql.functions.json_object_keys