You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@iotdb.apache.org by le...@apache.org on 2020/01/12 09:25:04 UTC

[incubator-iotdb] branch rel/0.9 updated: [IOTDB-316] add AVG function to 4-SQL Reference.md and modify style (#584)

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

leirui pushed a commit to branch rel/0.9
in repository https://gitbox.apache.org/repos/asf/incubator-iotdb.git


The following commit(s) were added to refs/heads/rel/0.9 by this push:
     new 03de669  [IOTDB-316] add AVG function to 4-SQL Reference.md and modify style (#584)
03de669 is described below

commit 03de6696089a3f2478863c788821c778c86248df
Author: Dawei Liu <13...@qq.com>
AuthorDate: Tue Nov 26 12:08:52 2019 +0800

    [IOTDB-316] add AVG function to 4-SQL Reference.md and modify style (#584)
    
    
    (cherry picked from commit b2433c70d189718543bea0797f2126bf1699bd66)
---
 .../UserGuide/5-Operation Manual/4-SQL Reference.md           | 11 +++++++----
 .../UserGuide/5-Operation Manual/4-SQL Reference.md           |  9 ++++-----
 2 files changed, 11 insertions(+), 9 deletions(-)

diff --git a/docs/Documentation-CHN/UserGuide/5-Operation Manual/4-SQL Reference.md b/docs/Documentation-CHN/UserGuide/5-Operation Manual/4-SQL Reference.md
index b1e10ee..f9d2424 100644
--- a/docs/Documentation-CHN/UserGuide/5-Operation Manual/4-SQL Reference.md	
+++ b/docs/Documentation-CHN/UserGuide/5-Operation Manual/4-SQL Reference.md	
@@ -141,6 +141,7 @@ Note: This statement can be used in IoTDB Client and JDBC.
 ```
 
 * 显示设备语句
+
 ```
 SHOW DEVICES
 Eg: IoTDB > SHOW DEVICES
@@ -148,6 +149,7 @@ Note: This statement can be used in IoTDB Client and JDBC.
 ```
 
 * 显示ROOT节点的子节点名称语句
+
 ```
 SHOW CHILD PATHS
 Eg: IoTDB > SHOW CHILD PATHS
@@ -155,6 +157,7 @@ Note: This statement can be used in IoTDB Client and JDBC.
 ```
 
 * 显示子节点名称语句
+
 ```
 SHOW CHILD PATHS <Path>
 Eg: IoTDB > SHOW CHILD PATHS root
@@ -516,11 +519,11 @@ Eg. SELECT MAX_VALUE(status), MAX_VALUE(temperature) FROM root.ln.wf01.wt01 WHER
 Note: the statement needs to satisfy this constraint: <PrefixPath> + <Path> = <Timeseries>
 ```
 
-* MEAN
-
+* AVG
+原有的 `MEAN` 方法在 `v0.9.0` 版本更名为 `AVG`。
 ```
-SELECT MEAN (Path) (COMMA MEAN (Path))* FROM <FromClause> [WHERE <WhereClause>]?
-Eg. SELECT MEAN (temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 24
+SELECT AVG (Path) (COMMA AVG (Path))* FROM <FromClause> [WHERE <WhereClause>]?
+Eg. SELECT AVG (temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 24
 Note: the statement needs to satisfy this constraint: <PrefixPath> + <Path> = <Timeseries>
 ```
 
diff --git a/docs/Documentation/UserGuide/5-Operation Manual/4-SQL Reference.md b/docs/Documentation/UserGuide/5-Operation Manual/4-SQL Reference.md
index b1b399f..65f96d1 100644
--- a/docs/Documentation/UserGuide/5-Operation Manual/4-SQL Reference.md	
+++ b/docs/Documentation/UserGuide/5-Operation Manual/4-SQL Reference.md	
@@ -398,7 +398,6 @@ For example, "select s0,s0,s1 from root.sg.* group by device" is not equal to "s
    - select count(*) from root.vehicle group by device
    - select sum(*) from root.vehicle GROUP BY (20ms,0,[2,50]) group by device
    - select * from root.vehicle where time = 3 Fill(int32[previous, 5ms]) group by device
-
 ```
 
 
@@ -610,13 +609,13 @@ Eg. SELECT MAX_VALUE(status), MAX_VALUE(temperature) FROM root.ln.wf01.wt01 WHER
 Note: the statement needs to satisfy this constraint: <PrefixPath> + <Path> = <Timeseries>
 ```
 
-* MEAN
+* AVG(Rename from `MEAN` at `V0.9.0`)
 
-The MEAN function returns the arithmetic mean value of the choosen timeseries over a specified period of time. The timeseries must be int32, int64, float, double type, and the other types are not to be calculated. The result is a double type number.
+The AVG function returns the arithmetic mean value of the choosen timeseries over a specified period of time. The timeseries must be int32, int64, float, double type, and the other types are not to be calculated. The result is a double type number.
 
 ```
-SELECT MEAN (Path) (COMMA MEAN (Path))* FROM <FromClause> [WHERE <WhereClause>]?
-Eg. SELECT MEAN (temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 24
+SELECT AVG (Path) (COMMA AVG (Path))* FROM <FromClause> [WHERE <WhereClause>]?
+Eg. SELECT AVG (temperature) FROM root.ln.wf01.wt01 WHERE root.ln.wf01.wt01.temperature < 24
 Note: the statement needs to satisfy this constraint: <PrefixPath> + <Path> = <Timeseries>
 ```