[CALCITE-2881] Add the JSON_PRETTY function

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.19.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Ritesh
• Created: 28/Feb/19 06:59
• Updated: 25/Mar/19 00:11
• Resolved: 04/Mar/19 04:52

Description

```
JSON_PRETTY(json_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 ] }

Issue Links

• links to: GitHub Pull Request #1075