MaxCompute supports four complex data types: ARRAY, MAP, STRUCT, and JSON. This topic describes JSON functions and their features.
For information about the limits of JSON functions, see Limits.
Function | Description |
Returns an ARRAY, MAP, or STRUCT type from a JSON string based on the specified output format. | |
Extracts a string from a JSON string using a specified path. | |
Inserts a JSON value at a specified position in a JSON document. | |
Generates a JSON object from key-value pairs. | |
Creates a JSON array from a list of values. The list can be empty. | |
Expands each element in a JSON array or JSON object into multiple rows. | |
Extracts data from a JSON string or JSON data type based on a specified JSONPath. | |
Checks whether a specified JSONPath exists in a JSON document. | |
Formats a JSON string for readability by adding line breaks and spaces. | |
Returns the type name of a JSON value. | |
Converts a JSON data type to a string. The output is not prettified by default. | |
Converts a string to a JSON data type. An error is returned if the string is not in valid JSON format. | |
Replaces an existing value or adds a new value at a specified path in a JSON document. | |
Removes all fields or elements with a value of | |
Checks whether a string is valid JSON. | |
Extracts the values of multiple keys from a JSON string and returns them as a tuple of strings. | |
Converts a specified complex data type to a JSON string. |