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)