Is there a way to by pass Group by time in continuous query?
I want to compute average of last 1 hour data every 10 seconds and store these values in a table.
Resample every 10s for 1h
Begin
Select mean(*) into average from raw GroupBy time(1h)
End
This query overwrites the computed mean values every 10s in the same row… I want to write new rows of average of last 1 hour of data.
If I change the group by to 10s, it averages only on 10s of data.