Home » Cassandra Collections

Cassandra Collections

by Online Tutorials Library

Cassandra Collections

Cassandra collections are used to handle tasks. You can store multiple elements in collection. There are three types of collection supported by Cassandra:

  • Set
  • List
  • Map

Set Collection

A set collection stores group of elements that returns sorted elements when querying.

Syntax:

Example:

Let’s take an example to demonstrate set collection. Create a table “employee” having the three columns id, name and email.

Cassandra Collection 1

The table is created like this:

Cassandra Collection 2

Insert values in the table:

Output:

Cassandra Collection 3


List Collection

The list collection is used when the order of elements matters.

Let’s take the above example of “employee” table and a new column name “department” in the table employee.

Cassandra Collection 4

Now the new column is added. Insert some value in the new column “department”.

Cassandra Collection 5

Output:

Cassandra Collection 6


Map Collection

The map collection is used to store key value pairs. It maps one thing to another. For example, if you want to save course name with its prerequisite course name, you can use map collection.

See this example:

Create a table named “course”.

Cassandra Collection 7

Now table is created. Insert some data in map collection type.

Output:

Cassandra Collection 8


You may also like