Cassandra

CQL provides the facility of creating and using user-defined data types. You can create a data type to handle multiple fields. This chapter explains how to create, alter, and delete…

CQL provides the facility of using Collection data types. Using these Collection types, you can store multiple values in a single variable. This chapter explains how to use Collections in…

CQL provides a rich set of built-in data types, including collection types. Along with these data types, users can also create their own custom data types. The following table provides…

Deleting Datafrom a Table You can delete data from a table using the command DELETE. Its syntax is as follows − DELETE FROM <identifier> WHERE <condition>; Example Let us assume there…

Reading Data using Select Clause SELECT clause is used to read data from a table in Cassandra. Using this clause, you can read a whole table, a single column, or…

Updating Data in a Table UPDATE is the command used to update data in a table. The following keywords are used while updating data in a table − Where − This clause…

Creating Data in a Table You can insert data into the columns of a row in a table using the command INSERT. Given below is the syntax for creating data in…

Using Batch Statements Using BATCH, you can execute multiple modification statements (insert, update, delete) simultaneiously. Its syntax is as follows − BEGIN BATCH <insert-stmt>/ <update-stmt>/ <delete-stmt> APPLY BATCH Example Assume there is…

Dropping an Index You can drop an index using the command DROP INDEX. Its syntax is as follows − DROP INDEX <identifier> Given below is an example to drop an index…

Creating an Index using Cqlsh You can create an index in Cassandra using the command CREATE INDEX. Its syntax is as follows − CREATE INDEX <identifier> ON <tablename> Given below is an…