You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@iotdb.apache.org by ja...@apache.org on 2022/02/10 11:53:31 UTC
[iotdb] branch IOTDB-2527 created (now c007d7a)
This is an automated email from the ASF dual-hosted git repository.
jackietien pushed a change to branch IOTDB-2527
in repository https://gitbox.apache.org/repos/asf/iotdb.git.
at c007d7a [IOTDB-2527] Move some contents in subSection to subSection
This branch includes the following new commits:
new c007d7a [IOTDB-2527] Move some contents in subSection to subSection
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: [IOTDB-2527] Move some contents in subSection to subSection
Posted by ja...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
jackietien pushed a commit to branch IOTDB-2527
in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit c007d7a3d20bae090d7c1456ef45e12e3087c0fa
Author: JackieTien97 <ja...@gmail.com>
AuthorDate: Thu Feb 10 19:52:05 2022 +0800
[IOTDB-2527] Move some contents in subSection to subSection
---
docs/UserGuide/Operate-Metadata/Timeseries.md | 68 +++++++++++------------
docs/zh/UserGuide/Operate-Metadata/Timeseries.md | 69 ++++++++++++------------
2 files changed, 71 insertions(+), 66 deletions(-)
diff --git a/docs/UserGuide/Operate-Metadata/Timeseries.md b/docs/UserGuide/Operate-Metadata/Timeseries.md
index 362fbcf..35ecfa4 100644
--- a/docs/UserGuide/Operate-Metadata/Timeseries.md
+++ b/docs/UserGuide/Operate-Metadata/Timeseries.md
@@ -130,39 +130,6 @@ Total line number = 4
It costs 0.004s
```
-* SHOW TIMESERIES (<`PathPattern`>)? WhereClause
-
- returns all the timeseries information that satisfy the where condition and match the pathPattern. SQL statements are as follows:
-
-```
-ALTER timeseries root.ln.wf02.wt02.hardware ADD TAGS unit=c
-ALTER timeseries root.ln.wf02.wt02.status ADD TAGS description=test1
-show timeseries root.ln.** where unit=c
-show timeseries root.ln.** where description contains 'test1'
-```
-
-The results are shown below respectly:
-
-```
-+--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
-| timeseries|alias|storage group|dataType|encoding|compression| tags|attributes|
-+--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
-|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN| SNAPPY|{"unit":"c"}| null|
-+--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
-Total line number = 1
-It costs 0.005s
-
-+------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
-| timeseries|alias|storage group|dataType|encoding|compression| tags|attributes|
-+------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
-|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN| SNAPPY|{"description":"test1"}| null|
-+------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
-Total line number = 1
-It costs 0.004s
-```
-
-> Notice that, we only support one condition in the where clause. Either it's an equal filter or it is an `contains` filter. In both case, the property in the where condition must be a tag.
-
* SHOW TIMESERIES LIMIT INT OFFSET INT
returns all the timeseries information start from the offset and limit the number of series returned. For example,
@@ -298,3 +265,38 @@ ALTER timeseries root.turbine.d1.s1 ADD ATTRIBUTES attr3=v3, attr4=v4
```
ALTER timeseries root.turbine.d1.s1 UPSERT ALIAS=newAlias TAGS(tag3=v3, tag4=v4) ATTRIBUTES(attr3=v3, attr4=v4)
```
+* show timeseries using tags
+```
+SHOW TIMESERIES (<`PathPattern`>)? WhereClause
+```
+
+ returns all the timeseries information that satisfy the where condition and match the pathPattern. SQL statements are as follows:
+
+```
+ALTER timeseries root.ln.wf02.wt02.hardware ADD TAGS unit=c
+ALTER timeseries root.ln.wf02.wt02.status ADD TAGS description=test1
+show timeseries root.ln.** where unit=c
+show timeseries root.ln.** where description contains 'test1'
+```
+
+The results are shown below respectly:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
+| timeseries|alias|storage group|dataType|encoding|compression| tags|attributes|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN| SNAPPY|{"unit":"c"}| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
+| timeseries|alias|storage group|dataType|encoding|compression| tags|attributes|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN| SNAPPY|{"description":"test1"}| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
+Total line number = 1
+It costs 0.004s
+```
+
+> Notice that, we only support one condition in the where clause. Either it's an equal filter or it is an `contains` filter. In both case, the property in the where condition must be a tag.
diff --git a/docs/zh/UserGuide/Operate-Metadata/Timeseries.md b/docs/zh/UserGuide/Operate-Metadata/Timeseries.md
index af87aed..45cc507 100644
--- a/docs/zh/UserGuide/Operate-Metadata/Timeseries.md
+++ b/docs/zh/UserGuide/Operate-Metadata/Timeseries.md
@@ -127,39 +127,6 @@ Total line number = 4
It costs 0.004s
```
-* SHOW TIMESERIES (<`PathPattern`>)? WhereClause
-
- 返回给定路径的下的所有满足条件的时间序列信息，SQL 语句如下所示：
-
-```
-ALTER timeseries root.ln.wf02.wt02.hardware ADD TAGS unit=c
-ALTER timeseries root.ln.wf02.wt02.status ADD TAGS description=test1
-show timeseries root.ln.** where unit=c
-show timeseries root.ln.** where description contains 'test1'
-```
-
-执行结果分别为：
-
-```
-+--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
-| timeseries|alias|storage group|dataType|encoding|compression| tags|attributes|
-+--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
-|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN| SNAPPY|{"unit":"c"}| null|
-+--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
-Total line number = 1
-It costs 0.005s
-
-+------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
-| timeseries|alias|storage group|dataType|encoding|compression| tags|attributes|
-+------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
-|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN| SNAPPY|{"description":"test1"}| null|
-+------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
-Total line number = 1
-It costs 0.004s
-```
-
-> 注意，现在我们只支持一个查询条件，要么是等值条件查询，要么是包含条件查询。当然 where 子句中涉及的必须是标签值，而不能是属性值。
-
* SHOW TIMESERIES LIMIT INT OFFSET INT
只返回从指定下标开始的结果，最大返回条数被 LIMIT 限制，用于分页查询。例如：
@@ -297,3 +264,39 @@ ALTER timeseries root.turbine.d1.s1 ADD ATTRIBUTES attr3=v3, attr4=v4
```
ALTER timeseries root.turbine.d1.s1 UPSERT ALIAS=newAlias TAGS(tag2=newV2, tag3=v3) ATTRIBUTES(attr3=v3, attr4=v4)
```
+
+* 使用标签作为过滤条件查询时间序列
+```
+* SHOW TIMESERIES (<`PathPattern`>)? WhereClause
+```
+
+ 返回给定路径的下的所有满足条件的时间序列信息，SQL 语句如下所示：
+
+```
+ALTER timeseries root.ln.wf02.wt02.hardware ADD TAGS unit=c
+ALTER timeseries root.ln.wf02.wt02.status ADD TAGS description=test1
+show timeseries root.ln.** where unit=c
+show timeseries root.ln.** where description contains 'test1'
+```
+
+执行结果分别为：
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
+| timeseries|alias|storage group|dataType|encoding|compression| tags|attributes|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN| SNAPPY|{"unit":"c"}| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
+| timeseries|alias|storage group|dataType|encoding|compression| tags|attributes|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN| SNAPPY|{"description":"test1"}| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+
+Total line number = 1
+It costs 0.004s
+```
+
+> 注意，现在我们只支持一个查询条件，要么是等值条件查询，要么是包含条件查询。当然 where 子句中涉及的必须是标签值，而不能是属性值。