Cassandra Cheat Sheets

December 13, 2011 Leave a comment


I’ll be getting some free time over the next few weeks and I intend to put together a series of Cassandra Cheat Sheets. I’ve been wanting to for a while but haven’t gotten round to it, so the following list are the individual sheets which target specific things relating to Cassandra.

  1. Cassandra Terminology
  2. Cassandra Query Language
  3. Cassandra Thrift API
  4. Cassandra Internals

I’ll add more as I get time in pdf,html and doc format… The first cheat sheet is already being written.

Filed under Cassandra, CQL Tagged with , , , , , ,

Cassandra Query Language (CQL) v2.0 reference

September 17, 2011 18 Comments


This is an update to my two previous posts:
http://crlog.info/2011/03/29/cassandra-query-language-aka-cql-syntax/ AND
http://crlog.info/2011/06/13/cassandra-query-language-cql-v1-0-0-updated/
If you’re using versions of Cassandra prior v1.0 beta one of the above links may be more appropriate as little things may have changed here and there. The official doc is on Gitub in textile markup here https://github.com/apache/cassandra/blob/trunk/doc/cql/CQL.textile

Cassandra Query Language (CQL) v2.0

Read more of this post

Filed under Cassandra, CQL, NoSQL Tagged with , , , , , , , , ,

CQL : Creating a column family

June 18, 2011 Leave a comment


Following on from my last post about how to create a keyspace with CQL,  in this tutorial/post I’ll create a Coloumn family. Unless this has changed recently CQL does not support creating supoer column families. As far as I know there are no plans to do so either… Read more of this post

Filed under Cassandra, CQL Tagged with , , , ,

Cassandra Query Language (CQL) v1.0.0 (UPDATED)

June 13, 2011 9 Comments


NOTE: CQL V2 reference is available here http://crlog.info/2011/09/17/cassandra-query-language-cql-v2-0-reference/

Cassandra Query Language (CQL) v1.0.0

This is an update to my previous post documenting the Cassandra query language CQL. A few changes have been made in CQL, the biggest change being the addition of the INSERT keyword. Previously the UPDATE statement would perform an insert if a value did not already exists, the INSERT statement now explicitly does this inserting. BATCH and ALTER TABLE are also now included in the mix, see the official doc here : https://github.com/apache/cassandra/blob/trunk/doc/cql/CQL.textile.

If you’re new to NoSQL and Cassandra you can read this gentle Introduction to NoSQL and Apache Cassandra
Read more of this post

Filed under Cassandra, CQL, NoSQL Tagged with , , , , , ,

Cassandra Query Language AKA CQL syntax

March 29, 2011 17 Comments


NOTE:  CQL V2 reference is available here http://crlog.info/2011/09/17/cassandra-query-language-cql-v2-0-reference/

A more recent version of the CQL Specification V1.0.0 is available here http://crlog.info/2011/06/13/cassandra-query-language-cql-v1-0-0-updated/

A very nice break down of the up and coming CQL syntax was posted on the Cassandra dev list yesterday.
It breaks down the current state of the query language in easy to understand steps. I’ve copied it purely for the sake
of duplication and getting it out there as much as possible. While CQL is still very immature it is gaining momentum
and is likely to become the de-facto interface to Cassandra. Read more of this post

Filed under Cassandra, CQL, NoSQL Tagged with , , , , , , , , ,

Follow

Get every new post delivered to your Inbox.

Join 351 other followers

%d bloggers like this: