You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@iotdb.apache.org by ro...@apache.org on 2021/08/17 08:52:52 UTC
[iotdb] branch fix-chinese-doc created (now 54af94e)
This is an automated email from the ASF dual-hosted git repository.
rong pushed a change to branch fix-chinese-doc
in repository https://gitbox.apache.org/repos/asf/iotdb.git.
at 54af94e Fix incorrect descriptions in DDL-Data-Definition-Language(Chinses) and a typo in DML-Data-Manipulation-Language(Chinses)
This branch includes the following new commits:
new 54af94e Fix incorrect descriptions in DDL-Data-Definition-Language(Chinses) and a typo in DML-Data-Manipulation-Language(Chinses)
The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
[iotdb] 01/01: Fix incorrect descriptions in
DDL-Data-Definition-Language(Chinses) and a typo in
DML-Data-Manipulation-Language(Chinses)
Posted by ro...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
rong pushed a commit to branch fix-chinese-doc
in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit 54af94e4fd3f2e728dcf6b3dff1d536cb0966348
Author: Steve Yurong Su <ro...@apache.org>
AuthorDate: Tue Aug 17 16:51:26 2021 +0800
Fix incorrect descriptions in DDL-Data-Definition-Language(Chinses) and a typo in DML-Data-Manipulation-Language(Chinses)
---
.../DDL-Data-Definition-Language.md | 45 ++++++++++++----------
.../DML-Data-Manipulation-Language.md | 2 +-
2 files changed, 25 insertions(+), 22 deletions(-)
diff --git a/docs/zh/UserGuide/IoTDB-SQL-Language/DDL-Data-Definition-Language.md b/docs/zh/UserGuide/IoTDB-SQL-Language/DDL-Data-Definition-Language.md
index 42ada73..8e0be49 100644
--- a/docs/zh/UserGuide/IoTDB-SQL-Language/DDL-Data-Definition-Language.md
+++ b/docs/zh/UserGuide/IoTDB-SQL-Language/DDL-Data-Definition-Language.md
@@ -265,31 +265,34 @@ IoTDB > COUNT TIMESERIES root.ln.wf01 GROUP BY LEVEL=2
```
IoTDB> COUNT TIMESERIES root GROUP BY LEVEL=1
-+---------+-----+
-| column|count|
-+---------+-----+
-| root.ln| 4|
-|root.sgcc| 2|
-+---------+-----+
-Total line number = 2
-It costs 0.103s
++------------+-----+
+| column|count|
++------------+-----+
+| root.sgcc| 2|
+|root.turbine| 1|
+| root.ln| 4|
++------------+-----+
+Total line number = 3
+It costs 0.002s
+
IoTDB > COUNT TIMESERIES root.ln GROUP BY LEVEL=2
-+--------------+-----+
-| column|count|
-+--------------+-----+
-| root.ln.wf02| 1|
-| root.ln.wf01| 3|
-+--------------+-----+
++------------+-----+
+| column|count|
++------------+-----+
+|root.ln.wf02| 2|
+|root.ln.wf01| 2|
++------------+-----+
Total line number = 2
-It costs 0.003s
+It costs 0.002s
+
IoTDB > COUNT TIMESERIES root.ln.wf01 GROUP BY LEVEL=2
-+--------------+-----+
-| column|count|
-+--------------+-----+
-| root.ln.wf01| 4|
-+--------------+-----+
++------------+-----+
+| column|count|
++------------+-----+
+|root.ln.wf01| 2|
++------------+-----+
Total line number = 1
-It costs 0.001s
+It costs 0.002s
```
> 注意：时间序列的路径只是过滤条件，与 level 的定义无关。
diff --git a/docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md b/docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
index 6a7b5d1..fe97521 100644
--- a/docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
+++ b/docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
@@ -783,7 +783,7 @@ select <path> from <prefixPath> where time = <T> fill(<data_type>[linear, <befor
</center>
-需要注意的是一旦时间序列在查询时间戳 T 时刻存在有效值，线性填充就回使用这个值作为结果返回。
+需要注意的是一旦时间序列在查询时间戳 T 时刻存在有效值，线性填充就会使用这个值作为结果返回。
除此之外，如果在 [T-before_range，T] 或 [T, T + after_range] 两个范围中任意一个范围内不存在有效填充值，则线性填充返回 null 值。
在这里，我们举一个使用线性方法填充空值的示例。 SQL 语句如下：