Use the influx query command
Use the influx query command to query data in InfluxDB using Flux. Pass Flux queries to the command as either a file or via stdin.
Run a query from a file
influx query --file /path/to/query.flux
Pass raw Flux via stdin pipe
influx query - # Return to open the pipe
data = from(bucket: "example-bucket") |> range(start: -10m) # ...
# Linux & macOS: <ctrl-d> to close the pipe and submit the command
# Windows: <enter>, then <ctrl-d>, then <enter> to close the pipe and submit the command
Remove unnecessary columns in large datasets
When using the influx query
command to query and download large datasets, drop columns such as _start
and _stop
to optimize the download file size.
// ...
|> drop(columns: ["_start", "_stop"])