cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Noam Liran (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-9977) SUM() (and others?) is not supported on COUNTER column types
Date Tue, 04 Aug 2015 15:14:05 GMT
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)

Mime
View raw message