{"id":15803,"date":"2018-05-30T06:40:58","date_gmt":"2018-05-30T06:40:58","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=15803"},"modified":"2021-04-05T13:45:24","modified_gmt":"2021-04-05T08:15:24","slug":"cassandra-collection","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/","title":{"rendered":"Cassandra Collection Data Types: List, Set, & Map"},"content":{"rendered":"

1. Objective<\/h2>\n

In our Cassandra <\/a><\/strong>journey, we will see Cassandra Collection Data Types tutorial. In this, we will know about Collection data type in Cassandra. These are data types just like arrays and structures in C, C++ etc. <\/span><\/p>\n

Moreover, we will discuss this Cassandra Collection Data Types with the help of list, set, and map.<\/span>
\nSo, let’s start Cassandra Collection Data Types<\/p>\n

\"Cassandra<\/a>

Cassandra Collection Data Types<\/p><\/div>\n

Do you know about Cassandra Troubleshooting<\/a><\/strong><\/p>\n

2. Cassandra Collection Data Types<\/h2>\n

Collection data types in Cassandra are basically a unit in which multiple values are stored. Usually, a single variable defines Cassandra-CQL collection data type. This variable, in turn, contains multiple values. <\/span><\/p>\n

There are a few collection data types, list, set and map. Many functions are performed on these Cassandra collection data types. These functions include create, insert, update and verify.<\/span>
\nCassandra Data Model | How Cassandra Stores Data<\/strong><\/a><\/p>\n

a. Cassandra List<\/h3>\n

In this data type, the values are stored in a form of a list. One value in this list is stored multiple times. There is one rule for the list data type. <\/span><\/p>\n

The order of the elements cannot be changed. After storing the values in the list, the elements get a particular index. The values can be retrieved through these indexes.<\/span><\/p>\n

i. Create<\/strong>
\nThis Cassandra Create table is used to create a table with list data type, the user can apply CREATE TABLE command. The table can contain many columns. The syntax<\/strong> used to create table is.<\/span><\/p>\n

cqlsh:<keyspace>>CREATE TABLE <table name>(column1 PRIMARY KEY,column2 list <data type>,column3 list <data type>,.....);<\/pre>\n
Creating a table ‘college students’ with columns, name, enrolment number and branch.<\/span>
\nBest Cassandra Books to gain complete knowledge of Cassandra<\/a><\/strong>
\nExample A.1 Creating the table.<\/strong>
\n<\/span>
\nInput:<\/p>\n
cqlsh> USE keyspace1;\r\ncqlsh:keyspace1> CREATE TABLE employee\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... (EN int,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... NAME text,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... EMAIL LIST<text>,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... PRIMARY KEY(EN),\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... );<\/pre>\n
ii. Insert<\/b>
\nTo insert elements in the table user can use INSERT INTO command. A comma separates all the values within square brackets. The syntax<\/strong> is.<\/span><\/p>\n
cqlsh:<keyspace>> INSERT INTO <table name>(column1, column2, column3,....) VALUES('R1value1',['R1value1','R1value2','R1value3'...]['R1value11','R1value12','R1value13'...]...);<\/pre>\n
Example A.2: Cassandra insert table.<\/strong><\/p>\n
cqlsh:keyspace1> INSERT INTO college student (EN, NAME, EMAIL)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... VALUES(001,'Ayush',{'ayush@gmail.com'});\r\ncqlsh:keyspace1> INSERT INTO college student (EN, NAME, EMAIL)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... VALUES(002,'Aarav',{'aarav@ymail.com'});\r\ncqlsh:keyspace1> INSERT INTO college student (EN, NAME, EMAIL)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... VALUES(003,'Kabir',{'kabir@hotmail.com'});<\/pre>\n
iii. Update<\/b>
\nUPDATE command in Cassandra is used to update the value in particular columns of the table. The syntax<\/strong> used to update is.<\/span>
\nLet’s revise Cassandra API<\/a><\/strong><\/p>\n
cqlsh:<keyspace> UPDATE<table name>\r\nSET <column2>=<column2>+['value']\r\nwhere <column1>='some value';<\/pre>\n
Example A.3:<\/strong> Updating the table in Cassandra Collection.<\/span><\/p>\n
cqlsh:keyspace2>UPDATE college student\r\nSET EMAIL=EMAIL+['ayush.1@gmail.com']\r\nwhere EN=001;<\/pre>\n
Have a look at Cassandra Cluster<\/a><\/p>\n
iv. Verify<\/b>
\nTo verify the contents of the table SELECT command is used. The syntax<\/strong>\u00a0for Verify the table in Cassandra Collection Data Types is.<\/span><\/p>\n
cqlsh:<keyspace>> SELECT*FROM <table name>;<\/pre>\n
To verify the tables<\/span>
\n<\/span>Input:<\/strong><\/p>\n
cqlsh:keyspace> SELECT*FROM employee;\r\n<\/pre>\n
Output\u00a0after Example A.1:<\/strong><\/span><\/p>\n\n\n\n\n
EN \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nNAME \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nEMAIL<\/span><\/td>\n<\/tr>\n
 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
(0 rows)<\/span>
\nExplore Important Cassandra Features\u00a0<\/a><\/strong>
\nOutput\u00a0after Example A.2:<\/strong><\/span><\/p>\n\n\n\n\n\n\n
EN<\/span><\/td>\nNAME<\/span><\/td>\nEMAIL<\/span><\/td>\n<\/tr>\n
001 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nAyush<\/span><\/td>\nayush@gmail.com<\/span><\/td>\n<\/tr>\n
002<\/span><\/td>\nAarav<\/span><\/td>\naarav@ymail.com<\/span><\/td>\n<\/tr>\n
003<\/span><\/td>\nKabir<\/span><\/td>\nkabir@hotmail.com<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
(3 rows)<\/span>
\nOutput\u00a0after Example A.3:<\/strong><\/span><\/p>\n\n\n\n\n\n\n
EN<\/span><\/td>\nNAME<\/span><\/td>\nEMAIL<\/span><\/td>\n<\/tr>\n
001 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nAyush<\/span><\/td>\nayush.1@gmail.com<\/span><\/td>\n<\/tr>\n
002<\/span><\/td>\nAarav<\/span><\/td>\naarav@ymail.com<\/span><\/td>\n<\/tr>\n
003<\/span><\/td>\nKabir<\/span><\/td>\nkabir@hotmail.com<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
(3 rows)<\/span><\/p>\n
b. Cassandra Set<\/h3>\n
To store a group of the element, a user can use SET Cassandra collection data type. The elements in the set returns in a sorted order after execution.<\/span><\/p>\n
i. Cassandra Create Table<\/strong>
\nTo create a table with the set, a user can use CREATE command with the following syntax<\/strong>.<\/span><\/p>\n
cqlsh:<keyspace> CREATE TABLE<table name> (column1 PRIMARY KEY, column2 set <data type>, column3 set <data type>.....);\r\n<\/pre>\n
Creating a table ‘college students’ with columns, name, enrolment number and branch.<\/span><\/p>\n
You must know about Cassandra Monitoring Tools<\/a><\/strong>
\nExample B.1<\/strong> Creating the table.<\/span>
\n<\/span>Input:<\/strong><\/p>\n
cqlsh> USE keyspace2;\r\ncqlsh:keyspace2> CREATE TABLE college students\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... (EN int,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... NAME text,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... BRANCH SET<text>,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... PRIMARY KEY(EN),\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... );<\/pre>\n
ii. Cassandra Insert<\/strong>
\nTo insert value in a set INSERT INTO command is used with the following syntax.<\/span><\/p>\n
cqlsh:<keyspace>> INSERT INTO <table name>(column1, column2, column3...) VALUES('R1value',{'R1value1', 'R1value2',..},{ 'R1value11', 'R1value12',..}....);<\/pre>\n
Example B.2:<\/strong> Inserting in the table.<\/span>
\nLet’s explore Cassandra\u00a0Terminologies<\/a><\/strong><\/p>\n
cqlsh:keyspace2> INSERT INTO college student (EN, NAME, BRANCH)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... VALUES(001,'Ayush',{'electrical engineering'});\r\ncqlsh:keyspace2> INSERT INTO college student (EN, NAME, BRANCH)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... VALUES(002,'Aarav',{'Computer engineering'});\r\ncqlsh:keyspace2> INSERT INTO college student (EN, NAME, BRANCH)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... VALUES(003,'Kabir',{'Applied Physics'});<\/pre>\n
iii. Cassandra Update<\/strong>
\nA user can update the contents in a set using this syntax.<\/strong><\/span><\/p>\n
cqlsh:<keyspace>>UPDATE <table name>\r\nSET <column2>=<column2>+['value']\r\nwhere <column1>='some value';\r\n<\/pre>\n
Example B.3:<\/strong> Updating the table.<\/span><\/p>\n
cqlsh:keyspace2>UPDATE college student\r\nSET BRANCH=BRANCH+['electrical and electronics']\r\nwhere EN=001;<\/pre>\n
Cassandra Applications | Why Cassandra Is So Popular?<\/strong><\/a>
\niv. Verify\u00a0<\/b>
\nTo verify the contents of the table SELECT command is used. The syntax<\/strong> is.<\/span><\/p>\n
cqlsh:<keyspace>> SELECT*FROM <table name>;<\/pre>\n
To verify the tables<\/span>
\n<\/span>Input:<\/strong>
\n<\/span><\/p>\n
cqlsh:keyspace2> SELECT*FROM COLLEGE STUDENTS;<\/pre>\n
Output<\/strong>\u00a0after Example B.1:<\/strong><\/span><\/p>\n\n\n\n\n
EN \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nNAME \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nBRANCH<\/span><\/td>\n<\/tr>\n
 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
(0 rows)<\/span>
\nOutput after Example B.2:<\/strong><\/p>\n\n\n\n\n\n\n
EN<\/span><\/td>\nNAME<\/span><\/td>\nBRANCH<\/span><\/td>\n<\/tr>\n
001 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nAyush<\/span><\/td>\nElectrical Engineering<\/span><\/td>\n<\/tr>\n
002<\/span><\/td>\nAarav<\/span><\/td>\nComputer Engineering<\/span><\/td>\n<\/tr>\n
003<\/span><\/td>\nKabir<\/span><\/td>\nApplied Physics<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
(3 rows)<\/span>
\nOutput after Example B.3:<\/strong><\/p>\n
Do you know about Cassandra Manipulation Command<\/a><\/strong><\/p>\n\n\n\n\n\n\n
EN<\/span><\/td>\nNAME<\/span><\/td>\nBRANCH<\/span><\/td>\n<\/tr>\n
001 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nAyush<\/span><\/td>\nElectrical and Electronics<\/span><\/td>\n<\/tr>\n
002<\/span><\/td>\nAarav<\/span><\/td>\nComputer Engineering<\/span><\/td>\n<\/tr>\n
003<\/span><\/td>\nKabir<\/span><\/td>\nApplied Physics<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
(3 rows)<\/span><\/p>\n
c. Cassandra Map<\/h3>\n
Map in Cassandra collection data type, stores a key-value pair of elements.<\/span><\/p>\n
i. Cassandra Create a Table<\/strong>
\nTo create a table with map, user can use CREATE command with following syntax<\/strong>.<\/span><\/p>\n
cqlsh:<keyspace> CREATE TABLE<table name> (column1 PRIMARY KEY, column2 map <type, data type>, column3 map <type, data type>.....);<\/pre>\n
Creating a table ‘student’ with 2 columns for Enrolment number and Subject.<\/span>
\nExample C.1:<\/strong> Creating the table.<\/span>
\nInput:<\/strong><\/p>\n
Have a look at Cassandra CQL Clauses<\/a><\/strong><\/p>\n
cqlsh:keyspace3>CREATE TABLE student\r\n                       ...(EN int,\r\n                       ... SUBJECT MAP(text,text),\r\n                       ... PRIMARY KEY(EN)\r\n                       ...);\r\n<\/pre>\n
ii. Insert<\/span><\/strong>
\nTo insert value in a map INSERT INTO command is used with the following syntax.<\/span><\/p>\n
cqlsh:<keyspace>> INSERT INTO <table name>(column1, column2, column3...) VALUES('R1value',{'R1value1':'R1value1' ,R1value2:'R1value01',..},{ 'R1value11':'R1value011','R1value12':'R1value012',..}....);<\/pre>\n
Example C.2<\/strong> Inserting in the table.<\/span>
\nInput:<\/strong><\/p>\n
cqlsh:keyspace3>INSERT INTO student(EN, SUBJECT)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... VALUES(001,{'physics':'mathematics'})\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\ncqlsh:keyspace3>INSERT INTO student(EN, SUBJECT)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... VALUES(002,{'operating system':'robotics'}) \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\ncqlsh:keyspace3>INSERT INTO student(EN, SUBJECT)\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0... VALUES(003,{'power system':'machines'<\/pre>\n
iii. Update<\/strong>
\nA user can update the contents in a set using this syntax.<\/strong><\/span><\/p>\n
cqlsh:<keyspace>>UPDATE <table name>\r\nSET <column2>=<column2>+['value1':'value2']\r\nwhere <column1>='some value';\r\n<\/pre>\n
Example C.3<\/strong> Updating the table.<\/span>
\nInput:<\/strong><\/p>\n
cqlsh:keyspace3>UPDATE student\r\nSET SUBJECT=SUBJECT+['programming':'artificial intelligence']\r\nwhere EN=002;<\/pre>\n
Learn about Cassandra Architecture<\/strong><\/a><\/p>\n
iv. Verify<\/strong>
\nTo verify the contents of the table SELECT command is used. The syntax<\/strong> is.<\/span><\/p>\n
cqlsh:<keyspace>> SELECT*FROM <table name>;<\/pre>\n
To verify the table we use the above syntax. <\/span>
\nInput<\/strong><\/p>\n
cqlsh:keyspace3>SELECT*FROM student;<\/pre>\n
Output after Example C.1<\/strong><\/p>\n\n\n\n\n
EN \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nSUBJECT<\/span><\/td>\n<\/tr>\n
 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
(0 rows)<\/span>
\nOutput after Example C.2<\/strong><\/p>\n\n\n\n\n\n\n
EN \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nSUBJECT<\/span><\/td>\n<\/tr>\n
001 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nphysics, mathematics<\/span><\/td>\n<\/tr>\n
002<\/span><\/td>\nOperating systems, robotics<\/span><\/td>\n<\/tr>\n
003<\/span><\/td>\nPower systems, machines<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
(3 rows)<\/span>
\nOutput after Example C.3<\/strong><\/p>\n\n\n\n\n\n\n
EN \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nSUBJECT<\/span><\/td>\n<\/tr>\n
001 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/td>\nPhysics, mathematics<\/span><\/td>\n<\/tr>\n
002<\/span><\/td>\nProgramming, artificial intelligence<\/span><\/td>\n<\/tr>\n
003<\/span><\/td>\nPower systems, machines<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
(3 rows)<\/span><\/p>\n
Test Your Cassandra Knowledge<\/a><\/strong>
\nSo, this was all about Collection data types in Cassandra. Hope you like the article.<\/p>\n
3. Conclusion<\/h2>\n
Hence, in this Cassandra Collection tutorial, we studied about collection data types in Cassandra. Also, we studied these Cassandra collection data types with the help of list, set and map Cassandra. <\/span><\/p>\n
In the next article, we will know about Cassandra Shell Commands<\/strong><\/a>. Furthermore, if you have any query, feel free to ask through the comment section.<\/span><\/p>\n
See also –\u00a0<\/strong><\/p>\n
Cassandra Interview Questions<\/a><\/strong>
\nFor reference<\/a><\/strong>
1. Objective In our Cassandra journey, we will see Cassandra Collection Data Types tutorial. In this, we will know about Collection data type in Cassandra. These are data types just like arrays and structures...<\/p>\n","protected":false},"author":7,"featured_media":16030,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[2330,2331,2332,2364,2365,2366,2367,2385,2631],"class_list":["post-15803","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cassandra","tag-cassandra-collection","tag-cassandra-collection-data-types","tag-cassandra-collections-performance","tag-cassandra-list","tag-cassandra-list-of-maps","tag-cassandra-map","tag-cassandra-map-data-type","tag-cassandra-set","tag-collection-data-types-in-cassandra"],"yoast_head":"\nCassandra Collection Data Types: List, Set, & Map - DataFlair<\/title>\n<meta name=\"description\" content=\"Cassandra Collection tutorial: collections data types in Cassandra, List, Set & Map Cassandra, Cassandra create table, Syntax, Cassandra collection example\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/cassandra-collection\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cassandra Collection Data Types: List, Set, & Map - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Cassandra Collection tutorial: collections data types in Cassandra, List, Set & Map Cassandra, Cassandra create table, Syntax, Cassandra collection example\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/cassandra-collection\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-30T06:40:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-05T08:15:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/cassandra-collection-.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cassandra Collection Data Types: List, Set, & Map - DataFlair","description":"Cassandra Collection tutorial: collections data types in Cassandra, List, Set & Map Cassandra, Cassandra create table, Syntax, Cassandra collection example","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/","og_locale":"en_US","og_type":"article","og_title":"Cassandra Collection Data Types: List, Set, & Map - DataFlair","og_description":"Cassandra Collection tutorial: collections data types in Cassandra, List, Set & Map Cassandra, Cassandra create table, Syntax, Cassandra collection example","og_url":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-05-30T06:40:58+00:00","article_modified_time":"2021-04-05T08:15:24+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/cassandra-collection-.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd"},"headline":"Cassandra Collection Data Types: List, Set, & Map","datePublished":"2018-05-30T06:40:58+00:00","dateModified":"2021-04-05T08:15:24+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/"},"wordCount":898,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/cassandra-collection-.jpg","keywords":["cassandra collection","Cassandra Collection data types","cassandra collections performance","Cassandra list","Cassandra list of maps","Cassandra map","cassandra map data type","Cassandra set","Collection data types in Cassandra"],"articleSection":["Cassandra Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/cassandra-collection\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/","url":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/","name":"Cassandra Collection Data Types: List, Set, & Map - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/cassandra-collection-.jpg","datePublished":"2018-05-30T06:40:58+00:00","dateModified":"2021-04-05T08:15:24+00:00","description":"Cassandra Collection tutorial: collections data types in Cassandra, List, Set & Map Cassandra, Cassandra create table, Syntax, Cassandra collection example","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/cassandra-collection\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/cassandra-collection-.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/cassandra-collection-.jpg","width":1200,"height":628,"caption":"Cassandra Collection Data Types"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/cassandra-collection\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Cassandra Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/cassandra\/"},{"@type":"ListItem","position":3,"name":"Cassandra Collection Data Types: List, Set, & Map"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team specializes in creating clear, actionable content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Backed by industry expertise, we make learning easy and career-oriented for beginners and pros alike.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam3\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/15803","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=15803"}],"version-history":[{"count":6,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/15803\/revisions"}],"predecessor-version":[{"id":90507,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/15803\/revisions\/90507"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/16030"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=15803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=15803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=15803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}