Re: Thrift to cql : mixed static and dynamic columns with secondary index

2015-07-17 Thread Clement Honore
Thanks for your answer Tyler. Unfortunately, I can't wait for 3.x to be released. I think I will update my schema to declare explicitely all columns with predictive names and I will migrate only the dynamic ones to a new table. This will reduce drastically the amount of data to migrate and I'll b

Re: Thrift to cql : mixed static and dynamic columns with secondary index

2015-07-16 Thread Tyler Hobbs
This schema is something that we're providing a better CQL conversion for in 3.0. The one column you defined will become a "static" column, meaning there is only one copy of it per partition. The schema will look something like this: CREATE TABLE ref_file ( key text, folder text static,

Thrift to cql : mixed static and dynamic columns with secondary index

2015-07-16 Thread Clement Honore
Hi, I'm trying to migrate from Cassandra 1.1 and Hector to a more up-to-date stack like Cassandra 1.2+ and CQL3. I have read http://www.datastax.com/dev/blog/thrift-to-cql3