This is an automated email from the ASF dual-hosted git repository.
HTHou pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/iotdb-docs.git
The following commit(s) were added to refs/heads/main by this push:
new f655273d Fix table TTL example SQL (#1192)
f655273d is described below
commit f655273de88b27de28fc5fd5a6d4dd99fa04ffec
Author: leto-bbq <[email protected]>
AuthorDate: Wed Aug 12 12:00:33 2026 +0800
Fix table TTL example SQL (#1192)
---
.../Master/Table/Basic-Concept/TTL-Delete-Data_apache.md | 12 ++++++------
.../latest-Table/Basic-Concept/TTL-Delete-Data_apache.md | 12 ++++++------
.../Master/Table/Basic-Concept/TTL-Delete-Data_apache.md | 12 ++++++------
.../latest-Table/Basic-Concept/TTL-Delete-Data_apache.md | 12 ++++++------
4 files changed, 24 insertions(+), 24 deletions(-)
diff --git a/src/UserGuide/Master/Table/Basic-Concept/TTL-Delete-Data_apache.md
b/src/UserGuide/Master/Table/Basic-Concept/TTL-Delete-Data_apache.md
index aeccefc2..dd34fe11 100644
--- a/src/UserGuide/Master/Table/Basic-Concept/TTL-Delete-Data_apache.md
+++ b/src/UserGuide/Master/Table/Basic-Concept/TTL-Delete-Data_apache.md
@@ -47,7 +47,7 @@ If TTL is specified when creating a table using SQL, the
table’s TTL takes pre
Example 1: Setting TTL during table creation:
```SQL
-CREATE TABLE test3 ("site" string id, "temperature" int32) with (TTL=3600);
+CREATE TABLE test3 ("site" string, "temperature" int32) with (TTL=3600);
```
Example 2: Changing TTL for an existing table:
@@ -59,8 +59,8 @@ ALTER TABLE tableB SET PROPERTIES TTL=3600;
**Example 3:** If TTL is not specified or set to the default value, it will
inherit the database's TTL. By default, the database TTL is `'INF'` (infinite):
```SQL
-CREATE TABLE test3 ("site" string id, "temperature" int32) with (TTL=DEFAULT);
-CREATE TABLE test3 ("site" string id, "temperature" int32);
+CREATE TABLE test3 ("site" string, "temperature" int32) with (TTL=DEFAULT);
+CREATE TABLE test3 ("site" string, "temperature" int32);
ALTER TABLE tableB set properties TTL=DEFAULT;
```
@@ -73,7 +73,7 @@ Example 4: A database with TTL=3600000 creates tables
inheriting this TTL:
```SQL
CREATE DATABASE db WITH (ttl=3600000);
use db;
-CREATE TABLE test3 ("site" string id, "temperature" int32);
+CREATE TABLE test3 ("site" string, "temperature" int32);
```
Example 5: A database without a TTL setting creates tables without TTL:
@@ -81,7 +81,7 @@ Example 5: A database without a TTL setting creates tables
without TTL:
```SQL
CREATE DATABASE db;
use db;
-CREATE TABLE test3 ("site" string id, "temperature" int32);
+CREATE TABLE test3 ("site" string, "temperature" int32);
```
Example 6: Setting a table with no TTL explicitly (TTL=INF) in a database with
a configured TTL:
@@ -89,7 +89,7 @@ Example 6: Setting a table with no TTL explicitly (TTL=INF)
in a database with a
```SQL
CREATE DATABASE db WITH (ttl=3600000);
use db;
-CREATE TABLE test3 ("site" string id, "temperature" int32) with (ttl='INF');
+CREATE TABLE test3 ("site" string, "temperature" int32) with (ttl='INF');
```
## 3. Remove TTL
diff --git a/src/UserGuide/latest-Table/Basic-Concept/TTL-Delete-Data_apache.md
b/src/UserGuide/latest-Table/Basic-Concept/TTL-Delete-Data_apache.md
index aeccefc2..dd34fe11 100644
--- a/src/UserGuide/latest-Table/Basic-Concept/TTL-Delete-Data_apache.md
+++ b/src/UserGuide/latest-Table/Basic-Concept/TTL-Delete-Data_apache.md
@@ -47,7 +47,7 @@ If TTL is specified when creating a table using SQL, the
table’s TTL takes pre
Example 1: Setting TTL during table creation:
```SQL
-CREATE TABLE test3 ("site" string id, "temperature" int32) with (TTL=3600);
+CREATE TABLE test3 ("site" string, "temperature" int32) with (TTL=3600);
```
Example 2: Changing TTL for an existing table:
@@ -59,8 +59,8 @@ ALTER TABLE tableB SET PROPERTIES TTL=3600;
**Example 3:** If TTL is not specified or set to the default value, it will
inherit the database's TTL. By default, the database TTL is `'INF'` (infinite):
```SQL
-CREATE TABLE test3 ("site" string id, "temperature" int32) with (TTL=DEFAULT);
-CREATE TABLE test3 ("site" string id, "temperature" int32);
+CREATE TABLE test3 ("site" string, "temperature" int32) with (TTL=DEFAULT);
+CREATE TABLE test3 ("site" string, "temperature" int32);
ALTER TABLE tableB set properties TTL=DEFAULT;
```
@@ -73,7 +73,7 @@ Example 4: A database with TTL=3600000 creates tables
inheriting this TTL:
```SQL
CREATE DATABASE db WITH (ttl=3600000);
use db;
-CREATE TABLE test3 ("site" string id, "temperature" int32);
+CREATE TABLE test3 ("site" string, "temperature" int32);
```
Example 5: A database without a TTL setting creates tables without TTL:
@@ -81,7 +81,7 @@ Example 5: A database without a TTL setting creates tables
without TTL:
```SQL
CREATE DATABASE db;
use db;
-CREATE TABLE test3 ("site" string id, "temperature" int32);
+CREATE TABLE test3 ("site" string, "temperature" int32);
```
Example 6: Setting a table with no TTL explicitly (TTL=INF) in a database with
a configured TTL:
@@ -89,7 +89,7 @@ Example 6: Setting a table with no TTL explicitly (TTL=INF)
in a database with a
```SQL
CREATE DATABASE db WITH (ttl=3600000);
use db;
-CREATE TABLE test3 ("site" string id, "temperature" int32) with (ttl='INF');
+CREATE TABLE test3 ("site" string, "temperature" int32) with (ttl='INF');
```
## 3. Remove TTL
diff --git
a/src/zh/UserGuide/Master/Table/Basic-Concept/TTL-Delete-Data_apache.md
b/src/zh/UserGuide/Master/Table/Basic-Concept/TTL-Delete-Data_apache.md
index 706b4647..5f846cdf 100644
--- a/src/zh/UserGuide/Master/Table/Basic-Concept/TTL-Delete-Data_apache.md
+++ b/src/zh/UserGuide/Master/Table/Basic-Concept/TTL-Delete-Data_apache.md
@@ -45,7 +45,7 @@ IoTDB支持对表（table）级别设置数据保留时间（TTL），允许系
示例1：创建表时设置 TTL
```SQL
-CREATE TABLE test3 ("场站" string id, "温度" int32) with (TTL=3600);
+CREATE TABLE test3 ("场站" string, "温度" int32) with (TTL=3600);
```
示例2：更改表语句设置TTL：
@@ -57,8 +57,8 @@ ALTER TABLE tableB SET PROPERTIES TTL=3600;
示例3：不指定TTL或设为默认值，它将与数据库的TTL相同，默认情况下是'INF'（无穷大）：
```SQL
-CREATE TABLE test3 ("场站" string id, "温度" int32) with (TTL=DEFAULT);
-CREATE TABLE test3 ("场站" string id, "温度" int32);
+CREATE TABLE test3 ("场站" string, "温度" int32) with (TTL=DEFAULT);
+CREATE TABLE test3 ("场站" string, "温度" int32);
ALTER TABLE tableB set properties TTL=DEFAULT;
```
@@ -71,7 +71,7 @@ ALTER TABLE tableB set properties TTL=DEFAULT;
```SQL
CREATE DATABASE db WITH (ttl=3600000);
use db;
-CREATE TABLE test3 ("场站" string id, "温度" int32);
+CREATE TABLE test3 ("场站" string, "温度" int32);
```
示例5：数据库不设置ttl，将生成一个没有ttl的表:
@@ -79,7 +79,7 @@ CREATE TABLE test3 ("场站" string id, "温度" int32);
```SQL
CREATE DATABASE db;
use db;
-CREATE TABLE test3 ("场站" string id, "温度" int32);
+CREATE TABLE test3 ("场站" string, "温度" int32);
```
示例6：数据库设置了ttl，但想显式设置没有TTL的表，可以将TTL设置为'INF'：
@@ -87,7 +87,7 @@ CREATE TABLE test3 ("场站" string id, "温度" int32);
```SQL
CREATE DATABASE db WITH (ttl=3600000);
use db;
-CREATE TABLE test3 ("场站" string id, "温度" int32) with (ttl='INF');
+CREATE TABLE test3 ("场站" string, "温度" int32) with (ttl='INF');
```
## 3. 取消 TTL
diff --git
a/src/zh/UserGuide/latest-Table/Basic-Concept/TTL-Delete-Data_apache.md
b/src/zh/UserGuide/latest-Table/Basic-Concept/TTL-Delete-Data_apache.md
index 706b4647..5f846cdf 100644
--- a/src/zh/UserGuide/latest-Table/Basic-Concept/TTL-Delete-Data_apache.md
+++ b/src/zh/UserGuide/latest-Table/Basic-Concept/TTL-Delete-Data_apache.md
@@ -45,7 +45,7 @@ IoTDB支持对表（table）级别设置数据保留时间（TTL），允许系
示例1：创建表时设置 TTL
```SQL
-CREATE TABLE test3 ("场站" string id, "温度" int32) with (TTL=3600);
+CREATE TABLE test3 ("场站" string, "温度" int32) with (TTL=3600);
```
示例2：更改表语句设置TTL：
@@ -57,8 +57,8 @@ ALTER TABLE tableB SET PROPERTIES TTL=3600;
示例3：不指定TTL或设为默认值，它将与数据库的TTL相同，默认情况下是'INF'（无穷大）：
```SQL
-CREATE TABLE test3 ("场站" string id, "温度" int32) with (TTL=DEFAULT);
-CREATE TABLE test3 ("场站" string id, "温度" int32);
+CREATE TABLE test3 ("场站" string, "温度" int32) with (TTL=DEFAULT);
+CREATE TABLE test3 ("场站" string, "温度" int32);
ALTER TABLE tableB set properties TTL=DEFAULT;
```
@@ -71,7 +71,7 @@ ALTER TABLE tableB set properties TTL=DEFAULT;
```SQL
CREATE DATABASE db WITH (ttl=3600000);
use db;
-CREATE TABLE test3 ("场站" string id, "温度" int32);
+CREATE TABLE test3 ("场站" string, "温度" int32);
```
示例5：数据库不设置ttl，将生成一个没有ttl的表:
@@ -79,7 +79,7 @@ CREATE TABLE test3 ("场站" string id, "温度" int32);
```SQL
CREATE DATABASE db;
use db;
-CREATE TABLE test3 ("场站" string id, "温度" int32);
+CREATE TABLE test3 ("场站" string, "温度" int32);
```
示例6：数据库设置了ttl，但想显式设置没有TTL的表，可以将TTL设置为'INF'：
@@ -87,7 +87,7 @@ CREATE TABLE test3 ("场站" string id, "温度" int32);
```SQL
CREATE DATABASE db WITH (ttl=3600000);
use db;
-CREATE TABLE test3 ("场站" string id, "温度" int32) with (ttl='INF');
+CREATE TABLE test3 ("场站" string, "温度" int32) with (ttl='INF');
```
## 3. 取消 TTL
