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 051f98d143d [feat]Add Iceberg JDBC Catalog doc (#3262)
051f98d143d is described below
commit 051f98d143dcdf17a05664f51eda6055a3fbb892
Author: Chenjunwei <[email protected]>
AuthorDate: Wed Jan 7 23:14:43 2026 +0800
[feat]Add Iceberg JDBC Catalog doc (#3262)
- Add iceberg-jdbc.md in metastores directory (zh-CN and en)
- Update iceberg-catalog.mdx to include JDBC Catalog in supported
metadata services
- Add JDBC Catalog examples with PostgreSQL, MySQL and HDFS storage
---
docs/lakehouse/catalogs/iceberg-catalog.mdx | 73 +++++++++++++++
docs/lakehouse/metastores/iceberg-jdbc.md | 102 +++++++++++++++++++++
.../current/lakehouse/catalogs/iceberg-catalog.mdx | 78 +++++++++++++++-
.../current/lakehouse/metastores/iceberg-jdbc.md | 102 +++++++++++++++++++++
.../lakehouse/catalogs/iceberg-catalog.mdx | 76 ++++++++++++++-
.../lakehouse/metastores/iceberg-jdbc.md | 102 +++++++++++++++++++++
.../lakehouse/catalogs/iceberg-catalog.mdx | 74 +++++++++++++++
.../lakehouse/metastores/iceberg-jdbc.md | 102 +++++++++++++++++++++
sidebars.ts | 1 +
.../lakehouse/catalogs/iceberg-catalog.mdx | 77 +++++++++++++++-
.../lakehouse/metastores/iceberg-jdbc.md | 102 +++++++++++++++++++++
.../lakehouse/catalogs/iceberg-catalog.mdx | 75 ++++++++++++++-
.../lakehouse/metastores/iceberg-jdbc.md | 102 +++++++++++++++++++++
versioned_sidebars/version-3.x-sidebars.json | 1 +
versioned_sidebars/version-4.x-sidebars.json | 1 +
15 files changed, 1061 insertions(+), 7 deletions(-)
diff --git a/docs/lakehouse/catalogs/iceberg-catalog.mdx
b/docs/lakehouse/catalogs/iceberg-catalog.mdx
index daf0d431585..434be54f4a2 100644
--- a/docs/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/docs/lakehouse/catalogs/iceberg-catalog.mdx
@@ -100,6 +100,7 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
* [AWS Glue](../metastores/aws-glue.md)
* [Aliyun DLF](../metastores/aliyun-dlf.md)
* [Iceberg Rest Catalog](../metastores/iceberg-rest.md)
+* [Iceberg JDBC Catalog](../metastores/iceberg-jdbc.md) (Supported since
version 4.1.0)
* [FileSystem](../metastores/filesystem.md)
> Note: The service types and parameters supported by different Doris versions
> are slightly different. Please refer to the [Examples] section.
@@ -919,6 +920,78 @@ Support for Nested Namespace needs to be explicitly
enabled. For details, please
</details>
+### Iceberg JDBC Catalog
+:::tip Note
+This is an experimental feature, supported since version 4.1.0.
+:::
+
+<details>
+ <summary>4.1+ Version</summary>
+ <Tabs>
+ <TabItem value='PostgreSQL' label='PostgreSQL' default>
+ Using PostgreSQL as metadata storage with S3
+ ```sql
+ CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' =
'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='MySQL' label='MySQL'>
+ Using MySQL as metadata storage with S3
+ ```sql
+ CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='SQLite' label='SQLite'>
+ Using SQLite as metadata storage (suitable for testing
environments)
+ ```sql
+ CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ </Tabs>
+</details>
+
### FileSystem
<details>
<summary>3.1+ Version</summary>
diff --git a/docs/lakehouse/metastores/iceberg-jdbc.md
b/docs/lakehouse/metastores/iceberg-jdbc.md
new file mode 100644
index 00000000000..0aff308edcf
--- /dev/null
+++ b/docs/lakehouse/metastores/iceberg-jdbc.md
@@ -0,0 +1,102 @@
+---
+{
+ "title": "Iceberg JDBC Catalog",
+ "language": "en",
+ "description": "This document describes the supported parameters when
connecting to and accessing Iceberg Catalog metadata services using the JDBC
interface."
+}
+---
+
+This document describes the supported parameters when connecting to and
accessing Iceberg Catalog metadata services using the JDBC interface through
the `CREATE CATALOG` statement.
+
+:::tip Note
+This is an experimental feature, supported since version 4.1.0.
+:::
+
+## Parameter Overview
+
+| Property Name | Description | Default Value | Required |
+| --- | --- | --- | --- |
+| iceberg.jdbc.uri | Specifies the JDBC connection URI | - | Yes |
+| iceberg.jdbc.user | JDBC connection username | - | Yes |
+| iceberg.jdbc.password | JDBC connection password | - | Yes |
+| warehouse | Specifies the iceberg warehouse | - | Yes |
+| iceberg.jdbc.init-catalog-tables | Whether to automatically initialize
Catalog-related table structures on first use | `true` | No |
+| iceberg.jdbc.schema-version | Schema version used by JDBC Catalog, supports
`V0` and `V1` | `V0` | No |
+| iceberg.jdbc.strict-mode | Whether to enable strict mode, which performs
stricter validation of metadata | `false` | No |
+| iceberg.jdbc.driver_class | JDBC driver class name, such as
`org.postgresql.Driver`, `com.mysql.cj.jdbc.Driver`, etc. | - | No |
+| iceberg.jdbc.driver_url | Path to JDBC driver JAR file | - | No |
+
+> Note:
+>
+> 1. Iceberg JDBC Catalog supports various relational databases as backend
storage, including PostgreSQL, MySQL, SQLite, etc.
+>
+> 2. Ensure the JDBC driver JAR file is accessible. You can specify the driver
location via `iceberg.jdbc.driver_url`.
+
+## Example Configurations
+
+### PostgreSQL as Metadata Storage
+
+Using PostgreSQL database to store Iceberg metadata:
+
+```sql
+CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>',
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### MySQL as Metadata Storage
+
+Using MySQL database to store Iceberg metadata:
+
+```sql
+CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### SQLite as Metadata Storage
+
+Using SQLite database to store Iceberg metadata (suitable for testing
environments):
+
+```sql
+CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
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 11d7d2eb9c7..fd43ae27323 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
@@ -9,8 +9,6 @@
import Tabs from '@theme/Tabs';
import TabItem from '@theme/TabItem';
-
-
Doris 支持通过多种元数据服务访问 Iceberg 表数据。除支持数据读取外，Doris 也支持对 Iceberg 表进行写入操作。
[使用 Docker 快速体验 Apache Doris & Iceberg](../best-practices/doris-iceberg.md)
@@ -109,6 +107,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
* [Iceberg Rest Catalog](../metastores/iceberg-rest.md)
+* [Iceberg JDBC Catalog](../metastores/iceberg-jdbc.md) (自 4.1.0 版本支持)
+
* [FileSystem](../metastores/filesystem.md)
> 注意：不同 Doris 版本所支持的服务类型和参数略有区别，请参考【基础示例】章节。
@@ -155,7 +155,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| fixed(N) | char(N) |
|
| string | string |
|
| binary | string/varbinary |由 properties
中 `enable.mapping.varbinary` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。 |
-| uuid | string/varbinary |version <
4.0.2 映射成 `string` 类型; version == 4.0.2 则映射成 `varbinary` 类型。version > 4.0.2，由
properties 中 `enable.mapping.varbinary`属性控制。默认为 `false`, 则映射到 `string`; |
+| uuid | string/varbinary |version <
4.0.2 映射成 `string` 类型; version == 4.0.2 则映射成 `varbinary` 类型。version > 4.0.2，由
properties 中 `enable.mapping.varbinary`属性控制。默认为 `false`, 则映射到 `string`; |
| struct | struct（2.1.3 版本开始支持） |
|
| map | map（2.1.3 版本开始支持） |
|
| list | array |
|
@@ -921,6 +921,78 @@ Iceberg 的元数层级关系是 Catalog -> Namespace -> Table。其中 Namespac
</details>
+### Iceberg JDBC Catalog
+:::tip 提示
+该功能为试验功能，自 4.1.0 版本支持。
+:::
+
+<details>
+ <summary>4.1+ 版本</summary>
+ <Tabs>
+ <TabItem value='PostgreSQL' label='PostgreSQL' default>
+ 使用 PostgreSQL 作为元数据存储，配合 S3 存储
+ ```sql
+ CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' =
'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='MySQL' label='MySQL'>
+ 使用 MySQL 作为元数据存储，配合 S3 存储
+ ```sql
+ CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='SQLite' label='SQLite'>
+ 使用 SQLite 作为元数据存储（适用于测试环境）
+ ```sql
+ CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ </Tabs>
+</details>
+
### FileSystem
<details>
<summary>3.1+ 版本 </summary>
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/metastores/iceberg-jdbc.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/metastores/iceberg-jdbc.md
new file mode 100644
index 00000000000..76124a3ff0a
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/metastores/iceberg-jdbc.md
@@ -0,0 +1,102 @@
+---
+{
+ "title": "Iceberg JDBC Catalog",
+ "language": "zh-CN",
+ "description": "本文档用于介绍通过 CREATE CATALOG 语句连接并访问使用 JDBC 接口的 Iceberg
Catalog 元数据服务时所支持的参数。"
+}
+---
+
+本文档用于介绍通过 `CREATE CATALOG` 语句连接并访问使用 JDBC 接口的 Iceberg Catalog 元数据服务时所支持的参数。
+
+:::tip 提示
+该功能为试验功能，自 4.1.0 版本支持。
+:::
+
+## 参数总览
+
+|属性名称 | 描述 | 默认值 | 是否必须 |
+| --- | --- | --- | --- |
+| iceberg.jdbc.uri | 指定 JDBC 连接地址 | - | 是 |
+| iceberg.jdbc.user | JDBC 连接用户名 | - | 是 |
+| iceberg.jdbc.password | JDBC 连接密码 | - | 是 |
+| warehouse | 指定 iceberg warehouse | - | 是 |
+| iceberg.jdbc.init-catalog-tables | 是否在首次使用时自动初始化 Catalog 相关的表结构 | `true` | 否
|
+| iceberg.jdbc.schema-version | JDBC Catalog 使用的 Schema 版本，支持 `V0` 和 `V1` |
`V0` | 否 |
+| iceberg.jdbc.strict-mode | 是否启用严格模式，严格模式下会对元数据进行更严格的校验 | `false` | 否 |
+| iceberg.jdbc.driver_class | JDBC 驱动类名，如
`org.postgresql.Driver`，`com.mysql.cj.jdbc.Driver` 等 | - | 否 |
+| iceberg.jdbc.driver_url | JDBC 驱动 JAR 包的路径 | - | 否 |
+
+> 注：
+>
+> 1. Iceberg JDBC Catalog 支持多种关系型数据库作为后端存储，包括 PostgreSQL、MySQL、SQLite 等。
+>
+> 2. 需要确保 JDBC 驱动 JAR 包可访问。可以通过 `iceberg.jdbc.driver_url` 指定驱动位置。
+
+## 示例配置
+
+### PostgreSQL 作为元数据存储
+
+使用 PostgreSQL 数据库存储 Iceberg 元数据：
+
+```sql
+CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>',
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### MySQL 作为元数据存储
+
+使用 MySQL 数据库存储 Iceberg 元数据：
+
+```sql
+CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### SQLite 作为元数据存储
+
+使用 SQLite 数据库存储 Iceberg 元数据（适用于测试环境）：
+
+```sql
+CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
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 81238df56eb..fd43ae27323 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
@@ -107,6 +107,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
* [Iceberg Rest Catalog](../metastores/iceberg-rest.md)
+* [Iceberg JDBC Catalog](../metastores/iceberg-jdbc.md) (自 4.1.0 版本支持)
+
* [FileSystem](../metastores/filesystem.md)
> 注意：不同 Doris 版本所支持的服务类型和参数略有区别，请参考【基础示例】章节。
@@ -153,7 +155,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| fixed(N) | char(N) |
|
| string | string |
|
| binary | string/varbinary |由 properties
中 `enable.mapping.varbinary` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。 |
-| uuid | string/varbinary |4.0.2 之前映射成
`string`，之后则映射成 `varbinary` 类型。 |
+| uuid | string/varbinary |version <
4.0.2 映射成 `string` 类型; version == 4.0.2 则映射成 `varbinary` 类型。version > 4.0.2，由
properties 中 `enable.mapping.varbinary`属性控制。默认为 `false`, 则映射到 `string`; |
| struct | struct（2.1.3 版本开始支持） |
|
| map | map（2.1.3 版本开始支持） |
|
| list | array |
|
@@ -919,6 +921,78 @@ Iceberg 的元数层级关系是 Catalog -> Namespace -> Table。其中 Namespac
</details>
+### Iceberg JDBC Catalog
+:::tip 提示
+该功能为试验功能，自 4.1.0 版本支持。
+:::
+
+<details>
+ <summary>4.1+ 版本</summary>
+ <Tabs>
+ <TabItem value='PostgreSQL' label='PostgreSQL' default>
+ 使用 PostgreSQL 作为元数据存储，配合 S3 存储
+ ```sql
+ CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' =
'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='MySQL' label='MySQL'>
+ 使用 MySQL 作为元数据存储，配合 S3 存储
+ ```sql
+ CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='SQLite' label='SQLite'>
+ 使用 SQLite 作为元数据存储（适用于测试环境）
+ ```sql
+ CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ </Tabs>
+</details>
+
### FileSystem
<details>
<summary>3.1+ 版本 </summary>
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/metastores/iceberg-jdbc.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/metastores/iceberg-jdbc.md
new file mode 100644
index 00000000000..76124a3ff0a
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.x/lakehouse/metastores/iceberg-jdbc.md
@@ -0,0 +1,102 @@
+---
+{
+ "title": "Iceberg JDBC Catalog",
+ "language": "zh-CN",
+ "description": "本文档用于介绍通过 CREATE CATALOG 语句连接并访问使用 JDBC 接口的 Iceberg
Catalog 元数据服务时所支持的参数。"
+}
+---
+
+本文档用于介绍通过 `CREATE CATALOG` 语句连接并访问使用 JDBC 接口的 Iceberg Catalog 元数据服务时所支持的参数。
+
+:::tip 提示
+该功能为试验功能，自 4.1.0 版本支持。
+:::
+
+## 参数总览
+
+|属性名称 | 描述 | 默认值 | 是否必须 |
+| --- | --- | --- | --- |
+| iceberg.jdbc.uri | 指定 JDBC 连接地址 | - | 是 |
+| iceberg.jdbc.user | JDBC 连接用户名 | - | 是 |
+| iceberg.jdbc.password | JDBC 连接密码 | - | 是 |
+| warehouse | 指定 iceberg warehouse | - | 是 |
+| iceberg.jdbc.init-catalog-tables | 是否在首次使用时自动初始化 Catalog 相关的表结构 | `true` | 否
|
+| iceberg.jdbc.schema-version | JDBC Catalog 使用的 Schema 版本，支持 `V0` 和 `V1` |
`V0` | 否 |
+| iceberg.jdbc.strict-mode | 是否启用严格模式，严格模式下会对元数据进行更严格的校验 | `false` | 否 |
+| iceberg.jdbc.driver_class | JDBC 驱动类名，如
`org.postgresql.Driver`，`com.mysql.cj.jdbc.Driver` 等 | - | 否 |
+| iceberg.jdbc.driver_url | JDBC 驱动 JAR 包的路径 | - | 否 |
+
+> 注：
+>
+> 1. Iceberg JDBC Catalog 支持多种关系型数据库作为后端存储，包括 PostgreSQL、MySQL、SQLite 等。
+>
+> 2. 需要确保 JDBC 驱动 JAR 包可访问。可以通过 `iceberg.jdbc.driver_url` 指定驱动位置。
+
+## 示例配置
+
+### PostgreSQL 作为元数据存储
+
+使用 PostgreSQL 数据库存储 Iceberg 元数据：
+
+```sql
+CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>',
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### MySQL 作为元数据存储
+
+使用 MySQL 数据库存储 Iceberg 元数据：
+
+```sql
+CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### SQLite 作为元数据存储
+
+使用 SQLite 数据库存储 Iceberg 元数据（适用于测试环境）：
+
+```sql
+CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
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 fe93f300aaf..fd43ae27323 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
@@ -107,6 +107,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
* [Iceberg Rest Catalog](../metastores/iceberg-rest.md)
+* [Iceberg JDBC Catalog](../metastores/iceberg-jdbc.md) (自 4.1.0 版本支持)
+
* [FileSystem](../metastores/filesystem.md)
> 注意：不同 Doris 版本所支持的服务类型和参数略有区别，请参考【基础示例】章节。
@@ -919,6 +921,78 @@ Iceberg 的元数层级关系是 Catalog -> Namespace -> Table。其中 Namespac
</details>
+### Iceberg JDBC Catalog
+:::tip 提示
+该功能为试验功能，自 4.1.0 版本支持。
+:::
+
+<details>
+ <summary>4.1+ 版本</summary>
+ <Tabs>
+ <TabItem value='PostgreSQL' label='PostgreSQL' default>
+ 使用 PostgreSQL 作为元数据存储，配合 S3 存储
+ ```sql
+ CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' =
'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='MySQL' label='MySQL'>
+ 使用 MySQL 作为元数据存储，配合 S3 存储
+ ```sql
+ CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='SQLite' label='SQLite'>
+ 使用 SQLite 作为元数据存储（适用于测试环境）
+ ```sql
+ CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ </Tabs>
+</details>
+
### FileSystem
<details>
<summary>3.1+ 版本 </summary>
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/metastores/iceberg-jdbc.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/metastores/iceberg-jdbc.md
new file mode 100644
index 00000000000..76124a3ff0a
--- /dev/null
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/lakehouse/metastores/iceberg-jdbc.md
@@ -0,0 +1,102 @@
+---
+{
+ "title": "Iceberg JDBC Catalog",
+ "language": "zh-CN",
+ "description": "本文档用于介绍通过 CREATE CATALOG 语句连接并访问使用 JDBC 接口的 Iceberg
Catalog 元数据服务时所支持的参数。"
+}
+---
+
+本文档用于介绍通过 `CREATE CATALOG` 语句连接并访问使用 JDBC 接口的 Iceberg Catalog 元数据服务时所支持的参数。
+
+:::tip 提示
+该功能为试验功能，自 4.1.0 版本支持。
+:::
+
+## 参数总览
+
+|属性名称 | 描述 | 默认值 | 是否必须 |
+| --- | --- | --- | --- |
+| iceberg.jdbc.uri | 指定 JDBC 连接地址 | - | 是 |
+| iceberg.jdbc.user | JDBC 连接用户名 | - | 是 |
+| iceberg.jdbc.password | JDBC 连接密码 | - | 是 |
+| warehouse | 指定 iceberg warehouse | - | 是 |
+| iceberg.jdbc.init-catalog-tables | 是否在首次使用时自动初始化 Catalog 相关的表结构 | `true` | 否
|
+| iceberg.jdbc.schema-version | JDBC Catalog 使用的 Schema 版本，支持 `V0` 和 `V1` |
`V0` | 否 |
+| iceberg.jdbc.strict-mode | 是否启用严格模式，严格模式下会对元数据进行更严格的校验 | `false` | 否 |
+| iceberg.jdbc.driver_class | JDBC 驱动类名，如
`org.postgresql.Driver`，`com.mysql.cj.jdbc.Driver` 等 | - | 否 |
+| iceberg.jdbc.driver_url | JDBC 驱动 JAR 包的路径 | - | 否 |
+
+> 注：
+>
+> 1. Iceberg JDBC Catalog 支持多种关系型数据库作为后端存储，包括 PostgreSQL、MySQL、SQLite 等。
+>
+> 2. 需要确保 JDBC 驱动 JAR 包可访问。可以通过 `iceberg.jdbc.driver_url` 指定驱动位置。
+
+## 示例配置
+
+### PostgreSQL 作为元数据存储
+
+使用 PostgreSQL 数据库存储 Iceberg 元数据：
+
+```sql
+CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>',
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### MySQL 作为元数据存储
+
+使用 MySQL 数据库存储 Iceberg 元数据：
+
+```sql
+CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### SQLite 作为元数据存储
+
+使用 SQLite 数据库存储 Iceberg 元数据（适用于测试环境）：
+
+```sql
+CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
diff --git a/sidebars.ts b/sidebars.ts
index 2191a115803..3294f4e744f 100644
--- a/sidebars.ts
+++ b/sidebars.ts
@@ -465,6 +465,7 @@ const sidebars: SidebarsConfig = {
'lakehouse/metastores/google-dataproc-metastore',
'lakehouse/metastores/aliyun-dlf',
'lakehouse/metastores/iceberg-rest',
+ 'lakehouse/metastores/iceberg-jdbc',
'lakehouse/metastores/filesystem',
],
},
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 f83248f65c3..434be54f4a2 100644
--- a/versioned_docs/version-3.x/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/versioned_docs/version-3.x/lakehouse/catalogs/iceberg-catalog.mdx
@@ -2,7 +2,7 @@
{
"title": "Iceberg Catalog",
"language": "en",
- "description": "Iceberg Catalog in Apache Doris 3.x connects to multiple
Iceberg metadata services to query and write Iceberg tables across HDFS and
cloud object storage, with detailed configuration, properties, query and write
operations."
+ "description": "Iceberg Catalog in Apache Doris connects to multiple
Iceberg metadata services to query and write Iceberg tables across HDFS and
cloud object storage, with detailed configuration, properties, query and write
operations."
}
---
@@ -100,6 +100,7 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
* [AWS Glue](../metastores/aws-glue.md)
* [Aliyun DLF](../metastores/aliyun-dlf.md)
* [Iceberg Rest Catalog](../metastores/iceberg-rest.md)
+* [Iceberg JDBC Catalog](../metastores/iceberg-jdbc.md) (Supported since
version 4.1.0)
* [FileSystem](../metastores/filesystem.md)
> Note: The service types and parameters supported by different Doris versions
> are slightly different. Please refer to the [Examples] section.
@@ -138,7 +139,7 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
| fixed(N) | char(N) |
|
| string | 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.|
+| uuid | string/varbinary | version <
4.0.2 maps to `string` type; version == 4.0.2 maps to `varbinary` type. For
version > 4.0.2, it is controlled by the `enable.mapping.varbinary` property in
the properties. The default is `false`, which maps to `string`.|
| struct | struct (supported from version
2.1.3) | |
| map | map (supported from version 2.1.3)
| |
| list | array |
|
@@ -919,6 +920,78 @@ Support for Nested Namespace needs to be explicitly
enabled. For details, please
</details>
+### Iceberg JDBC Catalog
+:::tip Note
+This is an experimental feature, supported since version 4.1.0.
+:::
+
+<details>
+ <summary>4.1+ Version</summary>
+ <Tabs>
+ <TabItem value='PostgreSQL' label='PostgreSQL' default>
+ Using PostgreSQL as metadata storage with S3
+ ```sql
+ CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' =
'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='MySQL' label='MySQL'>
+ Using MySQL as metadata storage with S3
+ ```sql
+ CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='SQLite' label='SQLite'>
+ Using SQLite as metadata storage (suitable for testing
environments)
+ ```sql
+ CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ </Tabs>
+</details>
+
### FileSystem
<details>
<summary>3.1+ Version</summary>
diff --git a/versioned_docs/version-3.x/lakehouse/metastores/iceberg-jdbc.md
b/versioned_docs/version-3.x/lakehouse/metastores/iceberg-jdbc.md
new file mode 100644
index 00000000000..0aff308edcf
--- /dev/null
+++ b/versioned_docs/version-3.x/lakehouse/metastores/iceberg-jdbc.md
@@ -0,0 +1,102 @@
+---
+{
+ "title": "Iceberg JDBC Catalog",
+ "language": "en",
+ "description": "This document describes the supported parameters when
connecting to and accessing Iceberg Catalog metadata services using the JDBC
interface."
+}
+---
+
+This document describes the supported parameters when connecting to and
accessing Iceberg Catalog metadata services using the JDBC interface through
the `CREATE CATALOG` statement.
+
+:::tip Note
+This is an experimental feature, supported since version 4.1.0.
+:::
+
+## Parameter Overview
+
+| Property Name | Description | Default Value | Required |
+| --- | --- | --- | --- |
+| iceberg.jdbc.uri | Specifies the JDBC connection URI | - | Yes |
+| iceberg.jdbc.user | JDBC connection username | - | Yes |
+| iceberg.jdbc.password | JDBC connection password | - | Yes |
+| warehouse | Specifies the iceberg warehouse | - | Yes |
+| iceberg.jdbc.init-catalog-tables | Whether to automatically initialize
Catalog-related table structures on first use | `true` | No |
+| iceberg.jdbc.schema-version | Schema version used by JDBC Catalog, supports
`V0` and `V1` | `V0` | No |
+| iceberg.jdbc.strict-mode | Whether to enable strict mode, which performs
stricter validation of metadata | `false` | No |
+| iceberg.jdbc.driver_class | JDBC driver class name, such as
`org.postgresql.Driver`, `com.mysql.cj.jdbc.Driver`, etc. | - | No |
+| iceberg.jdbc.driver_url | Path to JDBC driver JAR file | - | No |
+
+> Note:
+>
+> 1. Iceberg JDBC Catalog supports various relational databases as backend
storage, including PostgreSQL, MySQL, SQLite, etc.
+>
+> 2. Ensure the JDBC driver JAR file is accessible. You can specify the driver
location via `iceberg.jdbc.driver_url`.
+
+## Example Configurations
+
+### PostgreSQL as Metadata Storage
+
+Using PostgreSQL database to store Iceberg metadata:
+
+```sql
+CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>',
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### MySQL as Metadata Storage
+
+Using MySQL database to store Iceberg metadata:
+
+```sql
+CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### SQLite as Metadata Storage
+
+Using SQLite database to store Iceberg metadata (suitable for testing
environments):
+
+```sql
+CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
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 91148c8fa49..434be54f4a2 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
@@ -2,7 +2,7 @@
{
"title": "Iceberg Catalog",
"language": "en",
- "description": "Iceberg Catalog in Apache Doris 4.x connects to multiple
Iceberg metadata services to query and write Iceberg tables across HDFS and
cloud object storage, with detailed configuration, properties, query and write
operations."
+ "description": "Iceberg Catalog in Apache Doris connects to multiple
Iceberg metadata services to query and write Iceberg tables across HDFS and
cloud object storage, with detailed configuration, properties, query and write
operations."
}
---
@@ -100,6 +100,7 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
* [AWS Glue](../metastores/aws-glue.md)
* [Aliyun DLF](../metastores/aliyun-dlf.md)
* [Iceberg Rest Catalog](../metastores/iceberg-rest.md)
+* [Iceberg JDBC Catalog](../metastores/iceberg-jdbc.md) (Supported since
version 4.1.0)
* [FileSystem](../metastores/filesystem.md)
> Note: The service types and parameters supported by different Doris versions
> are slightly different. Please refer to the [Examples] section.
@@ -919,6 +920,78 @@ Support for Nested Namespace needs to be explicitly
enabled. For details, please
</details>
+### Iceberg JDBC Catalog
+:::tip Note
+This is an experimental feature, supported since version 4.1.0.
+:::
+
+<details>
+ <summary>4.1+ Version</summary>
+ <Tabs>
+ <TabItem value='PostgreSQL' label='PostgreSQL' default>
+ Using PostgreSQL as metadata storage with S3
+ ```sql
+ CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' =
'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='MySQL' label='MySQL'>
+ Using MySQL as metadata storage with S3
+ ```sql
+ CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ <TabItem value='SQLite' label='SQLite'>
+ Using SQLite as metadata storage (suitable for testing
environments)
+ ```sql
+ CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+ );
+ ```
+ </TabItem>
+ </Tabs>
+</details>
+
### FileSystem
<details>
<summary>3.1+ Version</summary>
diff --git a/versioned_docs/version-4.x/lakehouse/metastores/iceberg-jdbc.md
b/versioned_docs/version-4.x/lakehouse/metastores/iceberg-jdbc.md
new file mode 100644
index 00000000000..0aff308edcf
--- /dev/null
+++ b/versioned_docs/version-4.x/lakehouse/metastores/iceberg-jdbc.md
@@ -0,0 +1,102 @@
+---
+{
+ "title": "Iceberg JDBC Catalog",
+ "language": "en",
+ "description": "This document describes the supported parameters when
connecting to and accessing Iceberg Catalog metadata services using the JDBC
interface."
+}
+---
+
+This document describes the supported parameters when connecting to and
accessing Iceberg Catalog metadata services using the JDBC interface through
the `CREATE CATALOG` statement.
+
+:::tip Note
+This is an experimental feature, supported since version 4.1.0.
+:::
+
+## Parameter Overview
+
+| Property Name | Description | Default Value | Required |
+| --- | --- | --- | --- |
+| iceberg.jdbc.uri | Specifies the JDBC connection URI | - | Yes |
+| iceberg.jdbc.user | JDBC connection username | - | Yes |
+| iceberg.jdbc.password | JDBC connection password | - | Yes |
+| warehouse | Specifies the iceberg warehouse | - | Yes |
+| iceberg.jdbc.init-catalog-tables | Whether to automatically initialize
Catalog-related table structures on first use | `true` | No |
+| iceberg.jdbc.schema-version | Schema version used by JDBC Catalog, supports
`V0` and `V1` | `V0` | No |
+| iceberg.jdbc.strict-mode | Whether to enable strict mode, which performs
stricter validation of metadata | `false` | No |
+| iceberg.jdbc.driver_class | JDBC driver class name, such as
`org.postgresql.Driver`, `com.mysql.cj.jdbc.Driver`, etc. | - | No |
+| iceberg.jdbc.driver_url | Path to JDBC driver JAR file | - | No |
+
+> Note:
+>
+> 1. Iceberg JDBC Catalog supports various relational databases as backend
storage, including PostgreSQL, MySQL, SQLite, etc.
+>
+> 2. Ensure the JDBC driver JAR file is accessible. You can specify the driver
location via `iceberg.jdbc.driver_url`.
+
+## Example Configurations
+
+### PostgreSQL as Metadata Storage
+
+Using PostgreSQL database to store Iceberg metadata:
+
+```sql
+CREATE CATALOG iceberg_jdbc_postgresql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:postgresql://127.0.0.1:5432/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.postgresql.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>',
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### MySQL as Metadata Storage
+
+Using MySQL database to store Iceberg metadata:
+
+```sql
+CREATE CATALOG iceberg_jdbc_mysql PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:mysql://127.0.0.1:3306/iceberg_db',
+ 'iceberg.jdbc.user' = 'iceberg_user',
+ 'iceberg.jdbc.password' = 'password',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'com.mysql.cj.jdbc.Driver',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
+
+### SQLite as Metadata Storage
+
+Using SQLite database to store Iceberg metadata (suitable for testing
environments):
+
+```sql
+CREATE CATALOG iceberg_jdbc_sqlite PROPERTIES (
+ 'type' = 'iceberg',
+ 'iceberg.catalog.type' = 'jdbc',
+ 'iceberg.jdbc.uri' = 'jdbc:sqlite:/tmp/iceberg_catalog.db',
+ 'iceberg.jdbc.init-catalog-tables' = 'true',
+ 'iceberg.jdbc.schema-version' = 'V1',
+ 'iceberg.jdbc.driver_class' = 'org.sqlite.JDBC',
+ 'iceberg.jdbc.driver_url' = '<jdbc_driver_jar>'
+ 'warehouse' = 's3://bucket/warehouse',
+ 's3.access_key' = '<ak>',
+ 's3.secret_key' = '<sk>',
+ 's3.endpoint' = 'https://s3.us-east-1.amazonaws.com',
+ 's3.region' = 'us-east-1'
+);
+```
diff --git a/versioned_sidebars/version-3.x-sidebars.json
b/versioned_sidebars/version-3.x-sidebars.json
index 4e4d45509a3..859ec9cbbbf 100644
--- a/versioned_sidebars/version-3.x-sidebars.json
+++ b/versioned_sidebars/version-3.x-sidebars.json
@@ -419,6 +419,7 @@
"lakehouse/metastores/google-dataproc-metastore",
"lakehouse/metastores/aliyun-dlf",
"lakehouse/metastores/iceberg-rest",
+ "lakehouse/metastores/iceberg-jdbc",
"lakehouse/metastores/filesystem"
]
},
diff --git a/versioned_sidebars/version-4.x-sidebars.json
b/versioned_sidebars/version-4.x-sidebars.json
index e3dcf6bda14..dc5d220ff95 100644
--- a/versioned_sidebars/version-4.x-sidebars.json
+++ b/versioned_sidebars/version-4.x-sidebars.json
@@ -471,6 +471,7 @@
"lakehouse/metastores/google-dataproc-metastore",
"lakehouse/metastores/aliyun-dlf",
"lakehouse/metastores/iceberg-rest",
+ "lakehouse/metastores/iceberg-jdbc",
"lakehouse/metastores/filesystem"
]
},
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
