Instant Cassandra Query Language [Instant]

This title is available as an eBook only
Instant Cassandra Query Language [Instant]
eBook: $14.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print & eBook also available on:
Learn in an Instant - Short, Fast, Focused
Table of Contents
Sample Chapters
  • 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

Book Details

Language : English
eBook : 54 pages
Release Date : September 2013
ISBN : 1783282711
ISBN 13 : 9781783282715
Author(s) : Amresh Singh
Topics and Technologies : All Books, Instant, Open Source

Table of Contents

Instant Cassandra Query Language
  • Instant Cassandra Query Language
    • So, what is CQL?
      • Where will you use CQL?
    • Installation
      • Step 1 – what do I need?
      • Step 2 – download Cassandra
      • Step 3 – install Cassandra
      • Step 4 – configure Cassandra
      • Step 5 – start Cassandra server
        • What may go wrong?
      • And that's it
    • Quick start – running CQL queries
      • Step 1 – start CQL shell (cqlsh)
        • On Unix
        • On Windows
      • Step 2 – create and use a keyspace
      • Step 3 – describe and list keyspace
      • Step 4 – create table and insert records
      • Step 5 – display records
        • How is data actually stored?
      • Step 6 – deleting data
        • DELETE
        • TRUNCATE
        • USING TTL
        • Dropping TABLE and KEYSPACE
        • CQL versions
      • Step 7 – building facebook
      • Creating keyspace for facebook
      • Storing facebook data using tables
      • Storing user profiles
        • Create table
        • Insert records
        • Update row
        • View rows
        • Alter table (add collections columns)
      • Storing facebook posts
        • Create table
        • Add records
      • Creating table for user wall (timeline)
        • How data is stored
      • Connecting users with their friends
      • Counting friends and posts
    • Top 3 features you need to know about
      • TTL (time to live)
        • Syntax
        • Gone in 60 seconds!
      • CQL for client applications
        • Using the Thrift API
        • Using the Datastax Java driver
        • Using high-level clients
      • Batch operations
        • Syntax
        • Three flavors of the batch operation
    • People and places you should get to know
      • Official sites
      • Articles and tutorials
      • Community
      • Blogs
      • Twitter

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
Sorry, we don't have any reviews for this title yet.

Code Downloads

Download the code and support files for this book.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sorry, there are currently no downloads available for this title.

Frequently bought together

Instant Cassandra Query Language [Instant] +    Microsoft SharePoint 2010 development cookbook =
50% Off
the second eBook
Price for both: £20.65

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • 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

In Detail

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.


Get to grips with a new technology, understand what it is and what it can do for you, and then get to work with the most important features and tasks. It’s an Instant Starter guide.

Who this book is for

Instant Cassandra Query Language is great for those who are working with Cassandra databases and who want to either learn CQL to check data from the console or build serious applications using CQL. If you’re looking for something that helps you get started with CQL in record time and you hate the idea of learning a new language syntax, then this book is for you.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software