incubator-cassandra-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Shaw <wfs...@gmail.com>
Subject Re: CQL support for compound columns
Date Fri, 30 Dec 2011 17:12:47 GMT
+1 on Gamma
+1 on haveing capability to specify a value.

My only reservation is the choice of the keword "TABLE",  which is going to
be a source of continued confusion.

On Fri, Dec 30, 2011 at 11:58 AM, Jonathan Ellis <jbellis@gmail.com> wrote:

> I think we're closing in on something workable.
>
> Dropping TRANSPOSED from Gamma as redundant with respect to the
> composite PRIMARY KEY definition.
>
> Should we support column values in non-sparse rows by adding a
> VALUE(column_name) section?
>
> CREATE TABLE timeline (
>    user_id int,
>    posted_at uuid,
>    body string,
>    posted_by string,
>    PRIMARY KEY(user_id, posted_at, posted_by),
>    VALUE(body)
> );
>
> (Open to better suggestions for that keyword.)
>
>
> On Thu, Dec 29, 2011 at 3:13 PM, Eric Evans <eevans@acunu.com> wrote:
> > On Thu, Dec 29, 2011 at 12:04 PM, Jonathan Ellis <jbellis@gmail.com>
> wrote:
> >> I've updated the wiki page at
> >> http://wiki.apache.org/cassandra/Cassandra2474 with a more in-depth
> >> Background section that hopefully clears up where I'm going with this
> >> sparse/dense business.
> >>
> >> Eric mentioned on IRC that he's uneasy about the PRIMARY KEY syntax
> >> implicitly using the first element of PRIMARY KEY as the row key.  We
> >> could make it explicit with another WITH option to the TRANSPOSED
> >> clause:
> >>
> >> {{{
> >> CREATE TABLE timeline (
> >>    user_id int,
> >>    posted_at uuid,
> >>    column string,
> >>    value blob,
> >>    PRIMARY KEY(user_id, posted_at)
> >> ) TRANSPOSED WITH ROW KEY(user_id)
> >> }}}
> >>
> >> This makes things more verbose (this would be a required clause) but
> >> I'm okay with that if consensus is that being explicit here is better.
> >
> > I think that was a reaction to an earlier iteration.  Assuming that
> > the only place where order matters is in that primary key definition,
> > then I think it makes sense without the "... WITH ROW KEY..." bit.
> >
> >
> >
> > --
> > Eric Evans
> > Acunu | http://www.acunu.com | @acunu
>
>
>
>  --
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder of DataStax, the source for professional Cassandra support
> http://www.datastax.com
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message