Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Learning Apache Cassandra
  • Toc
  • feedback
Learning Apache Cassandra

Learning Apache Cassandra

By : Yarabarla
4 (26)
close
Learning Apache Cassandra

Learning Apache Cassandra

4 (26)
By: Yarabarla

Overview of this book

Cassandra is a distributed database that stands out thanks to its robust feature set and intuitive interface, while providing high availability and scalability of a distributed data store. This book will introduce you to the rich feature set offered by Cassandra, and empower you to create and manage a highly scalable, performant and fault-tolerant database layer. The book starts by explaining the new features implemented in Cassandra 3.x and get you set up with Cassandra. Then you’ll walk through data modeling in Cassandra and the rich feature set available to design a flexible schema. Next you’ll learn to create tables with composite partition keys, collections and user-defined types and get to know different methods to avoid denormalization of data. You will then proceed to create user-defined functions and aggregates in Cassandra. Then, you will set up a multi node cluster and see how the dynamics of Cassandra change with it. Finally, you will implement some application-level optimizations using a Java client. By the end of this book, you'll be fully equipped to build powerful, scalable Cassandra database layers for your applications.
Table of Contents (15 chapters)
close

Removing a value from a column

Let's say bob decides he doesn't want his location on his profile. We'd like to get the location column back to the state it was in earlier, which appears as null in cqlsh, but simply means no data here.

Missing columns in Cassandra

As we discussed previously, Cassandra doesn't have the concept of NULL columns in the SQL sense. Technically, the following statement is not possible in Cassandra:

SELECT * FROM "users" WHERE "location" IS NULL; 

Relational databases typically store a separate bit in each column to indicate whether that column contains a NULL value. In Cassandra, on the other hand, all data columns are optional, and only the columns with a value are represented in storage. We can...

bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete