[CASSANDRA-9778] CQL support for time series aggregation - ASF JIRA

[CASSANDRA-9778] CQL support for time series aggregation - ASF JIRA

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:

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);  

Read full article from [CASSANDRA-9778] CQL support for time series aggregation - ASF JIRA