JSON Type
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
The JSON type can contain any valid Javascript Object Notation data, including maps, arrays, and nested types.
While the DDL will allow you to specify a length of up to 4GB, there is an internal limit applied when assigning a value to a string or JSON field that caps the maximum size of a single value to max_
.
Data Type |
Size |
Size (Not Null) |
---|---|---|
JSON |
20 bytes + data size |
16 bytes + data size |
Last modified: May 11, 2022