Query a Last Value Cache |
Use the [`last_cache()` SQL function](/influxdb3/core/reference/sql/functions/cache/#last_cache)
in the `FROM` clause of an SQL `SELECT` statement to query data from the
Last Value Cache.
|
influxdb3_core |
parent |
Manage the Last Value Cache |
|
|
202 |
|
```sql
SELECT * FROM last_cache('table-name', 'cache-name')
```
> [!Important]
> You must use SQL to query the LVC.
> InfluxQL does not support the `last_cache()` function.
|
/influxdb3/core/reference/sql/functions/cache/#last_cache, last_cache SQL function |
|
/shared/influxdb3-admin/last-value-cache/query.md |