Re: Dynamic column family using CQL2, possible?

[Oleksandr Petrov <ol...@gmail.com>]

WITH COMPACT STORAGE should allow accessing your dataset from CQL2,
actually.
There're newer driver that supports binary CQL, namely
https://github.com/iconara/cql-rb which is written by guys from Bart, who
know stuff about cassandra :)

We're using COMPACT STORAGE for tables we access through Thrift/Hadoop, and
it works perfectly well.
You can refer to Data Modelling guide if you want to learn more about how
to model your data to make it fit into Cassandra well:
http://clojurecassandra.info/articles/data_modelling.html


On Wed, May 29, 2013 at 12:44 AM, Matthew Hillsborough <
matthew.hillsborough@gmail.com> wrote:

> 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.
>



-- 
alex p