Hi, I wrote this query: from(bucket: "statisticaldata") |> range(start: -24h) // we know that data is flushed daily |> last() |> filter(fn: (r) => r["_measurement"] == "systemStatus") |> filter(fn: (r) => r["_field"] == "conveyorSpeed") The result I get is: 2021-06-07 01:37:26 0 If…

Rows not sorted by time when using last()

dan-moran June 11, 2021, 7:04pm 9

@ypnos v2.0.4 contained a bug in our implementation of the last() pushdown rule, I’d recommend upgrading to the newest version (now v2.0.7) as it’ll probably fix the problems you’re hitting.

2 Likes

Topic		Replies	Views
Flux doesn't seem to sort on _time as is expected InfluxDB 2	3	2011	July 28, 2023
Flux not sorting data based on time, even using sort() function InfluxDB 2 time	0	53	November 16, 2024
Last() function returns a different value each time I submit the script InfluxDB 2 flux	1	218	January 10, 2025
JAVA client Library sort() does not return the data sorted InfluxDB 2 influxdb , query , flux	1	701	June 22, 2020
Sort by highest value InfluxDB 2 query	3	1451	August 19, 2022

Rows not sorted by time when using last()

Related topics