This is an automated email from the ASF dual-hosted git repository.
haonan 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 00cbce8d fix code style (#952)
00cbce8d is described below
commit 00cbce8d406c613cf5009fce3a2f255d8b7a5418
Author: leto-b <[email protected]>
AuthorDate: Mon Jan 5 10:38:29 2026 +0800
fix code style (#952)
---
.../Master/Tree/SQL-Manual/SQL-Manual_apache.md | 22 ++++++++---------
.../Master/Tree/SQL-Manual/SQL-Manual_timecho.md | 18 +++++++-------
.../latest/SQL-Manual/SQL-Manual_apache.md | 22 ++++++++---------
.../latest/SQL-Manual/SQL-Manual_timecho.md | 18 +++++++-------
.../Master/Tree/SQL-Manual/SQL-Manual_apache.md | 28 +++++++++++-----------
.../Master/Tree/SQL-Manual/SQL-Manual_timecho.md | 26 ++++++++++----------
.../latest/SQL-Manual/SQL-Manual_apache.md | 28 +++++++++++-----------
.../latest/SQL-Manual/SQL-Manual_timecho.md | 24 +++++++++----------
8 files changed, 93 insertions(+), 93 deletions(-)
diff --git a/src/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_apache.md
b/src/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_apache.md
index ef386d00..b27cc355 100644
--- a/src/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_apache.md
+++ b/src/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_apache.md
@@ -119,13 +119,13 @@ For more details, see document
[Operate-Metadata](../Basic-Concept/Operate-Metad
**Example 1:** Create a template containing two non-aligned timeseires
-```shell
+```sql
IoTDB> create device template t1 (temperature FLOAT, status BOOLEAN)
```
**Example 2:** Create a template containing a group of aligned timeseires
-```shell
+```sql
IoTDB> create device template t2 aligned (lat FLOAT, lon FLOAT)
```
@@ -465,7 +465,7 @@ For more details, see document [Data
Import](../Tools-System/Data-Import-Tool_ap
#### Load with Script
-```
+```sql
./load-rewrite.bat -f D:\IoTDB\data -h 192.168.0.101 -p 6667 -u root -pw root
```
@@ -902,11 +902,11 @@ IoTDB > select s1, s2 into root.sg_copy.d1(t1, t2),
aligned root.sg_copy.d2(t1,
## 8. Maintennance
Generate the corresponding query plan:
-```
+```sql
explain select s1,s2 from root.sg.d1
```
Execute the corresponding SQL, analyze the execution and output:
-```
+```sql
explain analyze select s1,s2 from root.sg.d1 order by s1
```
## 9. OPERATOR
@@ -1703,13 +1703,13 @@ eg: REVOKE ALL ON ROOT.** FROM USER user1;
#### Delete Time Partition (experimental)
-```
+```sql
Eg: IoTDB > DELETE PARTITION root.ln 0,1,2
```
#### Continuous Query,CQ
-```
+```sql
Eg: IoTDB > CREATE CONTINUOUS QUERY cq1 BEGIN SELECT max_value(temperature)
INTO temperature_max FROM root.ln.*.* GROUP BY time(10s) END
```
@@ -1717,13 +1717,13 @@ Eg: IoTDB > CREATE CONTINUOUS QUERY cq1 BEGIN SELECT
max_value(temperature) INTO
- FLUSH
-```
+```sql
Eg: IoTDB > flush
```
- MERGE
-```
+```sql
Eg: IoTDB > MERGE
Eg: IoTDB > FULL MERGE
```
@@ -1748,12 +1748,12 @@ Eg: IoTDB > STOP REPAIR DATA
- SET SYSTEM TO READONLY / WRITABLE
-```
+```sql
Eg: IoTDB > SET SYSTEM TO READONLY / WRITABLE
```
- Query abort
-```
+```sql
Eg: IoTDB > KILL QUERY 1
```
\ No newline at end of file
diff --git a/src/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_timecho.md
b/src/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_timecho.md
index 17065d4e..07363f7c 100644
--- a/src/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_timecho.md
+++ b/src/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_timecho.md
@@ -386,7 +386,7 @@ For more details, see document [Data
Import](../Tools-System/Data-Import-Tool_ti
#### Load with Script
-```
+```sql
./load-rewrite.bat -f D:\IoTDB\data -h 192.168.0.101 -p 6667 -u root -pw root
```
@@ -823,11 +823,11 @@ IoTDB > select s1, s2 into root.sg_copy.d1(t1, t2),
aligned root.sg_copy.d2(t1,
## 7. Maintennance
Generate the corresponding query plan:
-```
+```sql
explain select s1,s2 from root.sg.d1
```
Execute the corresponding SQL, analyze the execution and output:
-```
+```sql
explain analyze select s1,s2 from root.sg.d1 order by s1
```
## 8. OPERATOR
@@ -1624,13 +1624,13 @@ eg: REVOKE ALL ON ROOT.** FROM USER user1;
#### Delete Time Partition (experimental)
-```
+```sql
Eg: IoTDB > DELETE PARTITION root.ln 0,1,2
```
#### Continuous Query,CQ
-```
+```sql
Eg: IoTDB > CREATE CONTINUOUS QUERY cq1 BEGIN SELECT max_value(temperature)
INTO temperature_max FROM root.ln.*.* GROUP BY time(10s) END
```
@@ -1638,13 +1638,13 @@ Eg: IoTDB > CREATE CONTINUOUS QUERY cq1 BEGIN SELECT
max_value(temperature) INTO
- FLUSH
-```
+```sql
Eg: IoTDB > flush
```
- MERGE
-```
+```sql
Eg: IoTDB > MERGE
Eg: IoTDB > FULL MERGE
```
@@ -1669,12 +1669,12 @@ Eg: IoTDB > STOP REPAIR DATA
- SET SYSTEM TO READONLY / WRITABLE
-```
+```sql
Eg: IoTDB > SET SYSTEM TO READONLY / WRITABLE
```
- Query abort
-```
+```sql
Eg: IoTDB > KILL QUERY 1
```
\ No newline at end of file
diff --git a/src/UserGuide/latest/SQL-Manual/SQL-Manual_apache.md
b/src/UserGuide/latest/SQL-Manual/SQL-Manual_apache.md
index ef386d00..b27cc355 100644
--- a/src/UserGuide/latest/SQL-Manual/SQL-Manual_apache.md
+++ b/src/UserGuide/latest/SQL-Manual/SQL-Manual_apache.md
@@ -119,13 +119,13 @@ For more details, see document
[Operate-Metadata](../Basic-Concept/Operate-Metad
**Example 1:** Create a template containing two non-aligned timeseires
-```shell
+```sql
IoTDB> create device template t1 (temperature FLOAT, status BOOLEAN)
```
**Example 2:** Create a template containing a group of aligned timeseires
-```shell
+```sql
IoTDB> create device template t2 aligned (lat FLOAT, lon FLOAT)
```
@@ -465,7 +465,7 @@ For more details, see document [Data
Import](../Tools-System/Data-Import-Tool_ap
#### Load with Script
-```
+```sql
./load-rewrite.bat -f D:\IoTDB\data -h 192.168.0.101 -p 6667 -u root -pw root
```
@@ -902,11 +902,11 @@ IoTDB > select s1, s2 into root.sg_copy.d1(t1, t2),
aligned root.sg_copy.d2(t1,
## 8. Maintennance
Generate the corresponding query plan:
-```
+```sql
explain select s1,s2 from root.sg.d1
```
Execute the corresponding SQL, analyze the execution and output:
-```
+```sql
explain analyze select s1,s2 from root.sg.d1 order by s1
```
## 9. OPERATOR
@@ -1703,13 +1703,13 @@ eg: REVOKE ALL ON ROOT.** FROM USER user1;
#### Delete Time Partition (experimental)
-```
+```sql
Eg: IoTDB > DELETE PARTITION root.ln 0,1,2
```
#### Continuous Query,CQ
-```
+```sql
Eg: IoTDB > CREATE CONTINUOUS QUERY cq1 BEGIN SELECT max_value(temperature)
INTO temperature_max FROM root.ln.*.* GROUP BY time(10s) END
```
@@ -1717,13 +1717,13 @@ Eg: IoTDB > CREATE CONTINUOUS QUERY cq1 BEGIN SELECT
max_value(temperature) INTO
- FLUSH
-```
+```sql
Eg: IoTDB > flush
```
- MERGE
-```
+```sql
Eg: IoTDB > MERGE
Eg: IoTDB > FULL MERGE
```
@@ -1748,12 +1748,12 @@ Eg: IoTDB > STOP REPAIR DATA
- SET SYSTEM TO READONLY / WRITABLE
-```
+```sql
Eg: IoTDB > SET SYSTEM TO READONLY / WRITABLE
```
- Query abort
-```
+```sql
Eg: IoTDB > KILL QUERY 1
```
\ No newline at end of file
diff --git a/src/UserGuide/latest/SQL-Manual/SQL-Manual_timecho.md
b/src/UserGuide/latest/SQL-Manual/SQL-Manual_timecho.md
index 17065d4e..07363f7c 100644
--- a/src/UserGuide/latest/SQL-Manual/SQL-Manual_timecho.md
+++ b/src/UserGuide/latest/SQL-Manual/SQL-Manual_timecho.md
@@ -386,7 +386,7 @@ For more details, see document [Data
Import](../Tools-System/Data-Import-Tool_ti
#### Load with Script
-```
+```sql
./load-rewrite.bat -f D:\IoTDB\data -h 192.168.0.101 -p 6667 -u root -pw root
```
@@ -823,11 +823,11 @@ IoTDB > select s1, s2 into root.sg_copy.d1(t1, t2),
aligned root.sg_copy.d2(t1,
## 7. Maintennance
Generate the corresponding query plan:
-```
+```sql
explain select s1,s2 from root.sg.d1
```
Execute the corresponding SQL, analyze the execution and output:
-```
+```sql
explain analyze select s1,s2 from root.sg.d1 order by s1
```
## 8. OPERATOR
@@ -1624,13 +1624,13 @@ eg: REVOKE ALL ON ROOT.** FROM USER user1;
#### Delete Time Partition (experimental)
-```
+```sql
Eg: IoTDB > DELETE PARTITION root.ln 0,1,2
```
#### Continuous Query,CQ
-```
+```sql
Eg: IoTDB > CREATE CONTINUOUS QUERY cq1 BEGIN SELECT max_value(temperature)
INTO temperature_max FROM root.ln.*.* GROUP BY time(10s) END
```
@@ -1638,13 +1638,13 @@ Eg: IoTDB > CREATE CONTINUOUS QUERY cq1 BEGIN SELECT
max_value(temperature) INTO
- FLUSH
-```
+```sql
Eg: IoTDB > flush
```
- MERGE
-```
+```sql
Eg: IoTDB > MERGE
Eg: IoTDB > FULL MERGE
```
@@ -1669,12 +1669,12 @@ Eg: IoTDB > STOP REPAIR DATA
- SET SYSTEM TO READONLY / WRITABLE
-```
+```sql
Eg: IoTDB > SET SYSTEM TO READONLY / WRITABLE
```
- Query abort
-```
+```sql
Eg: IoTDB > KILL QUERY 1
```
\ No newline at end of file
diff --git a/src/zh/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_apache.md
b/src/zh/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_apache.md
index e4260e8a..a84b8ae0 100644
--- a/src/zh/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_apache.md
+++ b/src/zh/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_apache.md
@@ -261,7 +261,7 @@ IoTDB> count devices where time>=2017-01-01T00:00:00 and
time<=2017-11-01T16:26:
#### 创建设备模板
-```Go
+```sql
CREATE DEVICE TEMPLATE <templateName> ALIGNED? '(' <measurementId>
<attributeClauses> [',' <measurementId> <attributeClauses>]+ ')'
```
@@ -579,7 +579,7 @@ GROUP BY([10, 90), 10ms);
SQL 语法:
-```Go
+```sql
select last <Path> [COMMA <Path>]* from < PrefixPath > [COMMA < PrefixPath >]*
<whereClause> [ORDER BY TIMESERIES (DESC | ASC)?]
```
@@ -949,7 +949,7 @@ IoTDB> select s1 + s2 into root.expr.add(d1s1_d1s2),
root.expr.add(d2s1_d2s2) fr
##### 按时间对齐(默认)
###### 目标设备不使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select s1, s2
@@ -959,7 +959,7 @@ from root.sg.d1, root.sg.d2;
```
该语句等价于:
-```
+```sql
select s1, s2
@@ -970,7 +970,7 @@ from root.sg.d1, root.sg.d2;
###### 目标设备使用变量占位符 & 目标物理量列表不使用变量占位符
-```
+```sql
select d1.s1, d1.s2, d2.s3, d3.s4
into ::(s1_1, s2_2), root.sg.d2_2(s3_3), root.${2}_copy.::(s4)
@@ -980,14 +980,14 @@ from root.sg;
###### 目标设备使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select * into root.sg_bk.::(::) from root.sg.**;
```
##### 按设备对齐(使用 `ALIGN BY DEVICE`)
###### 目标设备不使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select s1, s2, s3, s4
@@ -999,7 +999,7 @@ align by device;
```
###### 目标设备使用变量占位符 & 目标物理量列表不使用变量占位符
-```
+```sql
select avg(s1), sum(s2) + sum(s3), count(s4)
@@ -1011,23 +1011,23 @@ align by device;
```
###### 目标设备使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select * into ::(backup_${4}) from root.sg.** align by device;
```
#### 指定目标序列为对齐序列
-```
+```sql
select s1, s2 into root.sg_copy.d1(t1, t2), aligned root.sg_copy.d2(t1, t2)
from root.sg.d1, root.sg.d2 align by device;
```
## 5. 运维语句
生成对应的查询计划
-```
+```sql
explain select s1,s2 from root.sg.d1
```
执行对应的查询语句,并获取分析结果
-```
+```sql
explain analyze select s1,s2 from root.sg.d1 order by s1
```
## 6. 运算符
@@ -1612,7 +1612,7 @@ SHOW TRIGGERS
### 12.1 语法
-```Go
+```sql
CREATE (CONTINUOUS QUERY | CQ) <cq_id>
[RESAMPLE
[EVERY <every_interval>]
@@ -1656,7 +1656,7 @@ END
\> SELECT temperature_max from root.ln.*.*;
```
#### 配置连续查询的时间窗口大小
-```
+```sql
CREATE CONTINUOUS QUERY cq2
RESAMPLE RANGE 40s
diff --git a/src/zh/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_timecho.md
b/src/zh/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_timecho.md
index 310ac056..55083e82 100644
--- a/src/zh/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_timecho.md
+++ b/src/zh/UserGuide/Master/Tree/SQL-Manual/SQL-Manual_timecho.md
@@ -504,7 +504,7 @@ GROUP BY([10, 90), 10ms);
SQL 语法:
-```Go
+```sql
select last <Path> [COMMA <Path>]* from < PrefixPath > [COMMA < PrefixPath >]*
<whereClause> [ORDER BY TIMESERIES (DESC | ASC)?]
```
@@ -874,7 +874,7 @@ IoTDB> select s1 + s2 into root.expr.add(d1s1_d1s2),
root.expr.add(d2s1_d2s2) fr
##### 按时间对齐(默认)
###### 目标设备不使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select s1, s2
@@ -884,7 +884,7 @@ from root.sg.d1, root.sg.d2;
```
该语句等价于:
-```
+```sql
select s1, s2
@@ -895,7 +895,7 @@ from root.sg.d1, root.sg.d2;
###### 目标设备使用变量占位符 & 目标物理量列表不使用变量占位符
-```
+```sql
select d1.s1, d1.s2, d2.s3, d3.s4
into ::(s1_1, s2_2), root.sg.d2_2(s3_3), root.${2}_copy.::(s4)
@@ -905,14 +905,14 @@ from root.sg;
###### 目标设备使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select * into root.sg_bk.::(::) from root.sg.**;
```
##### 按设备对齐(使用 `ALIGN BY DEVICE`)
###### 目标设备不使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select s1, s2, s3, s4
@@ -924,7 +924,7 @@ align by device;
```
###### 目标设备使用变量占位符 & 目标物理量列表不使用变量占位符
-```
+```sql
select avg(s1), sum(s2) + sum(s3), count(s4)
@@ -936,23 +936,23 @@ align by device;
```
###### 目标设备使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select * into ::(backup_${4}) from root.sg.** align by device;
```
#### 指定目标序列为对齐序列
-```
+```sql
select s1, s2 into root.sg_copy.d1(t1, t2), aligned root.sg_copy.d2(t1, t2)
from root.sg.d1, root.sg.d2 align by device;
```
## 5. 运维语句
生成对应的查询计划
-```
+```sql
explain select s1,s2 from root.sg.d1
```
执行对应的查询语句,并获取分析结果
-```
+```sql
explain analyze select s1,s2 from root.sg.d1 order by s1
```
## 6. 运算符
@@ -1537,7 +1537,7 @@ SHOW TRIGGERS
### 12.1 语法
-```Go
+```sql
CREATE (CONTINUOUS QUERY | CQ) <cq_id>
[RESAMPLE
[EVERY <every_interval>]
@@ -1581,7 +1581,7 @@ END
\> SELECT temperature_max from root.ln.*.*;
```
#### 配置连续查询的时间窗口大小
-```
+```sql
CREATE CONTINUOUS QUERY cq2
RESAMPLE RANGE 40s
diff --git a/src/zh/UserGuide/latest/SQL-Manual/SQL-Manual_apache.md
b/src/zh/UserGuide/latest/SQL-Manual/SQL-Manual_apache.md
index e4260e8a..a84b8ae0 100644
--- a/src/zh/UserGuide/latest/SQL-Manual/SQL-Manual_apache.md
+++ b/src/zh/UserGuide/latest/SQL-Manual/SQL-Manual_apache.md
@@ -261,7 +261,7 @@ IoTDB> count devices where time>=2017-01-01T00:00:00 and
time<=2017-11-01T16:26:
#### 创建设备模板
-```Go
+```sql
CREATE DEVICE TEMPLATE <templateName> ALIGNED? '(' <measurementId>
<attributeClauses> [',' <measurementId> <attributeClauses>]+ ')'
```
@@ -579,7 +579,7 @@ GROUP BY([10, 90), 10ms);
SQL 语法:
-```Go
+```sql
select last <Path> [COMMA <Path>]* from < PrefixPath > [COMMA < PrefixPath >]*
<whereClause> [ORDER BY TIMESERIES (DESC | ASC)?]
```
@@ -949,7 +949,7 @@ IoTDB> select s1 + s2 into root.expr.add(d1s1_d1s2),
root.expr.add(d2s1_d2s2) fr
##### 按时间对齐(默认)
###### 目标设备不使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select s1, s2
@@ -959,7 +959,7 @@ from root.sg.d1, root.sg.d2;
```
该语句等价于:
-```
+```sql
select s1, s2
@@ -970,7 +970,7 @@ from root.sg.d1, root.sg.d2;
###### 目标设备使用变量占位符 & 目标物理量列表不使用变量占位符
-```
+```sql
select d1.s1, d1.s2, d2.s3, d3.s4
into ::(s1_1, s2_2), root.sg.d2_2(s3_3), root.${2}_copy.::(s4)
@@ -980,14 +980,14 @@ from root.sg;
###### 目标设备使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select * into root.sg_bk.::(::) from root.sg.**;
```
##### 按设备对齐(使用 `ALIGN BY DEVICE`)
###### 目标设备不使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select s1, s2, s3, s4
@@ -999,7 +999,7 @@ align by device;
```
###### 目标设备使用变量占位符 & 目标物理量列表不使用变量占位符
-```
+```sql
select avg(s1), sum(s2) + sum(s3), count(s4)
@@ -1011,23 +1011,23 @@ align by device;
```
###### 目标设备使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select * into ::(backup_${4}) from root.sg.** align by device;
```
#### 指定目标序列为对齐序列
-```
+```sql
select s1, s2 into root.sg_copy.d1(t1, t2), aligned root.sg_copy.d2(t1, t2)
from root.sg.d1, root.sg.d2 align by device;
```
## 5. 运维语句
生成对应的查询计划
-```
+```sql
explain select s1,s2 from root.sg.d1
```
执行对应的查询语句,并获取分析结果
-```
+```sql
explain analyze select s1,s2 from root.sg.d1 order by s1
```
## 6. 运算符
@@ -1612,7 +1612,7 @@ SHOW TRIGGERS
### 12.1 语法
-```Go
+```sql
CREATE (CONTINUOUS QUERY | CQ) <cq_id>
[RESAMPLE
[EVERY <every_interval>]
@@ -1656,7 +1656,7 @@ END
\> SELECT temperature_max from root.ln.*.*;
```
#### 配置连续查询的时间窗口大小
-```
+```sql
CREATE CONTINUOUS QUERY cq2
RESAMPLE RANGE 40s
diff --git a/src/zh/UserGuide/latest/SQL-Manual/SQL-Manual_timecho.md
b/src/zh/UserGuide/latest/SQL-Manual/SQL-Manual_timecho.md
index 310ac056..256e2794 100644
--- a/src/zh/UserGuide/latest/SQL-Manual/SQL-Manual_timecho.md
+++ b/src/zh/UserGuide/latest/SQL-Manual/SQL-Manual_timecho.md
@@ -504,7 +504,7 @@ GROUP BY([10, 90), 10ms);
SQL 语法:
-```Go
+```sql
select last <Path> [COMMA <Path>]* from < PrefixPath > [COMMA < PrefixPath >]*
<whereClause> [ORDER BY TIMESERIES (DESC | ASC)?]
```
@@ -874,7 +874,7 @@ IoTDB> select s1 + s2 into root.expr.add(d1s1_d1s2),
root.expr.add(d2s1_d2s2) fr
##### 按时间对齐(默认)
###### 目标设备不使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select s1, s2
@@ -884,7 +884,7 @@ from root.sg.d1, root.sg.d2;
```
该语句等价于:
-```
+```sql
select s1, s2
@@ -895,7 +895,7 @@ from root.sg.d1, root.sg.d2;
###### 目标设备使用变量占位符 & 目标物理量列表不使用变量占位符
-```
+```sql
select d1.s1, d1.s2, d2.s3, d3.s4
into ::(s1_1, s2_2), root.sg.d2_2(s3_3), root.${2}_copy.::(s4)
@@ -905,14 +905,14 @@ from root.sg;
###### 目标设备使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select * into root.sg_bk.::(::) from root.sg.**;
```
##### 按设备对齐(使用 `ALIGN BY DEVICE`)
###### 目标设备不使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select s1, s2, s3, s4
@@ -924,7 +924,7 @@ align by device;
```
###### 目标设备使用变量占位符 & 目标物理量列表不使用变量占位符
-```
+```sql
select avg(s1), sum(s2) + sum(s3), count(s4)
@@ -936,23 +936,23 @@ align by device;
```
###### 目标设备使用变量占位符 & 目标物理量列表使用变量占位符
-```
+```sql
select * into ::(backup_${4}) from root.sg.** align by device;
```
#### 指定目标序列为对齐序列
-```
+```sql
select s1, s2 into root.sg_copy.d1(t1, t2), aligned root.sg_copy.d2(t1, t2)
from root.sg.d1, root.sg.d2 align by device;
```
## 5. 运维语句
生成对应的查询计划
-```
+```sql
explain select s1,s2 from root.sg.d1
```
执行对应的查询语句,并获取分析结果
-```
+```sql
explain analyze select s1,s2 from root.sg.d1 order by s1
```
## 6. 运算符
@@ -1581,7 +1581,7 @@ END
\> SELECT temperature_max from root.ln.*.*;
```
#### 配置连续查询的时间窗口大小
-```
+```sql
CREATE CONTINUOUS QUERY cq2
RESAMPLE RANGE 40s