[
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)
