JSON Functions
Details
| Detail name | Value |
|---|---|
| Changelog Number | 9189 |
| Type | New Feature |
| Status | Resolved |
| Fix Versions | Exasol 7.0.0, Exasol 7.0.beta1, Exasol 6.2.7 |
| Resolution Date | 2020-07-01 |
Background
JSON data can be stored in VARCHAR columns, but interpreting the data required external UDFs.
Feature Description
To work with JSON data stored in Exasol we implemented new JSON functionality:
- IS [NOT] JSON predicate to check whether a string is valid JSON data as defined by the SQL standard.
- JSON_VALUE() function to extract JSON data using one SQL/JSON path specification as defined by the SQL standard.
- JSON_EXTRACT() function to extract JSON data using one or more SQL/JSON path specifications. This function can also extract multiple rows of data from a single JSON input. This function is an Exasol-specific extension to the SQL standard.
For details, see Exasol SQL Reference.
Restrictions
Version 6.2
The new functionality is available starting from version 6.2.7 and can be activated by setting the following database parameter:
-enableJsonFunctions=1
Version 7.0
The new functionality is available by default, no database parameter is needed.
