[
https://issues.apache.org/jira/browse/CASSANDRA-4914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vijay updated CASSANDRA-4914:
-----------------------------
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
was:
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
> 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 | 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
--
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
