[CALCITE-2880] Add the JSON_PRETTY function

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Labels: pull-request-available
• Assignee: Forward Xu
• Reporter: Ritesh
• Created: 28/Feb/19 06:54
• Updated: 15/Mar/19 07:31
• Resolved: 28/Feb/19 06:58

Description

```
JSON_PRETTY(*json_string_doc*)
```

Returns the pretty formatted JSON document. Returns `NULL` if any argument is `NULL` or if JSON document is invalid.

Example Sql:

```sql
SELECT JSON_PRETTY(v) AS c1
FROM (VALUES ('{"a": [10, true],"b": [10, true]}')) as t(v)
limit 10
```

Result:

c1

{ "a" : [ 10, true ], "b" : [ 10, true ] }