Skip to main content
Version: 2.5

json_string

Description

Converting JSON object to JSON string

Syntax

json_string(json_object_expr)

Parameters

  • json_object_expr: the expression that represents the JSON object. The object can be a JSON column, or a JSON object that is produced by a JSON constructor function such as PARSE_JSON.

Return value

Returns a VARCHAR value.

Examples

Example 1: Converting the JSON object to a JSON string

select json_string('{"Name": "Alice"}');
+----------------------------------+
| json_string('{"Name": "Alice"}') |
+----------------------------------+
| {"Name": "Alice"} |
+----------------------------------+

Example 1: Convert the result of PARSE_JSON to a JSON string

select json_string(parse_json('{"Name": "Alice"}'));
+----------------------------------+
| json_string('{"Name": "Alice"}') |
+----------------------------------+
| {"Name": "Alice"} |
+----------------------------------+