This is an automated email from the ASF dual-hosted git repository.
qiaojialin pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-iotdb.git
The following commit(s) were added to refs/heads/master by this push:
new 0e7f217 fix group by sql reference
new ca7c698 Merge remote-tracking branch 'origin/master'
0e7f217 is described below
commit 0e7f217b2ccf72a7014b91d6e24987bb502f3ce2
Author: qiaojialin <[email protected]>
AuthorDate: Thu Mar 5 10:29:37 2020 +0800
fix group by sql reference
---
docs/Documentation/UserGuide/5-Operation Manual/4-SQL Reference.md | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
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 f7f5ab2..463de8d 100644
--- a/docs/Documentation/UserGuide/5-Operation Manual/4-SQL Reference.md
+++ b/docs/Documentation/UserGuide/5-Operation Manual/4-SQL Reference.md
@@ -274,9 +274,9 @@ GroupByClause : LPAREN <TimeInterval> COMMA <TimeUnit>
(COMMA <TimeUnit>)? RPARE
TimeInterval: LBRACKET <TimeValue> COMMA <TimeValue> RBRACKET
TimeUnit : Integer <DurationUnit>
DurationUnit : "ms" | "s" | "m" | "h" | "d" | "w"
-Eg: SELECT COUNT(status), COUNT(temperature) FROM root.ln.wf01.wt01 where
temperature < 24 GROUP BY([1509465720000, 1509466380000], 5m)
-Eg. SELECT COUNT (status), MAX_VALUE(temperature) FROM root.ln.wf01.wt01 WHERE
time < 1509466500000 GROUP BY([1509465720000, 1509466380000], 5m, 10m)
-Eg. SELECT MIN_TIME(status), MIN_VALUE(temperature) FROM root.ln.wf01.wt01
WHERE temperature < 25 GROUP BY ([1509466140000, 1509466380000], 3m, 5ms)
+Eg: SELECT COUNT(status), COUNT(temperature) FROM root.ln.wf01.wt01 where
temperature < 24 GROUP BY([1509465720000, 1509466380000), 5m)
+Eg. SELECT COUNT (status), MAX_VALUE(temperature) FROM root.ln.wf01.wt01 WHERE
time < 1509466500000 GROUP BY([1509465720000, 1509466380000), 5m, 10m)
+Eg. SELECT MIN_TIME(status), MIN_VALUE(temperature) FROM root.ln.wf01.wt01
WHERE temperature < 25 GROUP BY ([1509466140000, 1509466380000), 3m, 5ms)
Note: the statement needs to satisfy this constraint: <Path>(SelectClause) +
<PrefixPath>(FromClause) = <Timeseries>
Note: If the <SensorExpr>(WhereClause) is started with <Path> and not with
ROOT, the statement needs to satisfy this constraint: <PrefixPath>(FromClause)
+ <Path>(SensorExpr) = <Timeseries>
Note: <TimeValue>(TimeInterval) needs to be greater than 0
