[ 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, 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. 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, 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. -- This message was sent by Atlassian JIRA (v6.1.5#6160)