cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tomas Salfischberger (JIRA)" <>
Subject [jira] [Created] (CASSANDRA-2830) Allow summing of counter columns in CQL
Date Mon, 27 Jun 2011 08:48:51 GMT
Allow summing of counter columns in CQL

                 Key: CASSANDRA-2830
             Project: Cassandra
          Issue Type: New Feature
          Components: API
            Reporter: Tomas Salfischberger

CQL could be extended with a method to calculate the sum of a set of counter columns. This
avoids transferring a long list of counter columns to be summed by the client, while the server
could calculate the total and instead only transfer that result. My proposal for the syntax
(based on the COUNT() suggestion in the comments of CASSANDRA-1704):
{code}SELECT SUM(<columnFrom>..<columnTo>) FROM <CF> WHERE ...{code}

The simplest approach would be to only allow summing of counters under the same key, thus
a query with a WHERE part that specifies multiple keys would return 1 result per key. This
avoids summing values from different nodes.

This message is automatically generated by JIRA.
For more information on JIRA, see:


View raw message