cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stephen Powis (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-4327) Sorting results when using IN()
Date Mon, 11 Jun 2012 06:01:45 GMT
Stephen Powis created CASSANDRA-4327:
----------------------------------------

             Summary: Sorting results when using IN() 
                 Key: CASSANDRA-4327
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4327
             Project: Cassandra
          Issue Type: Improvement
    Affects Versions: 1.1.1
            Reporter: Stephen Powis
            Priority: Minor
             Fix For: 1.1.2


Using the following test schema:

CREATE TABLE test (
  my_id varchar, 
  time_id uuid,
  value int,
  PRIMARY KEY (my_id, time_id)
);

When you issue a CQL3 query like: 
select * from test where my_id in('key1', 'key2') order by time_id; 

You receive the error:
"Ordering is only supported if the first part of the PRIMARY KEY is restricted by an Equal"

I'm including a patch I put together after spending an hour or two poking thru the code base
that sorts the results for these types of queries.  I'm hoping someone with a deeper understanding
of Cassandra's code base can take a look at it, clean it up or use it as a starting place,
and include it in an upcoming release.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message