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

Re: Dynamic CF

2012-07-10 Thread Sylvain Lebresne
On Fri, Jul 6, 2012 at 10:49 PM, Leonid Ilyevsky 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 columns. I thought, the whole point of Cassandra was to provide dynamic tables.

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 lilyev...@mooncapital.com

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

Re: Dynamic CF

2012-07-10 Thread Sylvain Lebresne
it won'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: Dynamic CF On Fri

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

RE: Dynamic CF

2012-07-10 Thread Leonid Ilyevsky
- 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 lilyev...@mooncapital.com wrote: So I guess, in the batch_mutate call, in the map that I pass

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

RE: Dynamic CF

2012-07-06 Thread Leonid Ilyevsky
[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_validation

RE: Dynamic CF

2012-07-06 Thread Leonid Ilyevsky
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 tables at all

Re: Dynamic CF

2012-07-06 Thread 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 that says what the options are. Looks like you need just 'default_validation

Re: Dynamic CF

2012-07-06 Thread Derek Williams
On Fri, Jul 6, 2012 at 2:49 PM, Leonid Ilyevsky lilyev...@mooncapital.comwrote: 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.

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 lilyev...@mooncapital.commailto: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

RE: Dynamic CF

2012-07-06 Thread Derek Williams
a table 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 ** ** On Fri, Jul 6, 2012 at 2

RE: Dynamic CF

2012-07-06 Thread Derek Williams
. ** ** *From:* Derek Williams [mailto:de...@fyrie.net] *Sent:* Friday, July 06, 2012 4:58 PM *To:* user@cassandra.apache.org *Subject:* Re: Dynamic CF ** ** On Fri, Jul 6, 2012 at 2:49 PM, Leonid Ilyevsky lilyev...@mooncapital.com wrote: At this point I am really confused