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
1. influx query --file /path/to/query.flux
Pass raw Flux via stdin pipe
1. influx query - # Return to open the pipe
3. data = from(bucket: "example-bucket") |> range(start: -10m) # ...
4. # Linux & macOS: <ctrl-d> to close the pipe and submit the command
5. # 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.
1. // ...
2. |> drop(columns: ["_start", "_stop"])
