You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Cristian O (JIRA)" <ji...@apache.org> on 2015/02/17 17:01:12 UTC
[jira] [Comment Edited] (CASSANDRA-4914) Aggregation functions in
CQL
[ https://issues.apache.org/jira/browse/CASSANDRA-4914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14324355#comment-14324355 ]
Cristian O edited comment on CASSANDRA-4914 at 2/17/15 4:00 PM:
----------------------------------------------------------------
To be clear I'm not talking about "distributed processing". I'm talking about online analitical queries, particularly time series. Incidentally, I don't know how many people realize this but Cass has the same distributed storage architecture that Vertica has. It's also possible to map a columnar "schema" on top of sstable. Of course native support for columnar storage would be immensely better. See CASSANDRA-7447
was (Author: onetoinfinity@yahoo.com):
To be clear I'm not talking about "distributed processing". I'm talking about online analitical queries, particularly time series. Incidentally, I don't know how many people realize this but Cass has the same distributed storage architecture that Vertica has. It's also possible to map a columnar "schema" on top of sstable. Of course native support for columnar storage would be immensely better. See CASSANDRA-7447
There's a lot of opportunity in this space, just need a bit of vision.
> Aggregation functions in CQL
> ----------------------------
>
> Key: CASSANDRA-4914
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4914
> Project: Cassandra
> Issue Type: New Feature
> Reporter: Vijay
> Assignee: Benjamin Lerer
> Labels: cql, docs
> Fix For: 3.0
>
> Attachments: CASSANDRA-4914-V2.txt, CASSANDRA-4914-V3.txt, CASSANDRA-4914-V4.txt, CASSANDRA-4914-V5.txt, CASSANDRA-4914.txt
>
>
> 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 was sent by Atlassian JIRA
(v6.3.4#6332)