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 <arodr...@gmail.com> wrote: > 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 <jbel...@gmail.com> > >> 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 <joe.greenaw...@gmail.com> >> wrote: >> > 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 (firstname, lastname) values >> > ('joe','shmoe'); >> > cqlsh:simplex> select * from user; >> > >> > firstname | lastname >> > -----------+---------- >> > joe | shmoe >> > >> > cqlsh:simplex> insert into user (firstname, lastname, middlename) values >> > ('joe','shmoe','lester'); >> > Bad Request: Unknown identifier middlename >> > cqlsh:simplex> insert into user (firstname, lastname, middlename) values >> > ('john','shmoe','lester'); >> > Bad Request: Unknown identifier middlename >> > >> > I'm assuming you can do this based on previous based thrift based >> clients >> > like pycassa, and also by reading this: >> > >> > The Cassandra data model is a dynamic schema, column-oriented data >> model. >> > This means that, unlike a relational database, you do not need to model >> all >> > of the columns required by your application up front, as each row is not >> > required to have the same set of columns. Columns and their metadata >> can be >> > added by your application as they are needed without incurring downtime >> to >> > your application. >> > >> > here: http://www.datastax.com/docs/1.2/ddl/index >> > >> > Is it a limitation of CQL3 and its connection vs. thrift? >> > Or more likely i'm just doing something wrong? >> > >> > Thanks, >> > Joe >> >> >> >> -- >> Jonathan Ellis >> Project Chair, Apache Cassandra >> co-founder, http://www.datastax.com >> @spyced >> > >
