This is an automated email from the ASF dual-hosted git repository.
critas pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/iotdb-docs.git
The following commit(s) were added to refs/heads/main by this push:
new 5e041d78 add show timeseries where tag (#657)
5e041d78 is described below
commit 5e041d78c83808f3fe7fdb906ec134146cefa42b
Author: leto-b <[email protected]>
AuthorDate: Tue Mar 25 11:34:35 2025 +0800
add show timeseries where tag (#657)
---
.../Tree/Basic-Concept/Operate-Metadata_apache.md | 31 +++++++++++++++++++
.../Tree/Basic-Concept/Operate-Metadata_timecho.md | 32 +++++++++++++++++++
.../Basic-Concept/Operate-Metadata_apache.md | 31 +++++++++++++++++++
.../Basic-Concept/Operate-Metadata_timecho.md | 32 +++++++++++++++++++
.../Basic-Concept/Operate-Metadata_apache.md | 31 +++++++++++++++++++
.../Basic-Concept/Operate-Metadata_timecho.md | 32 +++++++++++++++++++
.../Basic-Concept/Operate-Metadata_apache.md | 31 +++++++++++++++++++
.../Basic-Concept/Operate-Metadata_timecho.md | 32 +++++++++++++++++++
.../Tree/Basic-Concept/Operate-Metadata_apache.md | 31 +++++++++++++++++++
.../Tree/Basic-Concept/Operate-Metadata_timecho.md | 32 +++++++++++++++++++
.../Basic-Concept/Operate-Metadata_apache.md | 32 +++++++++++++++++++
.../Basic-Concept/Operate-Metadata_timecho.md | 31 +++++++++++++++++++
.../Basic-Concept/Operate-Metadata_apache.md | 36 ++++++++++++++++++++--
.../Basic-Concept/Operate-Metadata_timecho.md | 35 +++++++++++++++++++--
.../Basic-Concept/Operate-Metadata_apache.md | 31 +++++++++++++++++++
.../Basic-Concept/Operate-Metadata_timecho.md | 32 +++++++++++++++++++
16 files changed, 506 insertions(+), 6 deletions(-)
diff --git a/src/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_apache.md
b/src/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_apache.md
index de7833bc..d2ebcb04 100644
--- a/src/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_apache.md
+++ b/src/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_apache.md
@@ -743,6 +743,37 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ The query result set is filtered by tags. For example:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+The query results are as follows:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
* SHOW LATEST TIMESERIES
diff --git
a/src/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_timecho.md
b/src/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_timecho.md
index f617f29e..f2dbb7e3 100644
--- a/src/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_timecho.md
+++ b/src/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_timecho.md
@@ -745,6 +745,38 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ The query result set is filtered by tags. For example:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+The query results are as follows:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
+
* SHOW LATEST TIMESERIES
all the returned timeseries information should be sorted in descending
order of the last timestamp of timeseries
diff --git a/src/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_apache.md
b/src/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_apache.md
index 00bd8e68..f74fccb5 100644
--- a/src/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_apache.md
+++ b/src/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_apache.md
@@ -743,6 +743,37 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ The query result set is filtered by tags. For example:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+ The query results are as follows:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
* SHOW LATEST TIMESERIES
diff --git a/src/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_timecho.md
b/src/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_timecho.md
index 568b1ee0..6cba2869 100644
--- a/src/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_timecho.md
+++ b/src/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_timecho.md
@@ -745,6 +745,38 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ The query result set is filtered by tags. For example:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+The query results are as follows:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
+
* SHOW LATEST TIMESERIES
all the returned timeseries information should be sorted in descending
order of the last timestamp of timeseries
diff --git a/src/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_apache.md
b/src/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_apache.md
index 00bd8e68..f74fccb5 100644
--- a/src/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_apache.md
+++ b/src/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_apache.md
@@ -743,6 +743,37 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ The query result set is filtered by tags. For example:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+ The query results are as follows:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
* SHOW LATEST TIMESERIES
diff --git a/src/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_timecho.md
b/src/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_timecho.md
index 568b1ee0..6cba2869 100644
--- a/src/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_timecho.md
+++ b/src/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_timecho.md
@@ -745,6 +745,38 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ The query result set is filtered by tags. For example:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+The query results are as follows:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
+
* SHOW LATEST TIMESERIES
all the returned timeseries information should be sorted in descending
order of the last timestamp of timeseries
diff --git a/src/UserGuide/latest/Basic-Concept/Operate-Metadata_apache.md
b/src/UserGuide/latest/Basic-Concept/Operate-Metadata_apache.md
index de7833bc..d2ebcb04 100644
--- a/src/UserGuide/latest/Basic-Concept/Operate-Metadata_apache.md
+++ b/src/UserGuide/latest/Basic-Concept/Operate-Metadata_apache.md
@@ -743,6 +743,37 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ The query result set is filtered by tags. For example:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+The query results are as follows:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
* SHOW LATEST TIMESERIES
diff --git a/src/UserGuide/latest/Basic-Concept/Operate-Metadata_timecho.md
b/src/UserGuide/latest/Basic-Concept/Operate-Metadata_timecho.md
index f617f29e..f2dbb7e3 100644
--- a/src/UserGuide/latest/Basic-Concept/Operate-Metadata_timecho.md
+++ b/src/UserGuide/latest/Basic-Concept/Operate-Metadata_timecho.md
@@ -745,6 +745,38 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ The query result set is filtered by tags. For example:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+The query results are as follows:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
+
* SHOW LATEST TIMESERIES
all the returned timeseries information should be sorted in descending
order of the last timestamp of timeseries
diff --git
a/src/zh/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_apache.md
b/src/zh/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_apache.md
index efc17275..bfb0391f 100644
--- a/src/zh/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_apache.md
+++ b/src/zh/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_apache.md
@@ -725,6 +725,37 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ 对查询结果集根据标签进行过滤。例如:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+执行结果分别为:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
* SHOW LATEST TIMESERIES
表示查询出的时间序列需要按照最近插入时间戳降序排列
diff --git
a/src/zh/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_timecho.md
b/src/zh/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_timecho.md
index 55a99009..effb7c03 100644
--- a/src/zh/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_timecho.md
+++ b/src/zh/UserGuide/Master/Tree/Basic-Concept/Operate-Metadata_timecho.md
@@ -724,12 +724,44 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ 对查询结果集根据标签进行过滤。例如:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+执行结果分别为:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
* SHOW LATEST TIMESERIES
表示查询出的时间序列需要按照最近插入时间戳降序排列
+
需要注意的是,当查询路径不存在时,系统会返回 0 条时间序列。
### 3.5 统计时间序列总数
diff --git a/src/zh/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_apache.md
b/src/zh/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_apache.md
index 1d4771d4..84fff90f 100644
--- a/src/zh/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_apache.md
+++ b/src/zh/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_apache.md
@@ -725,6 +725,38 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ 对查询结果集根据标签进行过滤。例如:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+执行结果分别为:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
+
* SHOW LATEST TIMESERIES
表示查询出的时间序列需要按照最近插入时间戳降序排列
diff --git a/src/zh/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_timecho.md
b/src/zh/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_timecho.md
index 7bbe7801..d8d79ebf 100644
--- a/src/zh/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_timecho.md
+++ b/src/zh/UserGuide/V1.3.x/Basic-Concept/Operate-Metadata_timecho.md
@@ -723,6 +723,37 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ 对查询结果集根据标签进行过滤。例如:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+执行结果分别为:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
* SHOW LATEST TIMESERIES
diff --git a/src/zh/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_apache.md
b/src/zh/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_apache.md
index ea83b049..84fff90f 100644
--- a/src/zh/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_apache.md
+++ b/src/zh/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_apache.md
@@ -141,9 +141,7 @@ It costs 0.002s
### 数据存活时间(TTL)
-IoTDB 支持对 device 级别设置数据存活时间(TTL),这使得 IoTDB 可以定期、自动地删除一定时间之前的数据。合理使用 TTL
-可以帮助您控制 IoTDB 占用的总磁盘空间以避免出现磁盘写满等异常。并且,随着文件数量的增多,查询性能往往随之下降,
-内存占用也会有所提高。及时地删除一些较老的文件有助于使查询性能维持在一个较高的水平和减少内存资源的占用。
+IoTDB 支持对 device 级别设置数据存活时间(TTL),这使得 IoTDB 可以定期、自动地删除一定时间之前的数据。合理使用 TTL可以帮助您控制
IoTDB
占用的总磁盘空间以避免出现磁盘写满等异常。并且,随着文件数量的增多,查询性能往往随之下降,内存占用也会有所提高。及时地删除一些较老的文件有助于使查询性能维持在一个较高的水平和减少内存资源的占用。
TTL的默认单位为毫秒,如果配置文件中的时间精度修改为其他单位,设置ttl时仍然使用毫秒单位。
@@ -727,6 +725,38 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ 对查询结果集根据标签进行过滤。例如:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+执行结果分别为:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
+
* SHOW LATEST TIMESERIES
表示查询出的时间序列需要按照最近插入时间戳降序排列
diff --git a/src/zh/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_timecho.md
b/src/zh/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_timecho.md
index 0fa4e4ec..d8d79ebf 100644
--- a/src/zh/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_timecho.md
+++ b/src/zh/UserGuide/dev-1.3/Basic-Concept/Operate-Metadata_timecho.md
@@ -140,9 +140,7 @@ It costs 0.002s
### 数据存活时间(TTL)
-IoTDB 支持对 device 级别设置数据存活时间(TTL),这使得 IoTDB 可以定期、自动地删除一定时间之前的数据。合理使用 TTL
-可以帮助您控制 IoTDB 占用的总磁盘空间以避免出现磁盘写满等异常。并且,随着文件数量的增多,查询性能往往随之下降,
-内存占用也会有所提高。及时地删除一些较老的文件有助于使查询性能维持在一个较高的水平和减少内存资源的占用。
+IoTDB 支持对 device 级别设置数据存活时间(TTL),这使得 IoTDB 可以定期、自动地删除一定时间之前的数据。合理使用 TTL
可以帮助您控制 IoTDB
占用的总磁盘空间以避免出现磁盘写满等异常。并且,随着文件数量的增多,查询性能往往随之下降,内存占用也会有所提高。及时地删除一些较老的文件有助于使查询性能维持在一个较高的水平和减少内存资源的占用。
TTL的默认单位为毫秒,如果配置文件中的时间精度修改为其他单位,设置ttl时仍然使用毫秒单位。
@@ -725,6 +723,37 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ 对查询结果集根据标签进行过滤。例如:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+执行结果分别为:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
* SHOW LATEST TIMESERIES
diff --git a/src/zh/UserGuide/latest/Basic-Concept/Operate-Metadata_apache.md
b/src/zh/UserGuide/latest/Basic-Concept/Operate-Metadata_apache.md
index efc17275..bfb0391f 100644
--- a/src/zh/UserGuide/latest/Basic-Concept/Operate-Metadata_apache.md
+++ b/src/zh/UserGuide/latest/Basic-Concept/Operate-Metadata_apache.md
@@ -725,6 +725,37 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ 对查询结果集根据标签进行过滤。例如:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+执行结果分别为:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
* SHOW LATEST TIMESERIES
表示查询出的时间序列需要按照最近插入时间戳降序排列
diff --git a/src/zh/UserGuide/latest/Basic-Concept/Operate-Metadata_timecho.md
b/src/zh/UserGuide/latest/Basic-Concept/Operate-Metadata_timecho.md
index 55a99009..effb7c03 100644
--- a/src/zh/UserGuide/latest/Basic-Concept/Operate-Metadata_timecho.md
+++ b/src/zh/UserGuide/latest/Basic-Concept/Operate-Metadata_timecho.md
@@ -724,12 +724,44 @@ It costs 0.016s
```
+* SHOW TIMESERIES WHERE TAGS(KEY) = VALUE
+* SHOW TIMESERIES WHERE TAGS(KEY) CONTAINS VALUE
+
+ 对查询结果集根据标签进行过滤。例如:
+
+```
+show timeseries root.ln.** where TAGS(unit)='c'
+show timeseries root.ln.** where TAGS(description) contains 'test1'
+```
+
+执行结果分别为:
+
+```
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.hardware| null| root.ln| TEXT| PLAIN|
SNAPPY|{"unit":"c"}| null| null| null|
++--------------------------+-----+-------------+--------+--------+-----------+------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.005s
+
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+| timeseries|alias| database|dataType|encoding|compression|
tags|attributes|deadband|deadband parameters|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+|root.ln.wf02.wt02.status| null| root.ln| BOOLEAN| PLAIN|
SNAPPY|{"description":"test1"}| null| null| null|
++------------------------+-----+-------------+--------+--------+-----------+-----------------------+----------+--------+-------------------+
+Total line number = 1
+It costs 0.004s
+
+```
+
* SHOW LATEST TIMESERIES
表示查询出的时间序列需要按照最近插入时间戳降序排列
+
需要注意的是,当查询路径不存在时,系统会返回 0 条时间序列。
### 3.5 统计时间序列总数