You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Jonathan Ellis (JIRA)" <ji...@apache.org> on 2011/04/22 03:57:05 UTC
[jira] [Commented] (CASSANDRA-2537) CQL: Error performing batch
insert
[ https://issues.apache.org/jira/browse/CASSANDRA-2537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13023078#comment-13023078 ]
Jonathan Ellis commented on CASSANDRA-2537:
-------------------------------------------
<CONSISTENCY> is defined as follows:
{noformat}
Consistency level specifications are made up the keyword @USING@, followed by a consistency level identifier. Valid consistency levels are as follows:
* @CONSISTENCY ZERO@
* @CONSISTENCY ONE@ (default)
* @CONSISTENCY QUORUM@
* @CONSISTENCY ALL@
* @CONSISTENCY DCQUORUM@
* @CONSISTENCY DCQUORUMSYNC@
{noformat}
i.e., you want "BEGIN BATCH USING CONSISTENCY QUORUM"
> 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.0
> Environment: 3-node Centos 5.5 cluster running 0.8 build from apr20.
> Reporter: Cathy Daw
> Labels: cql
>
> *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