influx delete

  • influx CLI 2.0.3+
  • InfluxDB 2.0.3+
  • Updated in CLI v2.3.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.

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.

Cannot delete data by field

InfluxDB 2.7 does not support deleting data by field.

Flags

Flag Description Input type Maps to ?
-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 (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 —token API token string INFLUX_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 -u +"%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 -u +"%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