cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-9778) CQL support for time series aggregation
Date Sat, 11 Jul 2015 16:00:05 GMT
Jonathan Ellis created CASSANDRA-9778:
-----------------------------------------

             Summary: CQL support for time series aggregation
                 Key: CASSANDRA-9778
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9778
             Project: Cassandra
          Issue Type: New Feature
          Components: API, Core
            Reporter: Jonathan Ellis
             Fix For: 3.x


Along with MV (CASSANDRA-6477), time series aggregation or "rollups" are a common design pattern
in cassandra applications.  I'd like to add CQL support for this along these lines:

{code}
CREATE MATERIALIZED VIEW stocks_by_hour AS
SELECT exchange, day, day_time(1h) AS hour, symbol, avg(price), sum(volume)
FROM stocks
GROUP BY exchange, day, symbol, hour
PRIMARY KEY  ((exchange, day), hour, symbol);
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message