You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Michael Shuler (JIRA)" <ji...@apache.org> on 2015/09/02 02:10:47 UTC

[jira] [Updated] (CASSANDRA-10114) Allow count(*) and count(1) to be use as normal aggregation

     [ https://issues.apache.org/jira/browse/CASSANDRA-10114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Shuler updated CASSANDRA-10114:
---------------------------------------
    Description: 
For the following query: 
{code}
SELECT count(*), max(timestamp), min(timestamp) FROM myData WHERE id = ?
{code}
Cassandra will throw a {{InvalidSyntaxException}}.

We should allow {{count(\*)}} and {{count(1)}} to be queried with other aggregations or columns

  was:
For the following query: 
{code}
SELECT count(*), max(timestamp), min(timestamp) FROM myData WHERE id = ?
{code}
Cassandra will throw a {{InvalidSyntaxException}}.

We should allow count(*) and count(1) to be queried with other aggregations or columns


> Allow count(*) and count(1) to be use as normal aggregation
> -----------------------------------------------------------
>
>                 Key: CASSANDRA-10114
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10114
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: Benjamin Lerer
>            Assignee: Benjamin Lerer
>            Priority: Minor
>             Fix For: 2.2.1, 3.0 beta 1
>
>         Attachments: 10114-2.2.txt
>
>
> For the following query: 
> {code}
> SELECT count(*), max(timestamp), min(timestamp) FROM myData WHERE id = ?
> {code}
> Cassandra will throw a {{InvalidSyntaxException}}.
> We should allow {{count(\*)}} and {{count(1)}} to be queried with other aggregations or columns



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