influxdb3 create distinct_cache
InfluxDB 3 Core is in Public Alpha
InfluxDB 3 Core is in public alpha and available for testing and feedback, but is not meant for production use. Both the product and this documentation are works in progress. We welcome and encourage your input about your experience with the alpha and invite you to join our public channels for updates and to share feedback.
The influxdb3 create distinct_cache command creates a new distinct value cache.
Usage
influxdb3 create distinct_cache [OPTIONS] \
--database <DATABASE_NAME> \
--table <TABLE> \
--columns <COLUMNS> \
[CACHE_NAME]
Arguments
- CACHE_NAME: (Optional) Name for the cache. If not provided, the command automatically generates a name.
Options
| Option | Description | |
|---|---|---|
-H | --host | Host URL of the running InfluxDB 3 Core server (default is http://127.0.0.1:8181) |
-d | --database | (Required) Name of the database to operate on |
--token | Authentication token | |
-t | --table | (Required) Table to create the cache for |
--columns | (Required) Comma-separated list of columns to cache distinct values for–for example: col1,col2,col3 (see Metadata cache hierarchy) | |
--max-cardinality | Maximum number of distinct value combinations to hold in the cache | |
--max-age | Maximum age of an entry in the cache entered as a human-readable duration–for example: 30d, 24h | |
-h | --help | Print help information |
Metadata cache hierarchy
The distinct value cache has a hierarchical structure with a level for each specified column.
The order specified in the --columns option determines the order of levels,
from top-to-bottom, of the cache hierarchy.
Option environment variables
You can use the following environment variables to set command options:
| Environment Variable | Option |
|---|---|
INFLUXDB3_HOST_URL | --host |
INFLUXDB3_DATABASE_NAME | --database |
INFLUXDB3_AUTH_TOKEN | --token |
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.