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 33c3165866 [hive] add doc for create non transactional hive table
(#729)
33c3165866 is described below
commit 33c3165866a8a87b76da80ebcb0348cfd4bfb678
Author: Mingyu Chen <morning...@163.com>
AuthorDate: Sat Jun 8 22:50:05 2024 +0800
[hive] add doc for create non transactional hive table (#729)
---
.../trino-connector-developer-guide.md | 2 +-
docs/lakehouse/datalake-building/hive-build.md | 17 +++++++++++++++++
.../trino-connector-developer-guide.md | 2 +-
.../current/lakehouse/datalake-building/hive-build.md | 16 ++++++++++++++++
.../lakehouse/datalake-building/hive-build.md | 17 ++++++++++++++++-
.../lakehouse/datalake-building/hive-build.md | 17 +++++++++++++++++
6 files changed, 68 insertions(+), 3 deletions(-)
diff --git a/community/how-to-contribute/trino-connector-developer-guide.md
b/community/how-to-contribute/trino-connector-developer-guide.md
index f825b60e67..22569b7eb6 100644
--- a/community/how-to-contribute/trino-connector-developer-guide.md
+++ b/community/how-to-contribute/trino-connector-developer-guide.md
@@ -29,7 +29,7 @@ under the License.
## Background
-Starting from version 4.0, Doris supports docking with the Trino Connector
plugin. Through the rich Trino Connector plugin and Doris' Trino-Connector
Catalog function, Doris can query more data sources.
+Starting from version 3.0, Doris supports docking with the Trino Connector
plugin. Through the rich Trino Connector plugin and Doris' Trino-Connector
Catalog function, Doris can query more data sources.
The purpose of the Trino Connector compatibility framework is to help Doris
quickly connect to more data sources to meet user needs.
diff --git a/docs/lakehouse/datalake-building/hive-build.md
b/docs/lakehouse/datalake-building/hive-build.md
index 1b30a91e0e..6866bcae2e 100644
--- a/docs/lakehouse/datalake-building/hive-build.md
+++ b/docs/lakehouse/datalake-building/hive-build.md
@@ -142,6 +142,23 @@ This is an experimental feature.
Note, unlike Hive's table creation statements. In Doris, when creating a
Hive partitioned table, the partition columns must also be included in the
Table's Schema. At the same time, the partition columns must be at the end of
all schemas and in the same order.
+ :::tip
+
+ 对于某些默认开启 ACID 事务特性的 Hive 集群，使用 Doris 建表后，表属性 `transactional` 会为 true。而
Doris 只支持部分 Hive 事务表的特性，因此可能会导致 Doris 创建的 Hive，Doris
本身无法读取的问题。因此，需要在建表的属性中，显式增加：`"transactional" = "false"`，来创建非事务的 Hive 表：
+ For some Hive clusters that enable ACID transaction features by default,
after using Doris to create a table, the table attribute `transactional` will
be true. However, Doris only supports some features of Hive transaction tables,
which may cause the problem that Doris itself cannot read the Hive created by
Doris. Therefore, it is necessary to explicitly add: `"transactional" =
"false"` in the table creation properties to create a non-transactional Hive
table:
+
+ ```
+ CREATE TABLE non_acid_table(
+ `col1` BOOLEAN COMMENT 'col1',
+ `col2` INT COMMENT 'col2',
+ `col3` BIGINT COMMENT 'col3'
+ ) ENGINE=hive
+ PROPERTIES (
+ 'transactional'='false',
+ );
+ ```
+ :::
+
- Drop
You can drop a Hive table using the `DROP TABLE` statement. Currently,
deleting the table also removes the data, including partition data.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs-community/current/how-to-contribute/trino-connector-developer-guide.md
b/i18n/zh-CN/docusaurus-plugin-content-docs-community/current/how-to-contribute/trino-connector-developer-guide.md
index 805282c8b0..bb3d5d631a 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs-community/current/how-to-contribute/trino-connector-developer-guide.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs-community/current/how-to-contribute/trino-connector-developer-guide.md
@@ -28,7 +28,7 @@ under the License.
## 背景
-从 4.0 版本开始，Doris 支持对接 Trino Connector 插件。通过丰富的 Trino Connector 插件以及 Doris 的
`Trino-Connector` Catalog 功能可以让 Doris 支持更多的数据源。
+从 3.0 版本开始，Doris 支持对接 Trino Connector 插件。通过丰富的 Trino Connector 插件以及 Doris 的
`Trino-Connector` Catalog 功能可以让 Doris 支持更多的数据源。
Trino Connector 兼容框架的目的在于帮助 Doris 快速对接更多的数据源，以满足用户需求。
对于 Hive、Iceberg、Hudi、Paimon、JDBC 等数据源，我们仍然建议使用 Doris 内置的 Catalog
进行连接，已获得更好的性能、稳定性和兼容性。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/datalake-building/hive-build.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/datalake-building/hive-build.md
index 1d8bd315f1..794f3d989e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/datalake-building/hive-build.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/lakehouse/datalake-building/hive-build.md
@@ -142,6 +142,22 @@ under the License.
注意，不同于 Hive 中的建表语句。在 Doris 中创建 Hive 分区表时，分区列也必须写到 Table 的 Schema
中。同时，分区列必须在所有 Schema 的最后，且顺序保持一致。
+ :::tip
+
+ 对于某些默认开启 ACID 事务特性的 Hive 集群，使用 Doris 建表后，表属性 `transactional` 会为 true。而
Doris 只支持部分 Hive 事务表的特性，因此可能会导致 Doris 创建的 Hive，Doris
本身无法读取的问题。因此，需要在建表的属性中，显式增加：`"transactional" = "false"`，来创建非事务的 Hive 表：
+
+ ```
+ CREATE TABLE non_acid_table(
+ `col1` BOOLEAN COMMENT 'col1',
+ `col2` INT COMMENT 'col2',
+ `col3` BIGINT COMMENT 'col3'
+ ) ENGINE=hive
+ PROPERTIES (
+ 'transactional'='false',
+ );
+ ```
+ :::
+
- 删除
可以通过 `DROP TABLE` 语句删除一个 Hive 表。当前删除表后，会同时删除数据，包括分区数据。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/datalake-building/hive-build.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/datalake-building/hive-build.md
index cbfc406055..794f3d989e 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/datalake-building/hive-build.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/lakehouse/datalake-building/hive-build.md
@@ -97,7 +97,6 @@ under the License.
```
注意，对于 Hive Database，必须先删除这个 Database 下的所有表后，才能删除 Database，否则会报错。这个操作会同步删除
Hive 中对应的 Database。
-
### Table
@@ -143,6 +142,22 @@ under the License.
注意，不同于 Hive 中的建表语句。在 Doris 中创建 Hive 分区表时，分区列也必须写到 Table 的 Schema
中。同时，分区列必须在所有 Schema 的最后，且顺序保持一致。
+ :::tip
+
+ 对于某些默认开启 ACID 事务特性的 Hive 集群，使用 Doris 建表后，表属性 `transactional` 会为 true。而
Doris 只支持部分 Hive 事务表的特性，因此可能会导致 Doris 创建的 Hive，Doris
本身无法读取的问题。因此，需要在建表的属性中，显式增加：`"transactional" = "false"`，来创建非事务的 Hive 表：
+
+ ```
+ CREATE TABLE non_acid_table(
+ `col1` BOOLEAN COMMENT 'col1',
+ `col2` INT COMMENT 'col2',
+ `col3` BIGINT COMMENT 'col3'
+ ) ENGINE=hive
+ PROPERTIES (
+ 'transactional'='false',
+ );
+ ```
+ :::
+
- 删除
可以通过 `DROP TABLE` 语句删除一个 Hive 表。当前删除表后，会同时删除数据，包括分区数据。
diff --git
a/versioned_docs/version-2.1/lakehouse/datalake-building/hive-build.md
b/versioned_docs/version-2.1/lakehouse/datalake-building/hive-build.md
index 1b30a91e0e..6866bcae2e 100644
--- a/versioned_docs/version-2.1/lakehouse/datalake-building/hive-build.md
+++ b/versioned_docs/version-2.1/lakehouse/datalake-building/hive-build.md
@@ -142,6 +142,23 @@ This is an experimental feature.
Note, unlike Hive's table creation statements. In Doris, when creating a
Hive partitioned table, the partition columns must also be included in the
Table's Schema. At the same time, the partition columns must be at the end of
all schemas and in the same order.
+ :::tip
+
+ 对于某些默认开启 ACID 事务特性的 Hive 集群，使用 Doris 建表后，表属性 `transactional` 会为 true。而
Doris 只支持部分 Hive 事务表的特性，因此可能会导致 Doris 创建的 Hive，Doris
本身无法读取的问题。因此，需要在建表的属性中，显式增加：`"transactional" = "false"`，来创建非事务的 Hive 表：
+ For some Hive clusters that enable ACID transaction features by default,
after using Doris to create a table, the table attribute `transactional` will
be true. However, Doris only supports some features of Hive transaction tables,
which may cause the problem that Doris itself cannot read the Hive created by
Doris. Therefore, it is necessary to explicitly add: `"transactional" =
"false"` in the table creation properties to create a non-transactional Hive
table:
+
+ ```
+ CREATE TABLE non_acid_table(
+ `col1` BOOLEAN COMMENT 'col1',
+ `col2` INT COMMENT 'col2',
+ `col3` BIGINT COMMENT 'col3'
+ ) ENGINE=hive
+ PROPERTIES (
+ 'transactional'='false',
+ );
+ ```
+ :::
+
- Drop
You can drop a Hive table using the `DROP TABLE` statement. Currently,
deleting the table also removes the data, including partition data.
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
