You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In the descriptions of README for single-groupy-X-X-X, it says that the group by time interval is every 5 mins, e.g. Simple aggregrate (MAX) on one metric for 1 host, every 5 mins for 1 hour for single-groupby-1-1-1.
However, in the generated sql for InfluxDB and TimescaleDB(I just checked these two, don't whether others are mismatched):
Sql generated for single-groupby-1-1-1
InfluxDB
SELECTmax(usage_user) from cpu where (hostname ='host_249') andtime>='2016-01-03T12:26:46Z'andtime<'2016-01-03T13:26:46Z'group bytime(1m)
TimescaleDB
SELECT time_bucket('60 seconds', time) AS minute,
max(usage_user) as max_usage_user
FROM cpu
WHERE tags_id IN (SELECT id FROM tags WHERE hostname IN ('host_249')) ANDtime>='2016-01-03 12:26:46.646325 +0000'ANDtime<'2016-01-03 13:26:46.646325 +0000'GROUP BY minute ORDER BY minute ASC
The text was updated successfully, but these errors were encountered:
for GroupByTime use 1min, fix issues timescale#214
IoTDB is same with InfluxDB and TimescaleDB now。
And that meas the behavior of IoTDB single-group-by queries is NOT same with README, but is same with other databases.
In the descriptions of README for single-groupy-X-X-X, it says that the group by time interval is every 5 mins, e.g.
Simple aggregrate (MAX) on one metric for 1 host, every 5 mins for 1 hour
forsingle-groupby-1-1-1
.However, in the generated sql for InfluxDB and TimescaleDB(I just checked these two, don't whether others are mismatched):
Sql generated for
single-groupby-1-1-1
InfluxDB
TimescaleDB
The text was updated successfully, but these errors were encountered: