Common queries

API token hashing is enabled by default in InfluxDB OSS 2.9.0

Stronger token security: tokens are stored as hashes on disk, so a copy of the database file doesn’t expose usable tokens. Existing tokens are hashed on first startup and the original strings can’t be recovered afterward — capture any plaintext tokens you still need before you upgrade.

For more information, see Token hashing.

The following articles walk through common queries using the NOAA water database data.

Operate on columns

Find and count unique values, recalculate the _value column, and use values to calculate a new column.

Use multiple fields in a calculation

Query multiple fields, pivot results, and use multiple field values to calculate new values in query results.

Comparing values from different buckets

Compare the value from the latest point to an average value stored in another bucket. This is useful when using the average value to calculate a threshold check.

IoT sensor common queries

Use Flux to address common IoT use cases that query data collected from sensors.

This list will continue to grow. If you have suggestions, please submit them to the InfluxData Community.

Was this page helpful?

Thank you for your feedback!