JSON_PARSE function

The JSON_PARSE function parses data in JSON format and converts it into the SUPER representation.

To ingest into SUPER data type using the INSERT or UPDATE command, use the JSON_PARSE function. When you use JSON_PARSE() to parse JSON strings into SUPER values, certain restrictions apply. For additional information, see Parsing options for SUPER.

Syntax

JSON_PARSE(json_string)

Arguments

json_string

An expression that returns serialized JSON as a varbyte or varchar type.

Return type

SUPER

Example

The following example is an example of the JSON_PARSE function.

SELECT JSON_PARSE('[10001,10002,"abc"]');
     json_parse
--------------------------
 [10001,10002,"abc"]
(1 row)

SELECT JSON_TYPEOF(JSON_PARSE('[10001,10002,"abc"]'));
 json_typeof
----------------
 array
(1 row)