influx delete

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

This page documents an earlier version of InfluxDB. InfluxDB v2.7 is the latest stable version. View this page in the v2.7 documentation.

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 either the active influx CLI configuration or by environment variables (INFLUX_HOST, INFLUX_ORG, and INFLUX_TOKEN). If you do not have a CLI configuration set up or the environment variables set, include these required credentials for each command with the following flags:

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

delete