Fix Version/s: None
In a time-series schema (like metrics), it is common to create roollups/buckets with datapoints at different rate.
It would be nice to have a keyword in CQL to be able to retrieve one every nth row (within a single storage engine wide row).
For example, in the following schema:
CREATE TABLE metrics (
... metric_id varchar,
... ts timestamp,
... value float,
... PRIMARY KEY (metric_id, ts)
The following query, will retrieve 1 in every 3 rows:
(SKIP keyword or something like that, but don't focus on the syntax)
SELECT ts, value WHERE metric_id = ? SKIP 2;
This would be very useful for continuous (and somehow linear) metrics.