This is an automated email from the ASF dual-hosted git repository. ericpai pushed a commit to branch feature/group_by_tag in repository https://gitbox.apache.org/repos/asf/iotdb.git
commit 77f967a1958d4c88f6a01d4b15e0a19de38fbdc5 Author: ericpai <[email protected]> AuthorDate: Tue Sep 6 17:25:55 2022 +0800 Fix type in docs --- docs/UserGuide/Query-Data/Aggregate-Query.md | 6 +++--- docs/zh/UserGuide/Query-Data/Aggregate-Query.md | 8 ++++---- 2 files changed, 7 insertions(+), 7 deletions(-) diff --git a/docs/UserGuide/Query-Data/Aggregate-Query.md b/docs/UserGuide/Query-Data/Aggregate-Query.md index d81f18c189..a293f3e038 100644 --- a/docs/UserGuide/Query-Data/Aggregate-Query.md +++ b/docs/UserGuide/Query-Data/Aggregate-Query.md @@ -528,7 +528,7 @@ insert into root.factory1.d9(time, temperature) values(3000, 52.1); If the user wants to know the average temperature of each workshop, he can query like this ```SQL -SELECT AVG(temperature) FROM root.sg.** GROUP BY TAGS city; +SELECT AVG(temperature) FROM root.factory1.** GROUP BY TAGS city; ``` The query will calculate the average of the temperatures of those timeseries which have the same tag value of the key `city`. @@ -562,7 +562,7 @@ So the aggregation by the tag `city` should be done first, and then by the tag ` SQL ```SQL -select avg(temperature) FROM root.factory1.** GROUP BY TAGS city, workshop; +SELECT avg(temperature) FROM root.factory1.** GROUP BY TAGS city, workshop; ``` The results @@ -592,7 +592,7 @@ For example, a user wants to know the average temperature of the devices in each SQL ```SQL -select avg(temperature) from root.factory1.** group by ([1000, 10000), 5s), tags city, workshop; +SELECT avg(temperature) FROM root.factory1.** GROUP BY ([1000, 10000), 5s), TAGS city, workshop; ``` The results diff --git a/docs/zh/UserGuide/Query-Data/Aggregate-Query.md b/docs/zh/UserGuide/Query-Data/Aggregate-Query.md index b7b5c285b5..7d7d4fba24 100644 --- a/docs/zh/UserGuide/Query-Data/Aggregate-Query.md +++ b/docs/zh/UserGuide/Query-Data/Aggregate-Query.md @@ -518,7 +518,7 @@ insert into root.factory1.d9(time, temperature) values(3000, 52.1); 用户想统统计该工厂每个地区的设备的温度的平均值，可以使用如下查询语句 ```SQL -SELECT AVG(temperature) FROM root.sg.** GROUP BY TAGS city; +SELECT AVG(temperature) FROM root.factory1.** GROUP BY TAGS city; ``` 该查询会将具有同一个 `city` 标签值的时间序列的所有满足查询条件的点做平均值计算，计算结果如下 @@ -549,7 +549,7 @@ It costs 0.231s SQL 语句如下 ```SQL -select avg(temperature) FROM root.factory1.** GROUP BY TAGS city, workshop; +SELECT avg(temperature) FROM root.factory1.** GROUP BY TAGS city, workshop; ``` 查询结果如下 @@ -579,7 +579,7 @@ It costs 0.027s SQL 语句如下 ```SQL -select avg(temperature) from root.factory1.** group by ([1000, 10000), 5s), tags city, workshop; +SELECT AVG(temperature) FROM root.factory1.** GROUP BY ([1000, 10000), 5s), TAGS city, workshop; ``` 查询结果如下 @@ -612,7 +612,7 @@ select avg(temperature) from root.factory1.** group by ([1000, 10000), 5s), tags > 3. 暂不支持 `LIMIT`，`OFFSET`，`SLIMIT`，`SOFFSET`。 > 4. 暂不支持 `ALIGN BY DEVICE`。 > 5. 暂不支持聚合函数内部包含表达式，例如 `count(s+1)`。 -> 6. 不支持值过滤条件聚合，和分成聚合查询行为保持一致。 +> 6. 不支持值过滤条件聚合，和分层聚合查询行为保持一致。 ## 聚合结果过滤
