cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DuyHai Doan <doanduy...@gmail.com>
Subject Re: insert two records with same primary key via batch
Date Sat, 16 Aug 2014 12:56:58 GMT
You're running into funny results due to the way CQL3 handles statements in
batches. Read this:
https://github.com/doanduyhai/Achilles/wiki/Batch-Mode#statements-ordering

There is already a JIRA opened but according to the developers this is the
expected behavior.

 In your example, largest value for column "count" is 9 and largest value
for "text" is "123" (sorted by lexicographic order)


On Sat, Aug 16, 2014 at 1:45 PM, 廖欽啟 <missionaryliao@gmail.com> wrote:

> Hi,
>
>    I'm trying this cql against cassandra 2.0.9:
>    BEGIN  BATCH
>       INSERT INTO cqlengine_test_lwt.test_if_not_exists_model (id, count,
> text) VALUES (1, 8, '123');
>       INSERT INTO cqlengine_test_lwt.test_if_not_exists_model (id, count,
> text) VALUES (1, 9, '111');
>    APPLY BATCH;
>
>    In this case, id is the primary key.
>    And when querying the record with id=1, the result I got is (id=1,
> count=9, text='123'), while I expect
>    the result should be (id=1, count=9, text='111').
>
>    Did I miss anything or is this result expected?
>
> B.R,
> Mission.
>

Mime
View raw message