SQL cache functions
InfluxDB 3 Enterprise is in Public Beta
InfluxDB 3 Enterprise 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 Enterprise SQL implementation supports the following functions that return data from InfluxDB 3 Enterprise caches.
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).
- datatype: Name of the the distinct value cache to query (formatted as a string literal).
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).
- 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 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.