Note
For OceanBase Database V4.2.1, this parameter was introduced in OceanBase Database V4.2.1 BP7. For other versions of OceanBase Database V4.2.x, this parameter was introduced in OceanBase Database V4.2.5.
Description
json_document_max_depth specifies the maximum nesting depth for a JSON document.
Limitations
Query the parameter
In the
systenant or a user tenant, you can execute theSHOW PARAMETERSstatement to query the parameter or query theGV$OB_PARAMETERSview for the parameter.Modify the parameter
You can modify the parameter in the
systenant or a user tenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Integer |
| Default value | 100 |
| Value range | [100, 1024] |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
We recommend that you do not use deep nested JSON data structures. This is because deep nested JSON data has low readability and maintainability. Moreover, parsing and serialization of deep nested JSON data usually consume more time and computing resources, lowering performance and efficiency.
Examples
Set the maximum nesting depth for a JSON document to 100.
obclient> ALTER SYSTEM SET json_document_max_depth=100;