JSON support

JSON is short for JavaScript Object Notation and is a way to store information in an organized, easy-to-access manner. In a nutshell, it gives us a human-readable collection of data that we can access in a really logical manner. It is the most commonly used data format for client/server communication.

Starting with Cassandra 2.2, JSON support was added to the features list of Cassandra. This is an extension of CQL, which makes it easier to work with JSON documents. The SELECT and INSERT statements now include a JSON-focused variant, and two new native functions have been added to convert to and from JSON.

INSERT JSON

The INSERT statement accepts a JSON variant. Suppose we want to insert some JSON data into our user_status_updates_by_datetime table, we can do it in the following way:

INSERT INTO "user_status_updates_by_datetime"
JSON '{"username": "alice", "status_date": "2016-11-24", "status_time":
"13:35:20.123456", "body": "Alice Update 7"}';

Now, if you run the query SELECT ...