Details
-
New Feature
-
Status: Resolved
-
Normal
-
Resolution: Duplicate
-
None
-
None
-
None
Description
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.
Attachments
Issue Links
- duplicates
-
CASSANDRA-7305 CQL3, Static columns not returning rows if values are not set
- Resolved