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)
