[
https://issues.apache.org/jira/browse/CASSANDRA-7277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sylvain Lebresne resolved CASSANDRA-7277.
-----------------------------------------
Resolution: Duplicate
This is basically what we're adding in CASSANDRA-7305 so closing as duplicate.
> CQL support for select distinct part_key,static_field from table
> -----------------------------------------------------------------
>
> Key: CASSANDRA-7277
> URL: https://issues.apache.org/jira/browse/CASSANDRA-7277
> Project: Cassandra
> Issue Type: New Feature
> Components: Core
> Reporter: Jonathan Shook
>
> Currently, a query which selects only static fields will return values with
> the cardinality of the primary key, including clustering columns. In some
> cases, this yields unintuitive results, even if it is correct according to
> primary key cardinality.
> For static fields which have useful semantics at the partition level, it
> should be easy to ask for them across partitions only. One way to achieve
> this would be to allow for distinct results at the partition level.
> select distinct part_key,static_field1,static_field2 from table1;
> In theory, this query could be optimized to avoid cell-level processing since
> nothing addressable by a clustering column is requested.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
