This is an automated email from the ASF dual-hosted git repository.

yuzelin pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-paimon.git


The following commit(s) were added to refs/heads/master by this push:
     new 776761322 [hotfix][doc] correct doc of purging partitions (#1573)
776761322 is described below

commit 776761322de7aed1431982a25a7452fa259833ec
Author: yuzelin <[email protected]>
AuthorDate: Mon Jul 17 16:14:14 2023 +0800

    [hotfix][doc] correct doc of purging partitions (#1573)
---
 docs/content/how-to/writing-tables.md | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)

diff --git a/docs/content/how-to/writing-tables.md 
b/docs/content/how-to/writing-tables.md
index 445c3ba5c..e123f48ed 100644
--- a/docs/content/how-to/writing-tables.md
+++ b/docs/content/how-to/writing-tables.md
@@ -216,7 +216,8 @@ Currently, Paimon supports two ways to purge partitions.
 
 ```sql
 -- Syntax
-INSERT OVERWRITE MyTable PARTITION (key1 = value1, key2 = value2, ...) SELECT 
selectSpec FROM MyTable WHERE false
+INSERT OVERWRITE MyTable /*+ OPTIONS('dynamic-partition-overwrite'='false') */ 
+PARTITION (key1 = value1, key2 = value2, ...) SELECT selectSpec FROM MyTable 
WHERE false
 
 -- The following SQL is an example:
 -- table definition
@@ -227,10 +228,12 @@ CREATE TABLE MyTable (
 ) PARTITIONED BY (k0, k1);
 
 -- you can use
-INSERT OVERWRITE MyTable PARTITION (k0 = 0) SELECT k1, v FROM MyTable WHERE 
false
+INSERT OVERWRITE MyTable /*+ OPTIONS('dynamic-partition-overwrite'='false') */ 
+PARTITION (k0 = 0) SELECT k1, v FROM MyTable WHERE false
 
 -- or
-INSERT OVERWRITE MyTable PARTITION (k0 = 0, k1 = 0) SELECT v FROM MyTable 
WHERE false
+INSERT OVERWRITE MyTable /*+ OPTIONS('dynamic-partition-overwrite'='false') */ 
+PARTITION (k0 = 0, k1 = 0) SELECT v FROM MyTable WHERE false
 ```
 
 {{< /tab >}}

Reply via email to