[CASSANDRA-9977] Support counter-columns for native aggregates (sum,avg,max,min)

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.5, 3.0.3
• Component/s: Legacy/CQL
• Assignee: Robert Stupp
• Reporter: Noam Liran

Authors

Robert Stupp

Reviewers

Benjamin Lerer

• Created: 04/Aug/15 15:13
• Updated: 16/Apr/19 09:31
• Resolved: 04/Jan/16 15:36

Description

When trying to SUM a column of type COUNTER, this error is returned:

InvalidRequest: code=2200 [Invalid query] message="Invalid call to function sum, none of its type signatures match (known type signatures: system.sum : (tinyint) -> tinyint, system.sum : (smallint) -> smallint, system.sum : (int) -> int, system.sum : (bigint) -> bigint, system.sum : (float) -> float, system.sum : (double) -> double, system.sum : (decimal) -> decimal, system.sum : (varint) -> varint)"

This might be relevant for other agg. functions.

CQL for reproduction:

CREATE TABLE test (
        key INT,
        ctr COUNTER,
        PRIMARY KEY (
                key
        )
);

UPDATE test SET ctr = ctr + 1 WHERE key = 1;
SELECT SUM(ctr) FROM test;

Issue Links

• is duplicated by: CASSANDRA-10319 aggregate sum on Counter type of Cassandra