This is an automated email from the ASF dual-hosted git repository.
zykkk pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 53850274eef [docs](jdbc catalog) add sqlserver timestamp type mapping
doc (#31832)
53850274eef is described below
commit 53850274eef3afb33ff0a8d382022581f3e3ae5c
Author: zy-kkk <zhongy...@gmail.com>
AuthorDate: Wed Mar 6 11:38:27 2024 +0800
[docs](jdbc catalog) add sqlserver timestamp type mapping doc (#31832)
---
docs/en/docs/lakehouse/multi-catalog/jdbc.md | 39 +++++++++++++------------
docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md | 5 ++--
2 files changed, 23 insertions(+), 21 deletions(-)
diff --git a/docs/en/docs/lakehouse/multi-catalog/jdbc.md
b/docs/en/docs/lakehouse/multi-catalog/jdbc.md
index e7d6c7051d9..64f598aec19 100644
--- a/docs/en/docs/lakehouse/multi-catalog/jdbc.md
+++ b/docs/en/docs/lakehouse/multi-catalog/jdbc.md
@@ -194,11 +194,11 @@ JDBC catalog has the following three stages for mapping
rules for external table
* Doris 2.1.0 and later versions:
- In order to avoid confusion with the `lower_case_table_names` parameter of
FE conf, this configuration name is changed to `lower_case_meta_names`, which
is valid for all databases. During query, all library names, table names and
column names will be converted into real names, and then Check it out. If you
upgrade from an old version to 2.0.4, you need `Refresh <catalog_name>` to take
effect.
+ In order to avoid confusion with the `lower_case_table_names` parameter of
FE conf, this configuration name is changed to `lower_case_meta_names`, which
is valid for all databases. During query, all library names, table names and
column names will be converted into real names, and then Check it out. If you
upgrade from an old version to 2.1.0, you need `Refresh <catalog_name>` to take
effect.
For specific rules, please refer to the introduction of
`lower_case_meta_names` at the beginning of this section.
- Users who have previously set the JDBC catalog `lower_case_table_names`
parameter will automatically have `lower_case_table_names` converted to
`lower_case_meta_names` when upgrading to 2.0.4.
+ Users who have previously set the JDBC catalog `lower_case_table_names`
parameter will automatically have `lower_case_table_names` converted to
`lower_case_meta_names` when upgrading to 2.1.0.
### Specify synchronization database:
@@ -594,23 +594,24 @@ As for data mapping from SQLServer to Doris, one Database
in Doris corresponds t
#### Type Mapping
-| SQLServer Type | Doris Type | Comment
|
-|----------------------------------------|---------------|--------------------------------------------------------------------------|
-| bit | BOOLEAN |
|
-| tinyint | SMALLINT | SQLServer's tinyint
is an unsigned number, so it maps to Doris' SMALLINT |
-| smallint | SMALLINT |
|
-| int | INT |
|
-| bigint | BIGINT |
|
-| real | FLOAT |
|
-| float | DOUBLE |
|
-| money | DECIMAL(19,4) |
|
-| smallmoney | DECIMAL(10,4) |
|
-| decimal/numeric | DECIMAL |
|
-| date | DATE |
|
-| datetime/datetime2/smalldatetime | DATETIMEV2 |
|
-| char/varchar/text/nchar/nvarchar/ntext | STRING |
|
-| time/datetimeoffset | STRING |
|
-| Other | UNSUPPORTED |
|
+| SQLServer Type | Doris Type | Comment
|
+|----------------------------------------|---------------|----------------------------------------------------------------------------------|
+| bit | BOOLEAN |
|
+| tinyint | SMALLINT | SQLServer's tinyint
is an unsigned number, so it maps to Doris' SMALLINT |
+| smallint | SMALLINT |
|
+| int | INT |
|
+| bigint | BIGINT |
|
+| real | FLOAT |
|
+| float | DOUBLE |
|
+| money | DECIMAL(19,4) |
|
+| smallmoney | DECIMAL(10,4) |
|
+| decimal/numeric | DECIMAL |
|
+| date | DATE |
|
+| datetime/datetime2/smalldatetime | DATETIMEV2 |
|
+| char/varchar/text/nchar/nvarchar/ntext | STRING |
|
+| time/datetimeoffset | STRING |
|
+| timestamp | STRING | Read the
hexadecimal display of binary data, which has no practical significance.|
+| Other | UNSUPPORTED |
|
### Doris
diff --git a/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
b/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
index 9aa8e6da173..edb5066508b 100644
--- a/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
+++ b/docs/zh-CN/docs/lakehouse/multi-catalog/jdbc.md
@@ -196,11 +196,11 @@ JDBC Catalog 对于外部表大小写的映射规则存在如下三个阶段：
* Doris 2.1.0 以及之后版本：
- 为了避免和 FE conf 的 `lower_case_table_names` 参数混淆，此配置名改为
`lower_case_meta_names`，对所有的数据库都有效，在查询时，会将所有的库名和表名以及列名转换为真实的名称，再去查询，如果是从老版本升级到
2.0.4 ，需要 `Refresh <catalog_name>` 才能生效。
+ 为了避免和 FE conf 的 `lower_case_table_names` 参数混淆，此配置名改为
`lower_case_meta_names`，对所有的数据库都有效，在查询时，会将所有的库名和表名以及列名转换为真实的名称，再去查询，如果是从老版本升级到
2.1.0 ，需要 `Refresh <catalog_name>` 才能生效。
具体规则参考本小节开始对于 `lower_case_meta_names` 的介绍。
- 此前设置过 JDBC Catalog `lower_case_table_names` 参数的用户会在升级到 2.0.4 时，自动将
`lower_case_table_names` 转换为 `lower_case_meta_names`。
+ 此前设置过 JDBC Catalog `lower_case_table_names` 参数的用户会在升级到 2.1.0 时，自动将
`lower_case_table_names` 转换为 `lower_case_meta_names`。
### 指定同步数据库
@@ -613,6 +613,7 @@ CREATE CATALOG jdbc_sqlserve PROPERTIES (
| datetime/datetime2/smalldatetime | DATETIMEV2 |
|
| char/varchar/text/nchar/nvarchar/ntext | STRING |
|
| time/datetimeoffset | STRING |
|
+| timestamp | STRING |
读取二进制数据的十六进制显示，无实际意义 |
| Other | UNSUPPORTED |
|
### Doris
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
