incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shahab Yunus <shahab.yu...@gmail.com>
Subject Re: Dynamic Columns Question Cassandra 1.2.5, Datastax Java Driver 1.0
Date Thu, 06 Jun 2013 13:33:50 GMT
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 9:02 AM, Joe Greenawalt <joe.greenawalt@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
>

Mime
View raw message