cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From eyeofthefrog@gmail.com <eyeofthef...@gmail.com>
Subject Re: "Group by" while limiting a clustering column with a range
Date Wed, 11 Apr 2018 00:05:01 GMT
I've opened the following issue: https://issues.apache.org/jira/browse/CASSANDRA-14376

On 2018/04/10 23:12:31, Chris Mildebrandt <chris@woodenrhino.com> wrote: 
> Hey all. I’m trying to use a range to limit a clustering column while at
> the same time using `group by` and running into issues. Here’s a sample
> table:
> create table if not exists samples (name text, partition int, sample int,
> city text, state text, count counter, primary key ((name, partition),
> sample, city, state)) with clustering order by (sample desc);
> 
> When I filter `sample` by a range, I get an error:
> select city, state, sum(count) from samples where name='bob' and
> partition=1 and sample>=1 and sample<=3 group by city, state;
> InvalidRequest: Error from server: code=2200 [Invalid query] message="Group
> by currently only support groups of columns following their declared order
> in the PRIMARY KEY"
> 
> However, it allows the query when I change from a range to an equals:
> select city, state, sum(count) from samples where name='bob' and
> partition=1 and sample=1 group by city, state;
> 
>  city   | state | system.sum(count)
> --------+-------+-------------------
>  Austin |    TX |                 2
>  Denver |    CO |                 1
> 
> Does this sound like a bug, or is it expected? Thanks.
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org


Mime
View raw message