cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cathy Daw (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-2537) CQL: Error performing batch insert
Date Fri, 22 Apr 2011 18:33:06 GMT

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

Cathy Daw commented on CASSANDRA-2537:
--------------------------------------

It seems like we probably need to change this bug to an improvement or new feature to support
batch inserts, batch deletes and the ability to rollback or abort batch.  My assumption is
that we allow batch processing to speed performance (batch writes being more efficient than
single row writes), and not for transactionality.  

> CQL: Error performing batch insert
> ----------------------------------
>
>                 Key: CASSANDRA-2537
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2537
>             Project: Cassandra
>          Issue Type: Bug
>    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.0
>
>
> *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