This is an automated email from the ASF dual-hosted git repository. yuxia pushed a commit to branch release-1.18 in repository https://gitbox.apache.org/repos/asf/flink.git
commit 78b0b7b5cb5da3cecaf30a175717c3c33080ed58 Author: Tartarus0zm <[email protected]> AuthorDate: Thu Sep 21 11:28:45 2023 +0800 [FLINK-33050][docs] Add notice of data duplicates for RTAS in docs This closes #23448 --- docs/content.zh/docs/dev/table/sql/create.md | 1 + docs/content/docs/dev/table/sql/create.md | 1 + 2 files changed, 2 insertions(+) diff --git a/docs/content.zh/docs/dev/table/sql/create.md b/docs/content.zh/docs/dev/table/sql/create.md index 7024b457585..f6c8674b6c8 100644 --- a/docs/content.zh/docs/dev/table/sql/create.md +++ b/docs/content.zh/docs/dev/table/sql/create.md @@ -615,6 +615,7 @@ INSERT INTO my_rtas_table SELECT id, name, age FROM source_table WHERE mod(id, 1 * 暂不支持主键约束。 **注意：** 默认情况下，RTAS 是非原子性的，这意味着如果在向表中插入数据时发生错误，该表不会被自动删除或还原成原来的表。 +**注意：** RTAS 会先删除表，然后创建表并写入数据。但如果表是在基于内存的 Catalog 里，删除表只会将其从 Catalog 里移除，并不会移除物理表中的数据。因此，执行RTAS语句之前的数据仍然存在。 ### 原子性 diff --git a/docs/content/docs/dev/table/sql/create.md b/docs/content/docs/dev/table/sql/create.md index 8dc17cd525d..3d94b111c53 100644 --- a/docs/content/docs/dev/table/sql/create.md +++ b/docs/content/docs/dev/table/sql/create.md @@ -616,6 +616,7 @@ INSERT INTO my_rtas_table SELECT id, name, age FROM source_table WHERE mod(id, 1 * Does not support specifying primary key constraints yet. **Note:** By default, RTAS is non-atomic which means the table won't be dropped or restored to its origin automatically if occur errors while inserting data into the table. +**Note:** RTAS will drop the table first, then create the table and insert the data. But if the table is in the in-memory catalog, dropping table will only remove it from the catalog without removing the data in the physical table. So, the data before executing RTAS statement will still exist. ### Atomicity
