[iotdb] branch master updated: Supplement the document (#1710)

Tue, 13 Oct 2020 20:55:03 -0700 

This is an automated email from the ASF dual-hosted git repository.

haonan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/iotdb.git


The following commit(s) were added to refs/heads/master by this push:
     new 844b4e6  Supplement the document (#1710)
844b4e6 is described below

commit 844b4e6d36af9d587e5a6e727b1b1634200004ae
Author: yanhong wang <[email protected]>
AuthorDate: Wed Oct 14 11:51:21 2020 +0800

    Supplement the document (#1710)
    
    * Supplement the document
    
    * indicate that the prefix path can be specified
    
    * docs
    
    * Update docs/UserGuide/Operation Manual/DDL Data Definition Language.md
    
    Co-authored-by: Haonan <[email protected]>
    
    Co-authored-by: yhwang-hbl <[email protected]>
    Co-authored-by: Haonan <[email protected]>
---
 .../Operation Manual/DDL Data Definition Language.md  | 19 +++++++++++++++++--
 docs/UserGuide/Operation Manual/SQL Reference.md      | 10 ++++++++++
 .../Operation Manual/DDL Data Definition Language.md  |  5 +++--
 docs/zh/UserGuide/Operation Manual/SQL Reference.md   | 10 ++++++++++
 4 files changed, 40 insertions(+), 4 deletions(-)

diff --git a/docs/UserGuide/Operation Manual/DDL Data Definition Language.md 
b/docs/UserGuide/Operation Manual/DDL Data Definition Language.md
index c39d482..bf2f0fb 100644
--- a/docs/UserGuide/Operation Manual/DDL Data Definition Language.md   
+++ b/docs/UserGuide/Operation Manual/DDL Data Definition Language.md   
@@ -41,14 +41,15 @@ Msg: org.apache.iotdb.exception.MetadataErrorException: 
org.apache.iotdb.excepti
 
 ## Show Storage Group
 
-After the storage group is created, we can use the [SHOW STORAGE 
GROUP](../Operation%20Manual/SQL%20Reference.md) statement to view all the 
storage groups. The SQL statement is as follows:
+After the storage group is created, we can use the [SHOW STORAGE 
GROUP](../Operation%20Manual/SQL%20Reference.md) statement and [SHOW STORAGE 
GROUP \<PrefixPath>](../Operation%20Manual/SQL%20Reference.md) to view the 
storage groups. The SQL statements are as follows:
 
 ```
 IoTDB> show storage group
+IoTDB> show storage group root.ln
 ```
 
 The result is as follows:
-<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/13203019/51577338-84c70600-1ef4-11e9-9dab-605b32c02836.jpg";></center>
+<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/67779101/92545299-6c029400-f282-11ea-80ea-b672a57f4b13.png";></center>
 
 ## Delete Storage Group
 
@@ -311,6 +312,20 @@ IoTDB> unset ttl to root.ln
 
 After unset TTL, all data will be accepted in `root.ln`
 
+## Show TTL
+
+To Show TTL, we can use follwing SQL statement:
+
+```
+IoTDB> SHOW ALL TTL
+IoTDB> SHOW TTL ON StorageGroupNames
+```
+
+The SHOW ALL TTL example gives the TTL for all storage groups.
+The SHOW TTL ON  root.group1 , root.group2 , root.group3 example shows the TTL 
for the three storage 
+groups specified.
+Note: the TTL for storage groups that do not have a TTL set will display as 
null.
+
 ## FLUSH
 
 Persist all the data points in the memory table of the storage group to the 
disk, and seal the data file.
diff --git a/docs/UserGuide/Operation Manual/SQL Reference.md 
b/docs/UserGuide/Operation Manual/SQL Reference.md
index 053e5c1..4b41bf9 100644
--- a/docs/UserGuide/Operation Manual/SQL Reference.md  
+++ b/docs/UserGuide/Operation Manual/SQL Reference.md  
@@ -193,6 +193,16 @@ Eg: IoTDB > SHOW STORAGE GROUP
 Note: This statement can be used in IoTDB Client and JDBC.
 ```
 
+* Show Specific Storage Group Statement
+
+```
+SHOW STORAGE GROUP <PrefixPath>
+Eg: IoTDB > SHOW STORAGE GROUP root.*
+Eg: IoTDB > SHOW STORAGE GROUP root.ln
+Note: The path can be prefix path or star path.
+Note: This statement can be used in IoTDB Client and JDBC.
+```
+
 * Show Merge Status Statement
 
 ```
diff --git a/docs/zh/UserGuide/Operation Manual/DDL Data Definition Language.md 
b/docs/zh/UserGuide/Operation Manual/DDL Data Definition Language.md
index ab77d87..7d7b0ff 100644
--- a/docs/zh/UserGuide/Operation Manual/DDL Data Definition Language.md        
+++ b/docs/zh/UserGuide/Operation Manual/DDL Data Definition Language.md        
@@ -41,14 +41,15 @@ Msg: org.apache.iotdb.exception.MetadataErrorException: 
org.apache.iotdb.excepti
 
 ## 查看存储组
 
-在存储组创建后，我们可以使用[SHOW STORAGE 
GROUP](../Operation%20Manual/SQL%20Reference.md)语句来查看所有的存储组，SQL语句如下所示：
+在存储组创建后，我们可以使用[SHOW STORAGE 
GROUP](../Operation%20Manual/SQL%20Reference.md)语句和[SHOW STORAGE GROUP 
\<PrefixPath>](../Operation%20Manual/SQL%20Reference.md)来查看存储组，SQL语句如下所示：
 
 ```
 IoTDB> show storage group
+IoTDB> show storage group root.ln
 ```
 
 执行结果为：
-<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/13203019/51577338-84c70600-1ef4-11e9-9dab-605b32c02836.jpg";></center>
+<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/67779101/92545299-6c029400-f282-11ea-80ea-b672a57f4b13.png";></center>
 
 ## 删除存储组
 
diff --git a/docs/zh/UserGuide/Operation Manual/SQL Reference.md 
b/docs/zh/UserGuide/Operation Manual/SQL Reference.md
index 294e2e7..504abf4 100644
--- a/docs/zh/UserGuide/Operation Manual/SQL Reference.md       
+++ b/docs/zh/UserGuide/Operation Manual/SQL Reference.md       
@@ -182,6 +182,16 @@ Eg: IoTDB > SHOW STORAGE GROUP
 Note: This statement can be used in IoTDB Client and JDBC.
 ```
 
+* 显示特定存储组语句
+
+```
+SHOW STORAGE GROUP <PrefixPath>
+Eg: IoTDB > SHOW STORAGE GROUP root.*
+Eg: IoTDB > SHOW STORAGE GROUP root.ln
+Note: The path can be prefix path or star path.
+Note: This statement can be used in IoTDB Client and JDBC.
+```
+
 * 显示Merge状态语句
 
 ```

Reply via email to