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 d94b5583f4b [fix] Fix deadlink and typo issues (#2330)
d94b5583f4b is described below
commit d94b5583f4b67762367778bd829ab05aa66f6ec4
Author: KassieZ <139741991+kass...@users.noreply.github.com>
AuthorDate: Sun Apr 27 18:23:53 2025 +0800
[fix] Fix deadlink and typo issues (#2330)
## Versions
- [ ] dev
- [ ] 3.0
- [ ] 2.1
- [ ] 2.0
## Languages
- [ ] Chinese
- [ ] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
...is-best-alternatives-for-real-time-analytics.md | 2 +-
docs/query-data/udf/java-user-defined-function.md | 2 +-
.../sql-data-types/data-type-overview.md | 2 +-
docs/table-design/data-type.md | 12 +++---
.../query-data/udf/java-user-defined-function.md | 4 +-
.../sql-data-types/data-type-overview.md | 4 +-
.../current/table-design/data-type.md | 12 +++---
.../query-data/udf/java-user-defined-function.md | 44 +---------------------
.../sql-data-types/data-type-overview.md | 4 +-
.../version-2.1/table-design/data-type.md | 12 +++---
.../sql-data-types/data-type-overview.md | 4 +-
.../version-3.0/table-design/data-type.md | 12 +++---
.../query-data/udf/java-user-defined-function.md | 43 +--------------------
.../sql-data-types/data-type-overview.md | 2 +-
.../version-2.1/table-design/data-type.md | 12 +++---
.../sql-data-types/data-type-overview.md | 2 +-
.../version-3.0/table-design/data-type.md | 12 +++---
17 files changed, 52 insertions(+), 133 deletions(-)
diff --git
a/blog/why-apache-doris-is-best-alternatives-for-real-time-analytics.md
b/blog/why-apache-doris-is-best-alternatives-for-real-time-analytics.md
index 86c4bc66007..0c11afc8b09 100644
--- a/blog/why-apache-doris-is-best-alternatives-for-real-time-analytics.md
+++ b/blog/why-apache-doris-is-best-alternatives-for-real-time-analytics.md
@@ -288,7 +288,7 @@ Elasticsearch does not support querying external data, and
of course, it does no
**Elasticsearch** is good at point queries (retrieving just a small amount of
data). However, it might struggle with complex analytical workloads.
-[Elasticsearch httplogs](https://elasticsearch-benchmarks.elastic.co/) and the
Microsoft Azure
[logsbench](https://gigaom.com/report/log-data-analytics-testing/) are
benchmarks for log storage and search. Both tests show that Doris is about 3~4
times faster than Elasticsearch in data writing, but only uses 1/6~1/4 of the
storage space that Elasticsearch uses. Then for data queries, Doris is more
than 2 times faster than Elasticsearch.
+[Elasticsearch httplogs](https://elasticsearch-benchmarks.elastic.co/) and the
Microsoft Azure
[logsbench](https://gigaom.com/report/log-data-analytics-testing/) are
benchmarks for log storage and search. Both tests show that Doris is about 3 -
4 times faster than Elasticsearch in data writing, but only uses 1/6 - 1/4 of
the storage space that Elasticsearch uses. Then for data queries, Doris is more
than 2 times faster than Elasticsearch.
diff --git a/docs/query-data/udf/java-user-defined-function.md
b/docs/query-data/udf/java-user-defined-function.md
index 7250e717835..895108825af 100644
--- a/docs/query-data/udf/java-user-defined-function.md
+++ b/docs/query-data/udf/java-user-defined-function.md
@@ -33,7 +33,7 @@ Doris supports the use of Java to develop UDFs, UDAFs, and
UDTFs. Unless otherwi
2. Java UDAF: A Java UDAF is a user-defined aggregate function that aggregates
multiple input rows into a single output row. Common examples include MIN, MAX,
and COUNT.
-3. Java UDTF: A Java UDTF is a user-defined table function, where a single
input row can generate one or multiple output rows. In Doris, UDTFs must be
used with Lateral View to achieve row-to-column transformations. Common
examples include EXPLODE and EXPLODE_SPLIT.
+3. Java UDTF: A Java UDTF is a user-defined table function, where a single
input row can generate one or multiple output rows. In Doris, UDTFs must be
used with Lateral View to achieve row-to-column transformations. Common
examples include EXPLODE and EXPLODE_SPLIT. **Java UDTF is available from
version 3.0.0 and onwards.**
## Type Correspondence
diff --git a/docs/sql-manual/basic-element/sql-data-types/data-type-overview.md
b/docs/sql-manual/basic-element/sql-data-types/data-type-overview.md
index 0c99fa4f316..2a18989e05e 100644
--- a/docs/sql-manual/basic-element/sql-data-types/data-type-overview.md
+++ b/docs/sql-manual/basic-element/sql-data-types/data-type-overview.md
@@ -64,7 +64,7 @@ The precise fixed-point type
[DECIMAL](../sql-data-types/numeric/DECIMAL.md), us
Date types include DATE, TIME and DATETIME, DATE type only stores the date
accurate to the day, DATETIME type stores the date and time, which can be
accurate to microseconds. TIME type only stores the time, and **does not
support the construction of the table storage for the time being, can only be
used in the query process**.
-Do calculation for datetime types or converting them to numeric types, please
use functions like
[TIME_TO_SEC](../sql-functions/scalar-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../sql-functions/scalar-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../sql-functions/scalar-functions/date-time-functions/unix-timestamp)
. The result of directly converting them as numeric types as not guaranteed.
+Do calculation for datetime types or converting them to numeric types, please
use functions like
[TIME_TO_SEC](../../sql-functions/scalar-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../../sql-functions/scalar-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../../sql-functions/scalar-functions/date-time-functions/unix-timestamp)
. The result of directly converting them as numeric types as not guaranteed.
For more information refer to [DATE](../sql-data-types/date-time/DATE),
[TIME](../sql-data-types/date-time/TIME) and
[DATETIME](../sql-data-types/date-time/DATETIME) documents.
diff --git a/docs/table-design/data-type.md b/docs/table-design/data-type.md
index aaa933944c6..7475a1d095f 100644
--- a/docs/table-design/data-type.md
+++ b/docs/table-design/data-type.md
@@ -28,7 +28,7 @@ Apache Doris support standard SQL syntax, using MySQL Network
Connection Protoco
The list of data types supported by Doris is as follows:
-## [Numeric data
type](../sql-manual/sql-data-types/data-type-overview#numeric-types)
+## [Numeric data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#numeric-types)
| Type Name | Storage
(bytes) | Description |
| ---------------------------------------------------------- | ---------------
| ------------------------------------------------------------ |
@@ -42,21 +42,21 @@ The list of data types supported by Doris is as follows:
| [DOUBLE](../sql-manual/basic-element/sql-data-types/numeric/DOUBLE)
| 8 | Double precision floating point number, range is [-1.79 *
10^308 to 1.79 * 10^308]. |
| [DECIMAL](../sql-manual/basic-element/sql-data-types/numeric/DECIMAL)
| 4/8/16 | An exact fixed-point number defined by precision (total
number of digits) and scale (number of digits to the right of the decimal
point). Format: DECIMAL(M[,D]), where M is precision and D is scale. The range
for M is [1, 38], and for D is [0, precision]. Storage requirements: - 4 bytes
for 0 < precision <= 9, - 8 bytes for 9 < precision <= 18, - 16 bytes for 18 <
precision <= 38. |
-## [Datetime data
type](../sql-manual/sql-data-types/data-type-overview#date-types)
+## [Datetime data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#date-types)
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE)
| 16 | DATE holds values for a calendar year, month and day, the
supported range is ['0000-01-01', '9999-12-31']. Default print format:
'yyyy-MM-dd'. |
| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME)
| 16 | A DATE and TIME combination Format: DATETIME ([P]).
The optional parameter P represents time precision, with a value range of
[0,6], supporting up to 6 decimal places (microseconds). When not set, it is 0.
The supported range is ['0000-01-01 00:00:00 [.000000]', '9999-12-31 23:59:59
[.999999]']. Default print format: 'yyy-MM-dd HH: mm: ss. SSSSSS '. |
-## [String data
type](../sql-manual/sql-data-types/data-type-overview#string-types)
+## [String data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#string-types)
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
| [CHAR](../sql-manual/basic-element/sql-data-types/string-type/CHAR)
| M | A FIXED length string, the parameter M specifies the
column length in characters. The range of M is from 1 to 255. |
| [VARCHAR](../sql-manual/basic-element/sql-data-types/string-type/VARCHAR)
| Variable Length | A VARIABLE length string , the parameter M specifies
the maximum string length in characters. The range of M is from 1 to 65533.
The variable-length string is stored in UTF-8 encoding. English characters
occupy 1 byte, and Chinese characters occupy 3 bytes. |
| [STRING](../sql-manual/basic-element/sql-data-types/string-type/STRING)
| Variable Length | A VARIABLE length string, default supports 1048576
bytes (1 MB), and a limit of maximum precision of 2147483643 bytes (2 GB).
Size can be configured string_type_length_soft_limit_bytes adjusted through BE.
String type can only be used in value column, not in key column and partition
bucket column. |
-## [Semi-structured data
type](../sql-manual/sql-data-types/data-type-overview#semi-structured-types)
+## [Semi-structured data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#semi-structured-types)
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
@@ -66,7 +66,7 @@ The list of data types supported by Doris is as follows:
| [JSON](../sql-manual/basic-element/sql-data-types/semi-structured/JSON)
| Variable Length | Binary JSON type, stored in binary JSON format, access
internal JSON fields through JSON function. Supported up to 1048576 bytes
(1MB) by default, and can be adjusted to a maximum of 2147483643 bytes (2GB).
This limit can be modified through the BE configuration parameter
'jsonb_type_length_soft_limit_bytes'. |
|
[VARIANT](../sql-manual/basic-element/sql-data-types/semi-structured/VARIANT)
| Variable Length | The VARIANT data type is dynamically adaptable,
specifically designed for semi-structured data like JSON. It can store any JSON
object and automatically splits JSON fields into subcolumns for improved
storage efficiency and query performance. The length limits and configuration
methods are the same as for the STRING type. However, the VARIANT type can only
be used in value columns a [...]
-## [Aggregation data
type](../sql-manual/sql-data-types/data-type-overview#aggregation-types)
+## [Aggregation data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#aggregation-types)
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
@@ -75,7 +75,7 @@ The list of data types supported by Doris is as follows:
| [QUANTILE_STATE](../sql-manual/sql-data-types/aggregate/QUANTILE_STATE) |
Variable Length | A type used to calculate approximate quantile values. When
loading, it performs pre-aggregation for the same keys with different values.
When the number of values does not exceed 2048, it records all data in detail.
When the number of values is greater than 2048, it employs the TDigest
algorithm to aggregate (cluster) the data and store the centroid points after
clustering. QUANTILE_STATE can [...]
| [AGG_STATE](../sql-manual/sql-data-types/aggregate/AGG_STATE) |
Variable Length | Aggregate function can only be used with state/merge/union
function combiners. AGG_STATE cannot be used as a key column. When creating a
table, the signature of the aggregate function needs to be declared alongside.
Users do not need to specify the length or default value. The actual data
storage size depends on the function's implementation. |
-## [IP types](../sql-manual/sql-data-types/data-type-overview#ip-types)
+## [IP
types](../sql-manual/basic-element/sql-data-types/data-type-overview#ip-types)
| Type Name | Storage
(bytes) | Description |
| ---------------------------------------------------------- | ---------------
| ------------------------------------------------------------ |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/udf/java-user-defined-function.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/udf/java-user-defined-function.md
index eeb2fbb2281..9b52b03c2d5 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/udf/java-user-defined-function.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/query-data/udf/java-user-defined-function.md
@@ -29,7 +29,7 @@ Java UDF 为用户提供使用 Java 编写 UDF 的接口，以方便用户使用
Doris 支持使用 JAVA 编写 UDF、UDAF 和 UDTF。下文如无特殊说明，使用 UDF 统称所有用户自定义函数。
1. Java UDF 是较为常见的自定义标量函数 (Scalar Function)，即每输入一行数据，就会有一行对应的结果输出，较为常见的有
ABS，LENGTH 等。值得一提的是对于用户来讲，Hive UDF 是可以直接迁移至 Doris 的。
2. Java UDAF 即为自定义的聚合函数 (Aggregate Function)，即在输入多行数据进行聚合后，仅输出一行对应的结果，较为常见的有
MIN，MAX，COUNT 等。
-3. JAVA UDTF 即为自定义的表函数 (Table Function)，即每输一行数据，可以产生一行或多行的结果，在 Doris 中需要结合
Lateral View 使用可以达到行转列的效果，较为常见的有 EXPLODE，EXPLODE_SPLIT 等。
+3. JAVA UDTF 即为自定义的表函数 (Table Function)，即每输一行数据，可以产生一行或多行的结果，在 Doris 中需要结合
Lateral View 使用可以达到行转列的效果，较为常见的有 EXPLODE，EXPLODE_SPLIT 等。**该功能自 Doris 3.0
版本起开始支持。**
## 类型对应关系
@@ -350,7 +350,7 @@ public void destroy(State state) {
### Java-UDTF 实例介绍
:::tip
-UDTF 自 Doris 3.0 版本开始支持
+UDTF 自 Doris 3.0 版本开始支持，
:::
1. 首先编写对应的 Java UDTF 代码，打包生成 JAR 包。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/data-type-overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/data-type-overview.md
index 4053f2a5cf1..a5d38868244 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/data-type-overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/data-type-overview.md
@@ -38,9 +38,9 @@ under the License.
都是有符号整数，xxINT 的差异是占用字节数和表示范围
-- TINYINT 占 1 字节，范围 [-128, 127], 更多信息参考 [TINYINT
文档](../../basic-element/sql-manual/sql-data-types/numeric/TINYINT.md)。
+- TINYINT 占 1 字节，范围 [-128, 127], 更多信息参考 [TINYINT
文档](../../basic-element/sql-data-types/numeric/TINYINT.md)。
-- SMALLINT 占 2 字节，范围 [-32768, 32767], 更多信息参考 [SMALLINT
文档](../../basic-element/sql-manual/sql-data-types/numeric/SMALLINT.md)。
+- SMALLINT 占 2 字节，范围 [-32768, 32767], 更多信息参考 [SMALLINT
文档](../../basic-element/sql-data-types/numeric/SMALLINT.md)。
- INT 占 4 字节，范围 [-2147483648, 2147483647], 更多信息参考 [INT
文档](../../basic-element/sql-data-types/numeric/INT.md)。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
index 4f8a6af64e4..404f20ff79f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
@@ -26,7 +26,7 @@ under the License.
Apache Doris 已支持的数据类型列表如下：
-### [数值类型](../sql-manual/sql-data-types/data-type-overview#数值类型)
+### [数值类型](../sql-manual/basic-element/sql-data-types/data-type-overview#数值类型)
| 类型名 | 存储空间（字节）| 描述
|
@@ -41,14 +41,14 @@ Apache Doris 已支持的数据类型列表如下：
| [DOUBLE](../sql-manual/basic-element/sql-data-types/numeric/DOUBLE)
| 8 | 浮点数，范围 [-1.79*10^308 ~ 1.79*10^308]。 |
| [DECIMAL](../sql-manual/basic-element/sql-data-types/numeric/DECIMAL)
| 4/8/16 | 高精度定点数，格式：DECIMAL(M[,D])。其中，M 代表一共有多少个有效数字（precision），D
代表小数位有多少数字（scale）。有效数字 M 的范围是 [1, 38]，小数位数字数量 D 的范围是 [0, precision]。0 <
precision <= 9 的场合，占用 4 字节。9 < precision <= 18 的场合，占用 8 字节。16 < precision <= 38
的场合，占用 16 字节。|
-### [日期类型](../sql-manual/sql-data-types/data-type-overview#日期类型)
+### [日期类型](../sql-manual/basic-element/sql-data-types/data-type-overview#日期类型)
| 类型名 | 存储空间（字节） | 描述
|
| --------------------- | ---------------- |
------------------------------------------------------------------------------------------
|
| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE) |
16 | 日期类型，目前的取值范围是 ['0000-01-01', '9999-12-31']，默认的打印形式是
'yyyy-MM-dd'。 |
| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME) |
16 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0, 6]，即最多支持 6
位小数（微秒）。不设置时为 0。<br />取值范围是 ['0000-01-01 00:00:00[.000000]', '9999-12-31
23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 |
-### [字符串类型](../sql-manual/sql-data-types/data-type-overview#字符串类型)
+###
[字符串类型](../sql-manual/basic-element/sql-data-types/data-type-overview#字符串类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
@@ -56,7 +56,7 @@ Apache Doris 已支持的数据类型列表如下：
| [VARCHAR](../sql-manual/basic-element/sql-data-types/string-type/VARCHAR)
| 不定长 | 变长字符串，M 代表的是变长字符串的字节长度。M 的范围是 1-65533。变长字符串是以 UTF-8
编码存储的，因此通常英文字符占 1 个字节，中文字符占 3 个字节。 |
| [STRING](../sql-manual/basic-element/sql-data-types/string-type/STRING)
| 不定长 | 变长字符串，默认支持 1048576 字节（1MB），可调大到 2147483643 字节（2GB）。可通过 BE 配置
string_type_length_soft_limit_bytes 调整。String 类型只能用在 Value 列，不能用在 Key 列和分区分桶列。 |
-### [半结构类型](../sql-manual/sql-data-types/data-type-overview#半结构化类型)
+###
[半结构类型](../sql-manual/basic-element/sql-data-types/data-type-overview#半结构化类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
| [ARRAY](../sql-manual/basic-element/sql-data-types/semi-structured/ARRAY)
| 不定长 | 由 T 类型元素组成的数组，不能作为 Key 列使用。目前支持在 Duplicate 和 Unique 模型的表中使用。 |
@@ -65,7 +65,7 @@ Apache Doris 已支持的数据类型列表如下：
| [JSON](../sql-manual/basic-element/sql-data-types/semi-structured/JSON)
| 不定长 | 二进制 JSON 类型，采用二进制 JSON 格式存储，通过 JSON 函数访问 JSON 内部字段。长度限制和配置方式与
String 相同 |
|
[VARIANT](../sql-manual/basic-element/sql-data-types/semi-structured/VARIANT)
| 不定长 | 动态可变数据类型，专为半结构化数据如 JSON 设计，可以存入任意 JSON，自动将 JSON
中的字段拆分成子列存储，提升存储效率和查询分析性能。长度限制和配置方式与 String 相同。Variant 类型只能用在 Value 列，不能用在 Key
列和分区分桶列。|
-### [聚合类型](../sql-manual/sql-data-types/data-type-overview#聚合类型)
+### [聚合类型](../sql-manual/basic-element/sql-data-types/data-type-overview#聚合类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
@@ -74,7 +74,7 @@ Apache Doris 已支持的数据类型列表如下：
|
[QUANTILE_STATE](../sql-manual/basic-element/sql-data-types/aggregate/QUANTILE-STATE)
| 不定长 | QUANTILE_STATE 是一种计算分位数近似值的类型，在导入时会对相同的 Key，不同 Value 进行预聚合，当 value
数量不超过 2048 时采用明细记录所有数据，当 Value 数量大于 2048 时采用 TDigest
算法，对数据进行聚合（聚类）保存聚类后的质心点。QUANTILE_STATE 不能作为 Key 列使用，建表时配合聚合类型为
QUANTILE_UNION。用户不需要指定长度和默认值。长度根据数据的聚合程度系统内控制。QUANTILE_STATE 列只能通过配套的
QUANTILE_PERCENT、QUANTILE_UNION、TO_QUANTILE_STATE 等函数进行查询或使用。 |
| [AGG_STATE](../sql-manual/basic-element/sql-data-types/aggregate/AGG-STATE)
| 不定长 | 聚合函数，只能配合 state/merge/union 函数组合器使用。AGG_STATE 不能作为 Key
列使用，建表时需要同时声明聚合函数的签名。用户不需要指定长度和默认值。实际存储的数据大小与函数实现有关。 |
-### [IP 类型](../sql-manual/sql-data-types/data-type-overview#ip-类型)
+### [IP
类型](../sql-manual/basic-element/sql-data-types/data-type-overview#ip-类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
| [IPv4](../sql-manual/basic-element/sql-data-types/ip/IPV4) | 4
字节 | 以 4 字节二进制存储 IPv4 地址，配合 ipv4_* 系列函数使用。 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/udf/java-user-defined-function.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/udf/java-user-defined-function.md
index eeb2fbb2281..d6dce5d4b72 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/udf/java-user-defined-function.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/query-data/udf/java-user-defined-function.md
@@ -29,7 +29,7 @@ Java UDF 为用户提供使用 Java 编写 UDF 的接口，以方便用户使用
Doris 支持使用 JAVA 编写 UDF、UDAF 和 UDTF。下文如无特殊说明，使用 UDF 统称所有用户自定义函数。
1. Java UDF 是较为常见的自定义标量函数 (Scalar Function)，即每输入一行数据，就会有一行对应的结果输出，较为常见的有
ABS，LENGTH 等。值得一提的是对于用户来讲，Hive UDF 是可以直接迁移至 Doris 的。
2. Java UDAF 即为自定义的聚合函数 (Aggregate Function)，即在输入多行数据进行聚合后，仅输出一行对应的结果，较为常见的有
MIN，MAX，COUNT 等。
-3. JAVA UDTF 即为自定义的表函数 (Table Function)，即每输一行数据，可以产生一行或多行的结果，在 Doris 中需要结合
Lateral View 使用可以达到行转列的效果，较为常见的有 EXPLODE，EXPLODE_SPLIT 等。
+3. JAVA UDTF 即为自定义的表函数 (Table Function)，即每输一行数据，可以产生一行或多行的结果，在 Doris 中需要结合
Lateral View 使用可以达到行转列的效果，较为常见的有 EXPLODE，EXPLODE_SPLIT 等。**该功能自 Doris 3.0
版本起开始支持。**
## 类型对应关系
@@ -349,51 +349,11 @@ public void destroy(State state) {
```
### Java-UDTF 实例介绍
+
:::tip
UDTF 自 Doris 3.0 版本开始支持
:::
-1. 首先编写对应的 Java UDTF 代码，打包生成 JAR 包。
-UDTF 和 UDF 函数一样，需要用户自主实现一个 `evaluate` 方法，但是 UDTF 函数的返回值必须是 Array 类型。
-
- ```JAVA
- public class UDTFStringTest {
- public ArrayList<String> evaluate(String value, String separator) {
- if (value == null || separator == null) {
- return null;
- } else {
- return new ArrayList<>(Arrays.asList(value.split(separator)));
- }
- }
- }
- ```
-
-2. 在 Doris 中注册创建 Java-UDTF 函数。此时会注册两个 UTDF 函数，另外一个是在函数名后面加上 `_outer` 后缀，其中带后缀
`_outer` 的是针对结果为 0 行时的特殊处理，具体可查看[OUTER
组合器](../../sql-manual/sql-functions/table-functions/explode-numbers)。
-更多语法帮助可参阅 [CREATE
FUNCTION](../../sql-manual/sql-statements/function/CREATE-FUNCTION).
-
- ```sql
- CREATE TABLES FUNCTION java-utdf(string, string) RETURNS array<string>
PROPERTIES (
- "file"="file:///pathTo/java-udtf.jar",
- "symbol"="org.apache.doris.udf.demo.UDTFStringTest",
- "always_nullable"="true",
- "type"="JAVA_UDF"
- );
- ```
-
-3. 使用 Java-UDTF, 在 Doris 中使用 UDTF 需要结合 [Lateral View](../lateral-view.md),
实现行转列的效果 :
-
- ```sql
- select id, str, e1 from test_table lateral view java_utdf(str,',') tmp as
e1;
- +------+-------+------+
- | id | str | e1 |
- +------+-------+------+
- | 1 | a,b,c | a |
- | 1 | a,b,c | b |
- | 1 | a,b,c | c |
- | 6 | d,e | d |
- | 6 | d,e | e |
- +------+-------+------+
- ```
## 最佳实践
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/sql-data-types/data-type-overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/sql-data-types/data-type-overview.md
index 4053f2a5cf1..a5d38868244 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/sql-data-types/data-type-overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/basic-element/sql-data-types/data-type-overview.md
@@ -38,9 +38,9 @@ under the License.
都是有符号整数，xxINT 的差异是占用字节数和表示范围
-- TINYINT 占 1 字节，范围 [-128, 127], 更多信息参考 [TINYINT
文档](../../basic-element/sql-manual/sql-data-types/numeric/TINYINT.md)。
+- TINYINT 占 1 字节，范围 [-128, 127], 更多信息参考 [TINYINT
文档](../../basic-element/sql-data-types/numeric/TINYINT.md)。
-- SMALLINT 占 2 字节，范围 [-32768, 32767], 更多信息参考 [SMALLINT
文档](../../basic-element/sql-manual/sql-data-types/numeric/SMALLINT.md)。
+- SMALLINT 占 2 字节，范围 [-32768, 32767], 更多信息参考 [SMALLINT
文档](../../basic-element/sql-data-types/numeric/SMALLINT.md)。
- INT 占 4 字节，范围 [-2147483648, 2147483647], 更多信息参考 [INT
文档](../../basic-element/sql-data-types/numeric/INT.md)。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
index 4f8a6af64e4..404f20ff79f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
@@ -26,7 +26,7 @@ under the License.
Apache Doris 已支持的数据类型列表如下：
-### [数值类型](../sql-manual/sql-data-types/data-type-overview#数值类型)
+### [数值类型](../sql-manual/basic-element/sql-data-types/data-type-overview#数值类型)
| 类型名 | 存储空间（字节）| 描述
|
@@ -41,14 +41,14 @@ Apache Doris 已支持的数据类型列表如下：
| [DOUBLE](../sql-manual/basic-element/sql-data-types/numeric/DOUBLE)
| 8 | 浮点数，范围 [-1.79*10^308 ~ 1.79*10^308]。 |
| [DECIMAL](../sql-manual/basic-element/sql-data-types/numeric/DECIMAL)
| 4/8/16 | 高精度定点数，格式：DECIMAL(M[,D])。其中，M 代表一共有多少个有效数字（precision），D
代表小数位有多少数字（scale）。有效数字 M 的范围是 [1, 38]，小数位数字数量 D 的范围是 [0, precision]。0 <
precision <= 9 的场合，占用 4 字节。9 < precision <= 18 的场合，占用 8 字节。16 < precision <= 38
的场合，占用 16 字节。|
-### [日期类型](../sql-manual/sql-data-types/data-type-overview#日期类型)
+### [日期类型](../sql-manual/basic-element/sql-data-types/data-type-overview#日期类型)
| 类型名 | 存储空间（字节） | 描述
|
| --------------------- | ---------------- |
------------------------------------------------------------------------------------------
|
| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE) |
16 | 日期类型，目前的取值范围是 ['0000-01-01', '9999-12-31']，默认的打印形式是
'yyyy-MM-dd'。 |
| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME) |
16 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0, 6]，即最多支持 6
位小数（微秒）。不设置时为 0。<br />取值范围是 ['0000-01-01 00:00:00[.000000]', '9999-12-31
23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 |
-### [字符串类型](../sql-manual/sql-data-types/data-type-overview#字符串类型)
+###
[字符串类型](../sql-manual/basic-element/sql-data-types/data-type-overview#字符串类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
@@ -56,7 +56,7 @@ Apache Doris 已支持的数据类型列表如下：
| [VARCHAR](../sql-manual/basic-element/sql-data-types/string-type/VARCHAR)
| 不定长 | 变长字符串，M 代表的是变长字符串的字节长度。M 的范围是 1-65533。变长字符串是以 UTF-8
编码存储的，因此通常英文字符占 1 个字节，中文字符占 3 个字节。 |
| [STRING](../sql-manual/basic-element/sql-data-types/string-type/STRING)
| 不定长 | 变长字符串，默认支持 1048576 字节（1MB），可调大到 2147483643 字节（2GB）。可通过 BE 配置
string_type_length_soft_limit_bytes 调整。String 类型只能用在 Value 列，不能用在 Key 列和分区分桶列。 |
-### [半结构类型](../sql-manual/sql-data-types/data-type-overview#半结构化类型)
+###
[半结构类型](../sql-manual/basic-element/sql-data-types/data-type-overview#半结构化类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
| [ARRAY](../sql-manual/basic-element/sql-data-types/semi-structured/ARRAY)
| 不定长 | 由 T 类型元素组成的数组，不能作为 Key 列使用。目前支持在 Duplicate 和 Unique 模型的表中使用。 |
@@ -65,7 +65,7 @@ Apache Doris 已支持的数据类型列表如下：
| [JSON](../sql-manual/basic-element/sql-data-types/semi-structured/JSON)
| 不定长 | 二进制 JSON 类型，采用二进制 JSON 格式存储，通过 JSON 函数访问 JSON 内部字段。长度限制和配置方式与
String 相同 |
|
[VARIANT](../sql-manual/basic-element/sql-data-types/semi-structured/VARIANT)
| 不定长 | 动态可变数据类型，专为半结构化数据如 JSON 设计，可以存入任意 JSON，自动将 JSON
中的字段拆分成子列存储，提升存储效率和查询分析性能。长度限制和配置方式与 String 相同。Variant 类型只能用在 Value 列，不能用在 Key
列和分区分桶列。|
-### [聚合类型](../sql-manual/sql-data-types/data-type-overview#聚合类型)
+### [聚合类型](../sql-manual/basic-element/sql-data-types/data-type-overview#聚合类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
@@ -74,7 +74,7 @@ Apache Doris 已支持的数据类型列表如下：
|
[QUANTILE_STATE](../sql-manual/basic-element/sql-data-types/aggregate/QUANTILE-STATE)
| 不定长 | QUANTILE_STATE 是一种计算分位数近似值的类型，在导入时会对相同的 Key，不同 Value 进行预聚合，当 value
数量不超过 2048 时采用明细记录所有数据，当 Value 数量大于 2048 时采用 TDigest
算法，对数据进行聚合（聚类）保存聚类后的质心点。QUANTILE_STATE 不能作为 Key 列使用，建表时配合聚合类型为
QUANTILE_UNION。用户不需要指定长度和默认值。长度根据数据的聚合程度系统内控制。QUANTILE_STATE 列只能通过配套的
QUANTILE_PERCENT、QUANTILE_UNION、TO_QUANTILE_STATE 等函数进行查询或使用。 |
| [AGG_STATE](../sql-manual/basic-element/sql-data-types/aggregate/AGG-STATE)
| 不定长 | 聚合函数，只能配合 state/merge/union 函数组合器使用。AGG_STATE 不能作为 Key
列使用，建表时需要同时声明聚合函数的签名。用户不需要指定长度和默认值。实际存储的数据大小与函数实现有关。 |
-### [IP 类型](../sql-manual/sql-data-types/data-type-overview#ip-类型)
+### [IP
类型](../sql-manual/basic-element/sql-data-types/data-type-overview#ip-类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
| [IPv4](../sql-manual/basic-element/sql-data-types/ip/IPV4) | 4
字节 | 以 4 字节二进制存储 IPv4 地址，配合 ipv4_* 系列函数使用。 |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/basic-element/sql-data-types/data-type-overview.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/basic-element/sql-data-types/data-type-overview.md
index d35229c976a..69047baebcc 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/basic-element/sql-data-types/data-type-overview.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/basic-element/sql-data-types/data-type-overview.md
@@ -37,9 +37,9 @@ under the License.
都是有符号整数，xxINT 的差异是占用字节数和表示范围
-- TINYINT 占 1 字节，范围 [-128, 127], 更多信息参考 [TINYINT
文档](../../basic-element/sql-manual/sql-data-types/numeric/TINYINT.md)。
+- TINYINT 占 1 字节，范围 [-128, 127], 更多信息参考 [TINYINT
文档](../../basic-element/sql-data-types/numeric/TINYINT.md)。
-- SMALLINT 占 2 字节，范围 [-32768, 32767], 更多信息参考 [SMALLINT
文档](../../basic-element/sql-manual/sql-data-types/numeric/SMALLINT.md)。
+- SMALLINT 占 2 字节，范围 [-32768, 32767], 更多信息参考 [SMALLINT
文档](../../basic-element/sql-data-types/numeric/SMALLINT.md)。
- INT 占 4 字节，范围 [-2147483648, 2147483647], 更多信息参考 [INT
文档](../../basic-element/sql-data-types/numeric/INT.md)。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/data-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/data-type.md
index 4f8a6af64e4..404f20ff79f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/data-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/table-design/data-type.md
@@ -26,7 +26,7 @@ under the License.
Apache Doris 已支持的数据类型列表如下：
-### [数值类型](../sql-manual/sql-data-types/data-type-overview#数值类型)
+### [数值类型](../sql-manual/basic-element/sql-data-types/data-type-overview#数值类型)
| 类型名 | 存储空间（字节）| 描述
|
@@ -41,14 +41,14 @@ Apache Doris 已支持的数据类型列表如下：
| [DOUBLE](../sql-manual/basic-element/sql-data-types/numeric/DOUBLE)
| 8 | 浮点数，范围 [-1.79*10^308 ~ 1.79*10^308]。 |
| [DECIMAL](../sql-manual/basic-element/sql-data-types/numeric/DECIMAL)
| 4/8/16 | 高精度定点数，格式：DECIMAL(M[,D])。其中，M 代表一共有多少个有效数字（precision），D
代表小数位有多少数字（scale）。有效数字 M 的范围是 [1, 38]，小数位数字数量 D 的范围是 [0, precision]。0 <
precision <= 9 的场合，占用 4 字节。9 < precision <= 18 的场合，占用 8 字节。16 < precision <= 38
的场合，占用 16 字节。|
-### [日期类型](../sql-manual/sql-data-types/data-type-overview#日期类型)
+### [日期类型](../sql-manual/basic-element/sql-data-types/data-type-overview#日期类型)
| 类型名 | 存储空间（字节） | 描述
|
| --------------------- | ---------------- |
------------------------------------------------------------------------------------------
|
| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE) |
16 | 日期类型，目前的取值范围是 ['0000-01-01', '9999-12-31']，默认的打印形式是
'yyyy-MM-dd'。 |
| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME) |
16 | 日期时间类型，格式：DATETIME([P])。可选参数 P 表示时间精度，取值范围是 [0, 6]，即最多支持 6
位小数（微秒）。不设置时为 0。<br />取值范围是 ['0000-01-01 00:00:00[.000000]', '9999-12-31
23:59:59[.999999]']。打印的形式是 'yyyy-MM-dd HH:mm:ss.SSSSSS'。 |
-### [字符串类型](../sql-manual/sql-data-types/data-type-overview#字符串类型)
+###
[字符串类型](../sql-manual/basic-element/sql-data-types/data-type-overview#字符串类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
@@ -56,7 +56,7 @@ Apache Doris 已支持的数据类型列表如下：
| [VARCHAR](../sql-manual/basic-element/sql-data-types/string-type/VARCHAR)
| 不定长 | 变长字符串，M 代表的是变长字符串的字节长度。M 的范围是 1-65533。变长字符串是以 UTF-8
编码存储的，因此通常英文字符占 1 个字节，中文字符占 3 个字节。 |
| [STRING](../sql-manual/basic-element/sql-data-types/string-type/STRING)
| 不定长 | 变长字符串，默认支持 1048576 字节（1MB），可调大到 2147483643 字节（2GB）。可通过 BE 配置
string_type_length_soft_limit_bytes 调整。String 类型只能用在 Value 列，不能用在 Key 列和分区分桶列。 |
-### [半结构类型](../sql-manual/sql-data-types/data-type-overview#半结构化类型)
+###
[半结构类型](../sql-manual/basic-element/sql-data-types/data-type-overview#半结构化类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
| [ARRAY](../sql-manual/basic-element/sql-data-types/semi-structured/ARRAY)
| 不定长 | 由 T 类型元素组成的数组，不能作为 Key 列使用。目前支持在 Duplicate 和 Unique 模型的表中使用。 |
@@ -65,7 +65,7 @@ Apache Doris 已支持的数据类型列表如下：
| [JSON](../sql-manual/basic-element/sql-data-types/semi-structured/JSON)
| 不定长 | 二进制 JSON 类型，采用二进制 JSON 格式存储，通过 JSON 函数访问 JSON 内部字段。长度限制和配置方式与
String 相同 |
|
[VARIANT](../sql-manual/basic-element/sql-data-types/semi-structured/VARIANT)
| 不定长 | 动态可变数据类型，专为半结构化数据如 JSON 设计，可以存入任意 JSON，自动将 JSON
中的字段拆分成子列存储，提升存储效率和查询分析性能。长度限制和配置方式与 String 相同。Variant 类型只能用在 Value 列，不能用在 Key
列和分区分桶列。|
-### [聚合类型](../sql-manual/sql-data-types/data-type-overview#聚合类型)
+### [聚合类型](../sql-manual/basic-element/sql-data-types/data-type-overview#聚合类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
@@ -74,7 +74,7 @@ Apache Doris 已支持的数据类型列表如下：
|
[QUANTILE_STATE](../sql-manual/basic-element/sql-data-types/aggregate/QUANTILE-STATE)
| 不定长 | QUANTILE_STATE 是一种计算分位数近似值的类型，在导入时会对相同的 Key，不同 Value 进行预聚合，当 value
数量不超过 2048 时采用明细记录所有数据，当 Value 数量大于 2048 时采用 TDigest
算法，对数据进行聚合（聚类）保存聚类后的质心点。QUANTILE_STATE 不能作为 Key 列使用，建表时配合聚合类型为
QUANTILE_UNION。用户不需要指定长度和默认值。长度根据数据的聚合程度系统内控制。QUANTILE_STATE 列只能通过配套的
QUANTILE_PERCENT、QUANTILE_UNION、TO_QUANTILE_STATE 等函数进行查询或使用。 |
| [AGG_STATE](../sql-manual/basic-element/sql-data-types/aggregate/AGG-STATE)
| 不定长 | 聚合函数，只能配合 state/merge/union 函数组合器使用。AGG_STATE 不能作为 Key
列使用，建表时需要同时声明聚合函数的签名。用户不需要指定长度和默认值。实际存储的数据大小与函数实现有关。 |
-### [IP 类型](../sql-manual/sql-data-types/data-type-overview#ip-类型)
+### [IP
类型](../sql-manual/basic-element/sql-data-types/data-type-overview#ip-类型)
| 类型名 | 存储空间（字节）| 描述
|
| -------------- | --------- |
------------------------------------------------------------ |
| [IPv4](../sql-manual/basic-element/sql-data-types/ip/IPV4) | 4
字节 | 以 4 字节二进制存储 IPv4 地址，配合 ipv4_* 系列函数使用。 |
diff --git
a/versioned_docs/version-2.1/query-data/udf/java-user-defined-function.md
b/versioned_docs/version-2.1/query-data/udf/java-user-defined-function.md
index 7250e717835..1150b9911eb 100644
--- a/versioned_docs/version-2.1/query-data/udf/java-user-defined-function.md
+++ b/versioned_docs/version-2.1/query-data/udf/java-user-defined-function.md
@@ -33,7 +33,7 @@ Doris supports the use of Java to develop UDFs, UDAFs, and
UDTFs. Unless otherwi
2. Java UDAF: A Java UDAF is a user-defined aggregate function that aggregates
multiple input rows into a single output row. Common examples include MIN, MAX,
and COUNT.
-3. Java UDTF: A Java UDTF is a user-defined table function, where a single
input row can generate one or multiple output rows. In Doris, UDTFs must be
used with Lateral View to achieve row-to-column transformations. Common
examples include EXPLODE and EXPLODE_SPLIT.
+3. Java UDTF: A Java UDTF is a user-defined table function, where a single
input row can generate one or multiple output rows. In Doris, UDTFs must be
used with Lateral View to achieve row-to-column transformations. Common
examples include EXPLODE and EXPLODE_SPLIT. **Java UDTF is available from
version 3.0.0 and onwards.**
## Type Correspondence
@@ -363,47 +363,6 @@ public class MedianUDAF {
UDTF is supported starting from Doris version 3.0.
:::
-1. Similar to UDFs, UDTFs require users to implement an `evaluate` method.
However, the return value of a UDTF must be of the Array type.
-
- ```JAVA
- public class UDTFStringTest {
- public ArrayList<String> evaluate(String value, String separator) {
- if (value == null || separator == null) {
- return null;
- } else {
- return new ArrayList<>(Arrays.asList(value.split(separator)));
- }
- }
- }
- ```
-
-2. Register and create the Java-UDTF function in Doris. Two UDTF functions
will be registered. Table functions in Doris may exhibit different behaviors
due to the `_outer` suffix. For more details, refer to [OUTER
combinator](../../sql-manual/sql-functions/table-functions/explode-numbers).
-For more syntax details, please refer to [CREATE
FUNCTION](../../sql-manual/sql-statements/function/CREATE-FUNCTION).
-
- ```sql
- CREATE TABLES FUNCTION java-utdf(string, string) RETURNS array<string>
PROPERTIES (
- "file"="file:///pathTo/java-udtf.jar",
- "symbol"="org.apache.doris.udf.demo.UDTFStringTest",
- "always_nullable"="true",
- "type"="JAVA_UDF"
- );
- ```
-
-3. When using Java-UDTF, in Doris, UDTFs must be used with [`Lateral
View`](../lateral-view.md) to achieve the row-to-column transformation effect:
-
- ```sql
- select id, str, e1 from test_table lateral view java_utdf(str,',') tmp as
e1;
- +------+-------+------+
- | id | str | e1 |
- +------+-------+------+
- | 1 | a,b,c | a |
- | 1 | a,b,c | b |
- | 1 | a,b,c | c |
- | 6 | d,e | d |
- | 6 | d,e | e |
- +------+-------+------+
- ```
-
## Best Practices
*Loading static variables*
diff --git
a/versioned_docs/version-2.1/sql-manual/basic-element/sql-data-types/data-type-overview.md
b/versioned_docs/version-2.1/sql-manual/basic-element/sql-data-types/data-type-overview.md
index 0c99fa4f316..2a18989e05e 100644
---
a/versioned_docs/version-2.1/sql-manual/basic-element/sql-data-types/data-type-overview.md
+++
b/versioned_docs/version-2.1/sql-manual/basic-element/sql-data-types/data-type-overview.md
@@ -64,7 +64,7 @@ The precise fixed-point type
[DECIMAL](../sql-data-types/numeric/DECIMAL.md), us
Date types include DATE, TIME and DATETIME, DATE type only stores the date
accurate to the day, DATETIME type stores the date and time, which can be
accurate to microseconds. TIME type only stores the time, and **does not
support the construction of the table storage for the time being, can only be
used in the query process**.
-Do calculation for datetime types or converting them to numeric types, please
use functions like
[TIME_TO_SEC](../sql-functions/scalar-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../sql-functions/scalar-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../sql-functions/scalar-functions/date-time-functions/unix-timestamp)
. The result of directly converting them as numeric types as not guaranteed.
+Do calculation for datetime types or converting them to numeric types, please
use functions like
[TIME_TO_SEC](../../sql-functions/scalar-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../../sql-functions/scalar-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../../sql-functions/scalar-functions/date-time-functions/unix-timestamp)
. The result of directly converting them as numeric types as not guaranteed.
For more information refer to [DATE](../sql-data-types/date-time/DATE),
[TIME](../sql-data-types/date-time/TIME) and
[DATETIME](../sql-data-types/date-time/DATETIME) documents.
diff --git a/versioned_docs/version-2.1/table-design/data-type.md
b/versioned_docs/version-2.1/table-design/data-type.md
index 890e92e99a0..f33e981d990 100644
--- a/versioned_docs/version-2.1/table-design/data-type.md
+++ b/versioned_docs/version-2.1/table-design/data-type.md
@@ -28,7 +28,7 @@ Apache Doris support standard SQL syntax, using MySQL Network
Connection Protoco
The list of data types supported by Doris is as follows:
-## [Numeric data
type](../sql-manual/sql-data-types/data-type-overview#numeric-types)
+## [Numeric data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#numeric-types)
| Type Name | Storage
(bytes) | Description |
| ---------------------------------------------------------- | ---------------
| ------------------------------------------------------------ |
@@ -42,21 +42,21 @@ The list of data types supported by Doris is as follows:
| [DOUBLE](../sql-manual/basic-element/sql-data-types/numeric/DOUBLE)
| 8 | Double precision floating point number, range is [-1.79 *
10^308 to 1.79 * 10^308]. |
| [DECIMAL](../sql-manual/basic-element/sql-data-types/numeric/DECIMAL)
| 4/8/16 | An exact fixed-point number defined by precision (total
number of digits) and scale (number of digits to the right of the decimal
point). Format: DECIMAL(M[,D]), where M is precision and D is scale. The range
for M is [1, 38], and for D is [0, precision]. Storage requirements: - 4 bytes
for 0 < precision <= 9, - 8 bytes for 9 < precision <= 18, - 16 bytes for 18 <
precision <= 38. |
-## [Datetime data
type](../sql-manual/sql-data-types/data-type-overview#date-types)
+## [Datetime data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#date-types)
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE)
| 16 | DATE holds values for a calendar year, month and day, the
supported range is ['0000-01-01', '9999-12-31']. Default print format:
'yyyy-MM-dd'. |
| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME)
| 16 | A DATE and TIME combination Format: DATETIME ([P]).
The optional parameter P represents time precision, with a value range of
[0,6], supporting up to 6 decimal places (microseconds). When not set, it is 0.
The supported range is ['0000-01-01 00:00:00 [.000000]', '9999-12-31 23:59:59
[.999999]']. Default print format: 'yyy-MM-dd HH: mm: ss. SSSSSS '. |
-## [String data
type](../sql-manual/sql-data-types/data-type-overview#string-types)
+## [String data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#string-types)
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
| [CHAR](../sql-manual/basic-element/sql-data-types/string-type/CHAR)
| M | A FIXED length string, the parameter M specifies the
column length in characters. The range of M is from 1 to 255. |
| [VARCHAR](../sql-manual/basic-element/sql-data-types/string-type/VARCHAR)
| Variable Length | A VARIABLE length string , the parameter M specifies
the maximum string length in characters. The range of M is from 1 to 65533.
The variable-length string is stored in UTF-8 encoding. English characters
occupy 1 byte, and Chinese characters occupy 3 bytes. |
| [STRING](../sql-manual/basic-element/sql-data-types/string-type/STRING)
| Variable Length | A VARIABLE length string, default supports 1048576
bytes (1 MB), and a limit of maximum precision of 2147483643 bytes (2 GB).
Size can be configured string_type_length_soft_limit_bytes adjusted through BE.
String type can only be used in value column, not in key column and partition
bucket column. |
-## [Semi-structured data
type](../sql-manual/sql-data-types/data-type-overview#semi-structured-types)
+## [Semi-structured data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#semi-structured-types)
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
@@ -66,7 +66,7 @@ The list of data types supported by Doris is as follows:
| [JSON](../sql-manual/basic-element/sql-data-types/semi-structured/JSON)
| Variable Length | Binary JSON type, stored in binary JSON format, access
internal JSON fields through JSON function. Supported up to 1048576 bytes
(1MB) by default, and can be adjusted to a maximum of 2147483643 bytes (2GB).
This limit can be modified through the BE configuration parameter
'jsonb_type_length_soft_limit_bytes'. |
|
[VARIANT](../sql-manual/basic-element/sql-data-types/semi-structured/VARIANT)
| Variable Length | The VARIANT data type is dynamically adaptable,
specifically designed for semi-structured data like JSON. It can store any JSON
object and automatically splits JSON fields into subcolumns for improved
storage efficiency and query performance. The length limits and configuration
methods are the same as for the STRING type. However, the VARIANT type can only
be used in value columns a [...]
-## [Aggregation data
type](../sql-manual/sql-data-types/data-type-overview#aggregation-types)
+## [Aggregation data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#aggregation-types)
| Type name |
Storeage (bytes)| Description |
|-------------------------------------------------------------------------|
--------------- | ------------------------------------------------------------ |
@@ -75,7 +75,7 @@ The list of data types supported by Doris is as follows:
|
[QUANTILE_STATE](../sql-manual/basic-element/sql-data-types/aggregate/QUANTILE-STATE)
| Variable Length | A type used to calculate approximate quantile values.
When loading, it performs pre-aggregation for the same keys with different
values. When the number of values does not exceed 2048, it records all data in
detail. When the number of values is greater than 2048, it employs the TDigest
algorithm to aggregate (cluster) the data and store the centroid points after
clustering. QUAN [...]
| [AGG_STATE](../sql-manual/basic-element/sql-data-types/aggregate/AGG-STATE)
| Variable Length | Aggregate function can only be used with
state/merge/union function combiners. AGG_STATE cannot be used as a key
column. When creating a table, the signature of the aggregate function needs to
be declared alongside. Users do not need to specify the length or default
value. The actual data storage size depends on the function's implementation. |
-## [IP types](../sql-manual/sql-data-types/data-type-overview#ip-types)
+## [IP
types](../sql-manual/basic-element/sql-data-types/data-type-overview#ip-types)
| Type Name | Storage
(bytes) | Description |
| ---------------------------------------------------------- | ---------------
| ------------------------------------------------------------ |
diff --git
a/versioned_docs/version-3.0/sql-manual/basic-element/sql-data-types/data-type-overview.md
b/versioned_docs/version-3.0/sql-manual/basic-element/sql-data-types/data-type-overview.md
index 0c99fa4f316..2a18989e05e 100644
---
a/versioned_docs/version-3.0/sql-manual/basic-element/sql-data-types/data-type-overview.md
+++
b/versioned_docs/version-3.0/sql-manual/basic-element/sql-data-types/data-type-overview.md
@@ -64,7 +64,7 @@ The precise fixed-point type
[DECIMAL](../sql-data-types/numeric/DECIMAL.md), us
Date types include DATE, TIME and DATETIME, DATE type only stores the date
accurate to the day, DATETIME type stores the date and time, which can be
accurate to microseconds. TIME type only stores the time, and **does not
support the construction of the table storage for the time being, can only be
used in the query process**.
-Do calculation for datetime types or converting them to numeric types, please
use functions like
[TIME_TO_SEC](../sql-functions/scalar-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../sql-functions/scalar-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../sql-functions/scalar-functions/date-time-functions/unix-timestamp)
. The result of directly converting them as numeric types as not guaranteed.
+Do calculation for datetime types or converting them to numeric types, please
use functions like
[TIME_TO_SEC](../../sql-functions/scalar-functions/date-time-functions/time-to-sec),
[DATE_DIFF](../../sql-functions/scalar-functions/date-time-functions/datediff),
[UNIX_TIMESTAMP](../../sql-functions/scalar-functions/date-time-functions/unix-timestamp)
. The result of directly converting them as numeric types as not guaranteed.
For more information refer to [DATE](../sql-data-types/date-time/DATE),
[TIME](../sql-data-types/date-time/TIME) and
[DATETIME](../sql-data-types/date-time/DATETIME) documents.
diff --git a/versioned_docs/version-3.0/table-design/data-type.md
b/versioned_docs/version-3.0/table-design/data-type.md
index 890e92e99a0..f33e981d990 100644
--- a/versioned_docs/version-3.0/table-design/data-type.md
+++ b/versioned_docs/version-3.0/table-design/data-type.md
@@ -28,7 +28,7 @@ Apache Doris support standard SQL syntax, using MySQL Network
Connection Protoco
The list of data types supported by Doris is as follows:
-## [Numeric data
type](../sql-manual/sql-data-types/data-type-overview#numeric-types)
+## [Numeric data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#numeric-types)
| Type Name | Storage
(bytes) | Description |
| ---------------------------------------------------------- | ---------------
| ------------------------------------------------------------ |
@@ -42,21 +42,21 @@ The list of data types supported by Doris is as follows:
| [DOUBLE](../sql-manual/basic-element/sql-data-types/numeric/DOUBLE)
| 8 | Double precision floating point number, range is [-1.79 *
10^308 to 1.79 * 10^308]. |
| [DECIMAL](../sql-manual/basic-element/sql-data-types/numeric/DECIMAL)
| 4/8/16 | An exact fixed-point number defined by precision (total
number of digits) and scale (number of digits to the right of the decimal
point). Format: DECIMAL(M[,D]), where M is precision and D is scale. The range
for M is [1, 38], and for D is [0, precision]. Storage requirements: - 4 bytes
for 0 < precision <= 9, - 8 bytes for 9 < precision <= 18, - 16 bytes for 18 <
precision <= 38. |
-## [Datetime data
type](../sql-manual/sql-data-types/data-type-overview#date-types)
+## [Datetime data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#date-types)
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
| [DATE](../sql-manual/basic-element/sql-data-types/date-time/DATE)
| 16 | DATE holds values for a calendar year, month and day, the
supported range is ['0000-01-01', '9999-12-31']. Default print format:
'yyyy-MM-dd'. |
| [DATETIME](../sql-manual/basic-element/sql-data-types/date-time/DATETIME)
| 16 | A DATE and TIME combination Format: DATETIME ([P]).
The optional parameter P represents time precision, with a value range of
[0,6], supporting up to 6 decimal places (microseconds). When not set, it is 0.
The supported range is ['0000-01-01 00:00:00 [.000000]', '9999-12-31 23:59:59
[.999999]']. Default print format: 'yyy-MM-dd HH: mm: ss. SSSSSS '. |
-## [String data
type](../sql-manual/sql-data-types/data-type-overview#string-types)
+## [String data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#string-types)
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
| [CHAR](../sql-manual/basic-element/sql-data-types/string-type/CHAR)
| M | A FIXED length string, the parameter M specifies the
column length in characters. The range of M is from 1 to 255. |
| [VARCHAR](../sql-manual/basic-element/sql-data-types/string-type/VARCHAR)
| Variable Length | A VARIABLE length string , the parameter M specifies
the maximum string length in characters. The range of M is from 1 to 65533.
The variable-length string is stored in UTF-8 encoding. English characters
occupy 1 byte, and Chinese characters occupy 3 bytes. |
| [STRING](../sql-manual/basic-element/sql-data-types/string-type/STRING)
| Variable Length | A VARIABLE length string, default supports 1048576
bytes (1 MB), and a limit of maximum precision of 2147483643 bytes (2 GB).
Size can be configured string_type_length_soft_limit_bytes adjusted through BE.
String type can only be used in value column, not in key column and partition
bucket column. |
-## [Semi-structured data
type](../sql-manual/sql-data-types/data-type-overview#semi-structured-types)
+## [Semi-structured data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#semi-structured-types)
| Type name | Storeage (bytes)| Description
|
| -------------- | --------------- |
------------------------------------------------------------ |
@@ -66,7 +66,7 @@ The list of data types supported by Doris is as follows:
| [JSON](../sql-manual/basic-element/sql-data-types/semi-structured/JSON)
| Variable Length | Binary JSON type, stored in binary JSON format, access
internal JSON fields through JSON function. Supported up to 1048576 bytes
(1MB) by default, and can be adjusted to a maximum of 2147483643 bytes (2GB).
This limit can be modified through the BE configuration parameter
'jsonb_type_length_soft_limit_bytes'. |
|
[VARIANT](../sql-manual/basic-element/sql-data-types/semi-structured/VARIANT)
| Variable Length | The VARIANT data type is dynamically adaptable,
specifically designed for semi-structured data like JSON. It can store any JSON
object and automatically splits JSON fields into subcolumns for improved
storage efficiency and query performance. The length limits and configuration
methods are the same as for the STRING type. However, the VARIANT type can only
be used in value columns a [...]
-## [Aggregation data
type](../sql-manual/sql-data-types/data-type-overview#aggregation-types)
+## [Aggregation data
type](../sql-manual/basic-element/sql-data-types/data-type-overview#aggregation-types)
| Type name |
Storeage (bytes)| Description |
|-------------------------------------------------------------------------|
--------------- | ------------------------------------------------------------ |
@@ -75,7 +75,7 @@ The list of data types supported by Doris is as follows:
|
[QUANTILE_STATE](../sql-manual/basic-element/sql-data-types/aggregate/QUANTILE-STATE)
| Variable Length | A type used to calculate approximate quantile values.
When loading, it performs pre-aggregation for the same keys with different
values. When the number of values does not exceed 2048, it records all data in
detail. When the number of values is greater than 2048, it employs the TDigest
algorithm to aggregate (cluster) the data and store the centroid points after
clustering. QUAN [...]
| [AGG_STATE](../sql-manual/basic-element/sql-data-types/aggregate/AGG-STATE)
| Variable Length | Aggregate function can only be used with
state/merge/union function combiners. AGG_STATE cannot be used as a key
column. When creating a table, the signature of the aggregate function needs to
be declared alongside. Users do not need to specify the length or default
value. The actual data storage size depends on the function's implementation. |
-## [IP types](../sql-manual/sql-data-types/data-type-overview#ip-types)
+## [IP
types](../sql-manual/basic-element/sql-data-types/data-type-overview#ip-types)
| Type Name | Storage
(bytes) | Description |
| ---------------------------------------------------------- | ---------------
| ------------------------------------------------------------ |
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
