cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jorge Bay (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-6644) CQL: Select every nth row within the same partition key
Date Fri, 31 Jan 2014 10:40:08 GMT
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)

Mime
View raw message