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

Jonathan Ellis commented on CASSANDRA-8854:
-------------------------------------------

I think this is outside the scope of what we want BATCH to do.  Implicitly, 
BATCH implies that its components should be treated as a unit.  Breaking that 
up into a swiss army knife of picking which parts to treat as a unit and which 
not to would get pretty messy.

IMO this use case would be better served by rolling a client side "batchlog" 
instead.

> Support for Async Atomic Batch
> ------------------------------
>
>                 Key: CASSANDRA-8854
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8854
>             Project: Cassandra
>          Issue Type: New Feature
>            Reporter: Jay Patel
>
> Use case sometimes demands atomicity (using C* logged batch) across multiple 
> DML statements; however, in order to minimize the end user latency, do not 
> want to wait for all the statements to be executed. 
> For instance, would like to have something like:
> BEGIN BATCH
>   Sync - INSERT INTO users (userID, name, email) VALUES ('user1', ‘first 
> user’, ’[email protected]')
>   Async - INSERT INTO users_by_name (name, userID) VALUES (‘first user’, 
> 'user1’); 
>   Async -  INSERT INTO users_by_email (name, userID) VALUES 
> (’[email protected]’, 'user1’);
>   ..... more Async statements!
> APPLY BATCH;
> Once the batch is serialized to the batchlog table and the sync statements 
> are executed, coordinator should return response without waiting for 
> execution of async batch statements.
> Some of the use cases that we’re working on will get benefited significantly 
> in terms of latency reduction. I can take a first cut at it if we don’t see 
> any concerns supporting it. 
> Also, need some discussions around specifying sync/async tag for each 
> statement in the batch.
> Thoughts welcome. Thanks!



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to