You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@iotdb.apache.org by qi...@apache.org on 2020/04/28 02:58:38 UTC
[incubator-iotdb] branch master updated: add show child paths
documents. (#1108)
This is an automated email from the ASF dual-hosted git repository.
qiaojialin pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-iotdb.git
The following commit(s) were added to refs/heads/master by this push:
new e1da6e8 add show child paths documents. (#1108)
e1da6e8 is described below
commit e1da6e8abff0916622dd67400e9311d915392fba
Author: Boris <zh...@gmail.com>
AuthorDate: Tue Apr 28 10:58:29 2020 +0800
add show child paths documents. (#1108)
* add show child paths doc
---
.../1-DDL Data Definition Language.md | 32 ++++++++++++++++++++++
.../1-DDL Data Definition Language.md | 32 ++++++++++++++++++++++
2 files changed, 64 insertions(+)
diff --git a/docs/UserGuide/5-Operation Manual/1-DDL Data Definition Language.md b/docs/UserGuide/5-Operation Manual/1-DDL Data Definition Language.md
index 61bf416..d1f9267 100644
--- a/docs/UserGuide/5-Operation Manual/1-DDL Data Definition Language.md
+++ b/docs/UserGuide/5-Operation Manual/1-DDL Data Definition Language.md
@@ -165,6 +165,38 @@ The results are shown below respectly:
It is worth noting that when the queried path does not exist, the system will return no timeseries.
+## Show Child Paths
+
+```
+SHOW CHILD PATHS prefixPath
+```
+
+Return all child paths of the prefixPath, the prefixPath could contains *.
+
+Example:
+
+* return the child paths of root.ln:show child paths root.ln
+
+```
++------------+
+| child paths|
++------------+
+|root.ln.wf01|
+|root.ln.wf02|
++------------+
+```
+
+* get all paths in form of root.xx.xx.xx:show child paths root.\*.\*
+
+```
++---------------+
+| child paths|
++---------------+
+|root.ln.wf01.s1|
+|root.ln.wf02.s2|
++---------------+
+```
+
## Count Timeseries
IoTDB is able to use `COUNT TIMESERIES <Path>` to count the number of timeseries in the path. SQL statements are as follows:
diff --git a/docs/zh/UserGuide/5-Operation Manual/1-DDL Data Definition Language.md b/docs/zh/UserGuide/5-Operation Manual/1-DDL Data Definition Language.md
index 867f120..7e6c3bc 100644
--- a/docs/zh/UserGuide/5-Operation Manual/1-DDL Data Definition Language.md
+++ b/docs/zh/UserGuide/5-Operation Manual/1-DDL Data Definition Language.md
@@ -163,6 +163,38 @@ show timeseries root.ln where description contains 'test1'
需要注意的是,当查询路径不存在时,系统会返回0条时间序列。
+## 查看子路径
+
+```
+SHOW CHILD PATHS prefixPath
+```
+
+可以查看此前缀路径的下一层的所有路径,前缀路径允许使用 * 通配符。
+
+示例:
+
+* 查询 root.ln 的下一层:show child paths root.ln
+
+```
++------------+
+| child paths|
++------------+
+|root.ln.wf01|
+|root.ln.wf02|
++------------+
+```
+
+* 查询形如 root.xx.xx.xx 的路径:show child paths root.\*.\*
+
+```
++---------------+
+| child paths|
++---------------+
+|root.ln.wf01.s1|
+|root.ln.wf02.s2|
++---------------+
+```
+
## 统计时间序列总数
IoTDB支持使用`COUNT TIMESERIES<Path>`来统计一条路径中的时间序列个数。SQL语句如下所示: