Uploaded image for project: 'Apache Cassandra'
  1. Apache Cassandra
  2. CASSANDRA-9778

CQL support for time series aggregation

    XMLWordPrintableJSON

Details

    Description

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

      Attachments

        Issue Links

          requires

          Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-9810 Lift some counters limitations in C* 3.X

          • Normal -
          • Open

          Activity

            People

              Unassigned Unassigned
              jbellis Jonathan Ellis
              Votes:
              12 Vote for this issue
              Watchers:
              43 Start watching this issue

              Dates

                Created:
                Updated: