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 ad9729c2543 [opt](catalog) change the version of some catalog feature
(#3181)
ad9729c2543 is described below
commit ad9729c2543951037d6bceaeea3608d48bb13bc4
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Thu Dec 11 22:32:33 2025 +0800
[opt](catalog) change the version of some catalog feature (#3181)
## Versions
- [x] dev
- [x] 4.x
- [x] 3.x
- [ ] 2.1
## Languages
- [x] Chinese
- [ ] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/lakehouse/catalogs/hive-catalog.mdx | 2 +-
docs/lakehouse/catalogs/iceberg-catalog.mdx | 61 ++++++++++++++++++++-
docs/lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 2 +-
docs/lakehouse/catalogs/jdbc-mysql-catalog.md | 2 +-
docs/lakehouse/catalogs/jdbc-oracle-catalog.md | 2 +-
docs/lakehouse/catalogs/jdbc-pg-catalog.md | 2 +-
docs/lakehouse/catalogs/jdbc-sqlserver-catalog.md | 2 +-
docs/lakehouse/catalogs/paimon-catalog.mdx | 2 +-
docs/lakehouse/huggingface.md | 2 +-
.../sql-functions/table-valued-functions/http.md | 2 +-
.../current/lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../current/lakehouse/catalogs/iceberg-catalog.mdx | 61 ++++++++++++++++++++-
.../lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-mysql-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-oracle-catalog.md | 2 +-
.../current/lakehouse/catalogs/jdbc-pg-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-sqlserver-catalog.md | 2 +-
.../current/lakehouse/catalogs/paimon-catalog.mdx | 2 +-
.../current/lakehouse/huggingface.md | 2 +-
.../sql-functions/table-valued-functions/http.md | 2 +-
.../lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../lakehouse/catalogs/iceberg-catalog.mdx | 61 ++++++++++++++++++++-
.../lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 1 +
.../lakehouse/catalogs/jdbc-mysql-catalog.md | 3 +-
.../lakehouse/catalogs/jdbc-oracle-catalog.md | 1 +
.../lakehouse/catalogs/jdbc-pg-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-sqlserver-catalog.md | 1 +
.../lakehouse/catalogs/paimon-catalog.mdx | 3 +-
.../lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../lakehouse/catalogs/iceberg-catalog.mdx | 61 ++++++++++++++++++++-
.../lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-mysql-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-oracle-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-pg-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-sqlserver-catalog.md | 2 +-
.../lakehouse/catalogs/paimon-catalog.mdx | 2 +-
.../lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../lakehouse/catalogs/iceberg-catalog.mdx | 61 ++++++++++++++++++++-
.../lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-mysql-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-oracle-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-pg-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-sqlserver-catalog.md | 2 +-
.../lakehouse/catalogs/paimon-catalog.mdx | 2 +-
.../version-4.x/lakehouse/huggingface.md | 2 +-
.../sql-functions/table-valued-functions/http.md | 2 +-
.../lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../lakehouse/catalogs/iceberg-catalog.mdx | 63 ++++++++++++++++++++--
.../lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 1 +
.../lakehouse/catalogs/jdbc-mysql-catalog.md | 5 +-
.../lakehouse/catalogs/jdbc-oracle-catalog.md | 3 +-
.../lakehouse/catalogs/jdbc-pg-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-sqlserver-catalog.md | 3 +-
.../lakehouse/catalogs/paimon-catalog.mdx | 3 +-
.../lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../lakehouse/catalogs/iceberg-catalog.mdx | 61 ++++++++++++++++++++-
.../lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-mysql-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-oracle-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-pg-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-sqlserver-catalog.md | 2 +-
.../lakehouse/catalogs/paimon-catalog.mdx | 2 +-
.../lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../lakehouse/catalogs/iceberg-catalog.mdx | 61 ++++++++++++++++++++-
.../lakehouse/catalogs/jdbc-ibmdb2-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-mysql-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-oracle-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-pg-catalog.md | 2 +-
.../lakehouse/catalogs/jdbc-sqlserver-catalog.md | 2 +-
.../lakehouse/catalogs/paimon-catalog.mdx | 2 +-
.../version-4.x/lakehouse/huggingface.md | 2 +-
.../sql-functions/table-valued-functions/http.md | 2 +-
72 files changed, 540 insertions(+), 82 deletions(-)
diff --git a/docs/lakehouse/catalogs/hive-catalog.mdx
b/docs/lakehouse/catalogs/hive-catalog.mdx
index e992c4ac81f..d0b47ab36e7 100644
--- a/docs/lakehouse/catalogs/hive-catalog.mdx
+++ b/docs/lakehouse/catalogs/hive-catalog.mdx
@@ -141,7 +141,7 @@ Hive transactional tables are supported from version 3.x
onwards. For details, r
| char(N) | char(N) |
|
| varchar(N) | varchar(N) |
|
| string | string |
|
-| binary | string/varbinary | Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| binary | string/varbinary | Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| array | array |
|
| map | map |
|
| struct | struct |
|
diff --git a/docs/lakehouse/catalogs/iceberg-catalog.mdx
b/docs/lakehouse/catalogs/iceberg-catalog.mdx
index 0057fd7d7ac..90d413b0a91 100644
--- a/docs/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/docs/lakehouse/catalogs/iceberg-catalog.mdx
@@ -136,8 +136,8 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
| timestamptz (Timestamp with timezone) | datetime(6) | Mapped to
datetime with precision 6 |
| fixed(N) | char(N) |
|
| string | string |
|
-| binary | string/varbinary | Controlled
by the `enable.mapping.varbinary` property of Catalog (supported since 4.0.3).
The default is `false`, which maps to `string`; when `true`, it maps to
`varbinary` type.|
-| uuid | string/varbinary | Before
4.0.3, it was mapped to `string`; after that, it is mapped to `varbinary` type.|
+| binary | string/varbinary | Controlled
by the `enable.mapping.varbinary` property of Catalog (supported since 4.0.2).
The default is `false`, which maps to `string`; when `true`, it maps to
`varbinary` type.|
+| uuid | string/varbinary | Before
4.0.2, it was mapped to `string`; after that, it is mapped to `varbinary` type.|
| struct | struct (supported from version
2.1.3) | |
| map | map (supported from version 2.1.3)
| |
| list | array |
|
@@ -1797,6 +1797,63 @@ Supported schema change operations include:
ALTER TABLE iceberg_table ORDER BY (col_name1, col_name2, ...);
```
+### Partition Evolution
+
+Starting from version 4.0.2, Doris supports Partition Evolution for Iceberg
tables through `ALTER` statements.
+
+Supported partition transforms include:
+
+| Transform | Syntax | Example |
+|-----------|--------|---------|
+| bucket | `bucket(N, column)` | `bucket(16, id)` |
+| truncate | `truncate(N, column)` | `truncate(10, name)` |
+| year | `year(column)` | `year(ts)` |
+| month | `month(column)` | `month(ts)` |
+| day | `day(column)` | `day(ts)` |
+| hour | `hour(column)` | `hour(ts)` |
+| identity | `column` | `category` |
+
+Supported operations include:
+
+- **Add partition key**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name ADD PARTITION KEY partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY year(ts);
+ -- use optional AS keyword to specify a custom name for the partition
field
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id) AS shard;
+ ```
+
+- **Drop partition key**
+
+ ```sql
+ ALTER TABLE table_name DROP PARTITION KEY partition_transform｜key_name;
+
+ -- example
+ ALTER TABLE prod.db.sample DROP PARTITION KEY catalog;
+ ALTER TABLE prod.db.sample DROP PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY year(ts);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY shard;
+ ```
+
+- **Replace partition key**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name REPLACE PARTITION KEY key_name WITH
partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts);
+ -- use optional AS keyword to specify a custom name for the new partition
field
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts) AS
day_of_ts;
+ ```
+
### Managing Branch & Tag
> Since 3.1.0
diff --git a/docs/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/docs/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index e5a6f9f3ef2..5b3138b20b2 100644
--- a/docs/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++ b/docs/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -67,7 +67,7 @@ When mapping IBM Db2, Doris's Database corresponds to a
Schema under the specifi
| time | string | |
| clob | string | |
| xml | string | |
-| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED | |
## Common Issues
diff --git a/docs/lakehouse/catalogs/jdbc-mysql-catalog.md
b/docs/lakehouse/catalogs/jdbc-mysql-catalog.md
index 2159f62efe9..8ef7e6f278b 100644
--- a/docs/lakehouse/catalogs/jdbc-mysql-catalog.md
+++ b/docs/lakehouse/catalogs/jdbc-mysql-catalog.md
@@ -88,7 +88,7 @@ When mapping MySQL, a Database in Doris corresponds to a
Database in MySQL. A Ta
| enum | string |
|
| bit | boolean / string | Doris
does not support the bit type, so the bit type is mapped to boolean when
bit(1), and to string in other cases. |
| tinytext, text, mediumtext, longtext | string |
|
-| blob, mediumblob, longblob, tinyblob, binary, varbinary | string/varbinary
| Controlled by the `enable.mapping.varbinary` property of
Catalog (supported since 4.0.3). The default is `false`, which maps to
`string`; when `true`, it maps to `varbinary` type.
|
+| blob, mediumblob, longblob, tinyblob, binary, varbinary | string/varbinary
| Controlled by the `enable.mapping.varbinary` property of
Catalog (supported since 4.0.2). The default is `false`, which maps to
`string`; when `true`, it maps to `varbinary` type.
|
| other | UNSUPPORTED |
|
## Appendix
diff --git a/docs/lakehouse/catalogs/jdbc-oracle-catalog.md
b/docs/lakehouse/catalogs/jdbc-oracle-catalog.md
index 83dd37f6f03..7da3a3c945b 100644
--- a/docs/lakehouse/catalogs/jdbc-oracle-catalog.md
+++ b/docs/lakehouse/catalogs/jdbc-oracle-catalog.md
@@ -60,7 +60,7 @@ When mapping Oracle, a Database in Apache Doris corresponds
to a User in Oracle.
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
-| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED
|
|
## Common Issues
diff --git a/docs/lakehouse/catalogs/jdbc-pg-catalog.md
b/docs/lakehouse/catalogs/jdbc-pg-catalog.md
index 48e740f29ce..ea563b65f34 100644
--- a/docs/lakehouse/catalogs/jdbc-pg-catalog.md
+++ b/docs/lakehouse/catalogs/jdbc-pg-catalog.md
@@ -81,7 +81,7 @@ When mapping PostgreSQL, a Database in Doris corresponds to a
Schema under a spe
| cidr/inet/macaddr | string |
|
| uuid | string |
|
| bit | boolean / string | Doris
does not support bit type, bit type will be mapped to boolean when bit(1),
otherwise mapped to string. |
-| bytea | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| bytea | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| array | array | Please
refer to the following explanation regarding the mapping methods for array
types. |
| other | UNSUPPORTED |
|
diff --git a/docs/lakehouse/catalogs/jdbc-sqlserver-catalog.md
b/docs/lakehouse/catalogs/jdbc-sqlserver-catalog.md
index b0aa9f41ccd..6279050ef9a 100644
--- a/docs/lakehouse/catalogs/jdbc-sqlserver-catalog.md
+++ b/docs/lakehouse/catalogs/jdbc-sqlserver-catalog.md
@@ -75,7 +75,7 @@ When mapping SQLServer, a Database in Doris corresponds to a
Schema under the sp
| char/varchar/text/nchar/nvarchar/ntext | string |
|
| time/datetimeoffset | string |
|
| timestamp | string | Displays
hexadecimal representation of binary data, no actual meaning |
-| image/binary/varbinary | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| image/binary/varbinary | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED |
|
## Common Issues
diff --git a/docs/lakehouse/catalogs/paimon-catalog.mdx
b/docs/lakehouse/catalogs/paimon-catalog.mdx
index 32512884428..7f3dc2088e0 100644
--- a/docs/lakehouse/catalogs/paimon-catalog.mdx
+++ b/docs/lakehouse/catalogs/paimon-catalog.mdx
@@ -143,7 +143,7 @@ The currently dependent Paimon version is 1.0.0.
| decimal(P, S) | decimal(P, S) |
|
| varchar | string |
|
| char | string |
|
-| binary, varbinary | string/varbinary |
Controlled by the `enable.mapping.varbinary` property of Catalog (supported
since 4.0.3). The default is `false`, which maps to `string`; when `true`, it
maps to `varbinary` type.|
+| binary, varbinary | string/varbinary |
Controlled by the `enable.mapping.varbinary` property of Catalog (supported
since 4.0.2). The default is `false`, which maps to `string`; when `true`, it
maps to `varbinary` type.|
| date | date |
|
| timestamp\_without\_time\_zone | datetime(N) | Mapped according to
precision. If precision is greater than 6, it maps to a maximum of 6 (may cause
precision loss). |
| timestamp\_with\_local\_time\_zone | datetime(N) | Mapped according to
precision. If precision is greater than 6, it maps to a maximum of 6 (may cause
precision loss). |
diff --git a/docs/lakehouse/huggingface.md b/docs/lakehouse/huggingface.md
index c6a7535e893..9f6ceedf908 100644
--- a/docs/lakehouse/huggingface.md
+++ b/docs/lakehouse/huggingface.md
@@ -12,7 +12,7 @@
Through the [HTTP Table Value
Function](../sql-manual/sql-functions/table-valued-functions/http.md) feature,
Doris can directly access data on Hugging Face datasets via SQL.
:::note
-This feature is supported since version 4.0.3
+This feature is supported since version 4.0.2
:::
## Usage Instructions
diff --git a/docs/sql-manual/sql-functions/table-valued-functions/http.md
b/docs/sql-manual/sql-functions/table-valued-functions/http.md
index c5c4ebc62fe..fd68c7eeda3 100644
--- a/docs/sql-manual/sql-functions/table-valued-functions/http.md
+++ b/docs/sql-manual/sql-functions/table-valued-functions/http.md
@@ -8,7 +8,7 @@
HTTP table-valued-function (tvf) allows users to read and access file content
on HTTP paths as if accessing relational table format data. Currently supports
`csv/csv_with_names/csv_with_names_and_types/json/parquet/orc` file formats.
:::note
-Supported since 4.0.3
+Supported since 4.0.2
:::
## Syntax
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/hive-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/hive-catalog.mdx
index ffe014960fb..d9e1b228eb6 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/hive-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/hive-catalog.mdx
@@ -152,7 +152,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| char(N) | char(N) | |
| varchar(N) | varchar(N) | |
| string | string | |
-| binary | string/varbianry| 由 properties 中 `enable.mapping.varbianry`
(4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| binary | string/varbianry| 由 properties 中 `enable.mapping.varbianry`
(4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| array | array | |
| map | map | |
| struct | struct | |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/iceberg-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/iceberg-catalog.mdx
index c5b4933f76f..c09d88839b3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/iceberg-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/iceberg-catalog.mdx
@@ -151,8 +151,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| timestamptz (Timestamp with timezone) | datetime(6) | 固定映射到精度为 6 的
datetime |
| fixed(N) | char(N) |
|
| string | string |
|
-| binary | string/varbinary |由 properties
中 `enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。 |
-| uuid | string/varbinary |4.0.3 之前映射成
`string`，之后则映射成 `varbianry` 类型。 |
+| binary | string/varbinary |由 properties
中 `enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。 |
+| uuid | string/varbinary |4.0.2 之前映射成
`string`，之后则映射成 `varbianry` 类型。 |
| struct | struct（2.1.3 版本开始支持） |
|
| map | map（2.1.3 版本开始支持） |
|
| list | array |
|
@@ -1808,6 +1808,63 @@ DROP DATABASE [IF EXISTS] iceberg.iceberg_db;
ALTER TABLE iceberg_table ORDER BY (col_name1, col_name2, ...);
```
+### Partition Evolution
+
+自 4.0.2 版本开始，Doris 支持通过 `ALTER` 语句对 Iceberg 表进行 Partition Evolution。
+
+支持的分区变换包括
+
+| 变换 | 语法 | 示例 |
+|-----------|--------|---------|
+| bucket | `bucket(N, column)` | `bucket(16, id)` |
+| truncate | `truncate(N, column)` | `truncate(10, name)` |
+| year | `year(column)` | `year(ts)` |
+| month | `month(column)` | `month(ts)` |
+| day | `day(column)` | `day(ts)` |
+| hour | `hour(column)` | `hour(ts)` |
+| identity | `column` | `category` |
+
+支持的操作包括：
+
+- **增加分区键**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name ADD PARTITION KEY partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY year(ts);
+ -- use optional AS keyword to specify a custom name for the partition
field
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id) AS shard;
+ ```
+
+- **删除分区键**
+
+ ```sql
+ ALTER TABLE table_name DROP PARTITION KEY partition_transform｜key_name;
+
+ -- example
+ ALTER TABLE prod.db.sample DROP PARTITION KEY catalog;
+ ALTER TABLE prod.db.sample DROP PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY year(ts);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY shard;
+ ```
+
+- **替换分区键**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name REPLACE PARTITION KEY key_name WITH
partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts);
+ -- use optional AS keyword to specify a custom name for the new partition
field
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts) AS
day_of_ts;
+ ```
+
### 管理 Branch & Tag
> 该功能自 3.1.0 版本支持
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index 21b2ddaf8ca..4b1b9f4094b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -67,7 +67,7 @@ CREATE CATALOG db2_catalog PROPERTIES (
| time | string | |
| clob | string | |
| xml | string | |
-| BLOB | varbinary |由 properties 中 `enable.mapping.varbianry`
(4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| BLOB | varbinary |由 properties 中 `enable.mapping.varbianry`
(4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED | |
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-mysql-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-mysql-catalog.md
index 63b69e4f941..05d893ab50d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-mysql-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-mysql-catalog.md
@@ -88,7 +88,7 @@ CREATE CATALOG mysql_catalog PROPERTIES (
| enum | string |
|
| bit | boolean / string | Doris
不支持 bit 类型，bit 类型会在 bit(1) 时被映射为 boolean，其他情况下映射为 string。 |
| tinytext, text, mediumtext, longtext | string |
|
-| blob, mediumblob, longblob, tinyblob, binary, varbinary | string /varbinary
| 由 properties 中 `enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`,
则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| blob, mediumblob, longblob, tinyblob, binary, varbinary | string /varbinary
| 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`,
则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED |
|
## 附录
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-oracle-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-oracle-catalog.md
index 98bf0f81b20..14fb01a41dd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-oracle-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-oracle-catalog.md
@@ -60,7 +60,7 @@ CREATE CATALOG oracle_catalog PROPERTIES (
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
-| BLOB | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.3 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| BLOB | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED
|
|
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-pg-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-pg-catalog.md
index b2f14cd3044..bd7885b523d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-pg-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-pg-catalog.md
@@ -81,7 +81,7 @@ CREATE CATALOG postgresql_catalog PROPERTIES (
| cidr/inet/macaddr | string |
|
| uuid | string |
|
| bit | boolean / string | Doris 不支持
bit 类型，bit 类型会在 bit(1) 时被映射为 boolean，其他情况下映射为 string。 |
-| bytea | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.3 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| bytea | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| array | array |
关于数组类型的映射方式，请参与下面的说明。 |
| other | UNSUPPORTED |
|
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-sqlserver-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-sqlserver-catalog.md
index 45ce1262cca..04797a43c24 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-sqlserver-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/jdbc-sqlserver-catalog.md
@@ -75,7 +75,7 @@ JDBC 驱动程序以及连接器自动使用传输层安全性 (TLS) 加密和
| char/varchar/text/nchar/nvarchar/ntext | string |
|
| time/datetimeoffset | string |
|
| timestamp | string |
读取二进制数据的十六进制显示，无实际意义 |
-| image/binary/varbinary | varbinary | 由 properties 中
`enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
+| image/binary/varbinary | varbinary | 由 properties 中
`enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED |
|
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/paimon-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/paimon-catalog.mdx
index b5057d4f57b..1c837ce2b9f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/paimon-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/catalogs/paimon-catalog.mdx
@@ -143,7 +143,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| decimal(P, S) | decimal(P, S) |
|
| varchar | string |
|
| char | string |
|
-| bianry, varbinary | string/varbinary|由 properties 中
`enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
+| bianry, varbinary | string/varbinary|由 properties 中
`enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
| date | date |
|
| timestamp\_without\_time\_zone | datetime(N) | 会根据精度进行对应映射。如果精度大于
6，则最大映射到 6。（可能导致精度丢失） |
| timestamp\_with\_local\_time\_zone | datetime(N) | 会根据精度进行对应映射。如果精度大于
6，则最大映射到 6。（可能导致精度丢失） |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/huggingface.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/huggingface.md
index c935e50028b..5c30f1e8490 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/huggingface.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/huggingface.md
@@ -12,7 +12,7 @@
通过 [HTTP Table Value
Function](../sql-manual/sql-functions/table-valued-functions/http.md) 功能，Doris
可以直接通过 SQL 访问 Hugging Face 数据集上的数据。
:::note
-该功能自 4.0.3 版本支持
+该功能自 4.0.2 版本支持
:::
## 使用说明
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/http.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/http.md
index 997e7aaacc9..2764c57ea28 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/http.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/http.md
@@ -8,7 +8,7 @@
HTTP 表函数（table-valued-function,tvf），可以让用户像访问关系表格式数据一样，读取并访问 HTTP 路径上的文件内容。目前支持
`csv/csv_with_names/csv_with_names_and_types/json/parquet/orc` 文件格式。
:::note
-该函数自 4.0.3 版本支持。
+该函数自 4.0.2 版本支持。
:::
## 语法
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/hive-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/hive-catalog.mdx
index 9aedf3baaf5..d9e1b228eb6 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/hive-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/hive-catalog.mdx
@@ -152,7 +152,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| char(N) | char(N) | |
| varchar(N) | varchar(N) | |
| string | string | |
-| binary | string | |
+| binary | string/varbianry| 由 properties 中 `enable.mapping.varbianry`
(4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| array | array | |
| map | map | |
| struct | struct | |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/iceberg-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/iceberg-catalog.mdx
index 25d70c02491..c09d88839b3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/iceberg-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/iceberg-catalog.mdx
@@ -151,8 +151,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| timestamptz (Timestamp with timezone) | datetime(6) | 固定映射到精度为 6 的
datetime |
| fixed(N) | char(N) |
|
| string | string |
|
-| binary | string |
|
-| uuid | string |
|
+| binary | string/varbinary |由 properties
中 `enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。 |
+| uuid | string/varbinary |4.0.2 之前映射成
`string`，之后则映射成 `varbianry` 类型。 |
| struct | struct（2.1.3 版本开始支持） |
|
| map | map（2.1.3 版本开始支持） |
|
| list | array |
|
@@ -1808,6 +1808,63 @@ DROP DATABASE [IF EXISTS] iceberg.iceberg_db;
ALTER TABLE iceberg_table ORDER BY (col_name1, col_name2, ...);
```
+### Partition Evolution
+
+自 4.0.2 版本开始，Doris 支持通过 `ALTER` 语句对 Iceberg 表进行 Partition Evolution。
+
+支持的分区变换包括
+
+| 变换 | 语法 | 示例 |
+|-----------|--------|---------|
+| bucket | `bucket(N, column)` | `bucket(16, id)` |
+| truncate | `truncate(N, column)` | `truncate(10, name)` |
+| year | `year(column)` | `year(ts)` |
+| month | `month(column)` | `month(ts)` |
+| day | `day(column)` | `day(ts)` |
+| hour | `hour(column)` | `hour(ts)` |
+| identity | `column` | `category` |
+
+支持的操作包括：
+
+- **增加分区键**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name ADD PARTITION KEY partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY year(ts);
+ -- use optional AS keyword to specify a custom name for the partition
field
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id) AS shard;
+ ```
+
+- **删除分区键**
+
+ ```sql
+ ALTER TABLE table_name DROP PARTITION KEY partition_transform｜key_name;
+
+ -- example
+ ALTER TABLE prod.db.sample DROP PARTITION KEY catalog;
+ ALTER TABLE prod.db.sample DROP PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY year(ts);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY shard;
+ ```
+
+- **替换分区键**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name REPLACE PARTITION KEY key_name WITH
partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts);
+ -- use optional AS keyword to specify a custom name for the new partition
field
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts) AS
day_of_ts;
+ ```
+
### 管理 Branch & Tag
> 该功能自 3.1.0 版本支持
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index a15469f1bb7..4b1b9f4094b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -67,6 +67,7 @@ CREATE CATALOG db2_catalog PROPERTIES (
| time | string | |
| clob | string | |
| xml | string | |
+| BLOB | varbinary |由 properties 中 `enable.mapping.varbianry`
(4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED | |
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-mysql-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-mysql-catalog.md
index 709c9b01611..05d893ab50d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-mysql-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-mysql-catalog.md
@@ -88,8 +88,7 @@ CREATE CATALOG mysql_catalog PROPERTIES (
| enum | string |
|
| bit | boolean / string | Doris
不支持 bit 类型，bit 类型会在 bit(1) 时被映射为 boolean，其他情况下映射为 string。 |
| tinytext, text, mediumtext, longtext | string |
|
-| blob, mediumblob, longblob, tinyblob | string |
|
-| binary, varbinary | string |
|
+| blob, mediumblob, longblob, tinyblob, binary, varbinary | string /varbinary
| 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`,
则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED |
|
## 附录
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-oracle-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-oracle-catalog.md
index 5d81bbbb217..14fb01a41dd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-oracle-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-oracle-catalog.md
@@ -60,6 +60,7 @@ CREATE CATALOG oracle_catalog PROPERTIES (
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
+| BLOB | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED
|
|
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-pg-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-pg-catalog.md
index b2f14cd3044..bd7885b523d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-pg-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-pg-catalog.md
@@ -81,7 +81,7 @@ CREATE CATALOG postgresql_catalog PROPERTIES (
| cidr/inet/macaddr | string |
|
| uuid | string |
|
| bit | boolean / string | Doris 不支持
bit 类型，bit 类型会在 bit(1) 时被映射为 boolean，其他情况下映射为 string。 |
-| bytea | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.3 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| bytea | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| array | array |
关于数组类型的映射方式，请参与下面的说明。 |
| other | UNSUPPORTED |
|
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-sqlserver-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-sqlserver-catalog.md
index abc01ef244c..04797a43c24 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-sqlserver-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/jdbc-sqlserver-catalog.md
@@ -75,6 +75,7 @@ JDBC 驱动程序以及连接器自动使用传输层安全性 (TLS) 加密和
| char/varchar/text/nchar/nvarchar/ntext | string |
|
| time/datetimeoffset | string |
|
| timestamp | string |
读取二进制数据的十六进制显示，无实际意义 |
+| image/binary/varbinary | varbinary | 由 properties 中
`enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED |
|
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/paimon-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/paimon-catalog.mdx
index aa449910204..1c837ce2b9f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/paimon-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/catalogs/paimon-catalog.mdx
@@ -143,8 +143,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| decimal(P, S) | decimal(P, S) |
|
| varchar | string |
|
| char | string |
|
-| bianry | string |
|
-| varbinary | string |
|
+| bianry, varbinary | string/varbinary|由 properties 中
`enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
| date | date |
|
| timestamp\_without\_time\_zone | datetime(N) | 会根据精度进行对应映射。如果精度大于
6，则最大映射到 6。（可能导致精度丢失） |
| timestamp\_with\_local\_time\_zone | datetime(N) | 会根据精度进行对应映射。如果精度大于
6，则最大映射到 6。（可能导致精度丢失） |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/hive-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/hive-catalog.mdx
index ffe014960fb..d9e1b228eb6 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/hive-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/hive-catalog.mdx
@@ -152,7 +152,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| char(N) | char(N) | |
| varchar(N) | varchar(N) | |
| string | string | |
-| binary | string/varbianry| 由 properties 中 `enable.mapping.varbianry`
(4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| binary | string/varbianry| 由 properties 中 `enable.mapping.varbianry`
(4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| array | array | |
| map | map | |
| struct | struct | |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/iceberg-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/iceberg-catalog.mdx
index c5b4933f76f..c09d88839b3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/iceberg-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/iceberg-catalog.mdx
@@ -151,8 +151,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| timestamptz (Timestamp with timezone) | datetime(6) | 固定映射到精度为 6 的
datetime |
| fixed(N) | char(N) |
|
| string | string |
|
-| binary | string/varbinary |由 properties
中 `enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。 |
-| uuid | string/varbinary |4.0.3 之前映射成
`string`，之后则映射成 `varbianry` 类型。 |
+| binary | string/varbinary |由 properties
中 `enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。 |
+| uuid | string/varbinary |4.0.2 之前映射成
`string`，之后则映射成 `varbianry` 类型。 |
| struct | struct（2.1.3 版本开始支持） |
|
| map | map（2.1.3 版本开始支持） |
|
| list | array |
|
@@ -1808,6 +1808,63 @@ DROP DATABASE [IF EXISTS] iceberg.iceberg_db;
ALTER TABLE iceberg_table ORDER BY (col_name1, col_name2, ...);
```
+### Partition Evolution
+
+自 4.0.2 版本开始，Doris 支持通过 `ALTER` 语句对 Iceberg 表进行 Partition Evolution。
+
+支持的分区变换包括
+
+| 变换 | 语法 | 示例 |
+|-----------|--------|---------|
+| bucket | `bucket(N, column)` | `bucket(16, id)` |
+| truncate | `truncate(N, column)` | `truncate(10, name)` |
+| year | `year(column)` | `year(ts)` |
+| month | `month(column)` | `month(ts)` |
+| day | `day(column)` | `day(ts)` |
+| hour | `hour(column)` | `hour(ts)` |
+| identity | `column` | `category` |
+
+支持的操作包括：
+
+- **增加分区键**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name ADD PARTITION KEY partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY year(ts);
+ -- use optional AS keyword to specify a custom name for the partition
field
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id) AS shard;
+ ```
+
+- **删除分区键**
+
+ ```sql
+ ALTER TABLE table_name DROP PARTITION KEY partition_transform｜key_name;
+
+ -- example
+ ALTER TABLE prod.db.sample DROP PARTITION KEY catalog;
+ ALTER TABLE prod.db.sample DROP PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY year(ts);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY shard;
+ ```
+
+- **替换分区键**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name REPLACE PARTITION KEY key_name WITH
partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts);
+ -- use optional AS keyword to specify a custom name for the new partition
field
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts) AS
day_of_ts;
+ ```
+
### 管理 Branch & Tag
> 该功能自 3.1.0 版本支持
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index 21b2ddaf8ca..4b1b9f4094b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -67,7 +67,7 @@ CREATE CATALOG db2_catalog PROPERTIES (
| time | string | |
| clob | string | |
| xml | string | |
-| BLOB | varbinary |由 properties 中 `enable.mapping.varbianry`
(4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| BLOB | varbinary |由 properties 中 `enable.mapping.varbianry`
(4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED | |
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-mysql-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-mysql-catalog.md
index 63b69e4f941..05d893ab50d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-mysql-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-mysql-catalog.md
@@ -88,7 +88,7 @@ CREATE CATALOG mysql_catalog PROPERTIES (
| enum | string |
|
| bit | boolean / string | Doris
不支持 bit 类型，bit 类型会在 bit(1) 时被映射为 boolean，其他情况下映射为 string。 |
| tinytext, text, mediumtext, longtext | string |
|
-| blob, mediumblob, longblob, tinyblob, binary, varbinary | string /varbinary
| 由 properties 中 `enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`,
则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| blob, mediumblob, longblob, tinyblob, binary, varbinary | string /varbinary
| 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`,
则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED |
|
## 附录
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-oracle-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-oracle-catalog.md
index 98bf0f81b20..14fb01a41dd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-oracle-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-oracle-catalog.md
@@ -60,7 +60,7 @@ CREATE CATALOG oracle_catalog PROPERTIES (
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
-| BLOB | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.3 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| BLOB | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED
|
|
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-pg-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-pg-catalog.md
index b2f14cd3044..bd7885b523d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-pg-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-pg-catalog.md
@@ -81,7 +81,7 @@ CREATE CATALOG postgresql_catalog PROPERTIES (
| cidr/inet/macaddr | string |
|
| uuid | string |
|
| bit | boolean / string | Doris 不支持
bit 类型，bit 类型会在 bit(1) 时被映射为 boolean，其他情况下映射为 string。 |
-| bytea | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.3 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| bytea | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| array | array |
关于数组类型的映射方式，请参与下面的说明。 |
| other | UNSUPPORTED |
|
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
index 45ce1262cca..04797a43c24 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
@@ -75,7 +75,7 @@ JDBC 驱动程序以及连接器自动使用传输层安全性 (TLS) 加密和
| char/varchar/text/nchar/nvarchar/ntext | string |
|
| time/datetimeoffset | string |
|
| timestamp | string |
读取二进制数据的十六进制显示，无实际意义 |
-| image/binary/varbinary | varbinary | 由 properties 中
`enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
+| image/binary/varbinary | varbinary | 由 properties 中
`enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED |
|
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/paimon-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/paimon-catalog.mdx
index b5057d4f57b..1c837ce2b9f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/paimon-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/catalogs/paimon-catalog.mdx
@@ -143,7 +143,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| decimal(P, S) | decimal(P, S) |
|
| varchar | string |
|
| char | string |
|
-| bianry, varbinary | string/varbinary|由 properties 中
`enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
+| bianry, varbinary | string/varbinary|由 properties 中
`enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
| date | date |
|
| timestamp\_without\_time\_zone | datetime(N) | 会根据精度进行对应映射。如果精度大于
6，则最大映射到 6。（可能导致精度丢失） |
| timestamp\_with\_local\_time\_zone | datetime(N) | 会根据精度进行对应映射。如果精度大于
6，则最大映射到 6。（可能导致精度丢失） |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/hive-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/hive-catalog.mdx
index ffe014960fb..d9e1b228eb6 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/hive-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/hive-catalog.mdx
@@ -152,7 +152,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| char(N) | char(N) | |
| varchar(N) | varchar(N) | |
| string | string | |
-| binary | string/varbianry| 由 properties 中 `enable.mapping.varbianry`
(4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| binary | string/varbianry| 由 properties 中 `enable.mapping.varbianry`
(4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| array | array | |
| map | map | |
| struct | struct | |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
index c5b4933f76f..c09d88839b3 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
@@ -151,8 +151,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| timestamptz (Timestamp with timezone) | datetime(6) | 固定映射到精度为 6 的
datetime |
| fixed(N) | char(N) |
|
| string | string |
|
-| binary | string/varbinary |由 properties
中 `enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。 |
-| uuid | string/varbinary |4.0.3 之前映射成
`string`，之后则映射成 `varbianry` 类型。 |
+| binary | string/varbinary |由 properties
中 `enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。 |
+| uuid | string/varbinary |4.0.2 之前映射成
`string`，之后则映射成 `varbianry` 类型。 |
| struct | struct（2.1.3 版本开始支持） |
|
| map | map（2.1.3 版本开始支持） |
|
| list | array |
|
@@ -1808,6 +1808,63 @@ DROP DATABASE [IF EXISTS] iceberg.iceberg_db;
ALTER TABLE iceberg_table ORDER BY (col_name1, col_name2, ...);
```
+### Partition Evolution
+
+自 4.0.2 版本开始，Doris 支持通过 `ALTER` 语句对 Iceberg 表进行 Partition Evolution。
+
+支持的分区变换包括
+
+| 变换 | 语法 | 示例 |
+|-----------|--------|---------|
+| bucket | `bucket(N, column)` | `bucket(16, id)` |
+| truncate | `truncate(N, column)` | `truncate(10, name)` |
+| year | `year(column)` | `year(ts)` |
+| month | `month(column)` | `month(ts)` |
+| day | `day(column)` | `day(ts)` |
+| hour | `hour(column)` | `hour(ts)` |
+| identity | `column` | `category` |
+
+支持的操作包括：
+
+- **增加分区键**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name ADD PARTITION KEY partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY year(ts);
+ -- use optional AS keyword to specify a custom name for the partition
field
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id) AS shard;
+ ```
+
+- **删除分区键**
+
+ ```sql
+ ALTER TABLE table_name DROP PARTITION KEY partition_transform｜key_name;
+
+ -- example
+ ALTER TABLE prod.db.sample DROP PARTITION KEY catalog;
+ ALTER TABLE prod.db.sample DROP PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY year(ts);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY shard;
+ ```
+
+- **替换分区键**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name REPLACE PARTITION KEY key_name WITH
partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts);
+ -- use optional AS keyword to specify a custom name for the new partition
field
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts) AS
day_of_ts;
+ ```
+
### 管理 Branch & Tag
> 该功能自 3.1.0 版本支持
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index 21b2ddaf8ca..4b1b9f4094b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -67,7 +67,7 @@ CREATE CATALOG db2_catalog PROPERTIES (
| time | string | |
| clob | string | |
| xml | string | |
-| BLOB | varbinary |由 properties 中 `enable.mapping.varbianry`
(4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| BLOB | varbinary |由 properties 中 `enable.mapping.varbianry`
(4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED | |
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-mysql-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-mysql-catalog.md
index 63b69e4f941..05d893ab50d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-mysql-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-mysql-catalog.md
@@ -88,7 +88,7 @@ CREATE CATALOG mysql_catalog PROPERTIES (
| enum | string |
|
| bit | boolean / string | Doris
不支持 bit 类型，bit 类型会在 bit(1) 时被映射为 boolean，其他情况下映射为 string。 |
| tinytext, text, mediumtext, longtext | string |
|
-| blob, mediumblob, longblob, tinyblob, binary, varbinary | string /varbinary
| 由 properties 中 `enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`,
则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| blob, mediumblob, longblob, tinyblob, binary, varbinary | string /varbinary
| 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`,
则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED |
|
## 附录
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-oracle-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-oracle-catalog.md
index 98bf0f81b20..14fb01a41dd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-oracle-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-oracle-catalog.md
@@ -60,7 +60,7 @@ CREATE CATALOG oracle_catalog PROPERTIES (
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
-| BLOB | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.3 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| BLOB | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED
|
|
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-pg-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-pg-catalog.md
index b2f14cd3044..bd7885b523d 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-pg-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-pg-catalog.md
@@ -81,7 +81,7 @@ CREATE CATALOG postgresql_catalog PROPERTIES (
| cidr/inet/macaddr | string |
|
| uuid | string |
|
| bit | boolean / string | Doris 不支持
bit 类型，bit 类型会在 bit(1) 时被映射为 boolean，其他情况下映射为 string。 |
-| bytea | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.3 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| bytea | varbinary | 由 properties 中 `enable.mapping.varbianry` (4.0.2 后开始支持)
属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
| array | array |
关于数组类型的映射方式，请参与下面的说明。 |
| other | UNSUPPORTED |
|
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
index 45ce1262cca..04797a43c24 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
@@ -75,7 +75,7 @@ JDBC 驱动程序以及连接器自动使用传输层安全性 (TLS) 加密和
| char/varchar/text/nchar/nvarchar/ntext | string |
|
| time/datetimeoffset | string |
|
| timestamp | string |
读取二进制数据的十六进制显示，无实际意义 |
-| image/binary/varbinary | varbinary | 由 properties 中
`enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
+| image/binary/varbinary | varbinary | 由 properties 中
`enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
| other | UNSUPPORTED |
|
## 常见问题
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/paimon-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/paimon-catalog.mdx
index b5057d4f57b..1c837ce2b9f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/paimon-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/catalogs/paimon-catalog.mdx
@@ -143,7 +143,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| decimal(P, S) | decimal(P, S) |
|
| varchar | string |
|
| char | string |
|
-| bianry, varbinary | string/varbinary|由 properties 中
`enable.mapping.varbianry` (4.0.3 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
+| bianry, varbinary | string/varbinary|由 properties 中
`enable.mapping.varbianry` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。|
| date | date |
|
| timestamp\_without\_time\_zone | datetime(N) | 会根据精度进行对应映射。如果精度大于
6，则最大映射到 6。（可能导致精度丢失） |
| timestamp\_with\_local\_time\_zone | datetime(N) | 会根据精度进行对应映射。如果精度大于
6，则最大映射到 6。（可能导致精度丢失） |
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/huggingface.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/huggingface.md
index c935e50028b..5c30f1e8490 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/huggingface.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/huggingface.md
@@ -12,7 +12,7 @@
通过 [HTTP Table Value
Function](../sql-manual/sql-functions/table-valued-functions/http.md) 功能，Doris
可以直接通过 SQL 访问 Hugging Face 数据集上的数据。
:::note
-该功能自 4.0.3 版本支持
+该功能自 4.0.2 版本支持
:::
## 使用说明
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/http.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/http.md
index 997e7aaacc9..2764c57ea28 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/http.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/http.md
@@ -8,7 +8,7 @@
HTTP 表函数（table-valued-function,tvf），可以让用户像访问关系表格式数据一样，读取并访问 HTTP 路径上的文件内容。目前支持
`csv/csv_with_names/csv_with_names_and_types/json/parquet/orc` 文件格式。
:::note
-该函数自 4.0.3 版本支持。
+该函数自 4.0.2 版本支持。
:::
## 语法
diff --git a/versioned_docs/version-2.1/lakehouse/catalogs/hive-catalog.mdx
b/versioned_docs/version-2.1/lakehouse/catalogs/hive-catalog.mdx
index 7c7603c36f9..d0b47ab36e7 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/hive-catalog.mdx
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/hive-catalog.mdx
@@ -141,7 +141,7 @@ Hive transactional tables are supported from version 3.x
onwards. For details, r
| char(N) | char(N) |
|
| varchar(N) | varchar(N) |
|
| string | string |
|
-| binary | string |
|
+| binary | string/varbinary | Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| array | array |
|
| map | map |
|
| struct | struct |
|
diff --git a/versioned_docs/version-2.1/lakehouse/catalogs/iceberg-catalog.mdx
b/versioned_docs/version-2.1/lakehouse/catalogs/iceberg-catalog.mdx
index 614d1394694..90d413b0a91 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/iceberg-catalog.mdx
@@ -136,8 +136,8 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
| timestamptz (Timestamp with timezone) | datetime(6) | Mapped to
datetime with precision 6 |
| fixed(N) | char(N) |
|
| string | string |
|
-| binary | string |
|
-| uuid | string |
|
+| binary | string/varbinary | Controlled
by the `enable.mapping.varbinary` property of Catalog (supported since 4.0.2).
The default is `false`, which maps to `string`; when `true`, it maps to
`varbinary` type.|
+| uuid | string/varbinary | Before
4.0.2, it was mapped to `string`; after that, it is mapped to `varbinary` type.|
| struct | struct (supported from version
2.1.3) | |
| map | map (supported from version 2.1.3)
| |
| list | array |
|
@@ -1797,6 +1797,63 @@ Supported schema change operations include:
ALTER TABLE iceberg_table ORDER BY (col_name1, col_name2, ...);
```
+### Partition Evolution
+
+Starting from version 4.0.2, Doris supports Partition Evolution for Iceberg
tables through `ALTER` statements.
+
+Supported partition transforms include:
+
+| Transform | Syntax | Example |
+|-----------|--------|---------|
+| bucket | `bucket(N, column)` | `bucket(16, id)` |
+| truncate | `truncate(N, column)` | `truncate(10, name)` |
+| year | `year(column)` | `year(ts)` |
+| month | `month(column)` | `month(ts)` |
+| day | `day(column)` | `day(ts)` |
+| hour | `hour(column)` | `hour(ts)` |
+| identity | `column` | `category` |
+
+Supported operations include:
+
+- **Add partition key**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name ADD PARTITION KEY partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY year(ts);
+ -- use optional AS keyword to specify a custom name for the partition
field
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id) AS shard;
+ ```
+
+- **Drop partition key**
+
+ ```sql
+ ALTER TABLE table_name DROP PARTITION KEY partition_transform｜key_name;
+
+ -- example
+ ALTER TABLE prod.db.sample DROP PARTITION KEY catalog;
+ ALTER TABLE prod.db.sample DROP PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY year(ts);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY shard;
+ ```
+
+- **Replace partition key**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name REPLACE PARTITION KEY key_name WITH
partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts);
+ -- use optional AS keyword to specify a custom name for the new partition
field
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts) AS
day_of_ts;
+ ```
+
### Managing Branch & Tag
> Since 3.1.0
@@ -2433,4 +2490,4 @@ Here are some example query strategies:
| 76492482642020578 | 2025-07-10 15:27:07.865000 | append |
["BRANCH:b3", "TAG:t3"] |
| 1788715857849070138 | 2025-07-12 04:15:19.626000 | append |
["BRANCH:main", "TAG:t4", "TAG:t5"] |
+---------------------+----------------------------+-----------+-------------------------------------+
- ```
\ No newline at end of file
+ ```
diff --git
a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index 4603b2a4a6d..5b3138b20b2 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -67,6 +67,7 @@ When mapping IBM Db2, Doris's Database corresponds to a
Schema under the specifi
| time | string | |
| clob | string | |
| xml | string | |
+| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED | |
## Common Issues
diff --git
a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-mysql-catalog.md
b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-mysql-catalog.md
index 7b14a6c8eb2..8ef7e6f278b 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-mysql-catalog.md
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-mysql-catalog.md
@@ -88,8 +88,7 @@ When mapping MySQL, a Database in Doris corresponds to a
Database in MySQL. A Ta
| enum | string |
|
| bit | boolean / string | Doris
does not support the bit type, so the bit type is mapped to boolean when
bit(1), and to string in other cases. |
| tinytext, text, mediumtext, longtext | string |
|
-| blob, mediumblob, longblob, tinyblob | string |
|
-| binary, varbinary | string |
|
+| blob, mediumblob, longblob, tinyblob, binary, varbinary | string/varbinary
| Controlled by the `enable.mapping.varbinary` property of
Catalog (supported since 4.0.2). The default is `false`, which maps to
`string`; when `true`, it maps to `varbinary` type.
|
| other | UNSUPPORTED |
|
## Appendix
@@ -288,4 +287,4 @@ When reading MySQL's timestamp type, add the parameters
`connectionTimeZone=LOCA
* Add the parameter `-Dcom.mysql.cj.disableAbandonedConnectionCleanup=true`
in the `JAVA_OPTS` of the FE and BE conf files to disable the connection
cleanup function of the MySQL JDBC driver, and restart the cluster
- Note: If the version of Doris is 2.0.13 or above, or 2.1.5 or above,
there is no need to add this parameter, because Doris has already disabled the
connection cleanup function of the MySQL JDBC driver by default. Just replace
the MySQL JDBC driver version. However, you need to restart the Doris cluster
to clean up the previously leaked threads.
\ No newline at end of file
+ Note: If the version of Doris is 2.0.13 or above, or 2.1.5 or above,
there is no need to add this parameter, because Doris has already disabled the
connection cleanup function of the MySQL JDBC driver by default. Just replace
the MySQL JDBC driver version. However, you need to restart the Doris cluster
to clean up the previously leaked threads.
diff --git
a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-oracle-catalog.md
b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-oracle-catalog.md
index 240a7d8407a..7da3a3c945b 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-oracle-catalog.md
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-oracle-catalog.md
@@ -60,6 +60,7 @@ When mapping Oracle, a Database in Apache Doris corresponds
to a User in Oracle.
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
+| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED
|
|
## Common Issues
@@ -70,4 +71,4 @@ When mapping Oracle, a Database in Apache Doris corresponds
to a User in Oracle.
2. `Non supported character set (add orai18n.jar in your classpath): ZHS16GBK`
exception occurs when creating or querying Oracle Catalog
- Download
[orai18n.jar](https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html)
and place it in the `custom_lib/` directory under each FE and BE (create
manually if it does not exist) and restart each FE and BE.
\ No newline at end of file
+ Download
[orai18n.jar](https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html)
and place it in the `custom_lib/` directory under each FE and BE (create
manually if it does not exist) and restart each FE and BE.
diff --git a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-pg-catalog.md
b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-pg-catalog.md
index 48e740f29ce..ea563b65f34 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-pg-catalog.md
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-pg-catalog.md
@@ -81,7 +81,7 @@ When mapping PostgreSQL, a Database in Doris corresponds to a
Schema under a spe
| cidr/inet/macaddr | string |
|
| uuid | string |
|
| bit | boolean / string | Doris
does not support bit type, bit type will be mapped to boolean when bit(1),
otherwise mapped to string. |
-| bytea | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| bytea | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| array | array | Please
refer to the following explanation regarding the mapping methods for array
types. |
| other | UNSUPPORTED |
|
diff --git
a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-sqlserver-catalog.md
b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-sqlserver-catalog.md
index f91519054ea..6279050ef9a 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-sqlserver-catalog.md
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/jdbc-sqlserver-catalog.md
@@ -75,6 +75,7 @@ When mapping SQLServer, a Database in Doris corresponds to a
Schema under the sp
| char/varchar/text/nchar/nvarchar/ntext | string |
|
| time/datetimeoffset | string |
|
| timestamp | string | Displays
hexadecimal representation of binary data, no actual meaning |
+| image/binary/varbinary | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED |
|
## Common Issues
@@ -114,4 +115,4 @@ When mapping SQLServer, a Database in Doris corresponds to
a Schema under the sp
jdk.tls.disabledAlgorithms=SSLv3, RC4, DES, MD5withRSA, \
DH keySize < 1024, EC keySize < 224, anon, NULL, \
include jdk.disabled.namedCurves
- ```
\ No newline at end of file
+ ```
diff --git a/versioned_docs/version-2.1/lakehouse/catalogs/paimon-catalog.mdx
b/versioned_docs/version-2.1/lakehouse/catalogs/paimon-catalog.mdx
index 43d8daae269..7f3dc2088e0 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/paimon-catalog.mdx
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/paimon-catalog.mdx
@@ -143,8 +143,7 @@ The currently dependent Paimon version is 1.0.0.
| decimal(P, S) | decimal(P, S) |
|
| varchar | string |
|
| char | string |
|
-| binary | string |
|
-| varbinary | string |
|
+| binary, varbinary | string/varbinary |
Controlled by the `enable.mapping.varbinary` property of Catalog (supported
since 4.0.2). The default is `false`, which maps to `string`; when `true`, it
maps to `varbinary` type.|
| date | date |
|
| timestamp\_without\_time\_zone | datetime(N) | Mapped according to
precision. If precision is greater than 6, it maps to a maximum of 6 (may cause
precision loss). |
| timestamp\_with\_local\_time\_zone | datetime(N) | Mapped according to
precision. If precision is greater than 6, it maps to a maximum of 6 (may cause
precision loss). |
diff --git a/versioned_docs/version-3.x/lakehouse/catalogs/hive-catalog.mdx
b/versioned_docs/version-3.x/lakehouse/catalogs/hive-catalog.mdx
index e992c4ac81f..d0b47ab36e7 100644
--- a/versioned_docs/version-3.x/lakehouse/catalogs/hive-catalog.mdx
+++ b/versioned_docs/version-3.x/lakehouse/catalogs/hive-catalog.mdx
@@ -141,7 +141,7 @@ Hive transactional tables are supported from version 3.x
onwards. For details, r
| char(N) | char(N) |
|
| varchar(N) | varchar(N) |
|
| string | string |
|
-| binary | string/varbinary | Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| binary | string/varbinary | Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| array | array |
|
| map | map |
|
| struct | struct |
|
diff --git a/versioned_docs/version-3.x/lakehouse/catalogs/iceberg-catalog.mdx
b/versioned_docs/version-3.x/lakehouse/catalogs/iceberg-catalog.mdx
index 0057fd7d7ac..90d413b0a91 100644
--- a/versioned_docs/version-3.x/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/versioned_docs/version-3.x/lakehouse/catalogs/iceberg-catalog.mdx
@@ -136,8 +136,8 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
| timestamptz (Timestamp with timezone) | datetime(6) | Mapped to
datetime with precision 6 |
| fixed(N) | char(N) |
|
| string | string |
|
-| binary | string/varbinary | Controlled
by the `enable.mapping.varbinary` property of Catalog (supported since 4.0.3).
The default is `false`, which maps to `string`; when `true`, it maps to
`varbinary` type.|
-| uuid | string/varbinary | Before
4.0.3, it was mapped to `string`; after that, it is mapped to `varbinary` type.|
+| binary | string/varbinary | Controlled
by the `enable.mapping.varbinary` property of Catalog (supported since 4.0.2).
The default is `false`, which maps to `string`; when `true`, it maps to
`varbinary` type.|
+| uuid | string/varbinary | Before
4.0.2, it was mapped to `string`; after that, it is mapped to `varbinary` type.|
| struct | struct (supported from version
2.1.3) | |
| map | map (supported from version 2.1.3)
| |
| list | array |
|
@@ -1797,6 +1797,63 @@ Supported schema change operations include:
ALTER TABLE iceberg_table ORDER BY (col_name1, col_name2, ...);
```
+### Partition Evolution
+
+Starting from version 4.0.2, Doris supports Partition Evolution for Iceberg
tables through `ALTER` statements.
+
+Supported partition transforms include:
+
+| Transform | Syntax | Example |
+|-----------|--------|---------|
+| bucket | `bucket(N, column)` | `bucket(16, id)` |
+| truncate | `truncate(N, column)` | `truncate(10, name)` |
+| year | `year(column)` | `year(ts)` |
+| month | `month(column)` | `month(ts)` |
+| day | `day(column)` | `day(ts)` |
+| hour | `hour(column)` | `hour(ts)` |
+| identity | `column` | `category` |
+
+Supported operations include:
+
+- **Add partition key**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name ADD PARTITION KEY partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY year(ts);
+ -- use optional AS keyword to specify a custom name for the partition
field
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id) AS shard;
+ ```
+
+- **Drop partition key**
+
+ ```sql
+ ALTER TABLE table_name DROP PARTITION KEY partition_transform｜key_name;
+
+ -- example
+ ALTER TABLE prod.db.sample DROP PARTITION KEY catalog;
+ ALTER TABLE prod.db.sample DROP PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY year(ts);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY shard;
+ ```
+
+- **Replace partition key**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name REPLACE PARTITION KEY key_name WITH
partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts);
+ -- use optional AS keyword to specify a custom name for the new partition
field
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts) AS
day_of_ts;
+ ```
+
### Managing Branch & Tag
> Since 3.1.0
diff --git
a/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index e5a6f9f3ef2..5b3138b20b2 100644
--- a/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++ b/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -67,7 +67,7 @@ When mapping IBM Db2, Doris's Database corresponds to a
Schema under the specifi
| time | string | |
| clob | string | |
| xml | string | |
-| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED | |
## Common Issues
diff --git
a/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-mysql-catalog.md
b/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-mysql-catalog.md
index 2159f62efe9..8ef7e6f278b 100644
--- a/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-mysql-catalog.md
+++ b/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-mysql-catalog.md
@@ -88,7 +88,7 @@ When mapping MySQL, a Database in Doris corresponds to a
Database in MySQL. A Ta
| enum | string |
|
| bit | boolean / string | Doris
does not support the bit type, so the bit type is mapped to boolean when
bit(1), and to string in other cases. |
| tinytext, text, mediumtext, longtext | string |
|
-| blob, mediumblob, longblob, tinyblob, binary, varbinary | string/varbinary
| Controlled by the `enable.mapping.varbinary` property of
Catalog (supported since 4.0.3). The default is `false`, which maps to
`string`; when `true`, it maps to `varbinary` type.
|
+| blob, mediumblob, longblob, tinyblob, binary, varbinary | string/varbinary
| Controlled by the `enable.mapping.varbinary` property of
Catalog (supported since 4.0.2). The default is `false`, which maps to
`string`; when `true`, it maps to `varbinary` type.
|
| other | UNSUPPORTED |
|
## Appendix
diff --git
a/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-oracle-catalog.md
b/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-oracle-catalog.md
index 83dd37f6f03..7da3a3c945b 100644
--- a/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-oracle-catalog.md
+++ b/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-oracle-catalog.md
@@ -60,7 +60,7 @@ When mapping Oracle, a Database in Apache Doris corresponds
to a User in Oracle.
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
-| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED
|
|
## Common Issues
diff --git a/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-pg-catalog.md
b/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-pg-catalog.md
index 48e740f29ce..ea563b65f34 100644
--- a/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-pg-catalog.md
+++ b/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-pg-catalog.md
@@ -81,7 +81,7 @@ When mapping PostgreSQL, a Database in Doris corresponds to a
Schema under a spe
| cidr/inet/macaddr | string |
|
| uuid | string |
|
| bit | boolean / string | Doris
does not support bit type, bit type will be mapped to boolean when bit(1),
otherwise mapped to string. |
-| bytea | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| bytea | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| array | array | Please
refer to the following explanation regarding the mapping methods for array
types. |
| other | UNSUPPORTED |
|
diff --git
a/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
b/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
index b0aa9f41ccd..6279050ef9a 100644
--- a/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
+++ b/versioned_docs/version-3.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
@@ -75,7 +75,7 @@ When mapping SQLServer, a Database in Doris corresponds to a
Schema under the sp
| char/varchar/text/nchar/nvarchar/ntext | string |
|
| time/datetimeoffset | string |
|
| timestamp | string | Displays
hexadecimal representation of binary data, no actual meaning |
-| image/binary/varbinary | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| image/binary/varbinary | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED |
|
## Common Issues
diff --git a/versioned_docs/version-3.x/lakehouse/catalogs/paimon-catalog.mdx
b/versioned_docs/version-3.x/lakehouse/catalogs/paimon-catalog.mdx
index 32512884428..7f3dc2088e0 100644
--- a/versioned_docs/version-3.x/lakehouse/catalogs/paimon-catalog.mdx
+++ b/versioned_docs/version-3.x/lakehouse/catalogs/paimon-catalog.mdx
@@ -143,7 +143,7 @@ The currently dependent Paimon version is 1.0.0.
| decimal(P, S) | decimal(P, S) |
|
| varchar | string |
|
| char | string |
|
-| binary, varbinary | string/varbinary |
Controlled by the `enable.mapping.varbinary` property of Catalog (supported
since 4.0.3). The default is `false`, which maps to `string`; when `true`, it
maps to `varbinary` type.|
+| binary, varbinary | string/varbinary |
Controlled by the `enable.mapping.varbinary` property of Catalog (supported
since 4.0.2). The default is `false`, which maps to `string`; when `true`, it
maps to `varbinary` type.|
| date | date |
|
| timestamp\_without\_time\_zone | datetime(N) | Mapped according to
precision. If precision is greater than 6, it maps to a maximum of 6 (may cause
precision loss). |
| timestamp\_with\_local\_time\_zone | datetime(N) | Mapped according to
precision. If precision is greater than 6, it maps to a maximum of 6 (may cause
precision loss). |
diff --git a/versioned_docs/version-4.x/lakehouse/catalogs/hive-catalog.mdx
b/versioned_docs/version-4.x/lakehouse/catalogs/hive-catalog.mdx
index e992c4ac81f..d0b47ab36e7 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/hive-catalog.mdx
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/hive-catalog.mdx
@@ -141,7 +141,7 @@ Hive transactional tables are supported from version 3.x
onwards. For details, r
| char(N) | char(N) |
|
| varchar(N) | varchar(N) |
|
| string | string |
|
-| binary | string/varbinary | Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| binary | string/varbinary | Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| array | array |
|
| map | map |
|
| struct | struct |
|
diff --git a/versioned_docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
b/versioned_docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
index 0057fd7d7ac..90d413b0a91 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
@@ -136,8 +136,8 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
| timestamptz (Timestamp with timezone) | datetime(6) | Mapped to
datetime with precision 6 |
| fixed(N) | char(N) |
|
| string | string |
|
-| binary | string/varbinary | Controlled
by the `enable.mapping.varbinary` property of Catalog (supported since 4.0.3).
The default is `false`, which maps to `string`; when `true`, it maps to
`varbinary` type.|
-| uuid | string/varbinary | Before
4.0.3, it was mapped to `string`; after that, it is mapped to `varbinary` type.|
+| binary | string/varbinary | Controlled
by the `enable.mapping.varbinary` property of Catalog (supported since 4.0.2).
The default is `false`, which maps to `string`; when `true`, it maps to
`varbinary` type.|
+| uuid | string/varbinary | Before
4.0.2, it was mapped to `string`; after that, it is mapped to `varbinary` type.|
| struct | struct (supported from version
2.1.3) | |
| map | map (supported from version 2.1.3)
| |
| list | array |
|
@@ -1797,6 +1797,63 @@ Supported schema change operations include:
ALTER TABLE iceberg_table ORDER BY (col_name1, col_name2, ...);
```
+### Partition Evolution
+
+Starting from version 4.0.2, Doris supports Partition Evolution for Iceberg
tables through `ALTER` statements.
+
+Supported partition transforms include:
+
+| Transform | Syntax | Example |
+|-----------|--------|---------|
+| bucket | `bucket(N, column)` | `bucket(16, id)` |
+| truncate | `truncate(N, column)` | `truncate(10, name)` |
+| year | `year(column)` | `year(ts)` |
+| month | `month(column)` | `month(ts)` |
+| day | `day(column)` | `day(ts)` |
+| hour | `hour(column)` | `hour(ts)` |
+| identity | `column` | `category` |
+
+Supported operations include:
+
+- **Add partition key**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name ADD PARTITION KEY partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample ADD PARTITION KEY year(ts);
+ -- use optional AS keyword to specify a custom name for the partition
field
+ ALTER TABLE prod.db.sample ADD PARTITION KEY bucket(16, id) AS shard;
+ ```
+
+- **Drop partition key**
+
+ ```sql
+ ALTER TABLE table_name DROP PARTITION KEY partition_transform｜key_name;
+
+ -- example
+ ALTER TABLE prod.db.sample DROP PARTITION KEY catalog;
+ ALTER TABLE prod.db.sample DROP PARTITION KEY bucket(16, id);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY truncate(4, data);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY year(ts);
+ ALTER TABLE prod.db.sample DROP PARTITION KEY shard;
+ ```
+
+- **Replace partition key**
+
+ ```sql
+ -- use optional AS keyword to specify a custom name for the partition field
+ ALTER TABLE table_name REPLACE PARTITION KEY key_name WITH
partition_transform [AS key_name];
+
+ -- example
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts);
+ -- use optional AS keyword to specify a custom name for the new partition
field
+ ALTER TABLE prod.db.sample REPLACE PARTITION KEY ts_day WITH day(ts) AS
day_of_ts;
+ ```
+
### Managing Branch & Tag
> Since 3.1.0
diff --git
a/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
b/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
index e5a6f9f3ef2..5b3138b20b2 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-ibmdb2-catalog.md
@@ -67,7 +67,7 @@ When mapping IBM Db2, Doris's Database corresponds to a
Schema under the specifi
| time | string | |
| clob | string | |
| xml | string | |
-| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED | |
## Common Issues
diff --git
a/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-mysql-catalog.md
b/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-mysql-catalog.md
index 2159f62efe9..8ef7e6f278b 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-mysql-catalog.md
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-mysql-catalog.md
@@ -88,7 +88,7 @@ When mapping MySQL, a Database in Doris corresponds to a
Database in MySQL. A Ta
| enum | string |
|
| bit | boolean / string | Doris
does not support the bit type, so the bit type is mapped to boolean when
bit(1), and to string in other cases. |
| tinytext, text, mediumtext, longtext | string |
|
-| blob, mediumblob, longblob, tinyblob, binary, varbinary | string/varbinary
| Controlled by the `enable.mapping.varbinary` property of
Catalog (supported since 4.0.3). The default is `false`, which maps to
`string`; when `true`, it maps to `varbinary` type.
|
+| blob, mediumblob, longblob, tinyblob, binary, varbinary | string/varbinary
| Controlled by the `enable.mapping.varbinary` property of
Catalog (supported since 4.0.2). The default is `false`, which maps to
`string`; when `true`, it maps to `varbinary` type.
|
| other | UNSUPPORTED |
|
## Appendix
diff --git
a/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-oracle-catalog.md
b/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-oracle-catalog.md
index 83dd37f6f03..7da3a3c945b 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-oracle-catalog.md
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-oracle-catalog.md
@@ -60,7 +60,7 @@ When mapping Oracle, a Database in Apache Doris corresponds
to a User in Oracle.
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
-| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| BLOB | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED
|
|
## Common Issues
diff --git a/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-pg-catalog.md
b/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-pg-catalog.md
index 48e740f29ce..ea563b65f34 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-pg-catalog.md
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-pg-catalog.md
@@ -81,7 +81,7 @@ When mapping PostgreSQL, a Database in Doris corresponds to a
Schema under a spe
| cidr/inet/macaddr | string |
|
| uuid | string |
|
| bit | boolean / string | Doris
does not support bit type, bit type will be mapped to boolean when bit(1),
otherwise mapped to string. |
-| bytea | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| bytea | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| array | array | Please
refer to the following explanation regarding the mapping methods for array
types. |
| other | UNSUPPORTED |
|
diff --git
a/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
b/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
index b0aa9f41ccd..6279050ef9a 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/jdbc-sqlserver-catalog.md
@@ -75,7 +75,7 @@ When mapping SQLServer, a Database in Doris corresponds to a
Schema under the sp
| char/varchar/text/nchar/nvarchar/ntext | string |
|
| time/datetimeoffset | string |
|
| timestamp | string | Displays
hexadecimal representation of binary data, no actual meaning |
-| image/binary/varbinary | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.3). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
+| image/binary/varbinary | varbinary |Controlled by the
`enable.mapping.varbinary` property of Catalog (supported since 4.0.2). The
default is `false`, which maps to `string`; when `true`, it maps to `varbinary`
type.|
| other | UNSUPPORTED |
|
## Common Issues
diff --git a/versioned_docs/version-4.x/lakehouse/catalogs/paimon-catalog.mdx
b/versioned_docs/version-4.x/lakehouse/catalogs/paimon-catalog.mdx
index 32512884428..7f3dc2088e0 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/paimon-catalog.mdx
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/paimon-catalog.mdx
@@ -143,7 +143,7 @@ The currently dependent Paimon version is 1.0.0.
| decimal(P, S) | decimal(P, S) |
|
| varchar | string |
|
| char | string |
|
-| binary, varbinary | string/varbinary |
Controlled by the `enable.mapping.varbinary` property of Catalog (supported
since 4.0.3). The default is `false`, which maps to `string`; when `true`, it
maps to `varbinary` type.|
+| binary, varbinary | string/varbinary |
Controlled by the `enable.mapping.varbinary` property of Catalog (supported
since 4.0.2). The default is `false`, which maps to `string`; when `true`, it
maps to `varbinary` type.|
| date | date |
|
| timestamp\_without\_time\_zone | datetime(N) | Mapped according to
precision. If precision is greater than 6, it maps to a maximum of 6 (may cause
precision loss). |
| timestamp\_with\_local\_time\_zone | datetime(N) | Mapped according to
precision. If precision is greater than 6, it maps to a maximum of 6 (may cause
precision loss). |
diff --git a/versioned_docs/version-4.x/lakehouse/huggingface.md
b/versioned_docs/version-4.x/lakehouse/huggingface.md
index c6a7535e893..9f6ceedf908 100644
--- a/versioned_docs/version-4.x/lakehouse/huggingface.md
+++ b/versioned_docs/version-4.x/lakehouse/huggingface.md
@@ -12,7 +12,7 @@
Through the [HTTP Table Value
Function](../sql-manual/sql-functions/table-valued-functions/http.md) feature,
Doris can directly access data on Hugging Face datasets via SQL.
:::note
-This feature is supported since version 4.0.3
+This feature is supported since version 4.0.2
:::
## Usage Instructions
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/http.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/http.md
index c5c4ebc62fe..fd68c7eeda3 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/http.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/http.md
@@ -8,7 +8,7 @@
HTTP table-valued-function (tvf) allows users to read and access file content
on HTTP paths as if accessing relational table format data. Currently supports
`csv/csv_with_names/csv_with_names_and_types/json/parquet/orc` file formats.
:::note
-Supported since 4.0.3
+Supported since 4.0.2
:::
## Syntax
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
