October 2018
Beginner to intermediate
348 pages
10h
English
Given the ways in which Apache Cassandra has been shown to handle things such as INSERT, UPDATE, and DELETE, it is important to discuss what they have in common. They all result in writes to the database. Let's take a look at how each one behaves in certain scenarios. Assume that we need to keep track of statuses for orders from an e-commerce website. Consider the following table:
CREATE TABLE order_status ( status TEXT, order_id UUID, shipping_weight_kg DECIMAL, total DECIMAL, PRIMARY KEY (status,order_id))WITH CLUSTERING ORDER BY (order_id DESC);