[jira] [Commented] (CASSANDRA-8854) Support for Async Atomic Batch

["Jonathan Ellis (JIRA)" <ji...@apache.org>]

    [ 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’, ’user1@gmail.com')
>   Async - INSERT INTO users_by_name (name, userID) VALUES (‘first user’, 'user1’); 
>   Async -  INSERT INTO users_by_email (name, userID) VALUES (’user1@gmail.com’, '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)