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.
