How to select last record in InfluxDB

influxdb
Ammad picture Ammad · Oct 1, 2016 · Viewed 11.3k times · Source

I have pretty simple measurement in influxDB and have default time column and two other columns as shown below,

Select * from measurement

gives me this out put.

time                            component_id    jkey
2016-09-27T02:49:17.837587671Z      3   "timestamp"
2016-09-27T02:49:17.849447239Z      3   "init_time"
2016-09-27T02:49:17.885999439Z      3   "ae_name"
2016-09-27T02:49:17.893056849Z      3   "init_time"

How can i select the last record of this measurement? The record which have maximum time value.

Answer

IIIIIIIIIIIIIIIIIIIIII picture IIIIIIIIIIIIIIIIIIIIII · Oct 1, 2016

This can be done with last(). See the docs for more information: link. Or take a look at this example from the docs.

SELECT LAST("water_level") FROM "h2o_feet" WHERE "location" = 'santa_monica'

This will return the "newest" entry.

Related questions

Can you delete data from influxdb?

How do you delete data from influxdb? The documentation shows it should be as simple as: delete from foo where time < now() -1h For some reason, influxdb rejects my delete statements saying "Delete queries can't have where clause …

Read More
How to format time in influxdb select query

I am new to InfluxDB. I am querying data in admin ui. I see time as timestamp. Is it possible to see it formatted as date and time?

Read More
InfluxDB - Getting only last value in query

Is possible to query only for the last value (or n-th value) of the results of a query? For example, in the query: SELECT value FROM response_times WHERE time > now() - 1h limit 1000; Is possible to get only …

Read More