Cassandra Truncate Table

In Cassandra, the TRUNCATE command is used to remove all data from a table in a single operation, effectively resetting the table to an empty state. Unlike the DELETE command, which deletes individual rows, the TRUNCATE command empties the entire table. This can be a useful operation for clearing out test data, resetting the state of a table, or other administrative tasks.

Syntax:

The syntax for the TRUNCATE command is as follows:

TRUNCATE [TABLE] keyspace_name.table_name;

Where “keyspace_name” is the name of the keyspace containing the table, and “table_name” is the name of the table to truncate. The optional “TABLE” keyword can be included for clarity, but is not strictly necessary.

Examples: To truncate a table in Cassandra, you must have the appropriate permissions to modify the table. Here are a few examples of how to use the TRUNCATE command:

1. Truncating a table named “users” in a keyspace named “test”:

TRUNCATE test.users;

2. Truncating a table named “orders” in a keyspace named “ecommerce”:

TRUNCATE ecommerce.orders;

3. Truncating a table named “logs” in a keyspace named “system”:

TRUNCATE system.logs;

Note that when you truncate a table, all data in the table is permanently deleted. There is no way to recover the data once the operation has completed, so it is important to be careful when using this command.

The TRUNCATE command in Cassandra is a powerful tool for quickly clearing out the contents of a table. It is a useful operation for a variety of administrative tasks, but should be used with caution to avoid accidentally deleting important data. By following the syntax and examples outlined in this tutorial, you can safely and effectively use the TRUNCATE command in your Cassandra deployments.