You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by di...@apache.org on 2023/06/28 10:01:49 UTC
[doris] branch master updated: [typo](doc)json document optimization (#20753)
This is an automated email from the ASF dual-hosted git repository.
diwu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 283fd2903f [typo](doc)json document optimization (#20753)
283fd2903f is described below
commit 283fd2903f19bb27b44f99471890c668e1c5a4ed
Author: caoliang-web <71...@users.noreply.github.com>
AuthorDate: Wed Jun 28 18:01:41 2023 +0800
[typo](doc)json document optimization (#20753)
---
docs/en/docs/admin-manual/config/be-config.md | 6 ++++++
docs/en/docs/sql-manual/sql-reference/Data-Types/JSON.md | 2 +-
docs/zh-CN/docs/admin-manual/config/be-config.md | 6 ++++++
docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/JSON.md | 2 +-
4 files changed, 14 insertions(+), 2 deletions(-)
diff --git a/docs/en/docs/admin-manual/config/be-config.md b/docs/en/docs/admin-manual/config/be-config.md
index 864d1cab84..f97cdb83cc 100644
--- a/docs/en/docs/admin-manual/config/be-config.md
+++ b/docs/en/docs/admin-manual/config/be-config.md
@@ -315,6 +315,12 @@ There are two ways to configure BE configuration items:
* Description: When using the odbc external table, if a column type of the odbc source table is not HLL, CHAR or VARCHAR, and the length of the column value exceeds this value, the query will report an error 'column value length longer than buffer length'. You can increase this value
* Default value: 100
+#### `jsonb_type_length_soft_limit_bytes`
+
+* Type: int32
+* Description: The soft limit of the maximum length of JSONB type.
+* Default value: 1,048,576
+
### Query
#### `fragment_pool_queue_size`
diff --git a/docs/en/docs/sql-manual/sql-reference/Data-Types/JSON.md b/docs/en/docs/sql-manual/sql-reference/Data-Types/JSON.md
index 1f722758b8..fdba861d3c 100644
--- a/docs/en/docs/sql-manual/sql-reference/Data-Types/JSON.md
+++ b/docs/en/docs/sql-manual/sql-reference/Data-Types/JSON.md
@@ -34,7 +34,7 @@ NOTICE: In version 1.2.x the data type name is JSONB. It's renamed to JSON to be
### description
JSON (Binary) datatype.
- Use binary JSON format for storage and json function to extract field.
+ Use binary JSON format for storage and json function to extract field.The maximum (default) support is 1048576 bytes (1MB), and the JSONB type is also limited by the be configuration `jsonb_type_length_soft_limit_bytes`
### note
There are some advantanges for JSON over plain JSON STRING.
diff --git a/docs/zh-CN/docs/admin-manual/config/be-config.md b/docs/zh-CN/docs/admin-manual/config/be-config.md
index a01b81a21e..253c234161 100644
--- a/docs/zh-CN/docs/admin-manual/config/be-config.md
+++ b/docs/zh-CN/docs/admin-manual/config/be-config.md
@@ -326,6 +326,12 @@ BE 重启后该配置将失效。如果想持久化修改结果，使用如下
* 描述：当使用odbc外表时，如果odbc源表的某一列类型不是HLL, CHAR或者VARCHAR，并且列值长度超过该值，则查询报错'column value length longer than buffer length'. 可增大该值
* 默认值：100
+#### `jsonb_type_length_soft_limit_bytes`
+
+* 类型: int32
+* 描述: JSONB 类型最大长度的软限，单位是字节
+* 默认值: 1048576
+
### 查询
#### `fragment_pool_queue_size`
diff --git a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/JSON.md b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/JSON.md
index 03203752c1..b822cb1552 100644
--- a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/JSON.md
+++ b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/JSON.md
@@ -34,7 +34,7 @@ under the License.
### description
JSON类型
- 二进制JSON类型，采用二进制JSON格式存储，通过json函数访问JSON内部字段。
+ 二进制JSON类型，采用二进制JSON格式存储，通过json函数访问JSON内部字段。最大（默认）支持1048576 字节（1MB），JSONB类型还受be配置`jsonb_type_length_soft_limit_bytes`限制
### note
与普通STRING类型存储的JSON字符串相比，JSON类型有两点优势
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org