DELETE does not support renention policies

[hanynowsky]

Following: #8088

• It is impossible to DELETE series by specifying the retention policy when using a DELETE statement:

DELETE FROM "mydb"."my_rp"."my_measurement" WHERE "device" = 'CIS-DSZ-IDE' AND "label" = '038FHJEDF8' AND time >= 1568725200000ms AND time <= 1568737800000ms
ERR: error parsing query: retention policy not supported at line 1, char 1

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[stale]

This issue has been automatically closed because it has not had recent activity. Please reopen if this issue is still important to you. Thank you for your contributions.

[bcutter]

Oh dear, would love to have found a solution for this... :-(

See also https://community.influxdata.com/t/deleting-data-with-autogen-retention-policy/8386