clintropolis commented on code in PR #12922: URL: https://github.com/apache/druid/pull/12922#discussion_r949855015
########## docs/querying/sql-functions.md: ########## @@ -647,6 +647,46 @@ Parses `address` into an IPv4 address stored as an integer. Converts `address` into an IPv4 address in dot-decimal notation. +## JSON_KEYS + +**Function type:** [JSON](sql-json-functions.md) + +`JSON_KEYS(expr, path)` + +Returns an array of field names in a `COMPLEX<json>` typed `expr`, at the specified `path`. + +## JSON_OBJECT + +**Function type:** [JSON](sql-json-functions.md) + +`JSON_OBJECT(KEY expr1 VALUE expr2[, KEY expr3 VALUE expr4, ...])` + +Constructs a new `COMPLEX<json>` object. The `KEY` expressions must evaluate to string types, but the `VALUE` expressions can be composed of any input type, including other `COMPLEX<json>` values. + +## JSON_PATHS + +**Function type:** [JSON](sql-json-functions.md) + +`JSON_PATHS(expr)` + +Returns an array of all paths which refer to literal values in a `COMPLEX<json>` typed `expr`, in JSONPath format. + +## JSON_QUERY + +**Function type:** [JSON](sql-json-functions.md) + +`JSON_QUERY(expr, path)` + +Extracts a `COMPLEX<json>` value from a `COMPLEX<json>` typed `expr`, at the specified `path`. Review Comment: i replace all fragments of the form > from a `COMPLEX<json>` typed `expr` with > `from `expr` since the former was no longer actually even accurate -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
