{"id":16033,"date":"2018-05-19T04:00:47","date_gmt":"2018-05-19T04:00:47","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=16033"},"modified":"2021-04-05T13:45:39","modified_gmt":"2021-04-05T08:15:39","slug":"cassandra-crud-operation","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/cassandra-crud-operation\/","title":{"rendered":"Cassandra Crud Operation – Create, Update, Read & Delete"},"content":{"rendered":"

1. Objective – Crud Operation<\/h2>\n

In this Cassandra Tutorial<\/a><\/strong>, we will learn about the Cassandra CRUD Operation: Create, Update, Read & Delete. Moreover, we will cover the syntax and example of each CRUD operation in Cassandra.<\/span><\/p>\n

So, let’s start with Cassandra CRUD Operation.<\/p>\n

\"Cassandra<\/a>

Cassandra Crud Operation – Create, Update, Read & Delete<\/p><\/div>\n

Test how much you know about Cassandra<\/strong><\/a><\/p>\n

2. What is Cassandra CRUD Operation?<\/h2>\n

Cassandra CRUD Operation stands for Create, Update, Read and Delete or Drop. These operations are used to manipulate data in Cassandra. Apart from this, CRUD operations in Cassandra, a user can also verify the command or the data.<\/span><\/p>\n

a. Create Operation<\/h3>\n

A\u00a0user can insert data into the table using Cassandra CRUD operation. The data is stored in the columns of a row in the table. Using INSERT command with proper what, a user can perform this operation.<\/span>
\nRead about\u00a0 Important Features of\u00a0Cassandra\u00a0<\/a><\/strong>
\nA Syntax of Create Operation-<\/strong><\/span><\/p>\n

INSERT INTO <table name>\r\n(<column1>,<column2>....)\r\nVALUES (<value1>,<value2>...)\r\nUSING<option><\/pre>\n
Let’s create a table data to illustrate the operation. Example consist of a table with information about students in college. The following table will give the details about the students.<\/span>
\nTable.1 Cassandra Crud Operation – Create Operation<\/strong><\/p>\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
 
EN<\/strong><\/span><\/td>\nNAME<\/strong><\/span><\/td>\nBRANCH<\/strong><\/span><\/td>\nPHONE<\/strong><\/span><\/td>\nCITY<\/strong><\/span><\/td>\n<\/tr>\n
001<\/span><\/td>\nAyush<\/span><\/td>\nElectrical Engineering<\/span><\/td>\n9999999999<\/span><\/td>\nBoston<\/span><\/td>\n<\/tr>\n
002<\/span><\/td>\nAarav<\/span><\/td>\nComputer Engineering<\/span><\/td>\n8888888888<\/span><\/td>\nNew York City<\/span><\/td>\n<\/tr>\n
003<\/span><\/td>\nKabir<\/span><\/td>\nApplied Physics<\/span><\/td>\n7777777777<\/span><\/td>\nPhiladelphia<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
EXAMPLE 1:<\/strong> Creating a table and inserting the data into a table:
\nINPUT:
\n<\/span><\/span><\/p>\n
cqlsh:keyspace1> INSERT INTO student(en, name, branch, phone, city)\r\nVALUES(001, 'Ayush', 'Electrical Engineering', 9999999999, 'Boston');\r\ncqlsh:keyspace1> INSERT INTO student(en, name, branch, phone, city)\r\nVALUES(002, 'Aarav', 'Computer Engineering', 8888888888, 'New York City');\r\ncqlsh:keyspace1> INSERT INTO student(en, name, branch, phone, city)\r\nVALUES(003, 'Kabir', 'Applied Physics', 7777777777, 'Philadelphia');<\/pre>\n
Let’s Learn Cassandra Architecture in detail<\/a><\/strong>
\nTable.2 Cassandra Crud Operation – OUTPUT After Verification (READ operation)<\/strong><\/span><\/span><\/p>\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n
 
EN<\/span><\/strong><\/span><\/td>\nNAME<\/span><\/strong><\/span><\/td>\nBRANCH<\/span><\/strong><\/span><\/td>\nPHONE<\/span><\/strong><\/span><\/td>\nCITY<\/span><\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n
001<\/span><\/span><\/td>\nAyush<\/span><\/span><\/td>\nElectrical Engineering<\/span><\/span><\/td>\n9999999999<\/span><\/span><\/td>\nBoston<\/span><\/span><\/td>\n<\/tr>\n
002<\/span><\/span><\/td>\nAarav<\/span><\/span><\/td>\nComputer Engineering<\/span><\/span><\/td>\n8888888888<\/span><\/span><\/td>\nNew York City<\/span><\/span><\/td>\n<\/tr>\n
003<\/span><\/span><\/td>\nKabir<\/span><\/span><\/td>\nApplied Physics<\/span><\/span><\/td>\n7777777777<\/span><\/span><\/td>\nPhiladelphia<\/span><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
b.Update Operation<\/h3>\n
The second operation in the Cassandra CRUD operation is the UPDATE operation. A user can use UPDATE command for the operation. This operation uses three keywords while updating the table. <\/span><\/span><\/p>\n