Mailing-List: contact dev-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of jbellis@gmail.com designates
 74.125.83.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAL35Oi3i-Cr-BZ9ae0Li1DWp_P919rMBm7y2y0r6isEc-D_8DQ@mail.gmail.com>
References: 
 <CAL35Oi2PCj=3KA-fMh0zvBV4EbzzYT_MuZAq-ozwV1YkKKvD+w@mail.gmail.com>
 <CALdd-zgysmDCOhsc=Rh9hz1O46eaGyO-4OUsHJXSVxRK9y_btA@mail.gmail.com>
 <CAL35Oi1p_ZPJs5DDPRL8myiYxoxZ3UPDqmRijEBhDQrw_y3Gfw@mail.gmail.com>
 <CALdd-zjup0KcA18WJT7MWRke9Vzuv-V=5xzJCdauVGeFFVxPoQ@mail.gmail.com>
 <CAL35Oi3i-Cr-BZ9ae0Li1DWp_P919rMBm7y2y0r6isEc-D_8DQ@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Thu, 29 Dec 2011 15:44:47 -0600
Message-ID: 
 <CALdd-zhvk6k+n25TJ-B0LgH6XkM4NE_nbxU---9PP_SxHCx=gg@mail.gmail.com>
Subject: Re: CQL support for compound columns
To: dev@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

That's to allow defining column names that are not text/utf8.  So you
could have column name "92d21d0a-d6cb-437c-9d3f-b67aa733a19f" be an
actual 128-bit uuid binary value internally, not its string
representation.  Put another way, this would affect the CqlMetadata
name_types map.

However, we already have the "column names are always strings"
limitations with existing CQL DDL so it probably makes more sense to
consider it separately from transposition.

On Thu, Dec 29, 2011 at 3:22 PM, Eric Evans <eevans@acunu.com> wrote:
> On Wed, Dec 28, 2011 at 1:05 PM, Jonathan Ellis <jbellis@gmail.com> wrote=
:
>> Gamma proposal update:
>>
>> The more I think about it the less happy I am with omitting support
>> for sparse columns. =A0Remember that dense composites may only be
>> inserted and deleted, not updated, since they are just a tuple of
>> values with "column names" determined by schema and/or convention.
>>
>> I think we can support sparse columns well in a way that improves the
>> conceptual integrity for the dense composites as well:
>>
>> {code}
>> -- "column" and "value" are sparse; a transposed row will be stored as
>> -- two columns of (user_id, posted_at, 'column': string) and (user_id,
>> posted_at, 'value': blob)
>> CREATE TABLE timeline (
>> =A0 user_id int,
>> =A0 posted_at uuid,
>> =A0 column string,
>> =A0 value blob,
>> =A0 PRIMARY KEY(user_id, posted_at)
>> ) TRANSPOSED;
>>
>> -- entire transposed row is stored as a single dense composite column
>> -- (series, ts1, cat, subcat, 1337, 92d21d0a-...: []). =A0Note that the
>> -- composite column's value is unused in this case.
>> CREATE TABLE events (
>> =A0 series text,
>> =A0 ts1 int,
>> =A0 cat text,
>> =A0 subcat text,
>> =A0 "1337" uuid,
>> =A0 "92d21d0a-d6cb-437c-9d3f-b67aa733a19f" bigint,
>> =A0 PRIMARY KEY(series, ts1, cat, subcat, "1337",
>> "92d21d0a-d6cb-437c-9d3f-b67aa733a19f")
>> ) TRANSPOSED WITH COLUMN NAMES ("1337" int,
>> "92d21d0a-d6cb-437c-9d3f-b67aa733a19f" uuid);
>> {code}
>
> Could you explain what this "TRANSPOSED WITH COLUMN NAMES" syntax does
> (or link to a previous description if I missed it)?
>
>> Thus, columns included in the (transposed) primary key will be
>> "dense," and not updateable, which conforms to our existing practice
>> that keys are not updateable. =A0Remaining columns will be updateable
>> since they will each map to a separate physical column.
>
>
>
> --
> Eric Evans
> Acunu |=A0http://www.acunu.com=A0| @acunu


--=20
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com