dsilletti commented on issue #17030:
URL: https://github.com/apache/iotdb/issues/17030#issuecomment-3822110455
Hi, @CRZbulabula ,
I have TTL configured for raw data cleanup:
```
IoTDB> SHOW ALL TTL;
+--------------------------------+---------+
| Device| TTL(ms)|
+--------------------------------+---------+
| root.**| INF|
|root.electricity.measured.raw.**|604800000|
+--------------------------------+---------+
Total line number = 2
It costs 0.015s
```
Basically I aggregate data in minutes and hours and I remove raw data using
the TTL, then I use 1h data or 1m data for my queries.
```
IoTDB> SHOW continuous queries;
+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+
| CQId|
Query| State|
+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+
| AVG_1h| CREATE CONTINUOUS QUERY AVG_1h
RESAMPLE EVERY 1h RANGE 2h
BEGIN
SELECT
CAST(avg(W) AS INT32),
CAST(avg(VAR) AS INT32),
CAST(ROUND(avg(V) * 100) / 100 AS FLOAT),
CAST(ROUND(avg(I) * 100) / 100 AS FLOAT),
CAST(ROUND(avg(pf) * 1000) / 1000 AS FLOAT),
CAST(ROUND(avg(Hz) * 100) / 100 AS FLOAT)
INTO root.electricity.measured.1h.::(W, VAR, V, I, pf, Hz)
FROM root.electricity.measured.1m.**
GROUP BY(1h)
ALIGN BY DEVICE
END|ACTIVE|
| AVG_1m|CREATE CONTINUOUS QUERY AVG_1m
RESAMPLE EVERY 1m RANGE 2m
BEGIN
SELECT
CAST(avg(W) AS INT32),
CAST(avg(VAR) AS INT32),
CAST(ROUND(avg(V) * 100) / 100 AS FLOAT),
CAST(ROUND(avg(I) * 100) / 100 AS FLOAT),
CAST(ROUND(avg(pf) * 1000) / 1000 AS FLOAT),
CAST(ROUND(avg(Hz) * 100) / 100 AS FLOAT)
INTO root.electricity.measured.1m.::(W, VAR, V, I, pf, Hz)
FROM root.electricity.measured.raw.**
GROUP BY(1m)
ALIGN BY DEVICE
END|ACTIVE|
| Wh_in_1h|
CREATE CONTINUOUS QUERY Wh_in_1h
RESAMPLE EVERY 1h RANGE 2h
BEGIN
SELECT
CAST(sum(Wh_in) AS FLOAT)
INTO root.electricity.measured.1h.::(Wh_in)
FROM root.electricity.measured.1m.**
GROUP BY(1h)
ALIGN BY DEVICE
END|ACTIVE|
| Wh_in_1m|
CREATE
CONTINUOUS QUERY Wh_in_1m
RESAMPLE EVERY 1m RANGE 2m
BEGIN
SELECT
CAST(sum(Wh) AS FLOAT)
INTO root.electricity.measured.1m.::(Wh_in)
FROM root.electricity.measured.raw.**
WHERE Wh > 0
GROUP BY(1m)
ALIGN BY DEVICE
END|ACTIVE|
|Wh_out_1h|
CREATE CONTINUOUS QUERY Wh_out_1h
RESAMPLE EVERY 1h RANGE 2h
BEGIN
SELECT
CAST(sum(Wh_out) AS FLOAT)
INTO root.electricity.measured.1h.::(Wh_out)
FROM root.electricity.measured.1m.**
GROUP BY(1h)
ALIGN BY DEVICE
END|ACTIVE|
|Wh_out_1m|
CREATE
CONTINUOUS QUERY Wh_out_1m
RESAMPLE EVERY 1m RANGE 2m
BEGIN
SELECT
CAST(sum(Wh) AS FLOAT)
INTO root.electricity.measured.1m.::(Wh_out)
FROM root.electricity.measured.raw.**
WHERE Wh < 0
GROUP BY(1m)
ALIGN BY DEVICE
END|ACTIVE|
+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+
Total line number = 6
It costs 0.016s
IoTDB>
```
I am sending you all the logs via email.
Thank you.
Best regards,
Domenico
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
