This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 4ae7973b5c2 [doc](load&timezone) set the default value to be global
time_zone in loading (#3393)
4ae7973b5c2 is described below
commit 4ae7973b5c29a7b07f56c66ab04ad5b0b40d3adc
Author: Refrain <[email protected]>
AuthorDate: Fri Feb 27 10:17:16 2026 +0800
[doc](load&timezone) set the default value to be global time_zone in
loading (#3393)
## Versions
- [x] dev
- [x] 4.x
- [ ] 3.x
- [ ] 2.1
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/data-operate/import/import-way/mysql-load-manual.md | 2 +-
docs/data-operate/import/import-way/stream-load-manual.md | 2 +-
.../sql-statements/data-modification/load-and-export/MYSQL-LOAD.md | 2 +-
.../current/data-operate/import/import-way/mysql-load-manual.md | 2 +-
.../current/data-operate/import/import-way/stream-load-manual.md | 2 +-
.../sql-statements/data-modification/load-and-export/MYSQL-LOAD.md | 2 +-
.../version-4.x/data-operate/import/import-way/mysql-load-manual.md | 2 +-
.../version-4.x/data-operate/import/import-way/stream-load-manual.md | 2 +-
.../sql-statements/data-modification/load-and-export/MYSQL-LOAD.md | 2 +-
.../version-4.x/data-operate/import/import-way/mysql-load-manual.md | 2 +-
.../version-4.x/data-operate/import/import-way/stream-load-manual.md | 2 +-
.../sql-statements/data-modification/load-and-export/MYSQL-LOAD.md | 2 +-
12 files changed, 12 insertions(+), 12 deletions(-)
diff --git a/docs/data-operate/import/import-way/mysql-load-manual.md
b/docs/data-operate/import/import-way/mysql-load-manual.md
index 17f878ba697..812fc4336d9 100644
--- a/docs/data-operate/import/import-way/mysql-load-manual.md
+++ b/docs/data-operate/import/import-way/mysql-load-manual.md
@@ -160,7 +160,7 @@ By the `PROPERTIES (key1 = value1 [, key2=value2])` syntax,
you can configure th
| max_filter_ratio | The maximum filtering rate allowed. Must be between 0
and 1, inclusive. The default value is 0, indicating no tolerance for any error
rows. |
| timeout | The import timeout, measured in seconds. The default
value is 600. The range allowed is from 1s to 259200s. |
| strict_mode | Whether to enable strict mode for this import. Disabled
by default. |
-| timezone | The time zone for this import. The default time zone is
UTC+8. This parameter will affect the results of any time zone-related
functions involved in the import. |
+| timezone | The time zone for this import. The default time zone is
the current cluster time zone. This parameter will affect the results of any
time zone-related functions involved in the import. |
| exec_mem_limit | Memory limit for the import, defaults to 2GB, measured
in bytes. |
| trim_double_quotes | Boolean, defaults to false. If this is set to true, the
outermost double quotes will be trimmed from each field in the import file. |
| enclose | This specifies the enclosure character. When a CSV data
field contains line breaks or column delimiters, you can specify a single-byte
character as the enclosure character to prevent accidental truncation.For
example, if the column delimiter is ",", and the enclosure character is "'", in
data "a,'b,c'", "b,c" will be parsed as one field. |
diff --git a/docs/data-operate/import/import-way/stream-load-manual.md
b/docs/data-operate/import/import-way/stream-load-manual.md
index 35ab52fe209..b8a109fddc3 100644
--- a/docs/data-operate/import/import-way/stream-load-manual.md
+++ b/docs/data-operate/import/import-way/stream-load-manual.md
@@ -316,7 +316,7 @@ Parameter Description: The default timeout for Stream Load.
The load job will be
| partitions | Used to specify the partitions involved in
this import. If users can determine the corresponding partitions for the data,
it is recommended to specify this option. Data that does not meet these
partition criteria will be filtered out. For example, to specify importing into
partitions p1 and p2, use the command `-H "partitions: p1, p2"`. |
| timeout | Used to specify the timeout for the import in
seconds. The default is 600 seconds, and the configurable range is from 1
second to 259200 seconds. For example, to specify an import timeout of 1200
seconds, use the command `-H "timeout:1200"`. |
| strict_mode | Used to specify whether to enable strict mode
for this import, which is disabled by default. For example, to enable strict
mode, use the command `-H "strict_mode:true"`. |
-| timezone | Used to specify the timezone to be used for
this import, which defaults to GMT+8. This parameter affects the results of all
timezone-related functions involved in the import. For example, to specify the
import timezone as Africa/Abidjan, use the command `-H
"timezone:Africa/Abidjan"`. |
+| timezone | Used to specify the timezone to be used for
this import, which defaults to the current cluster time zone. This parameter
affects the results of all timezone-related functions involved in the import.
For example, to specify the import timezone as Africa/Abidjan, use the command
`-H "timezone:Africa/Abidjan"`. |
| exec_mem_limit | The memory limit for the import, which
defaults to 2GB. The unit is bytes. |
| format | Used to specify the format of the imported
data, which defaults to CSV. Currently supported formats include: CSV, JSON,
arrow, csv_with_names (supports filtering the first row of the csv file),
csv_with_names_and_types (supports filtering the first two rows of the csv
file), Parquet, and ORC. For example, to specify the imported data format as
JSON, use the command `-H "format:json"`. |
| jsonpaths | There are two ways to import JSON data
format: Simple Mode and Matching Mode. If no jsonpaths are specified, it is
the simple mode that requires the JSON data to be of the object type.Matching
mode used when the JSON data is relatively complex and requires matching the
corresponding values through the jsonpaths parameter.In simple mode, the keys
in JSON are required to correspond one-to-one with the column names in the
table. For example, in the JSON dat [...]
diff --git
a/docs/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
b/docs/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
index 71485d9ed54..090aa0c8c27 100644
---
a/docs/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
+++
b/docs/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
@@ -69,7 +69,7 @@ INTO TABLE "<tbl_name>"
| max_filter_ratio | The maximum tolerable ratio of filterable data (due to
reasons such as data irregularities), with a default of zero tolerance. |
| timeout | Specify the import timeout period in seconds. The default is 600
seconds, and the valid range is from 1 second to 259,200 seconds. |
| strict_mode | Users can specify whether to enable strict mode for this
import. The default is disabled. |
-| timezone | Specify the time zone for this import. The default is the East
Eight Time Zone. This parameter will affect the results of all time - zone -
related functions involved in the import. |
+| timezone | Specify the time zone for this import. The default is the current
cluster time zone. This parameter will affect the results of all time - zone -
related functions involved in the import. |
| exec_mem_limit | The import memory limit, with a default of 2GB in bytes. |
| trim_double_quotes | A boolean type with a default value of `false`. When
set to `true`, it means trimming the outermost double quotes of each field in
the imported file. |
| enclose | Enclosure character. When a CSV data field contains a line
separator or column separator, to prevent accidental truncation, a single -
byte character can be specified as the enclosure character for protection. For
example, if the column separator is ",", the enclosure character is "'", and
the data is "a,'b,c'", then "b,c" will be parsed as one field. Note: When
`enclose` is set to `""`, `trim_double_quotes` must be set to `true`. |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/mysql-load-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/mysql-load-manual.md
index 4f74837775d..6c6a288a9df 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/mysql-load-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/mysql-load-manual.md
@@ -164,7 +164,7 @@ INTO TABLE [<db_name>.]<table_name>
| max_filter_ratio | 允许的最大过滤率。必须在大于等于 0 到小于等于 1 之间。默认值是 0，表示不容忍任何错误行。 |
| timeout | 指定导入的超时时间，单位秒。默认是 600 秒。可设置范围为 1s ~ 259200s。 |
| strict_mode | 用户指定此次导入是否开启严格模式，默认为关闭。 |
-| timezone | 指定本次导入所使用的时区。默认为东八区。该参数会影响所有导入涉及的和时区有关的函数结果。 |
+| timezone | 指定本次导入所使用的时区。默认为集群当前时区。该参数会影响所有导入涉及的和时区有关的函数结果。 |
| exec_mem_limit | 导入内存限制。默认为 2GB。单位为字节。 |
| trim_double_quotes | 布尔类型，默认值为 false，为 true 时表示裁剪掉导入文件每个字段最外层的双引号。 |
| enclose | 指定包围符。当 CSV
数据字段中含有行分隔符或列分隔符时，为防止意外截断，可指定单字节字符作为包围符起到保护作用。例如列分隔符为 ","，包围符为 "'"，数据为
"a,'b,c'"，则 "b,c" 会被解析为一个字段。 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/stream-load-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/stream-load-manual.md
index 18e1cac3bff..c877103e535 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/stream-load-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/import-way/stream-load-manual.md
@@ -312,7 +312,7 @@ Stream Load 操作支持 HTTP 分块导入（HTTP chunked）与 HTTP 非分块
| partitions | 用于指定这次导入所涉及的 partition。如果用户能够确定数据对应的
partition，推荐指定该项。不满足这些分区的数据将被过滤掉。例如，指定导入到 p1, p2 分区，需要指定命令 `-H "partitions: p1,
p2"`。 |
| timeout | 指定导入的超时时间。单位秒。默认是 600 秒。可设置范围为 1 秒 ~ 259200
秒。例如，指定导入超时时间为 1200s，需要指定命令 `-H "timeout:1200"`。 |
| strict_mode | 用户指定此次导入是否开启严格模式，默认为关闭。例如，指定开启严格模式，需要指定命令 `-H
"strict_mode:true"`。 |
-| timezone |
指定本次导入所使用的时区。默认为东八区。该参数会影响所有导入涉及的和时区有关的函数结果。例如，指定导入时区为 Africa/Abidjan，需要指定命令
`-H "timezone:Africa/Abidjan"`。 |
+| timezone |
指定本次导入所使用的时区。默认为集群当前时区。该参数会影响所有导入涉及的和时区有关的函数结果。例如，指定导入时区为 Africa/Abidjan，需要指定命令
`-H "timezone:Africa/Abidjan"`。 |
| exec_mem_limit | 导入内存限制。默认为 2GB。单位为字节。 |
| format | 指定导入数据格式，默认是 CSV 格式。目前支持以下格式：CSV, JSON,
arrow, csv_with_names（支持 csv 文件行首过滤）csv_with_names_and_types（支持 CSV
文件前两行过滤）Parquet, ORC 例如，指定导入数据格式为 JSON，需要指定命令 `-H "format:json"`。 |
| jsonpaths | 导入 JSON 数据格式有两种方式：简单模式：没有指定 jsonpaths
为简单模式，这种模式要求 JSON 数据是对象类型匹配模式：用于 JSON 数据相对复杂，需要通过 jsonpaths 参数匹配对应的 value
在简单模式下，要求 JSON 中的 key 列与表中的列名是一一对应的，如 JSON 数据 {"k1":1, "k2":2, "k3":"hello"}，其中
k1、k2 及 k3 分别对应表中的列。 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
index 91238b648b4..dad8c6b089f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
@@ -70,7 +70,7 @@ INTO TABLE "<tbl_name>"
| max_filter_ratio | 最大容忍可过滤（数据不规范等原因）的数据比例，默认零容忍。 |
| timeout | 指定导入的超时时间，单位秒。默认是 600 秒。可设置范围为 1 秒 ~ 259200 秒。 |
| strict_mode | 用户指定此次导入是否开启严格模式，默认为关闭。 |
-| timezone | 指定本次导入所使用的时区，默认为东八区。该参数会影响所有导入涉及的和时区有关的函数结果。 |
+| timezone | 指定本次导入所使用的时区，默认为集群当前时区。该参数会影响所有导入涉及的和时区有关的函数结果。 |
| exec_mem_limit | 导入内存限制，默认为 2GB，单位为字节。 |
| trim_double_quotes | 布尔类型，默认值为 false，为 true 时表示裁剪掉导入文件每个字段最外层的双引号。 |
| enclose | 包围符。当 csv
数据字段中含有行分隔符或列分隔符时，为防止意外截断，可指定单字节字符作为包围符起到保护作用。例如列分隔符为","，包围符为"'"，数据为"a,'b,c'"，则"b,c"会被解析为一个字段。注意：当
enclose 设置为`"`时，trim_double_quotes 一定要设置为 true。 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/data-operate/import/import-way/mysql-load-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/data-operate/import/import-way/mysql-load-manual.md
index 4f74837775d..6c6a288a9df 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/data-operate/import/import-way/mysql-load-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/data-operate/import/import-way/mysql-load-manual.md
@@ -164,7 +164,7 @@ INTO TABLE [<db_name>.]<table_name>
| max_filter_ratio | 允许的最大过滤率。必须在大于等于 0 到小于等于 1 之间。默认值是 0，表示不容忍任何错误行。 |
| timeout | 指定导入的超时时间，单位秒。默认是 600 秒。可设置范围为 1s ~ 259200s。 |
| strict_mode | 用户指定此次导入是否开启严格模式，默认为关闭。 |
-| timezone | 指定本次导入所使用的时区。默认为东八区。该参数会影响所有导入涉及的和时区有关的函数结果。 |
+| timezone | 指定本次导入所使用的时区。默认为集群当前时区。该参数会影响所有导入涉及的和时区有关的函数结果。 |
| exec_mem_limit | 导入内存限制。默认为 2GB。单位为字节。 |
| trim_double_quotes | 布尔类型，默认值为 false，为 true 时表示裁剪掉导入文件每个字段最外层的双引号。 |
| enclose | 指定包围符。当 CSV
数据字段中含有行分隔符或列分隔符时，为防止意外截断，可指定单字节字符作为包围符起到保护作用。例如列分隔符为 ","，包围符为 "'"，数据为
"a,'b,c'"，则 "b,c" 会被解析为一个字段。 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/data-operate/import/import-way/stream-load-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/data-operate/import/import-way/stream-load-manual.md
index 552f984b8e7..081b07d770a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/data-operate/import/import-way/stream-load-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/data-operate/import/import-way/stream-load-manual.md
@@ -312,7 +312,7 @@ Stream Load 操作支持 HTTP 分块导入（HTTP chunked）与 HTTP 非分块
| partitions | 用于指定这次导入所涉及的 partition。如果用户能够确定数据对应的
partition，推荐指定该项。不满足这些分区的数据将被过滤掉。例如，指定导入到 p1, p2 分区，需要指定命令 `-H "partitions: p1,
p2"`。 |
| timeout | 指定导入的超时时间。单位秒。默认是 600 秒。可设置范围为 1 秒 ~ 259200
秒。例如，指定导入超时时间为 1200s，需要指定命令 `-H "timeout:1200"`。 |
| strict_mode | 用户指定此次导入是否开启严格模式，默认为关闭。例如，指定开启严格模式，需要指定命令 `-H
"strict_mode:true"`。 |
-| timezone |
指定本次导入所使用的时区。默认为东八区。该参数会影响所有导入涉及的和时区有关的函数结果。例如，指定导入时区为 Africa/Abidjan，需要指定命令
`-H "timezone:Africa/Abidjan"`。 |
+| timezone |
指定本次导入所使用的时区。默认为集群当前时区。该参数会影响所有导入涉及的和时区有关的函数结果。例如，指定导入时区为 Africa/Abidjan，需要指定命令
`-H "timezone:Africa/Abidjan"`。 |
| exec_mem_limit | 导入内存限制。默认为 2GB。单位为字节。 |
| format | 指定导入数据格式，默认是 CSV 格式。目前支持以下格式：CSV, JSON,
arrow, csv_with_names（支持 csv 文件行首过滤）csv_with_names_and_types（支持 CSV
文件前两行过滤）Parquet, ORC 例如，指定导入数据格式为 JSON，需要指定命令 `-H "format:json"`。 |
| jsonpaths | 导入 JSON 数据格式有两种方式：简单模式：没有指定 jsonpaths
为简单模式，这种模式要求 JSON 数据是对象类型匹配模式：用于 JSON 数据相对复杂，需要通过 jsonpaths 参数匹配对应的 value
在简单模式下，要求 JSON 中的 key 列与表中的列名是一一对应的，如 JSON 数据 {"k1":1, "k2":2, "k3":"hello"}，其中
k1、k2 及 k3 分别对应表中的列。 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
index 91238b648b4..dad8c6b089f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
@@ -70,7 +70,7 @@ INTO TABLE "<tbl_name>"
| max_filter_ratio | 最大容忍可过滤（数据不规范等原因）的数据比例，默认零容忍。 |
| timeout | 指定导入的超时时间，单位秒。默认是 600 秒。可设置范围为 1 秒 ~ 259200 秒。 |
| strict_mode | 用户指定此次导入是否开启严格模式，默认为关闭。 |
-| timezone | 指定本次导入所使用的时区，默认为东八区。该参数会影响所有导入涉及的和时区有关的函数结果。 |
+| timezone | 指定本次导入所使用的时区，默认为集群当前时区。该参数会影响所有导入涉及的和时区有关的函数结果。 |
| exec_mem_limit | 导入内存限制，默认为 2GB，单位为字节。 |
| trim_double_quotes | 布尔类型，默认值为 false，为 true 时表示裁剪掉导入文件每个字段最外层的双引号。 |
| enclose | 包围符。当 csv
数据字段中含有行分隔符或列分隔符时，为防止意外截断，可指定单字节字符作为包围符起到保护作用。例如列分隔符为","，包围符为"'"，数据为"a,'b,c'"，则"b,c"会被解析为一个字段。注意：当
enclose 设置为`"`时，trim_double_quotes 一定要设置为 true。 |
diff --git
a/versioned_docs/version-4.x/data-operate/import/import-way/mysql-load-manual.md
b/versioned_docs/version-4.x/data-operate/import/import-way/mysql-load-manual.md
index 17f878ba697..812fc4336d9 100644
---
a/versioned_docs/version-4.x/data-operate/import/import-way/mysql-load-manual.md
+++
b/versioned_docs/version-4.x/data-operate/import/import-way/mysql-load-manual.md
@@ -160,7 +160,7 @@ By the `PROPERTIES (key1 = value1 [, key2=value2])` syntax,
you can configure th
| max_filter_ratio | The maximum filtering rate allowed. Must be between 0
and 1, inclusive. The default value is 0, indicating no tolerance for any error
rows. |
| timeout | The import timeout, measured in seconds. The default
value is 600. The range allowed is from 1s to 259200s. |
| strict_mode | Whether to enable strict mode for this import. Disabled
by default. |
-| timezone | The time zone for this import. The default time zone is
UTC+8. This parameter will affect the results of any time zone-related
functions involved in the import. |
+| timezone | The time zone for this import. The default time zone is
the current cluster time zone. This parameter will affect the results of any
time zone-related functions involved in the import. |
| exec_mem_limit | Memory limit for the import, defaults to 2GB, measured
in bytes. |
| trim_double_quotes | Boolean, defaults to false. If this is set to true, the
outermost double quotes will be trimmed from each field in the import file. |
| enclose | This specifies the enclosure character. When a CSV data
field contains line breaks or column delimiters, you can specify a single-byte
character as the enclosure character to prevent accidental truncation.For
example, if the column delimiter is ",", and the enclosure character is "'", in
data "a,'b,c'", "b,c" will be parsed as one field. |
diff --git
a/versioned_docs/version-4.x/data-operate/import/import-way/stream-load-manual.md
b/versioned_docs/version-4.x/data-operate/import/import-way/stream-load-manual.md
index c0df5c8da71..97377b7dfac 100644
---
a/versioned_docs/version-4.x/data-operate/import/import-way/stream-load-manual.md
+++
b/versioned_docs/version-4.x/data-operate/import/import-way/stream-load-manual.md
@@ -316,7 +316,7 @@ Parameter Description: The default timeout for Stream Load.
The load job will be
| partitions | Used to specify the partitions involved in
this import. If users can determine the corresponding partitions for the data,
it is recommended to specify this option. Data that does not meet these
partition criteria will be filtered out. For example, to specify importing into
partitions p1 and p2, use the command `-H "partitions: p1, p2"`. |
| timeout | Used to specify the timeout for the import in
seconds. The default is 600 seconds, and the configurable range is from 1
second to 259200 seconds. For example, to specify an import timeout of 1200
seconds, use the command `-H "timeout:1200"`. |
| strict_mode | Used to specify whether to enable strict mode
for this import, which is disabled by default. For example, to enable strict
mode, use the command `-H "strict_mode:true"`. |
-| timezone | Used to specify the timezone to be used for
this import, which defaults to GMT+8. This parameter affects the results of all
timezone-related functions involved in the import. For example, to specify the
import timezone as Africa/Abidjan, use the command `-H
"timezone:Africa/Abidjan"`. |
+| timezone | Used to specify the timezone to be used for
this import, which defaults to the current cluster time zone. This parameter
affects the results of all timezone-related functions involved in the import.
For example, to specify the import timezone as Africa/Abidjan, use the command
`-H "timezone:Africa/Abidjan"`. |
| exec_mem_limit | The memory limit for the import, which
defaults to 2GB. The unit is bytes. |
| format | Used to specify the format of the imported
data, which defaults to CSV. Currently supported formats include: CSV, JSON,
arrow, csv_with_names (supports filtering the first row of the csv file),
csv_with_names_and_types (supports filtering the first two rows of the csv
file), Parquet, and ORC. For example, to specify the imported data format as
JSON, use the command `-H "format:json"`. |
| jsonpaths | There are two ways to import JSON data
format: Simple Mode and Matching Mode. If no jsonpaths are specified, it is
the simple mode that requires the JSON data to be of the object type.Matching
mode used when the JSON data is relatively complex and requires matching the
corresponding values through the jsonpaths parameter.In simple mode, the keys
in JSON are required to correspond one-to-one with the column names in the
table. For example, in the JSON dat [...]
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
b/versioned_docs/version-4.x/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
index 71485d9ed54..090aa0c8c27 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-statements/data-modification/load-and-export/MYSQL-LOAD.md
@@ -69,7 +69,7 @@ INTO TABLE "<tbl_name>"
| max_filter_ratio | The maximum tolerable ratio of filterable data (due to
reasons such as data irregularities), with a default of zero tolerance. |
| timeout | Specify the import timeout period in seconds. The default is 600
seconds, and the valid range is from 1 second to 259,200 seconds. |
| strict_mode | Users can specify whether to enable strict mode for this
import. The default is disabled. |
-| timezone | Specify the time zone for this import. The default is the East
Eight Time Zone. This parameter will affect the results of all time - zone -
related functions involved in the import. |
+| timezone | Specify the time zone for this import. The default is the current
cluster time zone. This parameter will affect the results of all time - zone -
related functions involved in the import. |
| exec_mem_limit | The import memory limit, with a default of 2GB in bytes. |
| trim_double_quotes | A boolean type with a default value of `false`. When
set to `true`, it means trimming the outermost double quotes of each field in
the imported file. |
| enclose | Enclosure character. When a CSV data field contains a line
separator or column separator, to prevent accidental truncation, a single -
byte character can be specified as the enclosure character for protection. For
example, if the column separator is ",", the enclosure character is "'", and
the data is "a,'b,c'", then "b,c" will be parsed as one field. Note: When
`enclose` is set to `""`, `trim_double_quotes` must be set to `true`. |
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
