Set is a collection of elements, which don't permits duplicate elements.
How to create a column of type set?
Use ‘set’ keyword to create a column of type set.
CREATE TABLE IF NOT EXISTS cassandratutorial.person (
id INT PRIMARY KEY,
firstName VARCHAR,
lastName VARCHAR,
hobbies SET<VARCHAR>
);
How to insert elements to set?
By placing the elements in {}, you can insert elements to a set.
INSERT INTO cassandratutorial.person (id, firstName, lastName, hobbies) VALUES (1, 'Hari', 'Krishna', {'football', 'cricket', 'trekking'});
cqlsh> CREATE TABLE IF NOT EXISTS cassandratutorial.person (
... id INT PRIMARY KEY,
... firstName VARCHAR,
... lastName VARCHAR,
... hobbies SET<VARCHAR>
... );
cqlsh>
cqlsh> INSERT INTO cassandratutorial.person (id, firstName, lastName, hobbies) VALUES (1, 'Hari', 'Krishna', {'football', 'cricket', 'trekking'});
cqlsh>
cqlsh> SELECT * FROM cassandratutorial.person;
id | firstname | hobbies | lastname
----+-----------+-------------------------------------+----------
1 | Hari | {'cricket', 'football', 'trekking'} | Krishna
(1 rows)
Add elements to a set
Using + operator, you can add elements to a set.
UPDATE cassandratutorial.person SET hobbies = hobbies + {'tennis', 'blogging'} WHERE id = 1;
cqlsh> UPDATE cassandratutorial.person SET hobbies = hobbies + {'tennis', 'blogging'} WHERE id = 1;
cqlsh>
cqlsh> SELECT * FROM cassandratutorial.person;
id | firstname | hobbies | lastname
----+-----------+-----------------------------------------------------------+----------
1 | Hari | {'blogging', 'cricket', 'football', 'tennis', 'trekking'} | Krishna
(1 rows)
Removing elements from a set
Using – operator, you can remove elements from the set.
cqlsh> UPDATE cassandratutorial.person SET hobbies = hobbies - {'tennis', 'blogging'} WHERE id = 1;
cqlsh>
cqlsh> SELECT * FROM cassandratutorial.person;
id | firstname | hobbies | lastname
----+-----------+-------------------------------------+----------
1 | Hari | {'cricket', 'football', 'trekking'} | Krishna
(1 rows)
No comments:
Post a Comment