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)
