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 b3ec64b1da0 [fix](catalog) opt example version info (#2907)
b3ec64b1da0 is described below
commit b3ec64b1da051b20b0315a82f4f3311427680490
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Mon Sep 22 22:50:39 2025 -0700
[fix](catalog) opt example version info (#2907)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/lakehouse/catalogs/hive-catalog.mdx | 2 +-
docs/lakehouse/catalogs/iceberg-catalog.mdx | 4 ++--
docs/lakehouse/catalogs/paimon-catalog.mdx | 11 ++++++++---
.../current/lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../current/lakehouse/catalogs/iceberg-catalog.mdx | 4 ++--
.../current/lakehouse/catalogs/paimon-catalog.mdx | 11 ++++++++---
.../version-2.1/lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../version-2.1/lakehouse/catalogs/iceberg-catalog.mdx | 4 ++--
.../version-2.1/lakehouse/catalogs/paimon-catalog.mdx | 11 ++++++++---
.../version-3.0/lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../version-3.0/lakehouse/catalogs/iceberg-catalog.mdx | 4 ++--
.../version-3.0/lakehouse/catalogs/paimon-catalog.mdx | 11 ++++++++---
.../version-2.1/lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../version-2.1/lakehouse/catalogs/iceberg-catalog.mdx | 4 ++--
.../version-2.1/lakehouse/catalogs/paimon-catalog.mdx | 11 ++++++++---
.../version-3.0/lakehouse/catalogs/hive-catalog.mdx | 2 +-
.../version-3.0/lakehouse/catalogs/iceberg-catalog.mdx | 4 ++--
.../version-3.0/lakehouse/catalogs/paimon-catalog.mdx | 11 ++++++++---
18 files changed, 66 insertions(+), 36 deletions(-)
diff --git a/docs/lakehouse/catalogs/hive-catalog.mdx
b/docs/lakehouse/catalogs/hive-catalog.mdx
index 1eb12eb12e0..46205b43285 100644
--- a/docs/lakehouse/catalogs/hive-catalog.mdx
+++ b/docs/lakehouse/catalogs/hive-catalog.mdx
@@ -211,7 +211,7 @@ Hive transactional tables are supported from version 3.x
onwards. For details, r
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG hive_hms_on_s3_iamrole PROPERTIES (
'type' = 'hms',
diff --git a/docs/lakehouse/catalogs/iceberg-catalog.mdx
b/docs/lakehouse/catalogs/iceberg-catalog.mdx
index 366f0e425eb..e80dc1f5101 100644
--- a/docs/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/docs/lakehouse/catalogs/iceberg-catalog.mdx
@@ -191,7 +191,7 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG iceberg_hms_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
@@ -882,7 +882,7 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG iceberg_fs_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
diff --git a/docs/lakehouse/catalogs/paimon-catalog.mdx
b/docs/lakehouse/catalogs/paimon-catalog.mdx
index 43ee177d22a..70d1746ada3 100644
--- a/docs/lakehouse/catalogs/paimon-catalog.mdx
+++ b/docs/lakehouse/catalogs/paimon-catalog.mdx
@@ -167,7 +167,7 @@ The currently dependent Paimon version is 1.0.0.
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role
(3.1.221+)
```sql
CREATE CATALOG paimon_hms_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -456,7 +456,7 @@ The currently dependent Paimon version is 1.0.0.
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG paimon_fs_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -703,8 +703,13 @@ Doris > SELECT snapshot_id,commit_time FROM
paimon_tbl$snapshots;
You can use `FOR TIME AS OF` and `FOR VERSION AS OF` statements to read
historical version data based on snapshot ID or the time when the snapshot was
created. Examples:
```sql
--- Notice: The time must be precise down to the millisecond.
+-- Notice:
+-- Before 3.1.1, only support format like YYYY-MM-DD HH:MM:SS.SSS
+-- After 3.1.2, support YYYY-MM-DD HH:MM:SS and YYYY-MM-DD
SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52.740";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17";
+
-- Notice: The timestamp must be precise down to the millisecond.
SELECT * FROM paimon_tbl FOR TIME AS OF 1755381952740;
-- Use snapshot id
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 e85042b18d9..b62672f038c 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
@@ -220,7 +220,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG hive_hms_on_s3_iamrole PROPERTIES (
'type' = 'hms',
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 b74a54933ed..8cdfae5db59 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
@@ -203,7 +203,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG iceberg_hms_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
@@ -894,7 +894,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG iceberg_fs_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
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 69dc5ef0fc4..251d8b3a9ba 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
@@ -166,7 +166,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.access_key' = '<ak>',
's3.secret_key' = '<sk>'
);
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG paimon_hms_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -455,7 +455,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG paimon_fs_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -702,8 +702,13 @@ Doris > SELECT snapshot_id,commit_time FROM
paimon_tbl$snapshots;
可以使用 `FOR TIME AS OF` 和 `FOR VERSION AS OF` 语句，根据快照 ID 或者快照产生的时间读取历史版本的数据。示例如下：
```sql
--- Notice: The time must be precise down to the millisecond.
+-- Notice:
+-- Before 3.1.1, only support format like YYYY-MM-DD HH:MM:SS.SSS
+-- After 3.1.2, support YYYY-MM-DD HH:MM:SS and YYYY-MM-DD
SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52.740";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17";
+
-- Notice: The timestamp must be precise down to the millisecond.
SELECT * FROM paimon_tbl FOR TIME AS OF 1755381952740;
-- Use snapshot id
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 e85042b18d9..b62672f038c 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
@@ -220,7 +220,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG hive_hms_on_s3_iamrole PROPERTIES (
'type' = 'hms',
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 b74a54933ed..8cdfae5db59 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
@@ -203,7 +203,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG iceberg_hms_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
@@ -894,7 +894,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG iceberg_fs_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
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 69dc5ef0fc4..251d8b3a9ba 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
@@ -166,7 +166,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.access_key' = '<ak>',
's3.secret_key' = '<sk>'
);
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG paimon_hms_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -455,7 +455,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG paimon_fs_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -702,8 +702,13 @@ Doris > SELECT snapshot_id,commit_time FROM
paimon_tbl$snapshots;
可以使用 `FOR TIME AS OF` 和 `FOR VERSION AS OF` 语句，根据快照 ID 或者快照产生的时间读取历史版本的数据。示例如下：
```sql
--- Notice: The time must be precise down to the millisecond.
+-- Notice:
+-- Before 3.1.1, only support format like YYYY-MM-DD HH:MM:SS.SSS
+-- After 3.1.2, support YYYY-MM-DD HH:MM:SS and YYYY-MM-DD
SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52.740";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17";
+
-- Notice: The timestamp must be precise down to the millisecond.
SELECT * FROM paimon_tbl FOR TIME AS OF 1755381952740;
-- Use snapshot id
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/hive-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/hive-catalog.mdx
index e85042b18d9..b62672f038c 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/hive-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/hive-catalog.mdx
@@ -220,7 +220,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG hive_hms_on_s3_iamrole PROPERTIES (
'type' = 'hms',
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/iceberg-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/iceberg-catalog.mdx
index b74a54933ed..8cdfae5db59 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/iceberg-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/iceberg-catalog.mdx
@@ -203,7 +203,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG iceberg_hms_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
@@ -894,7 +894,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG iceberg_fs_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/paimon-catalog.mdx
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/paimon-catalog.mdx
index 69dc5ef0fc4..251d8b3a9ba 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/paimon-catalog.mdx
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/lakehouse/catalogs/paimon-catalog.mdx
@@ -166,7 +166,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.access_key' = '<ak>',
's3.secret_key' = '<sk>'
);
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG paimon_hms_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -455,7 +455,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
's3.secret_key' = '<sk>'
);
```
- 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.1+)
+ 使用 IAM Assumed Role 的方式获取 S3 访问凭证 (3.1.2+)
```sql
CREATE CATALOG paimon_fs_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -702,8 +702,13 @@ Doris > SELECT snapshot_id,commit_time FROM
paimon_tbl$snapshots;
可以使用 `FOR TIME AS OF` 和 `FOR VERSION AS OF` 语句，根据快照 ID 或者快照产生的时间读取历史版本的数据。示例如下：
```sql
--- Notice: The time must be precise down to the millisecond.
+-- Notice:
+-- Before 3.1.1, only support format like YYYY-MM-DD HH:MM:SS.SSS
+-- After 3.1.2, support YYYY-MM-DD HH:MM:SS and YYYY-MM-DD
SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52.740";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17";
+
-- Notice: The timestamp must be precise down to the millisecond.
SELECT * FROM paimon_tbl FOR TIME AS OF 1755381952740;
-- Use snapshot id
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 1eb12eb12e0..46205b43285 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/hive-catalog.mdx
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/hive-catalog.mdx
@@ -211,7 +211,7 @@ Hive transactional tables are supported from version 3.x
onwards. For details, r
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG hive_hms_on_s3_iamrole PROPERTIES (
'type' = 'hms',
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 366f0e425eb..e80dc1f5101 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/iceberg-catalog.mdx
@@ -191,7 +191,7 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG iceberg_hms_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
@@ -882,7 +882,7 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG iceberg_fs_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
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 43ee177d22a..70d1746ada3 100644
--- a/versioned_docs/version-2.1/lakehouse/catalogs/paimon-catalog.mdx
+++ b/versioned_docs/version-2.1/lakehouse/catalogs/paimon-catalog.mdx
@@ -167,7 +167,7 @@ The currently dependent Paimon version is 1.0.0.
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role
(3.1.221+)
```sql
CREATE CATALOG paimon_hms_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -456,7 +456,7 @@ The currently dependent Paimon version is 1.0.0.
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG paimon_fs_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -703,8 +703,13 @@ Doris > SELECT snapshot_id,commit_time FROM
paimon_tbl$snapshots;
You can use `FOR TIME AS OF` and `FOR VERSION AS OF` statements to read
historical version data based on snapshot ID or the time when the snapshot was
created. Examples:
```sql
--- Notice: The time must be precise down to the millisecond.
+-- Notice:
+-- Before 3.1.1, only support format like YYYY-MM-DD HH:MM:SS.SSS
+-- After 3.1.2, support YYYY-MM-DD HH:MM:SS and YYYY-MM-DD
SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52.740";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17";
+
-- Notice: The timestamp must be precise down to the millisecond.
SELECT * FROM paimon_tbl FOR TIME AS OF 1755381952740;
-- Use snapshot id
diff --git a/versioned_docs/version-3.0/lakehouse/catalogs/hive-catalog.mdx
b/versioned_docs/version-3.0/lakehouse/catalogs/hive-catalog.mdx
index 1eb12eb12e0..46205b43285 100644
--- a/versioned_docs/version-3.0/lakehouse/catalogs/hive-catalog.mdx
+++ b/versioned_docs/version-3.0/lakehouse/catalogs/hive-catalog.mdx
@@ -211,7 +211,7 @@ Hive transactional tables are supported from version 3.x
onwards. For details, r
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG hive_hms_on_s3_iamrole PROPERTIES (
'type' = 'hms',
diff --git a/versioned_docs/version-3.0/lakehouse/catalogs/iceberg-catalog.mdx
b/versioned_docs/version-3.0/lakehouse/catalogs/iceberg-catalog.mdx
index 366f0e425eb..e80dc1f5101 100644
--- a/versioned_docs/version-3.0/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/versioned_docs/version-3.0/lakehouse/catalogs/iceberg-catalog.mdx
@@ -191,7 +191,7 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG iceberg_hms_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
@@ -882,7 +882,7 @@ The current Iceberg dependency is version 1.6.1, which is
compatible with higher
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG iceberg_fs_on_s3_iamrole PROPERTIES (
'type' = 'iceberg',
diff --git a/versioned_docs/version-3.0/lakehouse/catalogs/paimon-catalog.mdx
b/versioned_docs/version-3.0/lakehouse/catalogs/paimon-catalog.mdx
index 43ee177d22a..70d1746ada3 100644
--- a/versioned_docs/version-3.0/lakehouse/catalogs/paimon-catalog.mdx
+++ b/versioned_docs/version-3.0/lakehouse/catalogs/paimon-catalog.mdx
@@ -167,7 +167,7 @@ The currently dependent Paimon version is 1.0.0.
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role
(3.1.221+)
```sql
CREATE CATALOG paimon_hms_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -456,7 +456,7 @@ The currently dependent Paimon version is 1.0.0.
's3.secret_key' = '<sk>'
);
```
- Obtaining S3 access credentials using an IAM Assumed Role (3.1.1+)
+ Obtaining S3 access credentials using an IAM Assumed Role (3.1.2+)
```sql
CREATE CATALOG paimon_fs_on_s3_iamrole PROPERTIES (
'type' = 'paimon',
@@ -703,8 +703,13 @@ Doris > SELECT snapshot_id,commit_time FROM
paimon_tbl$snapshots;
You can use `FOR TIME AS OF` and `FOR VERSION AS OF` statements to read
historical version data based on snapshot ID or the time when the snapshot was
created. Examples:
```sql
--- Notice: The time must be precise down to the millisecond.
+-- Notice:
+-- Before 3.1.1, only support format like YYYY-MM-DD HH:MM:SS.SSS
+-- After 3.1.2, support YYYY-MM-DD HH:MM:SS and YYYY-MM-DD
SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52.740";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17 06:05:52";
+SELECT * FROM paimon_tbl FOR TIME AS OF "2025-08-17";
+
-- Notice: The timestamp must be precise down to the millisecond.
SELECT * FROM paimon_tbl FOR TIME AS OF 1755381952740;
-- Use snapshot id
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
