This is an automated email from the ASF dual-hosted git repository.
kassiez pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new f13bc9068bb Data type json (#1611)
f13bc9068bb is described below
commit f13bc9068bb4308e9ab3d84ba07bbadf3ec26f09
Author: wangtianyi2004 <[email protected]>
AuthorDate: Thu Dec 26 15:28:21 2024 +0800
Data type json (#1611)
## Versions
- [ ] dev
- [ ] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [ ] Chinese
- [ ] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---------
Co-authored-by: KassieZ <[email protected]>
---
docs/sql-manual/sql-data-types/semi-structured/JSON.md | 3 +++
.../current/sql-manual/sql-data-types/semi-structured/JSON.md | 2 ++
.../version-2.1/sql-manual/sql-data-types/semi-structured/JSON.md | 2 ++
.../version-3.0/sql-manual/sql-data-types/semi-structured/JSON.md | 2 ++
.../version-2.1/sql-manual/sql-data-types/semi-structured/JSON.md | 2 ++
.../version-3.0/sql-manual/sql-data-types/semi-structured/JSON.md | 3 +++
6 files changed, 14 insertions(+)
diff --git a/docs/sql-manual/sql-data-types/semi-structured/JSON.md
b/docs/sql-manual/sql-data-types/semi-structured/JSON.md
index 4ce84debda6..0c2be9def09 100644
--- a/docs/sql-manual/sql-data-types/semi-structured/JSON.md
+++ b/docs/sql-manual/sql-data-types/semi-structured/JSON.md
@@ -56,6 +56,9 @@ INSERT INTO table_name(id, json_column_name) VALUES (1,
'{"k1": "100"}')
14 [123, 456]
```
+- When the all special character with `'\'` such as `'\r'`, `'\t'` appears in
JSON, you need to use the replace function to replace `"\"` with `"\\"`, for
example, you need replace `"\n"` to `"\\n"`
+
+
**Query:**
- Directly select the entire JSON column:
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/semi-structured/JSON.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/semi-structured/JSON.md
index 1278ca9dda5..7622696a582 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/semi-structured/JSON.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-data-types/semi-structured/JSON.md
@@ -55,6 +55,8 @@ INSERT INTO table_name(id, json_column_name) VALUES (1,
'{"k1": "100"}')
13 []
14 [123, 456]
```
+- 在 JSON 中出现转移符号 `"\"`，如 `"\n"` 或 `"\t"` 时，在导入时需要通过 replace 函数将 `"\"` 替换为
`"\\"`，例如将 `"\n"` 替换为 `"\\n"`
+
**查询**
- 直接将整个 JSON 列 SELECT 出来
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/semi-structured/JSON.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/semi-structured/JSON.md
index 1278ca9dda5..b3eb7a4b6dd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/semi-structured/JSON.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-data-types/semi-structured/JSON.md
@@ -56,6 +56,8 @@ INSERT INTO table_name(id, json_column_name) VALUES (1,
'{"k1": "100"}')
14 [123, 456]
```
+- 在 JSON 中出现转移符号 `"\"`，如 `"\n"` 或 `"\t"` 时，在导入时需要通过 replace 函数将 `"\"` 替换为
`"\\"`，例如将 `"\n"` 替换为 `"\\n"`
+
**查询**
- 直接将整个 JSON 列 SELECT 出来
```sql
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/semi-structured/JSON.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/semi-structured/JSON.md
index 1278ca9dda5..7622696a582 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/semi-structured/JSON.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-data-types/semi-structured/JSON.md
@@ -55,6 +55,8 @@ INSERT INTO table_name(id, json_column_name) VALUES (1,
'{"k1": "100"}')
13 []
14 [123, 456]
```
+- 在 JSON 中出现转移符号 `"\"`，如 `"\n"` 或 `"\t"` 时，在导入时需要通过 replace 函数将 `"\"` 替换为
`"\\"`，例如将 `"\n"` 替换为 `"\\n"`
+
**查询**
- 直接将整个 JSON 列 SELECT 出来
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-data-types/semi-structured/JSON.md
b/versioned_docs/version-2.1/sql-manual/sql-data-types/semi-structured/JSON.md
index 4ce84debda6..22be1257c77 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-data-types/semi-structured/JSON.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-data-types/semi-structured/JSON.md
@@ -56,6 +56,8 @@ INSERT INTO table_name(id, json_column_name) VALUES (1,
'{"k1": "100"}')
14 [123, 456]
```
+- When the all special character with `'\'` such as `'\r'`, `'\t'` appears in
JSON, you need to use the replace function to replace `"\"` with `"\\"`, for
example, you need replace `"\n"` to `"\\n"`
+
**Query:**
- Directly select the entire JSON column:
```sql
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-data-types/semi-structured/JSON.md
b/versioned_docs/version-3.0/sql-manual/sql-data-types/semi-structured/JSON.md
index 4ce84debda6..0c2be9def09 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-data-types/semi-structured/JSON.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-data-types/semi-structured/JSON.md
@@ -56,6 +56,9 @@ INSERT INTO table_name(id, json_column_name) VALUES (1,
'{"k1": "100"}')
14 [123, 456]
```
+- When the all special character with `'\'` such as `'\r'`, `'\t'` appears in
JSON, you need to use the replace function to replace `"\"` with `"\\"`, for
example, you need replace `"\n"` to `"\\n"`
+
+
**Query:**
- Directly select the entire JSON column:
```sql
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
