[
https://issues.apache.org/jira/browse/CASSANDRA-6644?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jorge Bay updated CASSANDRA-6644:
---------------------------------
Description:
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.
was:
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.
> 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)
