cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dan Hunt (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-7026) CQL:WHERE ... IN with full partition keys
Date Fri, 11 Apr 2014 19:45:17 GMT
Dan Hunt created CASSANDRA-7026:
-----------------------------------

             Summary: CQL:WHERE ... IN with full partition keys
                 Key: CASSANDRA-7026
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7026
             Project: Cassandra
          Issue Type: Wish
          Components: Core, Drivers (now out of tree)
            Reporter: Dan Hunt


It would be handy to be able to pass in a list of fully qualified composite partition keys
in an IN filter to retrieve multiple distinct rows with a single select.  Not entirely sure
how that would work.  It looks like maybe it could be done with the existing token() function,
like:

SELECT * FROM table WHERE token(keyPartA, keyPartB) IN (token(1, 1), token(4, 2))

Though, I guess you'd also want some way to pass a list of tokens to a prepared statement
through the driver.  This of course all assumes that an IN filter could be faster than a bunch
of prepared statements, which might not be true.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message