cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jon Haddad (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-10707) Add support for Group By to Select statement
Date Thu, 25 Feb 2016 16:32:18 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-10707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15167398#comment-15167398
] 

Jon Haddad edited comment on CASSANDRA-10707 at 2/25/16 4:32 PM:
-----------------------------------------------------------------

{quote}
I do not think that the order in which we perform the operations and the CQL syntax should
be linked. If I am not mistaken, we filter the data once they have been sorted, in most of
the cases, but the restrictions appear before the ORDER BY clause. In my opinion we should
stick to the SQL syntax for that. As most of the C* users have a SQL background it will prevent
some confusions.
{quote}

I agree with this, sticking with SQL syntax will trip people up a lot less.  


was (Author: rustyrazorblade):
{bq}
I do not think that the order in which we perform the operations and the CQL syntax should
be linked. If I am not mistaken, we filter the data once they have been sorted, in most of
the cases, but the restrictions appear before the ORDER BY clause. In my opinion we should
stick to the SQL syntax for that. As most of the C* users have a SQL background it will prevent
some confusions.
{bq}

I agree with this, sticking with SQL syntax will trip people up a lot less.  

> Add support for Group By to Select statement
> --------------------------------------------
>
>                 Key: CASSANDRA-10707
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10707
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: CQL
>            Reporter: Benjamin Lerer
>            Assignee: Benjamin Lerer
>
> Now that Cassandra support aggregate functions, it makes sense to support {{GROUP BY}}
on the {{SELECT}} statements.
> It should be possible to group either at the partition level or at the clustering column
level.
> {code}
> SELECT partitionKey, max(value) FROM myTable GROUP BY partitionKey;
> SELECT partitionKey, clustering0, clustering1, max(value) FROM myTable GROUP BY partitionKey,
clustering0, clustering1; 
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message