NoSQL: Cassandra Batch to execute multiple Statements

In this post, I am sharing basic help to execute multiple statements using one single Cassandra batch.

Many times, it is required to execute multiple statements using single batch.
Cassandra CQL provides the BEGIN BATCH…APPLY BATCH command to execute multiple statements.

Below is a small demonstration:

Create Keyspace if not exists:

1	CREATE KEYSPACE IF NOT EXISTS dbrnd WITH replication = {'class': 'SimpleStrategy', 'replication_factor' : 3};

Use a Keyspace:

1	USE dbrnd;

Create a Sample Table:

1 2 3 4 5 6 7

CREATE TABLE IF NOT EXISTS tbl_Employee (   EmpID INT PRIMARY KEY   ,EmpFirstName VARCHAR   ,EmpLastName VARCHAR   ,EmpSalary INT );

Insert few sample records:

1 2 3 4 5 6 7 8 9

INSERT INTO tbl_Employee (EmpID,EmpFirstName,EmpLastName,EmpSalary) VALUES (1,'Anvesh','Patel',50000);   INSERT INTO tbl_Employee (EmpID,EmpFirstName,EmpLastName,EmpSalary) VALUES (2,'Neevan','Patel',150000);

Execute INSERT, UPDATE, DELETE using one Single Batch command:

1 2 3 4 5 6 7 8 9 10

cassandra@cqlsh:dbrnd>     begin batch          INSERT INTO tbl_Employee          (EmpID,EmpFirstName,EmpLastName,EmpSalary)          VALUES          (3,'Meera','Patel',80000);          UPDATE tbl_Employee SET EmpFirstName ='Martin' WHERE EmpID=2;                   DELETE FROM tbl_Employee WHERE EmpID=3;     apply batch;

Check the result:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

cassandra@cqlsh:dbrnd> SELECT *FROM tbl_Employee;   @ Row 1 --------------+-------- empid        | 1 empfirstname | Anvesh emplastname  | Patel empsalary    | 50000   @ Row 2 --------------+-------- empid        | 2 empfirstname | Martin emplastname  | Patel empsalary    | 150000   (2 rows)