You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "suchenglong (Jira)" <ji...@apache.org> on 2022/07/19 07:33:00 UTC
[jira] [Created] (IOTDB-3886) Continuous query does not support running on the hour
suchenglong created IOTDB-3886:
----------------------------------
Summary: Continuous query does not support running on the hour
Key: IOTDB-3886
URL: https://issues.apache.org/jira/browse/IOTDB-3886
Project: Apache IoTDB
Issue Type: Bug
Affects Versions: 0.13.1-SNAPSHOT
Reporter: suchenglong
连续查询不支持整点运行。
有如下数据，使用连续查询功能，在当前时间的前100s后，按10秒一次计算10s内的最大值。实际测试的结果中，期望得到的值为任意一个0s-10s(举例，也有10s-20s,20s-30s等)区间的最大值，实际按当前创建时间进行的设置。
CREATE TIMESERIES root.sg1.d1.s1 WITH DATATYPE=DOUBLE, ENCODING=PLAIN;
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:00.000, 100);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:09.000, 101);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:10.000, 102);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:15.000, 103);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:19.000, 104);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:20.000, 105);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:22.000, 106);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:28.000, 107);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:33.000, 108);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:36.000, 109);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:41.000, 110);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:48.000, 111);
INSERT INTO root.sg1.d1(timestamp, s1) VALUES (2022-07-19 15:01:52.000, 112);
连续查询配置：
CREATE CONTINUOUS QUERY cq1 RESAMPLE EVERY 10s FOR 10s BOUNDARY now()-100s
BEGIN SELECT max_value(s1) INTO root.sg1.d2.s1_max FROM root.sg1.d1 GROUP BY time(10s) END;
注：CREATE CONTINUOUS QUERY cq3 RESAMPLE EVERY 10s FOR 10s BOUNDARY 2022-07-19 14:50:00.000 BEGIN SELECT max_value(s1) INTO root.sg1.d2.s1_max FROM root.sg1.d1 GROUP BY time(10s) END;换成固定值，能够正确统计区间内的值。
--
This message was sent by Atlassian Jira
(v8.20.10#820010)