cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Warren (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-4386) Allow cql to use the IN syntax on secondary index values
Date Wed, 23 Sep 2015 14:44:04 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-4386?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14903314#comment-14903314
] 

Steven Warren edited comment on CASSANDRA-4386 at 9/23/15 2:43 PM:
-------------------------------------------------------------------

I am fine with unordered rows for the IN clause, the current alternative with parallel queries
also returns unordered results. I don't have a use case for the other operators, but assume
that would be fine vs the alternative of not being supported.

EDIT: Wouldn't the results come back in secondary index order though?


was (Author: swarren):
I am fine with unordered rows for the IN clause, the current alternative with parallel queries
also returns unordered results. I don't have a use case for the other operators, but assume
that would be fine vs the alternative of not being supported.

> 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)

Mime
View raw message