Deleting values from a column or entire row
CQL provides the
DELETE statement to delete a column or row.
Deleted values are removed completely by the first compaction following deletion.
Delete the value of the column
lastnamefrom the table
DELETE lastname FROM cycling.cyclist_name WHERE id = c7fceba0-c141-4207-9494-a29f9809de6f;
Delete entire row for a particular race from the table
DELETE FROM cycling.calendar WHERE race_id = 201;