incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Hillsborough <matthew.hillsboro...@gmail.com>
Subject Dynamic column family using CQL2, possible?
Date Tue, 28 May 2013 22:44:50 GMT
Hi all,

I started building a schema using CQL3's interface following the
instructions here: http://www.datastax.com/dev/blog/thrift-to-cql3

In particular, the dynamic column family instructions did exactly what I
need to model my data on that blog post.

I created a schema that looks like the following:

CREATE TABLE user_games (
  g_sp_key text,
  user_id int,
  nickname text,
  PRIMARY KEY (g_sp_key, user_id)
) WITH COMPACT STORAGE;

Worked great. My problem is I tested everything in CQLsh. As soon as it
came time to implementing in my application (a Ruby on Rails app using the
cassandra-cql gem found at https://github.com/kreynolds/cassandra-cql), I
realized cassandra-cql does not support CQL3 and I have to stick to CQL2.

My question simply comes down to is it possible to do what I was attempting
to do above in CQL2? How would my schema above change? Do I have to go back
to using a Thrift based client?

Thanks all.

Mime
View raw message