[
https://issues.apache.org/jira/browse/CASSANDRA-9977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15070974#comment-15070974
]
Robert Stupp edited comment on CASSANDRA-9977 at 12/24/15 1:06 PM:
-------------------------------------------------------------------
Thanks!
Committed as 8287ebcb6ad46529ca90600dc0c2f98ecab89cf0 to 2.2 and as
0858bfbd7b1e2c1ff43baf1ec96a5fadf115e88d to 3.0 and merged to trunk.
was (Author: snazy):
Thanks!
Committed as d379c40deb5f4296a9de0488bc35c590b3e9dd47 to 2.2 and as
c1650a45dbe484cb5c152c9c3932ab2e0c8c395b to 3.0 and merged to trunk.
> Support counter-columns for native aggregates (sum,avg,max,min)
> ---------------------------------------------------------------
>
> Key: CASSANDRA-9977
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9977
> Project: Cassandra
> Issue Type: Improvement
> Components: CQL
> Reporter: Noam Liran
> Assignee: Robert Stupp
> Fix For: 2.2.5, 3.0.3
>
>
> 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)
