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/26 11:11:48 UTC
[doris] branch branch-1.2-lts updated: [typo](doc)1.2 jsonb document optimization (#20752)
This is an automated email from the ASF dual-hosted git repository.
diwu pushed a commit to branch branch-1.2-lts
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-1.2-lts by this push:
new dc481573e6 [typo](doc)1.2 jsonb document optimization (#20752)
dc481573e6 is described below
commit dc481573e6561b1098cd9b01fdfd5df428bc55b1
Author: caoliang-web <71...@users.noreply.github.com>
AuthorDate: Mon Jun 26 19:11:31 2023 +0800
[typo](doc)1.2 jsonb document optimization (#20752)
---
docs/en/docs/admin-manual/config/be-config.md | 6 ++++++
docs/en/docs/sql-manual/sql-reference/Data-Types/JSONB.md | 2 +-
docs/zh-CN/docs/admin-manual/config/be-config.md | 6 ++++++
docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/JSONB.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 c9443394cf..8989e0a18d 100644
--- a/docs/en/docs/admin-manual/config/be-config.md
+++ b/docs/en/docs/admin-manual/config/be-config.md
@@ -327,6 +327,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/JSONB.md b/docs/en/docs/sql-manual/sql-reference/Data-Types/JSONB.md
index 57ac8d7440..b136dd416f 100644
--- a/docs/en/docs/sql-manual/sql-reference/Data-Types/JSONB.md
+++ b/docs/en/docs/sql-manual/sql-reference/Data-Types/JSONB.md
@@ -34,7 +34,7 @@ JSONB
### description
JSONB (JSON Binary) datatype.
- Use binary JSON format for storage and jsonb function to extract field.
+ Use binary JSON format for storage and jsonb 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 JSONB 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 0a009d4ce3..8156d2b2a0 100644
--- a/docs/zh-CN/docs/admin-manual/config/be-config.md
+++ b/docs/zh-CN/docs/admin-manual/config/be-config.md
@@ -338,6 +338,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/JSONB.md b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/JSONB.md
index 9119fd7797..3c1ad4d6f9 100644
--- a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/JSONB.md
+++ b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/JSONB.md
@@ -34,7 +34,7 @@ JSONB
### description
JSONB(JSON Binary)类型
- 二进制JSON类型，采用二进制JSONB格式存储，通过jsonb函数访问JSON内部字段。
+ 二进制JSON类型，采用二进制JSONB格式存储，通过jsonb函数访问JSON内部字段。最大（默认）支持1048576 字节（1MB），JSONB类型还受be配置`jsonb_type_length_soft_limit_bytes`限制
### note
与普通STRING类型存储的JSON字符串相比，JSONB类型有两点优势
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org