search

timescale / tsbs

Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data
MIT License
1.24k stars 293 forks source link

Mismatched interval in description and generated sql for single-groupy-X-X-X series #214

Open JackieTien97 opened 1 year ago

JackieTien97 commented 1 year ago

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

SELECT max(usage_user) from cpu where (hostname = 'host_249') and time >= '2016-01-03T12:26:46Z' and time < '2016-01-03T13:26:46Z' group by time(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')) AND time >= '2016-01-03 12:26:46.646325 +0000' AND time < '2016-01-03 13:26:46.646325 +0000'
        GROUP BY minute ORDER BY minute ASC