Influxdata
/
docs-v2
mirror of https://github.com/influxdata/docs-v2.git
1
0
Fork 0
Code Issues Projects Releases Wiki Activity
docs-v2/content/shared/influxdb-v2/reference/cli/influx/delete/_index.md

4.4 KiB
Raw Permalink Blame History

The influx delete command deletes points from an InfluxDB bucket in a specified time range. Select points to delete within the specified time range using delete predicate syntax.

{{% warn %}}

Deleting data without a delete predicate

Running influx delete without the -p or --predicate flag deletes all data with timestamps between the specified --start and --stop times in the specified bucket.

{{% show-in "v2" %}}

Cannot delete data by field

InfluxDB {{< current-version >}} does not support deleting data by field.

{{% /show-in %}} {{% /warn %}}

Flags

Flag Description Input type {{< cli/mapped >}}
-c --active-config CLI configuration to use for command string
-b --bucket Name of bucket to remove data from (mutually exclusive with --bucket-id) string INFLUX_BUCKET_NAME
--bucket-id Bucket ID (mutually exclusive with --bucket) string INFLUX_BUCKET_ID
--configs-path Path to influx CLI configurations (default ~/.influxdbv2/configs) string INFLUX_CONFIGS_PATH
-h --help Help for the delete 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 --predicate InfluxQL-like predicate string (see Delete predicate) string
--skip-verify Skip TLS certificate verification INFLUX_SKIP_VERIFY
--start ({{< req >}}) Start time in RFC3339 format (i.e. 2009-01-02T23:00:00Z) string
--stop ({{< req >}}) Stop time in RFC3339 format (i.e. 2009-01-02T23:00:00Z) string
-t --token API token string INFLUX_TOKEN

Examples

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

Delete all points in a measurement
influx delete \
  --bucket example-bucket \
  --start 1970-01-01T00:00:00Z \
  --stop $(date -u +"%Y-%m-%dT%H:%M:%SZ") \
  --predicate '_measurement="example-measurement"'
Delete points in a measurement with a specific tag value
influx delete \
  --bucket example-bucket \
  --start 1970-01-01T00:00:00Z \
  --stop $(date -u +"%Y-%m-%dT%H:%M:%SZ") \
  --predicate '_measurement="example-measurement" AND host="old-host"'
Delete all points within a specified time frame
influx delete \
  --bucket example-bucket \
  --start 2020-03-01T00:00:00Z \
  --stop 2020-11-14T00:00:00Z