Execute Flux queries
See the equivalent InfluxDB v2.0 documentation: Execute queries.
There are multiple ways to execute Flux queries with InfluxDB and Chronograf v1.8+. This guide covers the different options:
Before attempting these methods, make sure Flux is enabled by setting
flux-enabled = truein the
[http]section of your InfluxDB configuration file.
Chronograf’s Data Explorer
Chronograf v1.8+ supports Flux in its Data Explorer. Flux queries can be built, executed, and visualized from within the Chronograf user interface.
influx CLI includes a
-type option which allows you specify
what type of interactive session to start.
-type=flux will start an interactive read-eval-print-loop (REPL) that supports Flux.
If authentication is enabled
on your InfluxDB instance, use the
-username flag to provide your InfluxDB username and
-password flag to provide your password.
Enter an interactive Flux REPL
Any Flux query can be executed within the REPL.
Submit a Flux query via parameter
Flux queries can also be passed to the Flux REPL as a parameter using the
-type=flux option and the
The accompanying string is executed as a Flux query and results are output in your terminal.
influx -type=flux -execute '<flux query>'
influx -type=flux -username myuser -password PasSw0rd -execute '<flux query>'
Submit a Flux query via via STDIN
Flux queries an be piped into the
influx CLI via STDIN.
Query results are otuput in your terminal.
echo '<flux query>' | influx -type=flux
echo '<flux query>' | influx -type=flux -username myuser -password PasSw0rd
Flux can be used to query InfluxDB through InfluxDB’s
Queried data is returned in annotated CSV format.
In your request, set the following:
- If authentication is enabled
on your InfluxDB instance,
This allows you to POST the Flux query in plain text and receive the annotated CSV response.
Below is an example
curl command that queries InfluxDB using Flux:
curl -XPOST localhost:8086/api/v2/query -sS \ -H 'Accept:application/csv' \ -H 'Content-type:application/vnd.flux' \ -d 'from(bucket:"telegraf") |> range(start:-5m) |> filter(fn:(r) => r._measurement == "cpu")'
curl -XPOST localhost:8086/api/v2/query -sS \ -H 'Accept:application/csv' \ -H 'Content-type:application/vnd.flux' \ -H 'Authorization: Token <username>:<password>' \ -d 'from(bucket:"telegraf") |> range(start:-5m) |> filter(fn:(r) => r._measurement == "cpu")'
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.