Feature Category
SQL Function / Operator
Problem / Use Case
json_object_keys
json_object_keys(json_object) - Returns all the keys of the outermost JSON object as an array.
Arguments:
json_object - A JSON object. If a valid JSON object is given, all the keys of the outermost object will be returned as an array. If it is any other valid JSON string, an invalid JSON string or an empty string, the function returns null.
Examples:
> SELECT json_object_keys('{}');
[]
> SELECT json_object_keys('{"key": "value"}');
["key"]
> SELECT json_object_keys('{"f1":"abc","f2":{"f3":"a", "f4":"b"}}');
["f1","f2"]
Since: 3.1.0
Proposed Solution
implement json_object_keys to match with sparksql
References / Prior Art
No response
Importance
Blocker (Cannot use Bolt without this)
Willingness to Contribute
Yes, I can submit a PR
Feature Category
SQL Function / Operator
Problem / Use Case
json_object_keys
json_object_keys(json_object) - Returns all the keys of the outermost JSON object as an array.
Arguments:
json_object - A JSON object. If a valid JSON object is given, all the keys of the outermost object will be returned as an array. If it is any other valid JSON string, an invalid JSON string or an empty string, the function returns null.
Examples:
Since: 3.1.0
Proposed Solution
implement json_object_keys to match with sparksql
References / Prior Art
No response
Importance
Blocker (Cannot use Bolt without this)
Willingness to Contribute
Yes, I can submit a PR