cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Shuler (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-10114) Allow count(*) and count(1) to be use as normal aggregation
Date Wed, 02 Sep 2015 00:10:47 GMT

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

Mime
View raw message