timescale / tsbs

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

groupby-orderby-limit query incorrect on influxdb #114

Open toddlipcon opened 4 years ago

toddlipcon commented 4 years ago

The description of this query is:

The last 5 aggregate readings (across time) before a randomly chosen endpoint

but the query produced for influx looks like:

SELECT max(usage_user) from cpu WHERE time < '2016-01-01T14:37:05Z' group by time(1m) limit 5

this is missing the appropriate ORDER BY clause to get the last five readings.. Instead it seems to pick up the first five minutes of the dataset.