You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Jorge Bay (JIRA)" <ji...@apache.org> on 2014/01/31 11:40:08 UTC
[jira] [Created] (CASSANDRA-6644) CQL: Select every nth row within
the same partition key
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)