This is an automated email from the ASF dual-hosted git repository. morningman 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 4f216f27e16 [fix](doc) add partitions now only support 3.0 (#1205)
4f216f27e16 is described below
commit 4f216f27e16753a551f0cdaaa030bf57aa1484be
Author: kkop <2449402...@qq.com>
AuthorDate: Tue Oct 22 22:35:47 2024 +0800
[fix](doc) add partitions now only support 3.0 (#1205)
# Versions
- [ ] dev
- [ ] 3.0
- [x] 2.1
- [x] 2.0
# Languages
- [x] Chinese
- [x] English
---
.../version-2.0/table-design/data-partition.md | 41 ----------------------
.../version-2.1/table-design/data-partition.md | 41 ----------------------
.../version-2.0/table-design/data-partition.md | 41 ----------------------
.../version-2.1/table-design/data-partition.md | 41 ----------------------
4 files changed, 164 deletions(-)
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/data-partition.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/data-partition.md
index 682ca9649ed..f60c18ce4b4 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/data-partition.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/data-partition.md
@@ -237,47 +237,6 @@ PARTITION BY RANGE(`date`)
)
```
-3. BATCH RANGE：批量创建数字类型和时间类型的 RANGE 分区，定义分区的左闭右开区间，设定步长。
-
-```Plain
-PARTITION BY RANGE(int_col)
-(
- FROM (start_num) TO (end_num) INTERVAL interval_value
-)
-
-PARTITION BY RANGE(date_col)
-(
- FROM ("start_date") TO ("end_date") INTERVAL num YEAR | num MONTH | num
WEEK | num DAY ｜ 1 HOUR
-)
-```
-
-示例如下：
-
-```shell
-PARTITION BY RANGE(age)
-(
- FROM (1) TO (100) INTERVAL 10
-)
-
-PARTITION BY RANGE(`date`)
-(
- FROM ("2000-11-14") TO ("2021-11-14") INTERVAL 2 YEAR
-)
-```
-
-4.MULTI RANGE：批量创建 RANGE 分区，定义分区的左闭右开区间。示例如下：
-
-```shell
-PARTITION BY RANGE(col)
-(
- FROM ("2000-11-14") TO ("2021-11-14") INTERVAL 1 YEAR,
- FROM ("2021-11-14") TO ("2022-11-14") INTERVAL 1 MONTH,
- FROM ("2022-11-14") TO ("2023-01-03") INTERVAL 1 WEEK,
- FROM ("2023-01-03") TO ("2023-01-14") INTERVAL 1 DAY,
- PARTITION p_20230114 VALUES [('2023-01-14'), ('2023-01-15'))
-)
-```
-
### List 分区
分区列支持 `BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, LARGEINT, DATE, DATETIME,
CHAR, VARCHAR` 数据类型，分区值为枚举值。只有当数据为目标分区枚举值其中之一时，才可以命中分区。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-partition.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-partition.md
index 6569ee31e7e..f66caf4063b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-partition.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-partition.md
@@ -233,47 +233,6 @@ PARTITION BY RANGE(`date`)
)
```
-3. BATCH RANGE：批量创建数字类型和时间类型的 RANGE 分区，定义分区的左闭右开区间，设定步长。
-
-```Plain
-PARTITION BY RANGE(int_col)
-(
- FROM (start_num) TO (end_num) INTERVAL interval_value
-)
-
-PARTITION BY RANGE(date_col)
-(
- FROM ("start_date") TO ("end_date") INTERVAL num YEAR | num MONTH | num
WEEK | num DAY ｜ 1 HOUR
-)
-```
-
-示例如下：
-
-```shell
-PARTITION BY RANGE(age)
-(
- FROM (1) TO (100) INTERVAL 10
-)
-
-PARTITION BY RANGE(`date`)
-(
- FROM ("2000-11-14") TO ("2021-11-14") INTERVAL 2 YEAR
-)
-```
-
-4.MULTI RANGE：批量创建 RANGE 分区，定义分区的左闭右开区间。示例如下：
-
-```shell
-PARTITION BY RANGE(col)
-(
- FROM ("2000-11-14") TO ("2021-11-14") INTERVAL 1 YEAR,
- FROM ("2021-11-14") TO ("2022-11-14") INTERVAL 1 MONTH,
- FROM ("2022-11-14") TO ("2023-01-03") INTERVAL 1 WEEK,
- FROM ("2023-01-03") TO ("2023-01-14") INTERVAL 1 DAY,
- PARTITION p_20230114 VALUES [('2023-01-14'), ('2023-01-15'))
-)
-```
-
### List 分区
分区列支持 `BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, LARGEINT, DATE, DATETIME,
CHAR, VARCHAR` 数据类型，分区值为枚举值。只有当数据为目标分区枚举值其中之一时，才可以命中分区。
diff --git a/versioned_docs/version-2.0/table-design/data-partition.md
b/versioned_docs/version-2.0/table-design/data-partition.md
index 61d22ef1047..b472b8b6b91 100644
--- a/versioned_docs/version-2.0/table-design/data-partition.md
+++ b/versioned_docs/version-2.0/table-design/data-partition.md
@@ -234,47 +234,6 @@ PARTITION BY RANGE(`date`)
)
```
-- BATCH RANGE: Batch create RANGE partitions of numeric and time types,
defining the partitions as left-closed, right-open intervals, and setting the
step size.
-
-```
-PARTITION BY RANGE(int_col)
-(
- FROM (start_num) TO (end_num) INTERVAL interval_value
-)
-
-PARTITION BY RANGE(date_col)
-(
- FROM ("start_date") TO ("end_date") INTERVAL num YEAR | num MONTH | num
WEEK | num DAY ｜ 1 HOUR
-)
-```
-
-For example:
-
-```
-PARTITION BY RANGE(age)
-(
- FROM (1) TO (100) INTERVAL 10
-)
-
-PARTITION BY RANGE(`date`)
-(
- FROM ("2000-11-14") TO ("2021-11-14") INTERVAL 2 YEAR
-)
-```
-
-- MULTI RANGE: Batch create RANGE partitions, defining the partitions as
left-closed, right-open intervals. For example:
-
-```
-PARTITION BY RANGE(col)
-(
- FROM ("2000-11-14") TO ("2021-11-14") INTERVAL 1 YEAR,
- FROM ("2021-11-14") TO ("2022-11-14") INTERVAL 1 MONTH,
- FROM ("2022-11-14") TO ("2023-01-03") INTERVAL 1 WEEK,
- FROM ("2023-01-03") TO ("2023-01-14") INTERVAL 1 DAY,
- PARTITION p_20230114 VALUES [('2023-01-14'), ('2023-01-15'))
-)
-```
-
### List partition
Partition columns support data types such as BOOLEAN, TINYINT, SMALLINT, INT,
BIGINT, LARGEINT, DATE, DATETIME, CHAR, and VARCHAR. Partition values are
enumerated values. Only when the data is one of the enumerated values of the
target partition, the partition can be hit .
diff --git a/versioned_docs/version-2.1/table-design/data-partition.md
b/versioned_docs/version-2.1/table-design/data-partition.md
index bd31e0688a1..cab5df50527 100644
--- a/versioned_docs/version-2.1/table-design/data-partition.md
+++ b/versioned_docs/version-2.1/table-design/data-partition.md
@@ -243,47 +243,6 @@ PARTITION BY RANGE(`date`)
)
```
-- `BATCH RANGE`: This method batch creates partitions based on ranges of
number or time, defining the partitions as left-closed, right-open intervals
and setting the step size.
-
-```sql
-PARTITION BY RANGE(int_col)
-(
- FROM (start_num) TO (end_num) INTERVAL interval_value
-)
-
-PARTITION BY RANGE(date_col)
-(
- FROM ("start_date") TO ("end_date") INTERVAL num YEAR | num MONTH | num
WEEK | num DAY ｜ 1 HOUR
-)
-```
-
-For example:
-
-```sql
-PARTITION BY RANGE(age)
-(
- FROM (1) TO (100) INTERVAL 10
-)
-
-PARTITION BY RANGE(`date`)
-(
- FROM ("2000-11-14") TO ("2021-11-14") INTERVAL 2 YEAR
-)
-```
-
-- `MULTI RANGE`: This method batch creates partitions based on range
partitioning, defining the partitions as left-closed, right-open intervals. For
example:
-
-```sql
-PARTITION BY RANGE(col)
-(
- FROM ("2000-11-14") TO ("2021-11-14") INTERVAL 1 YEAR,
- FROM ("2021-11-14") TO ("2022-11-14") INTERVAL 1 MONTH,
- FROM ("2022-11-14") TO ("2023-01-03") INTERVAL 1 WEEK,
- FROM ("2023-01-03") TO ("2023-01-14") INTERVAL 1 DAY,
- PARTITION p_20230114 VALUES [('2023-01-14'), ('2023-01-15'))
-)
-```
-
### LIST partitioning
Partition columns based on LIST partitioning support data types such as
`BOOLEAN`, `TINYINT`, `SMALLINT`, `INT`, `BIGINT`, `LARGEINT`, `DATE`,
`DATETIME`, `CHAR`, and `VARCHAR`. Partition values are enumerated values. Only
when the data is one of the enumerated values of the target partition, the
partition can be hit.
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
