SQL cache functions
InfluxDB 3 Core is in Public Beta
InfluxDB 3 Core is in public beta and available for testing and feedback, but is not meant for production use yet. Both the product and this documentation are works in progress. We welcome and encourage your input about your experience with the beta and invite you to join our public channels for updates and to share feedback.
The InfluxDB 3 Core SQL implementation supports the following functions that return data from InfluxDB 3 Core caches.
distinct_cache
Returns data from an InfluxDB 3 Core 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).
- datatype: Name of the the distinct value cache to query (formatted as a string literal).
last_cache
Returns data from an InfluxDB 3 Core 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).
- datatype: Name of the the last value cache to query (formatted as a string literal).
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB 3 Core and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.