Spark SQL - Return JSON Array Length (json_array_length)

Kontext Kontext
Kontext
Stats
articleArticles 82
codeCode 52
imageDiagrams 21
descriptionNotebooks 0
chat_bubble_outlineThreads 1
commentComments 7
loyaltyKontext Points 1197
account_circle Profile
visibility 1,255 event 2022-06-05 access_time 2 years ago language English
share
Twitter Facebook LinkedIn
more_vert
arrow_upward arrow_downward

Spark SQL function json_array_length returns the number of elements in the outmost JSON array of the JSON array. The input can be a valid JSON array string too. If the input is not valid, it returns NULL.

Code snippet

spark-sql> SELECT json_array_length('["a","b","c"]');
  3
spark-sql> SELECT json_array_length('[1,2,3,4');
  NULL
spark-sql> SELECT json_array_length('{}');
  NULL
spark-sql> SELECT json_array_length('{"key1":1,"key2":2}');
  NULL
spark-sql> SELECT json_array_length('[{"key1":1},{"key2":2},{"key3":3},{"k41":4,"k42":[5,6]}]');
  4
infoThis function is only available from Spark 3.1.0.

Other references

Spark SQL - Extract Value from JSON String

Spark SQL - Convert Object to JSON String

Spark SQL - Return JSON Object Keys (json_object_keys)

More from Kontext
copyright This page is subject to Site terms.
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts