You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@iotdb.apache.org by ge...@apache.org on 2020/12/03 03:06:25 UTC
[iotdb] 01/01: update doc
This is an automated email from the ASF dual-hosted git repository.
geniuspig pushed a commit to branch update_doc
in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit 2750f2e072830a01bb09601bf95268dc5e92506a
Author: Boris <96...@qq.com>
AuthorDate: Thu Dec 3 11:06:03 2020 +0800
update doc
---
.../Operation Manual/DML Data Manipulation Language.md | 10 ++++++++++
.../Operation Manual/DML Data Manipulation Language.md | 16 +++++++++++++++-
2 files changed, 25 insertions(+), 1 deletion(-)
diff --git a/docs/UserGuide/Operation Manual/DML Data Manipulation Language.md b/docs/UserGuide/Operation Manual/DML Data Manipulation Language.md
index 994f4e9..a772308 100644
--- a/docs/UserGuide/Operation Manual/DML Data Manipulation Language.md
+++ b/docs/UserGuide/Operation Manual/DML Data Manipulation Language.md
@@ -752,6 +752,11 @@ The SQL statement is:
select s1,s2 from root.sg1.* align by device
```
+The result shows below:
+
+<center><img style="width:100%; max-width:800px; max-height:600px; margin-left:auto; margin-right:auto; display:block;" src="https://user-images.githubusercontent.com/26118649/100957517-94362200-3555-11eb-932c-511ea629f317.png"></center>
+
+
For more syntax description, please read [SQL Reference](../Operation%20Manual/SQL%20Reference.md).
The 'disable align' indicates that there are 2 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.
@@ -762,6 +767,11 @@ The SQL statement is:
select * from root.sg1 where time > 10 disable align
```
+The result shows below:
+
+<center><img style="width:100%; max-width:800px; max-height:600px; margin-left:auto; margin-right:auto; display:block;" src="https://user-images.githubusercontent.com/26118649/100957521-95ffe580-3555-11eb-8b26-14f36e106b13.png"></center>
+
+
For more syntax description, please read [SQL Reference](../Operation%20Manual/SQL%20Reference.md).
#### Error Handling
diff --git a/docs/zh/UserGuide/Operation Manual/DML Data Manipulation Language.md b/docs/zh/UserGuide/Operation Manual/DML Data Manipulation Language.md
index f021162..76a3527 100644
--- a/docs/zh/UserGuide/Operation Manual/DML Data Manipulation Language.md
+++ b/docs/zh/UserGuide/Operation Manual/DML Data Manipulation Language.md
@@ -802,9 +802,23 @@ SQL语句是：
select s1,s2 from root.sg1.* ALIGN BY DEVICE
```
+结果显示如下:
+<center><img style="width:100%; max-width:800px; max-height:600px; margin-left:auto; margin-right:auto; display:block;" src="https://user-images.githubusercontent.com/26118649/100957517-94362200-3555-11eb-932c-511ea629f317.png"></center>
-“禁用对齐”指示结果集中每个时间序列都有3列。 有关更多语法描述，更多语法请参照 [SQL REFERENCE](../Operation%20Manual/SQL%20Reference.md).
+“禁用对齐”指示结果集中每个时间序列都有3列。
+
+SQL语句是:
+
+ ```
+ select * from root.sg1 where time > 10 disable align
+ ```
+
+结果显示如下:
+
+<center><img style="width:100%; max-width:800px; max-height:600px; margin-left:auto; margin-right:auto; display:block;" src="https://user-images.githubusercontent.com/26118649/100957521-95ffe580-3555-11eb-8b26-14f36e106b13.png"></center>
+
+有关更多语法描述，更多语法请参照 [SQL REFERENCE](../Operation%20Manual/SQL%20Reference.md).
#### 错误处理