ContextQMD
Back to Influxdb

Index

content/shared/influxdb-v2/reference/cli/influx/query/_index.md

latest3.3 KB
Original Source

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.

js
// ...
    |> drop(columns: ["_start", "_stop"])

{{% /note %}}

Flags

FlagDescriptionInput type{{< cli/mapped >}}
-c--active-configCLI configuration to use for commandstring
--configs-pathPath to influx CLI configurations (default ~/.influxdbv2/configs)stringINFLUX_CONFIGS_PATH
-f--filePath to Flux script filestring
-h--helpHelp for the query command
--hostHTTP address of InfluxDB (default http://localhost:8086)stringINFLUX_HOST
--http-debugInspect communication with InfluxDB servers.string
-o--orgOrganization name (mutually exclusive with --org-id)stringINFLUX_ORG
--org-idOrganization ID (mutually exclusive with --org)stringINFLUX_ORG_ID
-p--profilersFlux query profilers to enable (comma-separated)string
-r--rawOutput raw query results (annotated CSV)
--skip-verifySkip TLS certificate verificationINFLUX_SKIP_VERIFY
-t--tokenAPI tokenstringINFLUX_TOKEN

Examples

{{< cli/influx-creds-note >}}

Query InfluxDB with a Flux string
sh
influx query 'from(bucket:"example-bucket") |> range(start:-1m)'
Query InfluxDB with a Flux file
sh
influx query --file /path/to/example-query.flux
Query InfluxDB and return annotated CSV
sh
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.

sh
influx query \
  --profilers operator,query \
  'from(bucket:"example-bucket") |> range(start:-1m)'