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

Reply via email to