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 11d963e7870 [doc](timestamptz) support timestamptz mapping in external
catalog (#3285)
11d963e7870 is described below
commit 11d963e78706721f97b99f4020a68ca1ee136d91
Author: zhangstar333 <[email protected]>
AuthorDate: Mon Jan 19 22:47:04 2026 +0800
[doc](timestamptz) support timestamptz mapping in external catalog (#3285)
## Versions
- [x] dev
- [x] 4.x
- [ ] 3.x
- [ ] 2.1
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
Co-authored-by: Calvin Kirs <[email protected]>
---
docs/lakehouse/catalogs/hive-catalog.mdx | 1 +
docs/lakehouse/catalogs/iceberg-catalog.mdx | 4 +++-
docs/lakehouse/catalogs/jdbc-mysql-catalog.md | 2 +-
docs/lakehouse/catalogs/jdbc-oracle-catalog.md | 1 +
docs/lakehouse/catalogs/jdbc-pg-catalog.md | 3 ++-
docs/lakehouse/catalogs/paimon-catalog.mdx | 4 +++-
docs/sql-manual/sql-functions/table-valued-functions/hdfs.md | 1 +
docs/sql-manual/sql-functions/table-valued-functions/local.md | 1 +
docs/sql-manual/sql-functions/table-valued-functions/s3.md | 1 +
.../current/lakehouse/catalogs/hive-catalog.mdx | 1 +
.../current/lakehouse/catalogs/iceberg-catalog.mdx | 4 +++-
.../current/lakehouse/catalogs/jdbc-mysql-catalog.md | 2 +-
.../current/lakehouse/catalogs/jdbc-oracle-catalog.md | 1 +
.../current/lakehouse/catalogs/jdbc-pg-catalog.md | 3 ++-
.../current/lakehouse/catalogs/paimon-catalog.mdx | 4 +++-
.../current/sql-manual/sql-functions/table-valued-functions/hdfs.md | 2 +-
.../current/sql-manual/sql-functions/table-valued-functions/local.md | 1 +
.../current/sql-manual/sql-functions/table-valued-functions/s3.md | 1 +
.../version-4.x/lakehouse/catalogs/hive-catalog.mdx | 1 +
.../version-4.x/lakehouse/catalogs/iceberg-catalog.mdx | 4 +++-
.../version-4.x/lakehouse/catalogs/jdbc-mysql-catalog.md | 2 +-
.../version-4.x/lakehouse/catalogs/jdbc-oracle-catalog.md | 1 +
.../version-4.x/lakehouse/catalogs/jdbc-pg-catalog.md | 3 ++-
.../version-4.x/lakehouse/catalogs/paimon-catalog.mdx | 4 +++-
.../sql-manual/sql-functions/table-valued-functions/hdfs.md | 1 +
.../sql-manual/sql-functions/table-valued-functions/local.md | 1 +
.../version-4.x/sql-manual/sql-functions/table-valued-functions/s3.md | 2 ++
versioned_docs/version-4.x/lakehouse/catalogs/hive-catalog.mdx | 1 +
versioned_docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx | 4 +++-
versioned_docs/version-4.x/lakehouse/catalogs/jdbc-mysql-catalog.md | 2 +-
versioned_docs/version-4.x/lakehouse/catalogs/jdbc-oracle-catalog.md | 1 +
versioned_docs/version-4.x/lakehouse/catalogs/jdbc-pg-catalog.md | 3 ++-
versioned_docs/version-4.x/lakehouse/catalogs/paimon-catalog.mdx | 4 +++-
.../sql-manual/sql-functions/table-valued-functions/hdfs.md | 2 ++
.../sql-manual/sql-functions/table-valued-functions/local.md | 2 ++
.../version-4.x/sql-manual/sql-functions/table-valued-functions/s3.md | 1 +
36 files changed, 59 insertions(+), 17 deletions(-)
diff --git a/docs/lakehouse/catalogs/hive-catalog.mdx
b/docs/lakehouse/catalogs/hive-catalog.mdx
index baea8b387a7..43886a5d71a 100644
--- a/docs/lakehouse/catalogs/hive-catalog.mdx
+++ b/docs/lakehouse/catalogs/hive-catalog.mdx
@@ -143,6 +143,7 @@ Hive transactional tables are supported from version 3.x
onwards. For details, r
| varchar(N) | varchar(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.|
+| timestamp with local time zone| datetime/timestamptz | The
`enable.mapping.timestamp_tz` property (supported since version 4.0.3) controls
the mapping behavior. By default, it is set to `false`, in which case the type
is mapped to `datetime`. When set to `true`, it is mapped to the `timestamptz`
type. |
| array | array |
|
| map | map |
|
| struct | struct |
|
diff --git a/docs/lakehouse/catalogs/iceberg-catalog.mdx
b/docs/lakehouse/catalogs/iceberg-catalog.mdx
index 3a74490f01c..ff99b712219 100644
--- a/docs/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/docs/lakehouse/catalogs/iceberg-catalog.mdx
@@ -141,7 +141,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| decimal(P, S) | decimal(P, S) |
|
| date | date |
|
| timestamp (Timestamp without timezone) | datetime(6) | Mapped to
datetime with precision 6 |
-| timestamptz (Timestamp with timezone) | datetime(6) | Mapped to
datetime with precision 6 |
+| timestamptz (Timestamp with timezone) | datetime(6)/timestamptz(6) | Mapped
to datetime with precision 6.The `enable.mapping.timestamp_tz` property
(supported since version 4.0.3) controls the mapping behavior. By default, it
is set to `false`, in which case the type is mapped to `datetime`. When set to
`true`, it is mapped to the `timestamptz` type. |
| 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.|
@@ -156,6 +156,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
> Doris currently does not support `Timestamp` types with timezone. All
> `timestamp` and `timestamptz` will be uniformly mapped to `datetime(N)`
> type. However, during reading and writing, Doris will correctly handle
> timezones based on the actual source type. For example, after specifying a
> timezone with `SET time_zone=<tz>`, it will affect the reading and writing
> results of `timestamptz` columns.
>
> You can check whether the source type has timezone information in the Extra
> column of the `DESCRIBE table_name` statement. If it shows `WITH_TIMEZONE`,
> it indicates that the source type is a timezone-aware type. (Supported since
> 3.1.0).
+>
+> Supported since version 4.0.3, `timestamptz` (timestamp with time zone) can
be mapped to the Doris `timestamptz` type.
## Namespace Mapping
diff --git a/docs/lakehouse/catalogs/jdbc-mysql-catalog.md
b/docs/lakehouse/catalogs/jdbc-mysql-catalog.md
index 50d55234b7e..f232e3d3f94 100644
--- a/docs/lakehouse/catalogs/jdbc-mysql-catalog.md
+++ b/docs/lakehouse/catalogs/jdbc-mysql-catalog.md
@@ -78,7 +78,7 @@ When mapping MySQL, a Database in Doris corresponds to a
Database in MySQL. A Ta
| decimal(P, S) | decimal(P, S) |
|
| unsigned decimal(P, S) | decimal(P + 1, S) / string | If it
exceeds the maximum precision supported by Doris, it will be handled by String.
Note that when this type is mapped to String, it only supports queries and
cannot write to MySQL. |
| date | date |
|
-| timestamp(S) | datetime(S) |
|
+| timestamp(S) | datetime(S) / timestamptz(S) | Controlled by the
`enable.mapping.timestamp_tz` property (supported since version 4.0.3). By
default, it is set to `false`, in which case it is mapped to `datetime`; when
set to `true`, it is mapped to the `timestamptz` type. |
| datetime(S) | datetime(S) |
|
| year | smallint | Doris
does not support the year type, so the year type is mapped to smallint.
|
| time | string | Doris
does not support the time type, so the time type is mapped to string.
|
diff --git a/docs/lakehouse/catalogs/jdbc-oracle-catalog.md
b/docs/lakehouse/catalogs/jdbc-oracle-catalog.md
index a6d3139b68c..a4678faa2de 100644
--- a/docs/lakehouse/catalogs/jdbc-oracle-catalog.md
+++ b/docs/lakehouse/catalogs/jdbc-oracle-catalog.md
@@ -58,6 +58,7 @@ When mapping Oracle, a Database in Apache Doris corresponds
to a User in Oracle.
| float/real | double
|
|
| date | date
|
|
| timestamp | datetime(S)
|
|
+| timestamp(s) with local time zone | datetime / timestamptz | Controlled by
the `enable.mapping.timestamp_tz` property (supported since version 4.0.3). By
default, it is `false`, in which case it is mapped to `datetime`; when set to
`true`, it is mapped to the `timestamptz` type. |
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
diff --git a/docs/lakehouse/catalogs/jdbc-pg-catalog.md
b/docs/lakehouse/catalogs/jdbc-pg-catalog.md
index eb8c971ed2e..8eaff9e1813 100644
--- a/docs/lakehouse/catalogs/jdbc-pg-catalog.md
+++ b/docs/lakehouse/catalogs/jdbc-pg-catalog.md
@@ -73,7 +73,8 @@ When mapping PostgreSQL, a Database in Doris corresponds to a
Schema under a spe
| bigserial | bigint |
|
| char(N) | char(N) |
|
| varchar/text | string |
|
-| timestamp(S)/timestampz(S) | datetime(S) |
|
+| timestamp(S) | datetime(S) |
|
+| timestamptz(S) | datetime(S) / timestamptz(S) | Controlled by the
`enable.mapping.timestamp_tz` property (supported since version 4.0.3). By
default, it is `false`, in which case it is mapped to `datetime`; when set to
`true`, it is mapped to the `timestamptz` type. |
| date | date |
|
| json/jsonb | string | For
better reading and computing performance balance, Doris maps JSON type to
STRING type. |
| time | string | Doris
does not support time type, time type will be mapped to string.
|
diff --git a/docs/lakehouse/catalogs/paimon-catalog.mdx
b/docs/lakehouse/catalogs/paimon-catalog.mdx
index dc58f2d43a1..b56a19b6acc 100644
--- a/docs/lakehouse/catalogs/paimon-catalog.mdx
+++ b/docs/lakehouse/catalogs/paimon-catalog.mdx
@@ -147,7 +147,7 @@ The currently dependent Paimon version is 1.0.0.
| 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). |
+| timestamp\_with\_local\_time\_zone | datetime(N)/timestamptz(N) | Mapped
according to precision. If precision is greater than 6, it maps to a maximum of
6 (may cause precision loss). The `enable.mapping.timestamp_tz` property
(supported since version 4.0.3) controls the mapping behavior. By default, it
is set to `false`, in which case the type is mapped to `datetime`. When set to
`true`, it is mapped to the `timestamptz` type.|
| array | array |
|
| map | map |
|
| row | struct |
|
@@ -158,6 +158,8 @@ The currently dependent Paimon version is 1.0.0.
> Doris currently does not support `Timestamp` types with timezone. All
> `timestamp_without_time_zone` and `timestamp_with_local_time_zone` will be
> uniformly mapped to `datetime(N)` type. However, during reading, Doris will
> correctly handle timezones based on the actual source type. For example,
> after specifying a timezone with `SET time_zone=<tz>`, it will affect the
> return results of `timestamp_with_local_time_zone` columns.
>
> You can check whether the source type contains timezone information in the
> Extra column of the `DESCRIBE table_name` statement. If it displays
> `WITH_TIMEZONE`, it indicates that the source type is a timezone-aware type.
> (This feature is supported since 3.0.8)
+>
+> Supported since version 4.0.3, `timestamp_with_local_time_zone` can be
mapped to Doris `timestamptz` type.
## Examples
### Hive Metastore
diff --git a/docs/sql-manual/sql-functions/table-valued-functions/hdfs.md
b/docs/sql-manual/sql-functions/table-valued-functions/hdfs.md
index 4d69c673bf4..6a962ce9915 100644
--- a/docs/sql-manual/sql-functions/table-valued-functions/hdfs.md
+++ b/docs/sql-manual/sql-functions/table-valued-functions/hdfs.md
@@ -48,6 +48,7 @@ LOCAL(
| `skip_lines` | For CSV format imports, optional, defaults to `0`,
which means skipping the first few lines of the CSV file. When the format is
`csv_with_names` or `csv_with_names_and_types`, this parameter is ignored. |
For CSV format |
| `path_partition_keys` | Optional, specifies the partition column names
carried in the file path, e.g., `/path/to/city=beijing/date="2023-07-09"`, then
fill in `path_partition_keys="city,date"`. This will automatically read the
corresponding column names and values from the path for import. |
|
| `enable_mapping_varbinary` | Defaults to false. When reading PARQUET/ORC, it
maps the BYTE_ARRAY type to STRING. When enabled, it maps to VARBINARY type. |
Supported since 4.0.3 |
+| `enable_mapping_timestamp_tz` | Defaults to `false`. When reading PARQUET
(`TIMESTAMP` with `isAdjustedToUTC`) or ORC (`TIMESTAMP_INSTANT`), the type is
mapped to `DATETIME`. When enabled, it is mapped to the `TIMESTAMPTZ` type. |
Supported since version 4.0.3 |
## Access Control Requirements
| Privilege | Object | Notes |
diff --git a/docs/sql-manual/sql-functions/table-valued-functions/local.md
b/docs/sql-manual/sql-functions/table-valued-functions/local.md
index 4d69c673bf4..6a962ce9915 100644
--- a/docs/sql-manual/sql-functions/table-valued-functions/local.md
+++ b/docs/sql-manual/sql-functions/table-valued-functions/local.md
@@ -48,6 +48,7 @@ LOCAL(
| `skip_lines` | For CSV format imports, optional, defaults to `0`,
which means skipping the first few lines of the CSV file. When the format is
`csv_with_names` or `csv_with_names_and_types`, this parameter is ignored. |
For CSV format |
| `path_partition_keys` | Optional, specifies the partition column names
carried in the file path, e.g., `/path/to/city=beijing/date="2023-07-09"`, then
fill in `path_partition_keys="city,date"`. This will automatically read the
corresponding column names and values from the path for import. |
|
| `enable_mapping_varbinary` | Defaults to false. When reading PARQUET/ORC, it
maps the BYTE_ARRAY type to STRING. When enabled, it maps to VARBINARY type. |
Supported since 4.0.3 |
+| `enable_mapping_timestamp_tz` | Defaults to `false`. When reading PARQUET
(`TIMESTAMP` with `isAdjustedToUTC`) or ORC (`TIMESTAMP_INSTANT`), the type is
mapped to `DATETIME`. When enabled, it is mapped to the `TIMESTAMPTZ` type. |
Supported since version 4.0.3 |
## Access Control Requirements
| Privilege | Object | Notes |
diff --git a/docs/sql-manual/sql-functions/table-valued-functions/s3.md
b/docs/sql-manual/sql-functions/table-valued-functions/s3.md
index 07a2ceac3be..07e5e4db552 100644
--- a/docs/sql-manual/sql-functions/table-valued-functions/s3.md
+++ b/docs/sql-manual/sql-functions/table-valued-functions/s3.md
@@ -60,6 +60,7 @@ S3(
| `path_partition_keys` | - | Specifies partition column names
in file path. For example, for path `/path/to/city=beijing/date="2023-07-09"`,
set `path_partition_keys="city,date"` to automatically read column names and
values from path |
|
| `resource` | - | Specifies Resource name. S3 TVF
can use existing S3 Resource to access S3 directly. For creating S3 Resource,
refer to
[CREATE-RESOURCE](../../sql-statements/cluster-management/compute-management/CREATE-RESOURCE).
Supported from version 2.1.4. |
|
| `enable_mapping_varbinary` | `false` | Maps BYTE_ARRAY type to STRING
when reading PARQUET/ORC. When enabled, maps to VARBINARY type instead.
| Supported from version 4.0.3
|
+| `enable_mapping_timestamp_tz` | Defaults to `false`. When reading PARQUET
(`TIMESTAMP` with `isAdjustedToUTC`) or ORC (`TIMESTAMP_INSTANT`), the type is
mapped to `DATETIME`. When enabled, it is mapped to the `TIMESTAMPTZ` type. |
Supported since version 4.0.3 |
## Notes
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 99faa91a2b4..1f2b2c80135 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
@@ -154,6 +154,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| varchar(N) | varchar(N) | |
| string | string | |
| binary | string/varbinary| 由 properties 中 `enable.mapping.varbinary`
(4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| timestamp with local time zone| datetime/timestamptz | 由 properties 中
`enable.mapping.timestamp_tz` (4.0.3 后开始支持) 属性控制，默认为 `false`, 则映射到 `datetime`;
为 `true` 时，则映射到 `timestamptz` 类型 |
| 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 94c38890d48..28f6ba545d5 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
@@ -158,7 +158,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| decimal(P, S) | decimal(P, S) |
|
| date | date |
|
| timestamp (Timestamp without timezone) | datetime(6) | 固定映射到精度为 6 的
datetime |
-| timestamptz (Timestamp with timezone) | datetime(6) | 固定映射到精度为 6 的
datetime |
+| timestamptz (Timestamp with timezone) | datetime(6)/timestamptz(6)
| 固定映射到精度为 6 的 datetime。由 properties 中 `enable.mapping.timestamp_tz` (4.0.3
后开始支持) 属性控制，默认为 `false`, 则映射到 `datetime`; 为 `true` 时，则映射到 `timestamptz` 类型 |
| fixed(N) | char(N) |
|
| string | string |
|
| binary | string/varbinary |由 properties
中 `enable.mapping.varbinary` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。 |
@@ -173,6 +173,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
> Doris 当前不支持带时区的 `Timestamp` 类型。所有 `timestamp` 和 `timestamptz` 会统一映射到
> `datetime(N)` 类型上。但在读取和写入时，Doris 会根据实际源类型正确处理时区。如通过 `SET time_zone=<tz>`
> 指定时区后，会影响 `timestamptz` 列的读取和写入结果。
>
> 可以在 `DESCRIBE table_name` 语句中的 Extra 列查看源类型是否带时区信息。如显示
> `WITH_TIMEZONE`，则表示源类型是带时区的类型。(该功能自 3.1.0 版本支持)。
+>
+> 4.0.3 后开始支持, 可以映射 `timestamptz (Timestamp with timezone)` 到 Doris 的
`timestamptz` 类型。
## Namespace 映射
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 b0bfb4abf26..7e4b733ba67 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
@@ -78,7 +78,7 @@ CREATE CATALOG mysql_catalog PROPERTIES (
| decimal(P, S) | decimal(P, S) |
|
| unsigned decimal(P, S) | decimal(P + 1, S) / string | 如果超过
Doris 支持的最大精度，则会使用 String 承接。注意在此类型被映射为 String 时，只能支持查询，不能对 MySQL 进行写入操作。 |
| date | date |
|
-| timestamp(S) | datetime(S) |
|
+| timestamp(S) | datetime(S)/timestamptz(S)
| properties 中 `enable.mapping.timestamp_tz` (4.0.3 后开始支持) 属性控制，默认为
`false`, 则映射到 `datetime`; 为 `true` 时，则映射到 `timestamptz` 类型
|
| datetime(S) | datetime(S) |
|
| year | smallint | Doris
不支持 year 类型，year 类型会被映射为 smallint。 |
| time | string | Doris
不支持 time 类型，time 类型会被映射为 string。 |
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 84fe2c72d06..0963845e2de 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
@@ -58,6 +58,7 @@ CREATE CATALOG oracle_catalog PROPERTIES (
| float/real | double
|
|
| date | date
|
|
| timestamp | datetime(S)
|
|
+|timestamp(s) with local time zone | datetime / timestamptz| properties 中
`enable.mapping.timestamp_tz` (4.0.3 后开始支持) 属性控制，默认为 `false`, 则映射到 `datetime`;
为 `true` 时，则映射到 `timestamptz` 类型|
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
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 4a484ad3976..7032e329a55 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
@@ -73,7 +73,8 @@ CREATE CATALOG postgresql_catalog PROPERTIES (
| bigserial | bigint |
|
| char(N) | char(N) |
|
| varchar/text | string |
|
-| timestamp(S)/timestampz(S) | datetime(S) |
|
+| timestamp(S) | datetime(S) |
|
+|timestamptz(S)| datetime(s) / timestamptz(s)| properties 中
`enable.mapping.timestamp_tz` (4.0.3 后开始支持) 属性控制，默认为 `false`, 则映射到 `datetime`;
为 `true` 时，则映射到 `timestamptz` 类型
|
| date | date |
|
| json/jsonb | string |
为了更好的读取与计算性能均衡，Doris 会将 JSON 类型映射为 STRING 类型。 |
| time | string | Doris 不支持
time 类型，time 类型会被映射为 string。 |
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 8d6a834823b..86e48213e2b 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
@@ -147,7 +147,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| bianry, varbinary | string/varbinary|由 properties 中
`enable.mapping.varbinary` (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。（可能导致精度丢失） |
+| timestamp\_with\_local\_time\_zone | datetime(N)/timestamptz(N) |
会根据精度进行对应映射。如果精度大于 6，则最大映射到 6。（可能导致精度丢失）。由 properties 中
`enable.mapping.timestamp_tz` (4.0.3 后开始支持) 属性控制，默认为 `false`, 则映射到 `datetime`;
为 `true` 时，则映射到 `timestamptz` 类型 |
| array | array |
|
| map | map |
|
| row | struct |
|
@@ -158,6 +158,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
> Doris 当前不支持带时区的 `Timestamp` 类型。所有 `timestamp_without_time_zone` 和
> `timestamp_with_local_time_zone` 会统一映射到 `datetime(N)` 类型上。但在读取时，Doris
> 会根据实际源类型正确处理时区。如通过 `SET time_zone=<tz>` 指定时区后，会影响
> `timestamp_with_local_time_zone` 列的返回结果。
>
> 可以在 `DESCRIBE table_name` 语句中的 Extra 列查看源类型是否带时区信息。如显示
> `WITH_TIMEZONE`，则表示源类型是带时区的类型。(该功能自 3.0.8 版本支持)。
+>
+> 4.0.3 后开始支持, 可以映射 `timestamp_with_local_time_zone` 到 Doris 的 `timestamptz`
类型。
## 基础示例
### Hive Metastore
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/hdfs.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/hdfs.md
index 9470a432325..ecdb9e9613f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/hdfs.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/hdfs.md
@@ -62,7 +62,7 @@ HDFS(
| `path_partition_keys` |
指定文件路径中携带的分区列名，例如/path/to/city=beijing/date="2023-07-09", 则填写
path_partition_keys="city,date"，将会自动从路径中读取相应列名和列值进行导入
|
|
| `resource` | 指定 Resource 名，HDFS TVF 可以利用已有的 HFDS Resource
来直接访问 HDFS。创建 HDFS Resource 的方法可以参照
[CREATE-RESOURCE](../../sql-statements/cluster-management/compute-management/CREATE-RESOURCE)
| 仅支持 2.1.4 及以上版本
|
|`enable_mapping_varbinary`|默认为 false，在读取 PARQUET / ORC 时将 BYTE_ARRAY 类型映射为
STRING，开启后则会映射到 VARBINAY 类型。| 在 4.0.3 之后开始支持 |
-
+|`enable_mapping_timestamp_tz`|默认为 false，在读取 PARQUET(TIMESTAMP WITH
isAdjustedToUTC) \ ORC(TIMESTAMP_INSTANT) 类型映射为 DATATIME，开启后则会映射到 TIMESTAMPTZ
类型。| 在 4.0.3 之后开始支持 |
## 权限控制
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/local.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/local.md
index b529c97292b..bafeb972a00 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/local.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/local.md
@@ -45,6 +45,7 @@ LOCAL(
| `skip_lines` | 对于 CSV 格式的导入，选填，默认为 0，表示跳过 CSV 文件的前几行。当设置格式为
`csv_with_names` 或 `csv_with_names_and_types` 时，该参数会失效 |
csv 格式 |
| `path_partition_keys`| 选填，指定文件路径中携带的分区列名，例如
`/path/to/city=beijing/date="2023-07-09"`，则填写
`path_partition_keys="city,date"`，将从路径中自动读取相应的列名和列值进行导入 |
|
|`enable_mapping_varbinary`|默认为 false，在读取 PARQUET / ORC 时将 BYTE_ARRAY 类型映射为
STRING，开启后则会映射到 VARBINAY 类型。| 在 4.0.3 之后开始支持 |
+|`enable_mapping_timestamp_tz`|默认为 false，在读取 PARQUET(TIMESTAMP WITH
isAdjustedToUTC) \ ORC(TIMESTAMP_INSTANT) 类型映射为 DATATIME，开启后则会映射到 TIMESTAMPTZ
类型。| 在 4.0.3 之后开始支持 |
## 权限控制
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/s3.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/s3.md
index b431becba8e..1f562af25f1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/s3.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/table-valued-functions/s3.md
@@ -60,6 +60,7 @@ S3(
| `path_partition_keys` | - | 指定文件路径中携带的分区列名。例如路径为
`/path/to/city=beijing/date="2023-07-09"`，则填写
`path_partition_keys="city,date"`，将自动从路径中读取相应的列名和列值进行导入 |
|
| `resource` | - | 指定 Resource 名称。S3 TVF 可以利用已有的 S3
Resource 来直接访问 S3。创建 S3 Resource 的方法可参照
[CREATE-RESOURCE](../../sql-statements/cluster-management/compute-management/CREATE-RESOURCE)。该功能自
2.1.4 版本开始支持。|
|
|`enable_mapping_varbinary`| `false` | 在读取 PARQUET/ORC 时将 BYTE_ARRAY 类型映射为
STRING，开启后则映射为 VARBINARY 类型。| 4.0.3 版本开始支持 |
+|`enable_mapping_timestamp_tz`|默认为 false，在读取 PARQUET(TIMESTAMP WITH
isAdjustedToUTC) \ ORC(TIMESTAMP_INSTANT) 类型映射为 DATATIME，开启后则会映射到 TIMESTAMPTZ
类型。| 在 4.0.3 之后开始支持 |
## 注意事项
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 99faa91a2b4..1f2b2c80135 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
@@ -154,6 +154,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| varchar(N) | varchar(N) | |
| string | string | |
| binary | string/varbinary| 由 properties 中 `enable.mapping.varbinary`
(4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为 `true` 时，则映射到 `varbinary` 类型。|
+| timestamp with local time zone| datetime/timestamptz | 由 properties 中
`enable.mapping.timestamp_tz` (4.0.3 后开始支持) 属性控制，默认为 `false`, 则映射到 `datetime`;
为 `true` 时，则映射到 `timestamptz` 类型 |
| 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 94c38890d48..28f6ba545d5 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
@@ -158,7 +158,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| decimal(P, S) | decimal(P, S) |
|
| date | date |
|
| timestamp (Timestamp without timezone) | datetime(6) | 固定映射到精度为 6 的
datetime |
-| timestamptz (Timestamp with timezone) | datetime(6) | 固定映射到精度为 6 的
datetime |
+| timestamptz (Timestamp with timezone) | datetime(6)/timestamptz(6)
| 固定映射到精度为 6 的 datetime。由 properties 中 `enable.mapping.timestamp_tz` (4.0.3
后开始支持) 属性控制，默认为 `false`, 则映射到 `datetime`; 为 `true` 时，则映射到 `timestamptz` 类型 |
| fixed(N) | char(N) |
|
| string | string |
|
| binary | string/varbinary |由 properties
中 `enable.mapping.varbinary` (4.0.2 后开始支持) 属性控制。默认为 `false`, 则映射到 `string`; 为
`true` 时，则映射到 `varbinary` 类型。 |
@@ -173,6 +173,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
> Doris 当前不支持带时区的 `Timestamp` 类型。所有 `timestamp` 和 `timestamptz` 会统一映射到
> `datetime(N)` 类型上。但在读取和写入时，Doris 会根据实际源类型正确处理时区。如通过 `SET time_zone=<tz>`
> 指定时区后，会影响 `timestamptz` 列的读取和写入结果。
>
> 可以在 `DESCRIBE table_name` 语句中的 Extra 列查看源类型是否带时区信息。如显示
> `WITH_TIMEZONE`，则表示源类型是带时区的类型。(该功能自 3.1.0 版本支持)。
+>
+> 4.0.3 后开始支持, 可以映射 `timestamptz (Timestamp with timezone)` 到 Doris 的
`timestamptz` 类型。
## Namespace 映射
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 b0bfb4abf26..7e4b733ba67 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
@@ -78,7 +78,7 @@ CREATE CATALOG mysql_catalog PROPERTIES (
| decimal(P, S) | decimal(P, S) |
|
| unsigned decimal(P, S) | decimal(P + 1, S) / string | 如果超过
Doris 支持的最大精度，则会使用 String 承接。注意在此类型被映射为 String 时，只能支持查询，不能对 MySQL 进行写入操作。 |
| date | date |
|
-| timestamp(S) | datetime(S) |
|
+| timestamp(S) | datetime(S)/timestamptz(S)
| properties 中 `enable.mapping.timestamp_tz` (4.0.3 后开始支持) 属性控制，默认为
`false`, 则映射到 `datetime`; 为 `true` 时，则映射到 `timestamptz` 类型
|
| datetime(S) | datetime(S) |
|
| year | smallint | Doris
不支持 year 类型，year 类型会被映射为 smallint。 |
| time | string | Doris
不支持 time 类型，time 类型会被映射为 string。 |
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 84fe2c72d06..0963845e2de 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
@@ -58,6 +58,7 @@ CREATE CATALOG oracle_catalog PROPERTIES (
| float/real | double
|
|
| date | date
|
|
| timestamp | datetime(S)
|
|
+|timestamp(s) with local time zone | datetime / timestamptz| properties 中
`enable.mapping.timestamp_tz` (4.0.3 后开始支持) 属性控制，默认为 `false`, 则映射到 `datetime`;
为 `true` 时，则映射到 `timestamptz` 类型|
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
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 4a484ad3976..7032e329a55 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
@@ -73,7 +73,8 @@ CREATE CATALOG postgresql_catalog PROPERTIES (
| bigserial | bigint |
|
| char(N) | char(N) |
|
| varchar/text | string |
|
-| timestamp(S)/timestampz(S) | datetime(S) |
|
+| timestamp(S) | datetime(S) |
|
+|timestamptz(S)| datetime(s) / timestamptz(s)| properties 中
`enable.mapping.timestamp_tz` (4.0.3 后开始支持) 属性控制，默认为 `false`, 则映射到 `datetime`;
为 `true` 时，则映射到 `timestamptz` 类型
|
| date | date |
|
| json/jsonb | string |
为了更好的读取与计算性能均衡，Doris 会将 JSON 类型映射为 STRING 类型。 |
| time | string | Doris 不支持
time 类型，time 类型会被映射为 string。 |
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 8d6a834823b..133e73361c4 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
@@ -147,7 +147,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| bianry, varbinary | string/varbinary|由 properties 中
`enable.mapping.varbinary` (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。（可能导致精度丢失） |
+| timestamp\_with\_local\_time\_zone | datetime(N)/timestamptz(N) |
会根据精度进行对应映射。如果精度大于 6，则最大映射到 6。（可能导致精度丢失）。 properties 中
`enable.mapping.timestamp_tz` (4.0.3 后开始支持) 属性控制，默认为 `false`, 则映射到 `datetime`;
为 `true` 时，则映射到 `timestamptz` 类型 |
| array | array |
|
| map | map |
|
| row | struct |
|
@@ -158,6 +158,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
> Doris 当前不支持带时区的 `Timestamp` 类型。所有 `timestamp_without_time_zone` 和
> `timestamp_with_local_time_zone` 会统一映射到 `datetime(N)` 类型上。但在读取时，Doris
> 会根据实际源类型正确处理时区。如通过 `SET time_zone=<tz>` 指定时区后，会影响
> `timestamp_with_local_time_zone` 列的返回结果。
>
> 可以在 `DESCRIBE table_name` 语句中的 Extra 列查看源类型是否带时区信息。如显示
> `WITH_TIMEZONE`，则表示源类型是带时区的类型。(该功能自 3.0.8 版本支持)。
+>
+> 4.0.3 后开始支持, 可以映射 `timestamp_with_local_time_zone` 到 Doris 的 `timestamptz`
类型。
## 基础示例
### Hive Metastore
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/hdfs.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/hdfs.md
index 9470a432325..46d8cd68862 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/hdfs.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/hdfs.md
@@ -62,6 +62,7 @@ HDFS(
| `path_partition_keys` |
指定文件路径中携带的分区列名，例如/path/to/city=beijing/date="2023-07-09", 则填写
path_partition_keys="city,date"，将会自动从路径中读取相应列名和列值进行导入
|
|
| `resource` | 指定 Resource 名，HDFS TVF 可以利用已有的 HFDS Resource
来直接访问 HDFS。创建 HDFS Resource 的方法可以参照
[CREATE-RESOURCE](../../sql-statements/cluster-management/compute-management/CREATE-RESOURCE)
| 仅支持 2.1.4 及以上版本
|
|`enable_mapping_varbinary`|默认为 false，在读取 PARQUET / ORC 时将 BYTE_ARRAY 类型映射为
STRING，开启后则会映射到 VARBINAY 类型。| 在 4.0.3 之后开始支持 |
+|`enable_mapping_timestamp_tz`|默认为 false，在读取 PARQUET(TIMESTAMP WITH
isAdjustedToUTC) \ ORC(TIMESTAMP_INSTANT) 类型映射为 DATATIME，开启后则会映射到 TIMESTAMPTZ
类型。| 在 4.0.3 之后开始支持 |
## 权限控制
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/local.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/local.md
index b529c97292b..bafeb972a00 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/local.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/local.md
@@ -45,6 +45,7 @@ LOCAL(
| `skip_lines` | 对于 CSV 格式的导入，选填，默认为 0，表示跳过 CSV 文件的前几行。当设置格式为
`csv_with_names` 或 `csv_with_names_and_types` 时，该参数会失效 |
csv 格式 |
| `path_partition_keys`| 选填，指定文件路径中携带的分区列名，例如
`/path/to/city=beijing/date="2023-07-09"`，则填写
`path_partition_keys="city,date"`，将从路径中自动读取相应的列名和列值进行导入 |
|
|`enable_mapping_varbinary`|默认为 false，在读取 PARQUET / ORC 时将 BYTE_ARRAY 类型映射为
STRING，开启后则会映射到 VARBINAY 类型。| 在 4.0.3 之后开始支持 |
+|`enable_mapping_timestamp_tz`|默认为 false，在读取 PARQUET(TIMESTAMP WITH
isAdjustedToUTC) \ ORC(TIMESTAMP_INSTANT) 类型映射为 DATATIME，开启后则会映射到 TIMESTAMPTZ
类型。| 在 4.0.3 之后开始支持 |
## 权限控制
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/s3.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/s3.md
index b431becba8e..866f4cd01ec 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/s3.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-4.x/sql-manual/sql-functions/table-valued-functions/s3.md
@@ -60,6 +60,8 @@ S3(
| `path_partition_keys` | - | 指定文件路径中携带的分区列名。例如路径为
`/path/to/city=beijing/date="2023-07-09"`，则填写
`path_partition_keys="city,date"`，将自动从路径中读取相应的列名和列值进行导入 |
|
| `resource` | - | 指定 Resource 名称。S3 TVF 可以利用已有的 S3
Resource 来直接访问 S3。创建 S3 Resource 的方法可参照
[CREATE-RESOURCE](../../sql-statements/cluster-management/compute-management/CREATE-RESOURCE)。该功能自
2.1.4 版本开始支持。|
|
|`enable_mapping_varbinary`| `false` | 在读取 PARQUET/ORC 时将 BYTE_ARRAY 类型映射为
STRING，开启后则映射为 VARBINARY 类型。| 4.0.3 版本开始支持 |
+|`enable_mapping_timestamp_tz`|默认为 false，在读取 PARQUET(TIMESTAMP WITH
isAdjustedToUTC) \ ORC(TIMESTAMP_INSTANT) 类型映射为 DATATIME，开启后则会映射到 TIMESTAMPTZ
类型。| 在 4.0.3 之后开始支持 |
+
## 注意事项
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 0056d27df03..68b5b513f83 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/hive-catalog.mdx
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/hive-catalog.mdx
@@ -143,6 +143,7 @@ Hive transactional tables are supported from version 3.x
onwards. For details, r
| varchar(N) | varchar(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.|
+| timestamp with local time zone| datetime/timestamptz | The
`enable.mapping.timestamp_tz` property (supported since version 4.0.3) controls
the mapping behavior. By default, it is set to `false`, in which case the type
is mapped to `datetime`. When set to `true`, it is mapped to the `timestamptz`
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 3a74490f01c..ff99b712219 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/iceberg-catalog.mdx
@@ -141,7 +141,7 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
| decimal(P, S) | decimal(P, S) |
|
| date | date |
|
| timestamp (Timestamp without timezone) | datetime(6) | Mapped to
datetime with precision 6 |
-| timestamptz (Timestamp with timezone) | datetime(6) | Mapped to
datetime with precision 6 |
+| timestamptz (Timestamp with timezone) | datetime(6)/timestamptz(6) | Mapped
to datetime with precision 6.The `enable.mapping.timestamp_tz` property
(supported since version 4.0.3) controls the mapping behavior. By default, it
is set to `false`, in which case the type is mapped to `datetime`. When set to
`true`, it is mapped to the `timestamptz` type. |
| 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.|
@@ -156,6 +156,8 @@ CREATE CATALOG [IF NOT EXISTS] catalog_name PROPERTIES (
> Doris currently does not support `Timestamp` types with timezone. All
> `timestamp` and `timestamptz` will be uniformly mapped to `datetime(N)`
> type. However, during reading and writing, Doris will correctly handle
> timezones based on the actual source type. For example, after specifying a
> timezone with `SET time_zone=<tz>`, it will affect the reading and writing
> results of `timestamptz` columns.
>
> You can check whether the source type has timezone information in the Extra
> column of the `DESCRIBE table_name` statement. If it shows `WITH_TIMEZONE`,
> it indicates that the source type is a timezone-aware type. (Supported since
> 3.1.0).
+>
+> Supported since version 4.0.3, `timestamptz` (timestamp with time zone) can
be mapped to the Doris `timestamptz` type.
## Namespace Mapping
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 50d55234b7e..f232e3d3f94 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
@@ -78,7 +78,7 @@ When mapping MySQL, a Database in Doris corresponds to a
Database in MySQL. A Ta
| decimal(P, S) | decimal(P, S) |
|
| unsigned decimal(P, S) | decimal(P + 1, S) / string | If it
exceeds the maximum precision supported by Doris, it will be handled by String.
Note that when this type is mapped to String, it only supports queries and
cannot write to MySQL. |
| date | date |
|
-| timestamp(S) | datetime(S) |
|
+| timestamp(S) | datetime(S) / timestamptz(S) | Controlled by the
`enable.mapping.timestamp_tz` property (supported since version 4.0.3). By
default, it is set to `false`, in which case it is mapped to `datetime`; when
set to `true`, it is mapped to the `timestamptz` type. |
| datetime(S) | datetime(S) |
|
| year | smallint | Doris
does not support the year type, so the year type is mapped to smallint.
|
| time | string | Doris
does not support the time type, so the time type is mapped to string.
|
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 a6d3139b68c..a4678faa2de 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
@@ -58,6 +58,7 @@ When mapping Oracle, a Database in Apache Doris corresponds
to a User in Oracle.
| float/real | double
|
|
| date | date
|
|
| timestamp | datetime(S)
|
|
+| timestamp(s) with local time zone | datetime / timestamptz | Controlled by
the `enable.mapping.timestamp_tz` property (supported since version 4.0.3). By
default, it is `false`, in which case it is mapped to `datetime`; when set to
`true`, it is mapped to the `timestamptz` type. |
| char/nchar | string
|
|
| varchar2/nvarchar2 | string
|
|
| long/raw/long raw/internal | string
|
|
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 eb8c971ed2e..8eaff9e1813 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
@@ -73,7 +73,8 @@ When mapping PostgreSQL, a Database in Doris corresponds to a
Schema under a spe
| bigserial | bigint |
|
| char(N) | char(N) |
|
| varchar/text | string |
|
-| timestamp(S)/timestampz(S) | datetime(S) |
|
+| timestamp(S) | datetime(S) |
|
+| timestamptz(S) | datetime(S) / timestamptz(S) | Controlled by the
`enable.mapping.timestamp_tz` property (supported since version 4.0.3). By
default, it is `false`, in which case it is mapped to `datetime`; when set to
`true`, it is mapped to the `timestamptz` type. |
| date | date |
|
| json/jsonb | string | For
better reading and computing performance balance, Doris maps JSON type to
STRING type. |
| time | string | Doris
does not support time type, time type will be mapped to string.
|
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 6e8d358738d..189371cf831 100644
--- a/versioned_docs/version-4.x/lakehouse/catalogs/paimon-catalog.mdx
+++ b/versioned_docs/version-4.x/lakehouse/catalogs/paimon-catalog.mdx
@@ -147,7 +147,7 @@ The currently dependent Paimon version is 1.0.0.
| 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). |
+| timestamp\_with\_local\_time\_zone | datetime(N)/timestamptz(N) | Mapped
according to precision. If precision is greater than 6, it maps to a maximum of
6 (may cause precision loss). The `enable.mapping.timestamp_tz` property
(supported since version 4.0.3) controls the mapping behavior. By default, it
is set to `false`, in which case the type is mapped to `datetime`. When set to
`true`, it is mapped to the `timestamptz` type.|
| array | array |
|
| map | map |
|
| row | struct |
|
@@ -158,6 +158,8 @@ The currently dependent Paimon version is 1.0.0.
> Doris currently does not support `Timestamp` types with timezone. All
> `timestamp_without_time_zone` and `timestamp_with_local_time_zone` will be
> uniformly mapped to `datetime(N)` type. However, during reading, Doris will
> correctly handle timezones based on the actual source type. For example,
> after specifying a timezone with `SET time_zone=<tz>`, it will affect the
> return results of `timestamp_with_local_time_zone` columns.
>
> You can check whether the source type contains timezone information in the
> Extra column of the `DESCRIBE table_name` statement. If it displays
> `WITH_TIMEZONE`, it indicates that the source type is a timezone-aware type.
> (This feature is supported since 3.0.8)
+>
+> Supported since version 4.0.3, `timestamp_with_local_time_zone` can be
mapped to Doris `timestamptz` type.
## Examples
### Hive Metastore
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/hdfs.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/hdfs.md
index 4d69c673bf4..c4c20cdfb4c 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/hdfs.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/hdfs.md
@@ -48,6 +48,8 @@ LOCAL(
| `skip_lines` | For CSV format imports, optional, defaults to `0`,
which means skipping the first few lines of the CSV file. When the format is
`csv_with_names` or `csv_with_names_and_types`, this parameter is ignored. |
For CSV format |
| `path_partition_keys` | Optional, specifies the partition column names
carried in the file path, e.g., `/path/to/city=beijing/date="2023-07-09"`, then
fill in `path_partition_keys="city,date"`. This will automatically read the
corresponding column names and values from the path for import. |
|
| `enable_mapping_varbinary` | Defaults to false. When reading PARQUET/ORC, it
maps the BYTE_ARRAY type to STRING. When enabled, it maps to VARBINARY type. |
Supported since 4.0.3 |
+| `enable_mapping_timestamp_tz` | Defaults to `false`. When reading PARQUET
(`TIMESTAMP` with `isAdjustedToUTC`) or ORC (`TIMESTAMP_INSTANT`), the type is
mapped to `DATETIME`. When enabled, it is mapped to the `TIMESTAMPTZ` type. |
Supported since version 4.0.3 |
+
## Access Control Requirements
| Privilege | Object | Notes |
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/local.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/local.md
index 4d69c673bf4..c4c20cdfb4c 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/local.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/local.md
@@ -48,6 +48,8 @@ LOCAL(
| `skip_lines` | For CSV format imports, optional, defaults to `0`,
which means skipping the first few lines of the CSV file. When the format is
`csv_with_names` or `csv_with_names_and_types`, this parameter is ignored. |
For CSV format |
| `path_partition_keys` | Optional, specifies the partition column names
carried in the file path, e.g., `/path/to/city=beijing/date="2023-07-09"`, then
fill in `path_partition_keys="city,date"`. This will automatically read the
corresponding column names and values from the path for import. |
|
| `enable_mapping_varbinary` | Defaults to false. When reading PARQUET/ORC, it
maps the BYTE_ARRAY type to STRING. When enabled, it maps to VARBINARY type. |
Supported since 4.0.3 |
+| `enable_mapping_timestamp_tz` | Defaults to `false`. When reading PARQUET
(`TIMESTAMP` with `isAdjustedToUTC`) or ORC (`TIMESTAMP_INSTANT`), the type is
mapped to `DATETIME`. When enabled, it is mapped to the `TIMESTAMPTZ` type. |
Supported since version 4.0.3 |
+
## Access Control Requirements
| Privilege | Object | Notes |
diff --git
a/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/s3.md
b/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/s3.md
index 07a2ceac3be..07e5e4db552 100644
---
a/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/s3.md
+++
b/versioned_docs/version-4.x/sql-manual/sql-functions/table-valued-functions/s3.md
@@ -60,6 +60,7 @@ S3(
| `path_partition_keys` | - | Specifies partition column names
in file path. For example, for path `/path/to/city=beijing/date="2023-07-09"`,
set `path_partition_keys="city,date"` to automatically read column names and
values from path |
|
| `resource` | - | Specifies Resource name. S3 TVF
can use existing S3 Resource to access S3 directly. For creating S3 Resource,
refer to
[CREATE-RESOURCE](../../sql-statements/cluster-management/compute-management/CREATE-RESOURCE).
Supported from version 2.1.4. |
|
| `enable_mapping_varbinary` | `false` | Maps BYTE_ARRAY type to STRING
when reading PARQUET/ORC. When enabled, maps to VARBINARY type instead.
| Supported from version 4.0.3
|
+| `enable_mapping_timestamp_tz` | Defaults to `false`. When reading PARQUET
(`TIMESTAMP` with `isAdjustedToUTC`) or ORC (`TIMESTAMP_INSTANT`), the type is
mapped to `DATETIME`. When enabled, it is mapped to the `TIMESTAMPTZ` type. |
Supported since version 4.0.3 |
## Notes
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
