# Deleting data with autogen retention policy

**URL:** <https://community.influxdata.com/t/deleting-data-with-autogen-retention-policy/8386>\
**Category:** Systems\
**Created:** [February 2, 2019, 12:00am UTC](https://community.influxdata.com/t/deleting-data-with-autogen-retention-policy/8386 "2019-02-02T00:00:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mcamack](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/mcamack/32/2859_2.png) [@mcamack](https://community.influxdata.com/u/mcamack)\
**Post date:** [February 2, 2019, 12:00am UTC](https://community.influxdata.com/t/deleting-data-with-autogen-retention-policy/8386/1 "2019-02-02T00:00:05Z")

</div>

Is it possible to delete data when only having the default autogen Retention Policy? We have not yet setup a different retention policy and when I run the following delete command, i get `error parsing query: retention policy not supported at line 1, char 1`

DELETE FROM “db”.“autogen”.“events” WHERE time \> now() - 1d AND “title”= ‘test1’

---

<div class="post-metadata">

**Author:** ![katy](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/katy/32/855_2.png) [@katy](https://community.influxdata.com/u/katy)\
**Post date:** [February 4, 2019, 10:01pm UTC](https://community.influxdata.com/t/deleting-data-with-autogen-retention-policy/8386/2 "2019-02-04T22:01:10Z")

</div>

How are you submitting the query? Sometimes it can change depending on whether you’re using the CLI or something like Chronograf or Grafana.

---

<div class="post-metadata">

**Author:** ![bcutter](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/bcutter/32/10122_2.png) [@bcutter](https://community.influxdata.com/u/bcutter)\
**Post date:** [May 11, 2022, 9:45pm UTC](https://community.influxdata.com/t/deleting-data-with-autogen-retention-policy/8386/3 "2022-05-11T21:45:05Z")

</div>

It doesn’t matter if CLI or Chronograf (GUI) is used. Always same output.

 ![grafik](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/4/4fd1f455025cb5977ecf51ea4eff8db0a1456e85.png)

Deleting stuff from InfluxDB is extremely complicated (or not possible at all for most of my cases up to now).

See also [DELETE does not support renention policies · Issue #15180 · influxdata/influxdb · GitHub](https://github.com/influxdata/influxdb/issues/15180) which never was solved.

---

<div class="post-metadata">

**Author:** ![sevinco](https://avatars.discourse-cdn.com/v4/letter/s/258eb7/32.png) [@sevinco](https://community.influxdata.com/u/sevinco)\
**Post date:** [September 9, 2022, 12:39pm UTC](https://community.influxdata.com/t/deleting-data-with-autogen-retention-policy/8386/4 "2022-09-09T12:39:23Z")

</div>

is there any solution to delete data with autogen retention policy?

---

<div class="post-metadata">

**Author:** ![bcutter](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/bcutter/32/10122_2.png) [@bcutter](https://community.influxdata.com/u/bcutter)\
**Post date:** [May 9, 2024, 4:36pm UTC](https://community.influxdata.com/t/deleting-data-with-autogen-retention-policy/8386/5 "2024-05-09T16:36:00Z")

</div>

Still nothing?!?

How dead can a community and a whole project be. Stunning. Always fun when you search for things 3 years later and find your own posts on the internet. Priceless.