• Home
  • Testing
  • SAP
  • Web
  • Must Learn!
  • Big Data
  • Live Projects
  • AI
  • Blog

Cassandra collections are a good way for handling tasks. Multiple elements can be stored in collections. There are limitations in Cassandra collections.

  • Cassandra collection cannot store data more than 64KB.
  • Keep a collection small to prevent the overhead of querying collection because entire collection needs to be traversed.
  • If you store more than 64 KB data in the collection, only 64 KB will be able to query, it will result in loss of data.

There are three types of collections that Cassandra supports.

  1. Set

    A Set stores group of elements that returns sorted elements when querying.

    Syntax

    Here is the syntax of the Set collection that store multiple email addresses for the teacher.

    Create table University.Teacher
    (
    id int,
    Name text,
    Email set<text>,
    Primary key(id)
    );

Execution

Here is the snapshot where table "Teacher" is created with "Email" column as a collection.

Cassandra Collections Tutorial - SET, LIST & MAP

Here is the snapshot where data is being inserted in the collection.

Cassandra Collections Tutorial - SET, LIST & MAP

  1. List

    When the order of elements matters, the list is used.

    Here is the snapshot where column courses of list type id added in table "Teacher."

    Cassandra Collections Tutorial - SET, LIST & MAP

    Here is the snapshot where data is being inserted in column "coursenames".

    Cassandra Collections Tutorial - SET, LIST & MAP

    Here is the snapshot that shows the current database state after insertion.

    Cassandra Collections Tutorial - SET, LIST & MAP

  2. Map

    The map is a collection type that is used to store key value pairs. As its name implies that it maps one thing to another.

    For example, if you want to save course name with its prerequisite course name, map collection can be used.

    Here is the snapshot where map type is created for course name and its prerequisite course name.

    Cassandra Collections Tutorial - SET, LIST & MAP

    Here is the snapshot where data is being inserted in map collection type.

    Cassandra Collections Tutorial - SET, LIST & MAP

 

YOU MIGHT LIKE: