JSON Functions
TDV supports the JSON functions listed in the table.
|
TDV-Supported JSON Function |
Comments |
|
DECODE_JSON |
See DECODE_JSON |
|
ENCODE_SIZE |
See ENCODED_SIZE |
|
ENCODE_JSON |
See ENCODE_JSON |
|
The JSON)PATH function provides XPath-like syntax for JSON structures. It provides a way to extract parts of a given document. |
|
|
Returns the listed values. The list can be empty. Array values must be of type string, number, object, array, boolean or null. |
|
|
Returns the average value of a JSON array within a JSON object |
|
|
Returns the number of elements in a JSON array within a JSON object. It returns the values based on the JSON path passed as the second argument to the function. |
|
|
The JSON_EXTRACT function can extract individual values from a JSON object |
|
|
JSON_EXTRACT_SCALAR |
|
|
Returns the highest numeric value of a JSON array within a JSON object |
|
|
Returns the lowest numeric value of a JSON array within a JSON object |
|
|
Evaluates a key-value pair and returns a JSON object containing the pair |
|
|
Returns the sum of the numeric values of a JSON array within a JSON object |
|
|
JSON_TABLE is a SQL extension that creates a relational view of JSON data. |