Spark SQL - Return JSON Object Keys (json_object_keys)

Kontext Kontext
Kontext
Stats
articleArticles 73
imageDiagrams 20
codeCode 45
chat_bubble_outlineThreads 1
commentComments 3
loyaltyKontext Points 1063
account_circle Profile
visibility 460 event 2022-06-05 access_time 7 months ago language English
more_vert

Spark SQL function json_object_keys can be used to return an array of the outmost JSON object's keys. The input can be a valid JSON string too.

Code snippet

spark-sql> select json_object_keys('{}');
  []
spark-sql> select json_object_keys('{"key": "value"}');
  ["key"]
spark-sql> select json_object_keys('{"key1":"value1","key2":{"key3":"value3", "key4":"value4"}}');
  ["key1","key2"]
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

copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext on LinkedIn
recommendMore from Kontext