SQL cache functions

The InfluxDB 3 Enterprise SQL implementation supports the following functions that return data from InfluxDB 3 Enterprise caches.

• distinct_cache
• last_cache

distinct_cache

Returns data from an InfluxDB 3 Enterprise distinct value cache.

distinct_cache(table_name, cache_name)

Arguments

• table_name: Name of the table associated with the distinct value cache (formatted as a string literal).
• cache_name: Name of the distinct value cache to query (formatted as a string literal).

SELECT * FROM distinct_cache('example_table', 'exampleCacheName')

last_cache

Returns data from an InfluxDB 3 Enterprise last value cache.

last_cache(table_name, cache_name)

Arguments

• table_name: Name of the table associated with the last value cache (formatted as a string literal).
• cache_name: Name of the last value cache to query (formatted as a string literal).

SELECT * FROM last_cache('example_table', 'exampleCacheName')