influx delete

  • influx CLI 2.0.3+
  • InfluxDB 2.0.3+
  • Updated in CLI v2.2.0

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.

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.

Flags

FlagDescriptionInput typeMaps to ?
-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(Required) Start time in RFC3339 format (i.e. 2009-01-02T23:00:00Z)string
—stop(Required) Stop time in RFC3339 format (i.e. 2009-01-02T23:00:00Z)string
-t—tokenAPI tokenstringINFLUX_TOKEN

Examples

Authentication credentials

The examples below assume your InfluxDB host, organization, and token are provided by the active influx CLI configuration. If you do not have a CLI configuration set up, use the appropriate flags to provide these required credentials.

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