[
https://issues.apache.org/jira/browse/CASSANDRA-4386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14904696#comment-14904696
]
Benjamin Lerer commented on CASSANDRA-4386:
-------------------------------------------
{quote}Wouldn't the results come back in secondary index order though?{quote}
I have not started working on this ticket but what I would expect is that:
If you have 2 index entries on the same node for value "A" and "B"
"A" is in 3 rows with the primary keys: pk1, pk5, pk 8
"B" is in 2 rows with primary keys: pk2 and pk3
What you will get will probably be: pk1, pk5, pk8, pk2 and pk3
> Allow cql to use the IN syntax on secondary index values
> --------------------------------------------------------
>
> Key: CASSANDRA-4386
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4386
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Reporter: Jeremy Hanna
> Assignee: Benjamin Lerer
> Priority: Minor
> Labels: cql
>
> Currently CQL has a syntax for using IN to get a set of rows with a set of
> keys. This would also be very helpful for use with columns with secondary
> indexes on them. Such as:
> {code}
> select * from users where first_name in ('françois','frank');
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
