Documentation

Query a Last Value Cache

Use the last_cache() SQL function in the FROM clause of an SQL SELECT statement to query data from the Last Value Cache (LVC).

You must use SQL to query the LVC. InfluxQL does not support the last_cache() function.

last_cache() supports the following arguments:

  • table_name: (Required) The name of the table the LVC is associated with formatted as a string literal.
  • cache_name: The name of the LVC to query formatted as a string literal. This argument is only required if there is more than one LVC associated with the specified table.
SELECT * FROM last_cache('table_name', 'cache_name')

You can use other SQL clauses to modify query results. For example, you can use the WHERE clause to return the last value for a specific tag set:

SELECT
  room,
  temp
FROM
  last_cache('home', 'homeCache')
WHERE
  room = 'Kitchen'

Was this page helpful?

Thank you for your feedback!


The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Read more

New in InfluxDB 3.4

Key enhancements in InfluxDB 3.4 and the InfluxDB 3 Explorer 1.2.

See the Blog Post

InfluxDB 3.4 is now available for both Core and Enterprise, which introduces offline token generation for use in automated deployments and configurable license type selection that lets you bypass the interactive license prompt. InfluxDB 3 Explorer 1.2 is also available, which includes InfluxDB cache management and other new features.

For more information, check out: