Instant Cassandra query language a practical, step-by-step guide for quickly getting started wtih Cassandra query language - Singh, Amresh (Packt Publishing, 2013)
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. 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
Cover; Copyright; Credits; About the Author; About the Reviewers; www.packtpub.com; packtlib.packtpub.com; Table of Contents; 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 recordsStep 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 aboutTTL (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