[jira] [Created] (CASSANDRA-7277) CQL support for select distinct part_key,static_field from table

["Jonathan Shook (JIRA)" <ji...@apache.org>]

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)