More Information
  • Install, configure, and start Cassandra and get to the CQL console
  • Read, write, and delete data using CQL
  • Design a database model for a social media application and use CQL over it
  • Configure CQL operations for secondary indexes, composite keys, collection types, and counter column families
  • Implement TTL, batch operations, and more using CQL
  • Build client applications using CQL

Apache Cassandra is a fault-tolerant, distributed data store that offers linear scalability, allowing it to act as a storage platform for large, high-volume websites. Cassandra Query Language, or CQL, is the default language/method used to access, change, and query the Cassandra database. It is essential to learn how to use CQL since the old RPC-based mechanism is now giving way to CQL-based Cassandra drivers.

Instant Cassandra Query Language serves as a great starting point for anyone who has started working on Cassandra and who wishes to learn its query language, CQL, in a simple, concise, and quick way. It teaches you how to use CQL in an efficient manner and shows you the exact query commands you need to run.

Instant Cassandra Query Language takes you on a journey through Cassandra Query Language. We first introduce CQL and help you to get started with it by installing, configuring, and opening the console. In order to get a quick feel for it before delving deeper into its inner workings, we’ll run some basic read and write commands. After the stage is set, we’ll design and experiment with a simple social media application, explaining the different CQL constructs used along the way.

You’ll also learn some specific skills like how to specify database columns that expire after a certain period of time, how to create batch operations, and more. Since CQL is used as a base for Cassandra drivers, it’s important to explore the usage of CQL via different libraries. You’ll learn how to write client applications over Cassandra in different ways, namely using Thrift and Datastax Java Driver. A listing of high-level clients is also provided that serves as a good starting point for you to explore them further. With this book, you’ll learn everything you’re likely to encounter while working with CQL.

  • Learn something new in an Instant! A short, fast, focused guide delivering immediate results
  • Covers the most frequently used constructs using practical examples
  • Dive deeper into CQL, TTL, batch operations, and more
  • Learn how to shed Thrift and adopt a CQL-based binary protocol
Page Count 54
Course Length 1 hours 37 minutes
ISBN 9781783282722
Date Of Publication 24 Sep 2013


Amresh Singh

Amresh Singh is an engineering graduate and has more than nine years of software development experience in Java SE/EE technologies. He has vast industry experience in serverside web development using Struts, JSF, Spring, Hibernate, RDBMS, and so on. He is core committer in the open source project, Kundera, which is a JPA 2.0-based object-data store mapping library for NoSQL databases, such as Cassandra, HBase, MongoDB, and OracleNoSQL. He has worked with reputed development and consulting IT organizations in business domains ranging from telecom to finance, and insurance. He is currently working as Lead Developer in Innovation Labs of Impetus Infotech (India) Pvt. Ltd. He has undertaken speaking engagements in Cloud Camp. He loves writing, and is a DZone Most Valuable Blogger. You can follow his blog at