Re: Dynamic CF

2012-07-31 Thread Greg Fausak
I thought I'd give this a try: create columnfamily at_event__ac_c ( ac_c text, ac_creation bigint, ac_name text, ac_value text, PRIMARY KEY (ac_c, ac_creation) ) with compression_parameters:sstable_compression = ''; Then, insert a few columns: begin batch using consistenc

RE: Dynamic CF

2012-07-10 Thread Leonid Ilyevsky
I see now there is a package org.apache.cassandra.cql3.statements, with BatchStatement class. Is this what I should use? -Original Message- From: Leonid Ilyevsky [mailto:lilyev...@mooncapital.com] Sent: Tuesday, July 10, 2012 11:45 AM To: user@cassandra.apache.org Subject: RE: Dynamic CF

RE: Dynamic CF

2012-07-10 Thread Leonid Ilyevsky
-Original Message----- From: Sylvain Lebresne [mailto:sylv...@datastax.com] Sent: Tuesday, July 10, 2012 10:37 AM To: user@cassandra.apache.org Subject: Re: Dynamic CF On Tue, Jul 10, 2012 at 4:17 PM, Leonid Ilyevsky wrote: > So I guess, in the batch_mutate call, in the map t

Re: Dynamic CF

2012-07-10 Thread Carlos Carrasco
I am confused then. I remember reviewing the source for CQL3 and finding that the row reader used the column count in the CF definition in order to find how many columns it needed to read a single row. I guess I missed a filter over the composited part or that I reviewed an old version. On 10 July

Re: Dynamic CF

2012-07-10 Thread Sylvain Lebresne
n't work at all, but also because the whole point of CQL3 is to hide that kind of complexity. -- Sylvain > > -Original Message- > From: Sylvain Lebresne [mailto:sylv...@datastax.com] > Sent: Tuesday, July 10, 2012 8:24 AM > To: user@cassandra.apache.org > Subject: Re:

Re: Dynamic CF

2012-07-10 Thread Sylvain Lebresne
On Tue, Jul 10, 2012 at 4:19 PM, Carlos Carrasco < carlos.carra...@groupalia.com> wrote: > I think he means something like having a fixed set of coiumns in the table > definition, then in the actual rows having other columns not specified in > the defintion, indepentent of the composited part of t

Re: Dynamic CF

2012-07-10 Thread Carlos Carrasco
I think he means something like having a fixed set of coiumns in the table definition, then in the actual rows having other columns not specified in the defintion, indepentent of the composited part of the PK. When I reviewed CQL3 for using in Gossie[1] I realized I couldn't have this, and that it

RE: Dynamic CF

2012-07-10 Thread Leonid Ilyevsky
waiting for your confirmation, I am going to try it. -Original Message- From: Sylvain Lebresne [mailto:sylv...@datastax.com] Sent: Tuesday, July 10, 2012 8:24 AM To: user@cassandra.apache.org Subject: Re: Dynamic CF On Fri, Jul 6, 2012 at 10:49 PM, Leonid Ilyevsky wrote: > At this poin

Re: Dynamic CF

2012-07-10 Thread Sylvain Lebresne
On Fri, Jul 6, 2012 at 10:49 PM, Leonid Ilyevsky wrote: > At this point I am really confused about what direction Cassandra is going. > CQL 3 has the benefit of composite keys, but no dynamic columns. > I thought, the whole point of Cassandra was to provide dynamic tables. CQL3 absolutely provid

RE: Dynamic CF

2012-07-06 Thread Derek Williams
de rows so the reads and writes would be more >> efficient. >> >> ** ** >> >> *From:* Derek Williams [mailto:de...@fyrie.net] >> *Sent:* Friday, July 06, 2012 4:58 PM >> *To:* user@cassandra.apache.org >> *Subject:* Re: Dynamic CF >> >> ** ** >> &

RE: Dynamic CF

2012-07-06 Thread Derek Williams
able with > even more rows; I wanted wide rows so the reads and writes would be more > efficient. > > ** ** > > *From:* Derek Williams [mailto:de...@fyrie.net] > *Sent:* Friday, July 06, 2012 4:58 PM > *To:* user@cassandra.apache.org > *Subject:* Re: Dynamic CF &

RE: Dynamic CF

2012-07-06 Thread Leonid Ilyevsky
:58 PM To: user@cassandra.apache.org Subject: Re: Dynamic CF On Fri, Jul 6, 2012 at 2:49 PM, Leonid Ilyevsky mailto:lilyev...@mooncapital.com>> wrote: At this point I am really confused about what direction Cassandra is going. CQL 3 has the benefit of composite keys, but no dynamic colu

Re: Dynamic CF

2012-07-06 Thread Derek Williams
On Fri, Jul 6, 2012 at 2:49 PM, Leonid Ilyevsky wrote: > At this point I am really confused about what direction Cassandra is > going. CQL 3 has the benefit of composite keys, but no dynamic columns. > I thought, the whole point of Cassandra was to provide dynamic tables. > See my earlier post on

Re: Dynamic CF

2012-07-06 Thread Jeremy Hanna
inal Message- > From: Jeremy Hanna [mailto:jeremy.hanna1...@gmail.com] > Sent: Friday, July 06, 2012 4:06 PM > To: user@cassandra.apache.org > Subject: Re: Dynamic CF > > you can use the cqlsh help but it will eventually refer you to a cql > reference such as this one t

RE: Dynamic CF

2012-07-06 Thread Leonid Ilyevsky
om] Sent: Friday, July 06, 2012 4:16 PM To: user@cassandra.apache.org Subject: RE: Dynamic CF Thanks Jeremy, but this doesn't work for me. I am using cql3, because I need new features like composite keys. The manual you pointed to is for 2.0. I have suspicion that cql3 does not support dynamic ta

RE: Dynamic CF

2012-07-06 Thread Leonid Ilyevsky
Hanna [mailto:jeremy.hanna1...@gmail.com] Sent: Friday, July 06, 2012 4:06 PM To: user@cassandra.apache.org Subject: Re: Dynamic CF you can use the cqlsh help but it will eventually refer you to a cql reference such as this one that says what the options are. Looks like you need just 'default_

Re: Dynamic CF

2012-07-06 Thread Jeremy Hanna
you can use the cqlsh help but it will eventually refer you to a cql reference such as this one that says what the options are. Looks like you need just 'default_validation'. http://www.datastax.com/docs/1.0/references/cql/index#cql-column-family-storage-parameters On Jul 6, 2012, at 2:13 PM,