3.4 KiB
3.4 KiB
The influx query command executes a literal Flux query provided as a string
or a literal Flux query contained in a file.
Usage
influx query [query literal] [flags]
{{% note %}}
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"])
{{% /note %}}
Flags
| Flag | Description | Input type | {{< cli/mapped >}} | |
|---|---|---|---|---|
-c |
--active-config |
CLI configuration to use for command | string | |
--configs-path |
Path to influx CLI configurations (default ~/.influxdbv2/configs) |
string | INFLUX_CONFIGS_PATH |
|
-f |
--file |
Path to Flux script file | string | |
-h |
--help |
Help for the query command |
||
--host |
HTTP address of InfluxDB (default http://localhost:8086) |
string | INFLUX_HOST |
|
--http-debug |
Inspect communication with InfluxDB servers. | string | ||
-o |
--org |
Organization name (mutually exclusive with --org-id) |
string | INFLUX_ORG |
--org-id |
Organization ID (mutually exclusive with --org) |
string | INFLUX_ORG_ID |
|
-p |
--profilers |
Flux query profilers to enable (comma-separated) | string | |
-r |
--raw |
Output raw query results (annotated CSV) | ||
--skip-verify |
Skip TLS certificate verification | INFLUX_SKIP_VERIFY |
||
-t |
--token |
API token | string | INFLUX_TOKEN |
Examples
{{< cli/influx-creds-note >}}
- Query InfluxDB with a Flux string
- Query InfluxDB using a Flux file
- Query InfluxDB and return annotated CSV
- Query InfluxDB and append query profile data to results
Query InfluxDB with a Flux string
influx query 'from(bucket:"example-bucket") |> range(start:-1m)'
Query InfluxDB with a Flux file
influx query --file /path/to/example-query.flux
Query InfluxDB and return annotated CSV
influx query 'from(bucket:"example-bucket") |> range(start:-1m)' --raw
Query InfluxDB and append query profile data to results
For more information about profilers, see Flux profilers.
influx query \
--profilers operator,query \
'from(bucket:"example-bucket") |> range(start:-1m)'