Experience Upserts

DSE Version: 6.7





Apache CassandraTM inserts and updates behave differently than their relational database counterparts, resulting in a phenomena known as upserts. This unit explains what upserts are and gives you a chance to see them in action.

No write up.

Exercise: Experience Upserts

In this exercise, you will:

  • Create an upsert using the CQL insert command

  • Create an upsert using the CQL update command

Apache Cassandra™ does not do a read before a write. This makes Cassandra fast and scalable. However, for those used to the more traditional relational perspective, not reading before writing can cause some unexpected consequences known as upserts. In this exercise, we will explore upserts.


1) Return to DataStax Studio. If you still have your DataStax Studio tab open in your browser, switch over to that tab. Otherwise, in DataStax Apache Cassandratm as a Service (CaaS), go to the view of your database. Click on the ellipsis to reveal the dropdown menu and click on the Launch Developer Studio link:

2) Complete the steps in the Bootcamp Upserts notebook. This is the second notebook you will work through (you already completed the Bootcamp Data Modeling notebook). Click on the Bootcamp Upserts notebook. Once you have opened the notebook, follow the steps to complete this exercise.


No FAQs.

Upserting data with Cassandra: upsert data and learn how data can be overwritten using an INSERT statement.

Comments are closed.