Noam Liran created CASSANDRA-9977:
-------------------------------------
Summary: SUM() (and others?) is not supported on COUNTER column
types
Key: CASSANDRA-9977
URL: https://issues.apache.org/jira/browse/CASSANDRA-9977
Project: Cassandra
Issue Type: Bug
Components: Core
Reporter: Noam Liran
When trying to SUM a column of type COUNTER, this error is returned:
{noformat}
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)"
{noformat}
This might be relevant for other agg. functions.
CQL for reproduction:
{noformat}
CREATE TABLE test (
key INT,
ctr COUNTER,
PRIMARY KEY (
key
)
);
UPDATE test SET ctr = ctr + 1 WHERE key = 1;
SELECT SUM(ctr) FROM test;
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
