From the course: Cassandra Data Modeling Essential Training

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Working with JSON

Working with JSON - Cassandra Tutorial

From the course: Cassandra Data Modeling Essential Training

Start my 1-month free trial Buy for my team

Working with JSON

“

- [Instructor] Let's take a minute to talk about Cassandra and JSON. Now, Cassandra does not have a JSON data type the way some other databases do. For example, Postgres has a JSON and JSON-B data types that allow you to store JSON objects, basically JSON strings, as those semi-structured types directly in a column in the database. That's not the case for Cassandra, but Cassandra does allow you to work in JSON in ways that are really convenient if you're doing application development with JSON. Specifically, it's possible to use JSON with SELECT and INSERT statements, and what happens is, for example, if you were to use the SELECT JSON command, for example, with SELECT JSON a, b FROM some_table, that would return a JSON structure with keys a and b, and the corresponding values for a and b. Now, that's useful if in your application, you're passing around JSON structures, that saves you an extra step of having to…

Contents