[CASSANDRA-4914] Aggregation functions in CQL

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.2.0 beta 1
• Component/s: Legacy/CQL
• Labels: cql docs
• Assignee: Benjamin Lerer
• Reporter: Vijay

Authors

Benjamin Lerer

Reviewers

Sylvain Lebresne

• Tester: Shawn Kumar
• Created: 05/Nov/12 19:45
• Updated: 16/Apr/19 09:32
• Resolved: 07/Oct/14 10:19

Description

The requirement is to do aggregation of data in Cassandra (Wide row of column values of int, double, float etc).

With some basic agree gate functions like AVG, SUM, Mean, Min, Max, etc (for the columns within a row).

Example:

SELECT * FROM emp WHERE empID IN (130) ORDER BY deptID DESC;
empid | deptid | first_name | last_name | salary
--------------------------------------
130 | 3 | joe | doe | 10.1
130 | 2 | joe | doe | 100
130 | 1 | joe | doe | 1e+03

SELECT sum(salary), empid FROM emp WHERE empID IN (130);
sum(salary) | empid
------------+-------
1110.1 | 130

Issue Links

• is duplicated by: CASSANDRA-6644 CQL: Select every nth row within the same partition key
• is related to: CASSANDRA-8214 Select Count(*) on empty table does not return 0 in trunk
• is related to: CASSANDRA-8216 Select Count with Limit returns wrong value
• is related to: CASSANDRA-12417 Built-in AVG aggregate is much less useful than it should be
• is related to: CASSANDRA-5184 Support server side operations on evaluating queries
• is related to: CASSANDRA-7168 Add repair aware consistency levels
• is related to: CASSANDRA-8826 Distributed aggregates
• is related to: CASSANDRA-8827 Aggregate sampling
• relates to: CASSANDRA-8090 NullPointerException when using prepared statements
• relates to: CASSANDRA-8053 Support for user defined aggregate functions