Jonathan Shook created CASSANDRA-7277:
-----------------------------------------
Summary: 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)
