cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexandre Gaudencio (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-4210) Support for variadic parameters list for "in clause" in prepared cql query
Date Fri, 14 Nov 2014 13:33:34 GMT

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

Alexandre Gaudencio edited comment on CASSANDRA-4210 at 11/14/14 1:32 PM:
--------------------------------------------------------------------------

Thanks. I'm quite convinced that this is related to the nodejs driver so I'll just report
this on github.

[edit] Sorry for the edit but there's no place on the github repo to open issues for the nodejs
driver. Do you know what the best place is to reach the team in charge of this driver ?


was (Author: shahor):
Thanks. I'm quite convinced that this is related to the nodejs driver so I'll just report
this on github.

> 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 was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message