Jorge Bay created CASSANDRA-6644:
------------------------------------
Summary: CQL: Select every nth row within the same partition key
Key: CASSANDRA-6644
URL: https://issues.apache.org/jira/browse/CASSANDRA-6644
Project: Cassandra
Issue Type: Wish
Reporter: Jorge Bay
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
SELECT ts, value WHERE metric_id = ? SKIP 2;
This would be very useful for continuous (and somehow linear) metrics.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
