[CASSANDRA-4693] CQL Protocol should allow multiple PreparedStatements to be atomically executed

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.0 beta 1
• Labels: cql protocol
• Assignee: Sylvain Lebresne
• Reporter: Michaël Figuière

Authors

Sylvain Lebresne

Reviewers

Aleksey Yeschenko

• Created: 20/Sep/12 14:22
• Updated: 16/Apr/19 09:32
• Resolved: 27/May/13 07:48

Description

Currently the only way to insert multiple records on the same partition key, atomically and using PreparedStatements is to use a CQL BATCH command. Unfortunately when doing so the amount of records to be inserted must be known prior to prepare the statement which is rarely the case. Thus the only workaround if one want to keep atomicity is currently to use unprepared statements which send a bulk of CQL strings and is fairly inefficient.

Therefore CQL Protocol should allow clients to send multiple PreparedStatements to be executed with similar guarantees and semantic as CQL BATCH command.

Issue Links

• is duplicated by: CASSANDRA-5959 CQL3 support for multi-column insert in a single operation (Batch Insert / Batch Mutate)