Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

2013-06-06 Thread Joe Greenawalt
Hey, this is good info. Seems like i have the same capabilities, i just need to twist my brain a bit to see it better. Thanks for all the feedback, much appreciated. Joe On Thu, Jun 6, 2013 at 11:27 AM, Alain RODRIGUEZ wrote: > Not sure if you remember this Jonathan, but Sylvain already wrot

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

2013-06-06 Thread Alain RODRIGUEZ
Not sure if you remember this Jonathan, but Sylvain already wrote a very clear documentation about it : http://www.datastax.com/dev/blog/thrift-to-cql3 (OCTOBER 26, 2012) Yet a second page will give to this important topic a greater visibility. 2013/6/6 Jonathan Ellis > This is becoming someth

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

2013-06-06 Thread Eric Stevens
Your data model should take into consideration the number of items you're storing in a collection. If you expect it will grow over time with no small upper bound, don't use a collection. You don't need to read before write to answer this question, it's a decision made at modeling time (before you

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

2013-06-06 Thread Jonathan Ellis
This is becoming something of a FAQ, so I wrote an more in-depth answer: http://www.datastax.com/dev/blog/does-cql-support-dynamic-columns-wide-rows On Thu, Jun 6, 2013 at 8:02 AM, Joe Greenawalt wrote: > Hi, > I'm having some problems figuring out how to append a dynamic column on a > column fa

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

2013-06-06 Thread Edward Capriolo
The problem about "being careful about how much you store in a collection" is that Cassandra is a blind-write system. Knowing how much data is currently in the collection before you write is an anti-pattern, read before write. Cassandra Rule 1: DON'T READ BEFORE WRITE Cassandra Rule 2: ROWS CAN HA

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

2013-06-06 Thread Eric Stevens
> > CQL3 does now support dynamic columns. For tags or metadata values you > could use a Collection: > This should probably be clarified. A collection is a super useful tool, but it is *not* the same thing as a dynamic column. It has many advantages, but there is one huge disadvantage in that yo

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

2013-06-06 Thread Francisco Andrades Grassi
Hi, CQL3 does now support dynamic columns. For tags or metadata values you could use a Collection: http://www.datastax.com/dev/blog/cql3_collections For wide rows there's the enhanced primary keys, which I personally prefer over the composite columns of yore: http://www.datastax.com/dev/blog/

Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

2013-06-06 Thread Shahab Yunus
Dynamic columns are not supported in CQL3. We just had a discussion a day or two ago about this where Eric Stevens explained it. Please see this: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/CQL-3-returning-duplicate-keys-td7588181.html Regards, Shahab On Thu, Jun 6, 2013 at

Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0

2013-06-06 Thread Joe Greenawalt
Hi, I'm having some problems figuring out how to append a dynamic column on a column family using the datastax java driver 1.0 and CQL3 on Cassandra 1.2.5. Below is what i'm trying: *cqlsh:simplex> create table user (firstname text primary key, lastname text); cqlsh:simplex> insert into user (fir