influxdata / docs-v2

InfluxData Documentation that covers InfluxDB Cloud, InfluxDB OSS 2.x, InfluxDB OSS 1.x, InfluxDB Enterprise, Telegraf, Chronograf, Kapacitor, and Flux.
https://docs.influxdata.com
MIT License
73 stars 277 forks source link

InfluxQL new syntax: FUTURE LIMIT and PAST LIMIT #5683

Open davidby-influx opened 1 week ago

davidby-influx commented 1 week ago

In the 1.x line (Enterprise and OSS), a new feature has been added which required changes to InfluxQL syntax.

There are two new reserved words, FUTURE and PAST, which are used in specifying write windows for retention periods.

Write windows prevent writes into a retention policy outside of optional future and past limits. These are specified as durations and are added and subtracted from now when determining a whether write is permitted, even if it is within the bounds of the retention policy.

If write limits are not specified, the default is current behavior (no write limits). A write limit of 0 is treated is if there were no limit (this is how to remove a limit with an ALTER RETENTION statement)

Relevant URLs

https://github.com/influxdata/influxql/pull/72 https://github.com/influxdata/plutonium/pull/4200 https://github.com/influxdata/influxdb/issues/25424 https://github.com/influxdata/influxdb/pull/25517 Somewhat outdated: https://github.com/influxdata/plutonium/issues/3005 https://github.com/influxdata/feature-requests/issues/258 https://github.com/influxdata/feature-requests/issues/258

Will be released in InfluxDB 1.12.0 OSS and Enterprise