Skip to Content
Mastering Apache Cassandra 3.x - Third Edition
book

Mastering Apache Cassandra 3.x - Third Edition

by Aaron Ploetz, Tejaswi Malepati
October 2018
Beginner to intermediate content levelBeginner to intermediate
348 pages
10h
English
Packt Publishing
Content preview from Mastering Apache Cassandra 3.x - Third Edition

Deleting data

While deleting data and its associated implications have been discussed, there are times when rows or individual column values may need to be deleted. In our use case, we discussed the difficulties of trying to work with the primary key on something that needs to be dynamic, such as status. In our case, we have an extra row for our order that we need to delete:

DELETE FROM order_statusWHERE status='PENDING'AND order_id=fcb15fc2-feaa-4ba9-a3c6-899d1107cce9;

As mentioned previously, DELETE can also enforce the removal of individual column values:

DELETE shipping_weight_kg FROM order_statusWHERE status='PICKED'AND order_id=99886f63-f271-459d-b0b1-218c09cd05a2;
Again, take care when using DELETE. Deleting creates tombstones, which ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Mastering Apache Cassandra - Second Edition

Mastering Apache Cassandra - Second Edition

Nishant Neeraj

Publisher Resources

ISBN: 9781789131499Supplemental Content