JSON_ARRAY
Updated at:
Generates a JSON array. This function converts a list of values into a JSON array that contains the values. The input list can be empty.
Syntax
json json_array(<element>)Parameters
element: required. The values in the list specified by this parameter must be of the STRING, BIGINT, BOOLEAN, or JSON type.
Return value
The return value is of the JSON type.
Examples
-- Generate a JSON array.
select json_array('a', 45, true, 13, json '{"a":456}');The following result is returned:
+-----+
| _c0 |
+-----+
| ["a",45,true,13,{"a":456}] |
+-----+Related functions
JSON_ARRAY is a complex type function. For more information about the functions that are used to process data of complex data types, such as ARRAY, MAP, STRUCT, and JSON, see Complex type functions.
Is this page helpful?