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] [Commented] (CASSANDRA-2537) CQL: Support for batch insert/delete
Date Fri, 22 Apr 2011 20:46:05 GMT

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

Jonathan Ellis commented on CASSANDRA-2537:
-------------------------------------------

bq. Lets make this an Improvement and change version to 0.8.1 "

+1

bq. My assumption is that we allow batch processing to speed performance

Partially, but grouping updates for idempotence is more important: http://maxgrinev.com/2010/07/12/update-idempotency-why-it-is-important-in-cassandra-applications-2/

> CQL: Support for batch insert/delete
> ------------------------------------
>
>                 Key: CASSANDRA-2537
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2537
>             Project: Cassandra
>          Issue Type: New Feature
>    Affects Versions: 0.8 beta 1
>         Environment: 3-node Centos 5.5 cluster running 0.8 build from apr20.
>            Reporter: Cathy Daw
>            Assignee: Pavel Yaskevich
>            Priority: Minor
>              Labels: cql
>             Fix For: 0.8.1
>
>
> *Test Case To Run*
> {code}
> // Setup
> CREATE COLUMNFAMILY users (
>   KEY varchar PRIMARY KEY,
>   password varchar);
> //Batch Insert
> BEGIN BATCH USING QUORUM
> INSERT INTO users (KEY, password) VALUES ('user2', 'ch@ngem3b');
> INSERT INTO users (KEY, password) VALUES ('user3', 'ch@ngem3c');
> APPLY BATCH
> {code}
> *Actual Behavior*
> {code}
> cqlsh> BEGIN BATCH USING QUORUM
>    ... INSERT INTO users (KEY, password) VALUES ('user2', 'ch@ngem3b');
> Bad Request: line 0:-1 mismatched input '<EOF>' expecting K_APPLY
> {code}
> *Documentation Sample*
> {code}
> BEGIN BATCH [USING <CONSISTENCY>]
> UPDATE CF1 SET name1 = value1, name2 = value2 WHERE KEY = keyname1;
> UPDATE CF1 SET name3 = value3 WHERE KEY = keyname2;
> UPDATE CF2 SET name4 = value4, name5 = value5 WHERE KEY = keyname3;
> APPLY BATCH
> {code}

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message