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
 209.85.215.172 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAL35Oi0Qa60Qa6Fm-Gnu8ZQ2W3fsS6HS6qQJoGsf6wnJSh6uHg@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>
 <CALdd-zhvk6k+n25TJ-B0LgH6XkM4NE_nbxU---9PP_SxHCx=gg@mail.gmail.com>
 <CAL35Oi0Qa60Qa6Fm-Gnu8ZQ2W3fsS6HS6qQJoGsf6wnJSh6uHg@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Thu, 29 Dec 2011 19:40:25 -0600
Message-ID: 
 <CALdd-zjTcmZwDbZCLsu7sq7EuonRHnJkJG6Uxvx3eZ2dAvXxjg@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

https://issues.apache.org/jira/browse/CASSANDRA-3685

On Thu, Dec 29, 2011 at 6:34 PM, Eric Evans <eevans@acunu.com> wrote:
> On Thu, Dec 29, 2011 at 3:44 PM, Jonathan Ellis <jbellis@gmail.com> wrote=
:
>> That's to allow defining column names that are not text/utf8. =A0So you
>> could have column name "92d21d0a-d6cb-437c-9d3f-b67aa733a19f" be an
>> actual 128-bit uuid binary value internally, not its string
>> representation. =A0Put 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.
>
> Right, and to get a jump on that bikeshedding I'd propose that look
> something like:
>
> CREATE TABLE test (
> =A0 int(10) text,
> =A0 uuid(92d21d0a-d6cb-437c-9d3f-b67aa733a19f) bigint
> )
>
> or...
>
> CREATE TABLE test (
> =A0 (int)10 text,
> =A0 (uuid)92d21d0a-d6cb-437c-9d3f-b67aa733a19f bigint
> )
>
> But I digress, that's probably best left for another issue and another ti=
me. :)
>
>
>> 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> wro=
te:
>>>> 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 th=
e
>>>> -- 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)?
>
> --
> 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