O'Reilly logo

Instant Cassandra Query Language by Amresh Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Quick start – running CQL queries

Welcome to the world of CQL! Now, since you have a working installation of Cassandra ready, it's time to learn and practice with CQL in a step-by-step manner. Let's open a CQL console and run a few most basic queries in order to get a feel for it.

Hello CQL

First things first; let's see how to start console, and then move on to running queries on it for reading/writing data.

Step 1 – start CQL shell (cqlsh)

cqlsh is a Python-based command-line client for Cassandra. It allows you to run CQL queries directly onto Cassandra database.

On Unix

On a Unix-flavored machine, you have virtually nothing to do in order to start cqlsh.

CASSANDRA_HOME/bin>./cqlsh

Note

Prior to Cassandra 1.2, default CQL version was 2.0 and we were ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required