This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 eaa52d3f4cb [doc](txn insert) fix txn insert doc (#820)
eaa52d3f4cb is described below
commit eaa52d3f4cb750f8751e448be6929e711e2ed079
Author: meiyi <myime...@gmail.com>
AuthorDate: Fri Jul 5 23:06:28 2024 +0800
[doc](txn insert) fix txn insert doc (#820)
Co-authored-by: Luzhijing <82810928+luzhij...@users.noreply.github.com>
---
docs/data-operate/import/transaction-load-manual.md | 4 ++++
.../current/data-operate/import/transaction-load-manual.md | 4 ++++
2 files changed, 8 insertions(+)
diff --git a/docs/data-operate/import/transaction-load-manual.md
b/docs/data-operate/import/transaction-load-manual.md
index f2dbea54213..e599c950dd4 100644
--- a/docs/data-operate/import/transaction-load-manual.md
+++ b/docs/data-operate/import/transaction-load-manual.md
@@ -371,6 +371,10 @@ mysql> SELECT * FROM dt3;
* Mixing the two transaction load of `INSERT INTO SELECT`, `UPDATE`, `DELETE`
and `INSERT INTO VALUES` is not allowed; otherwise, you will encounter the
error `Transaction insert can not insert into values and insert into select at
the same time`.
+* [Delete Command](../delete/delete-manual.md) supports delete by specifying a
filter predicate or using clause, to guarantee the isolation, currently only
support that, the delete operations must before the insert operations for one
table in one transaction, otherwise, you will encounter the error `Can not
delete because there is a insert operation for the same table`.
+
* If the time-consuming from `BEGIN` statement exceeds the timeout configured
in Doris, the transaction will be rolled back. Currently, the timeout uses the
maximum value of session variables `insert_timeout` and `query_timeout`.
* When using JDBC to connect to Doris for transaction operations, please add
`useLocalSessionState=true` in the JDBC URL; otherwise, you may encounter the
error `This is in a transaction, only insert, update, delete, commit, rollback
is acceptable`.
+
+* In cloud mode, transaction load does not support `merge on write` unique
tables, otherwise, you will encounter the error `Transaction load is not
supported for merge on write unique keys table in cloud mode`.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/transaction-load-manual.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/transaction-load-manual.md
index e13692f48e8..af17b329f6b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/transaction-load-manual.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/import/transaction-load-manual.md
@@ -371,6 +371,10 @@ mysql> SELECT * FROM dt3;
* 两种事务写入`INSERT INTO SELECT`, `UPDATE`, `DELETE` 和 `INSET INTO VALUES`
不能混用，否则会遇到错误 `Transaction insert can not insert into values and insert into
select at the same time`
+* [Delete 操作](../delete/delete-manual.md)提供了通过谓词和 Using
子句两种方式，为了保证隔离级别，在一个事务中，对相同表的删除必须在写入前，否则会遇到报错 `Can not delete because there is a
insert operation for the same table`
+
* 当从 `BEGIN` 开始的导入耗时超出 Doris 配置的 timeout 时，会导致事务回滚，导入失败。目前 timeout 使用的是
Session 变量 `insert_timeout` 和 `query_timeout` 的最大值
* 当使用 JDBC 连接 Doris 进行事务操作时，请在 JDBC URL 中添加
`useLocalSessionState=true`，否则可能会遇到错误 `This is in a transaction, only insert,
update, delete, commit, rollback is acceptable.`
+
+* 存算分离模式下，事务写不支持 Merge-on-Write 表，否则会遇到报错 `Transaction load is not supported
for merge on write unique keys table in cloud mode`
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
