Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databricks.com/aws/en/sql/language-manual/functions/json_object_keys below:

json_object_keys function | Databricks Documentation

Applies to: Databricks SQL Databricks Runtime

Returns all the keys of the outermost JSON object as an array.

json_object_keys(jsonObject)

• jsonObject: A STRING expression of a valid JSON array format.

An ARRAY < STRING >.

If 'jsonObject' is any other valid JSON string, an invalid JSON string or an empty string, the function returns NULL.

SQL

> SELECT json_object_keys('{}');
  []
> SELECT json_object_keys('{"key": "value"}');
  [key]
> SELECT json_object_keys('{"f1":"abc","f2":{"f3":"a", "f4":"b"}}');
  [f1,f2]

• : operator
• json_array_length function
• json_tuple table-valued generator function
• from_json function
• get_json_object function
• schema_of_json function
• to_json function

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4