16 of 19Image
The CLI client
The CLI client lets you run such commands as USE (to address a specific keyspace) and CREATE COLUMN FAMILY (which is self-explanatory), both of which are shown here. Make sure to end all commands with a semi-colon. When you're done, type "exit;" at the prompt (without the quotes) and tap the Enter key.
CQL, here we come
CQL, the Cassandra Query Language, looks very much like SQL. Run the CQL shell by running the "cqlsh" python script back in the bin folder (double click the "cqlsh" file, then specify the application to run it with as the full path to python.exe on your machine).
Once you're in the CQL shell, you can use the USE command as you did in the CLI client. Then, SQL-like sytax becomes the norm. Use the CREATE TABLE command to create a column family, and use INSERT and SELECT to create data and query it, respectively. The commands shown here create a column family called "emp", insert a row of data into it and read the data back.
Works from code, too
Connectors and libraries for Cassandra are available for almost any development environment, including Enterprise Windows environments like .NET and C#. Nick Berardi's Fluent Cassandra client is available as an open source NuGet package for .NET developers.
As shown here in Visual Studio 2012, you can grab Fluent Cassandra by entering the "Install-Package FluentCassandra" command in the Package Manager window.