Influxdb query last row of all series in a measurement

I trying to find a way to get the most recent row for each serie in a measurement.

for example:

Assuming the series in results measurement are:

select series from test_result
results,service=MyService,team=A
result,service=MyService,team=B
result,service=MyService,team=C

and the rows in a given time frame are:

select * from test_result order by time desc

time service team status duration


1523370939000000000 MyService A 1 300
1523370940000000000 MyService B 1 300
1523370941000000000 MyService A 1 300
1523370941000000000 MyService C 1 300
1523371748000000000 MyService A 1 300
1523371749000000000 MyService B 1 300
1523371750000000000 MyService B 1 300
1523371754000000000 MyService A 1 300

I would expect the query to return the first, second and fourth rows.
Any suggestion is much appreciated.

Thanks!

To separate the series, you can add GROUP BY *, which will give you the results separated by series. Then you can add aggregates to your query, like LAST.
For example:
SELCT LAST(field_name, *) from test_result GROUP BY *

Keep in mind that your fields are also a factor here. You can use * without specifying a field, but there’s room for error there. It’s better to specify a field if you know what you need.

That did the job. Thanks!

found out that last() accepts only one input so here’s the correct syntax if anyone ever need it:

SELECT LAST(field_name), * from test_result GROUP BY *

2 Likes

Yep, thanks for fixing that!