HTHou commented on a change in pull request #2072:
URL: https://github.com/apache/iotdb/pull/2072#discussion_r526540052
##########
File path: docs/UserGuide/Operation Manual/DML Data Manipulation Language.md
##########
@@ -742,12 +742,20 @@ The 'align by device' indicates that the deviceId is
considered as a column. The
The SQL statement is:
```
-select s1,s2 from root.sg1.* ALIGN BY DEVICE
+select s1,s2 from root.sg1.* align by device
```
For more syntax description, please read SQL REFERENCE.
-The 'disable align' indicaes that there are 3 columns for each time series in
the resultset. For more syntax description, please read SQL REFERENCE.
+The 'disable align' indicates that there are 3 columns for each time series in
the result set. Disable Align Clause can only be used at the end of a query
statement. Disable Align Clause cannot be used with Aggregation, Fill
Statements, Group By or Group By Device Statements, but can with Limit
Statements. The display principle of the result table is that only when the
column (or row) has existing data will the column (or row) be shown, with
nonexistent cells being empty.
+
+The SQL statement is:
+
+```
+select * from root.sg1 where time > 10 disable align
+```
Review comment:
How about add a sample screenshot？
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
