Re: Supercolumn behavior on writes

2012-06-17 Thread aaron morton
Writing to a super column family does not involve deserialisation, other than writing to the commit log it is an in memory operation. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/06/2012, at 3:36 AM, Greg Fausak wrote: > Derek, > >

Re: Supercolumn behavior on writes

2012-06-14 Thread Greg Fausak
Derek, Thanks for that! Yes, I am aware of that technique. I am currently using something very similar on an sql database. I think one of the great benefits with Cassandra is that you can invent these on the fly. I also think there is great benefit to keep all of the columns in the same row.

Re: Supercolumn behavior on writes

2012-06-13 Thread Derek Williams
On Wed, Jun 13, 2012 at 9:08 PM, Greg Fausak wrote: > Interesting. > > How do you do it? > > I have a version 2 CF, that works fine. > A version 3 table won't let me invent columns that > don't exist yet. (for composite tables). What's the trick? > You are able to get the same behaviour as non

Re: Supercolumn behavior on writes

2012-06-13 Thread samal
I have just check on datastax blog, "CQL3 does not support, I am not aware." But as a whole we can via client lib using cql. On Thu, Jun 14, 2012 at 9:12 AM, Dave Brosius wrote: > Via thrift, or a high level client on thrift, see as an example > > http://www.datastax.com/dev/blog/introduction-

Re: Supercolumn behavior on writes

2012-06-13 Thread Dave Brosius
Via thrift, or a high level client on thrift, see as an example http://www.datastax.com/dev/blog/introduction-to-composite-columns-part-1 On 06/13/2012 11:08 PM, Greg Fausak wrote: Interesting. How do you do it? I have a version 2 CF, that works fine. A version 3 table won't let me invent col

Re: Supercolumn behavior on writes

2012-06-13 Thread Greg Fausak
Interesting. How do you do it? I have a version 2 CF, that works fine. A version 3 table won't let me invent columns that don't exist yet. (for composite tables). What's the trick? cqlsh -3 cas1 use onplus; cqlsh:onplus> select * from at_event where ac_event_id = 7690254; ac_event_id | ac_crea

Re: Supercolumn behavior on writes

2012-06-13 Thread samal
You can't 'invent' columns on the fly, everything has > to be declared when you declare the column family. >> >> That' s incorrect. You can define name on fly. Validation must be define when declaring CF

Re: Supercolumn behavior on writes

2012-06-13 Thread Dave Brosius
You can create composite columns on the fly. On 06/13/2012 09:58 PM, Greg Fausak wrote: That's a good question. I just went to a class, Ben was saying that any action on a super column requires de-re-serialization. But, it would be nice if a write had this sort of efficiency. I have been pl

Re: Supercolumn behavior on writes

2012-06-13 Thread Greg Fausak
That's a good question. I just went to a class, Ben was saying that any action on a super column requires de-re-serialization. But, it would be nice if a write had this sort of efficiency. I have been playing with the 1.1.1 version, in that one there are 'composite' columns, which I think are li

Supercolumn behavior on writes

2012-06-13 Thread Oleg Dulin
Does a write to a sub column involve deserialization of the entire super column ? Thanks, Oleg