cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vijay (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-4914) Aggregate functions in CQL
Date Mon, 05 Nov 2012 19:46:12 GMT
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

Mime
View raw message