Spark SQL - Return JSON Object Keys (json_object_keys)
articleArticles 82
codeCode 52
imageDiagrams 21
descriptionNotebooks 0
chat_bubble_outlineThreads 1
commentComments 7
loyaltyKontext Points 1197
account_circle Profile
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
copyright
This page is subject to Site terms.
comment Comments
No comments yet.
Log in with external accounts
warning Please login first to view stats information.
