Vijay created CASSANDRA-4914: -------------------------------- Summary: Aggregate functions in CQL Key: CASSANDRA-4914 URL: https://issues.apache.org/jira/browse/CASSANDRA-4914 Project: Cassandra Issue Type: Bug Reporter: Vijay Assignee: Vijay Fix For: 1.2.0 beta 2
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 | sughit | singh | 10.1 130 | 2 | sughit | singh | 100 130 | 1 | sughit | singh | 1e+03 SELECT sum(salary), empid FROM emp WHERE empID IN (130) ORDER BY deptID DESC; sum(salary) | empid -------------+-------- 1110.1 | 130 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira