ContextQMD
Back to Influxdb

Index

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

latest4.4 KB
Original Source

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

FlagDescriptionInput type{{< cli/mapped >}}
-c--active-configCLI configuration to use for commandstring
-b--bucketName of bucket to remove data from (mutually exclusive with --bucket-id)stringINFLUX_BUCKET_NAME
--bucket-idBucket ID (mutually exclusive with --bucket)stringINFLUX_BUCKET_ID
--configs-pathPath to influx CLI configurations (default ~/.influxdbv2/configs)stringINFLUX_CONFIGS_PATH
-h--helpHelp for the delete 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--predicateInfluxQL-like predicate string (see Delete predicate)string
--skip-verifySkip TLS certificate verificationINFLUX_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--tokenAPI tokenstringINFLUX_TOKEN

Examples

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

Delete all points in a measurement
sh
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
sh
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
sh
influx delete \
  --bucket example-bucket \
  --start 2020-03-01T00:00:00Z \
  --stop 2020-11-14T00:00:00Z