cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-4210) Support for variadic parameters list for "in clause" in prepared cql query
Date Wed, 18 Sep 2013 12:51:59 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-4210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jonathan Ellis updated CASSANDRA-4210:
--------------------------------------

    Reviewer: iamaleksey
    
> Support for variadic parameters list for "in clause" in prepared cql query
> --------------------------------------------------------------------------
>
>                 Key: CASSANDRA-4210
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4210
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Core
>    Affects Versions: 1.1.0
>         Environment: prepared cql queries
>            Reporter: Pierre Chalamet
>            Assignee: Sylvain Lebresne
>            Priority: Minor
>             Fix For: 2.0.1
>
>         Attachments: 4210.txt
>
>
> This query
> {code}
> select * from Town where key in (?)
> {code}
> only allows one parameter for '?'.
> This means querying for 'Paris' and 'London' can't be executed in one step with this
prepared statement.
> Current workarounds are:
> * either execute the prepared query 2 times with 'Paris' then 'London'
> * or prepare a new query {{select * from Town where key in (?, ?)}} and bind the 2 parameters
> Having a support for variadic parameters list with in clause could improve performance:
> * single hop to get the data
> * // fetching server side

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message