Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of jens.rantil@tink.se
 designates 209.85.216.180 as permitted sender)
Date: Thu, 01 Jan 2015 11:46:49 -0800 (PST)
MIME-Version: 1.0
Message-Id: <1420141608654.ed870327@Nodemailer>
In-Reply-To: 
 <CABNXB2BGiDtV7Y-WjUg+vE922ADyXda3uyGh_LY7sCYBiHfFbQ@mail.gmail.com>
References: 
 <CABNXB2BGiDtV7Y-WjUg+vE922ADyXda3uyGh_LY7sCYBiHfFbQ@mail.gmail.com>
From: "Jens Rantil" <jens.rantil@tink.se>
To: user@cassandra.apache.org
Cc: user@cassandra.apache.org
Subject: Re: is primary key( foo, bar) the same as primary key ( foo ) with
 a =?UTF-8?Q?=E2=80=98set'?= of bars?
Content-Type: multipart/alternative;
 boundary="----Nodemailer-0.5.0-?=_1-1420141608991"

------Nodemailer-0.5.0-?=_1-1420141608991
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

...they have a somewhat different conflict/repair resolutions, too.

On Thu, Jan 1, 2015 at 8:06 PM, DuyHai Doan <doanduyhai@gmail.com> wrote:

> Storage-engine wise, they are almost equivalent, thought there are some
> minor differences:
> 1) with Set structure, you cannot store more that 64kb worth of data
> 2) collections and maps are loaded entirely by Cassandra for each query,
> whereas with clustering columns you can select a slice of columns
> On Thu, Jan 1, 2015 at 7:46 PM, Kevin Burton <burton@spinn3r.com> wrote:
>> I think the two tables are the same.  Correct=3F
>>
>> create table foo (
>>
>>     source text,
>>     target text,
>>     primary key( source, target )
>> )
>>
>>
>> vs
>>
>> create table foo (
>>
>>     source text,
>>     target set<text>,
>>     primary key( source )
>> )
>>
>> =E2=80=A6 meaning that the first one, under the covers is represented =
the same as
>> the second.  As a slice.
>>
>> Am I correct=3F
>>
>> --
>>
>> Founder/CEO Spinn3r.com
>> Location: *San Francisco, CA*
>> blog: http://burtonator.wordpress.com
>> =E2=80=A6 or check out my Google+ profile
>> <https://plus.google.com/102718274791889610666/posts>
>> <http://spinn3r.com>
>>
>>
------Nodemailer-0.5.0-?=_1-1420141608991
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable


<div>...they have a somewhat different conflict/repair resolutions, too.=
</div>
<div class=3D=22mailbox=5Fsignature=22><br></div>
<br><br><div class=3D=22gmail=5Fquote=22><p>On Thu, Jan 1, 2015 at 8:06 PM,=
 DuyHai Doan <span dir=3D=22ltr=22>&lt;<a href=3D=22mailto:doanduyhai@gmail=
.com=22 target=3D=22=5Fblank=22>doanduyhai@gmail.com</a>&gt;</span> =
wrote:<br></p><blockquote class=3D=22gmail=5Fquote=22 style=3D=22margin:0 0=
 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;=22>
<div dir=3D=22ltr=22>Storage-engine wise, they are almost equivalent, =
thought there are some minor differences:<div><br></div>
<div>1) with Set structure, you cannot store more that 64kb worth of =
data</div>
<div>2) collections and maps are loaded entirely by Cassandra for each =
query, whereas with clustering columns you can select a slice of =
columns</div>
<div><br></div>
<div><br></div>
</div>
<div class=3D=22gmail=5Fextra=22>
<br><div class=3D=22gmail=5Fquote=22>On Thu, Jan 1, 2015 at 7:46 PM, Kevin =
Burton <span dir=3D=22ltr=22>&lt;<a href=3D=22mailto:burton@spinn3r.=
com=22>burton@spinn3r.com</a>&gt;</span> wrote:<br><blockquote =
class=3D=22gmail=5Fquote=22 style=3D=22margin:0 0 0 .8ex;border-left:1px =
#ccc solid;padding-left:1ex=22>
<div dir=3D=22ltr=22>I think the two tables are the same.=C2=A0 =
Correct=3F<div><br></div>
<div>
<div>create table foo (</div>
<div><br></div>
<div>=C2=A0 =C2=A0 source text,</div>
<div>=C2=A0 =C2=A0 target text,</div>
<div>=C2=A0 =C2=A0 primary key( source, target )</div>
<div>)</div>
</div>
<div><br></div>
<div><br></div>
<div>vs=C2=A0</div>
<div><br></div>
<div><div>
<div>create table foo (</div>
<div><br></div>
<div>=C2=A0 =C2=A0 source text,</div>
<div>=C2=A0 =C2=A0 target set&lt;text&gt;,</div>
<div>=C2=A0 =C2=A0 primary key( source )</div>
<div>)</div>
</div></div>
<div><br></div>
<div>=E2=80=A6 meaning that the first one, under the covers is represented =
the same as the second.=C2=A0 As a slice.</div>
<div><br></div>
<div>Am I correct=3F</div>
<span class=3D=22HOEnZb=22><font color=3D=22#888888=22><div><br></div>
<div>-- <br><div><div dir=3D=22ltr=22><div><div>
<p style=3D=22margin:0px 0px 12pt=22></p>
<div>Founder/CEO=C2=A0<a href=3D=22http://Spinn3r.com=22>Spinn3r.=
com</a><br></div>
<div>Location:=C2=A0<b>San Francisco, CA</b><br></div>
<div>
<font color=3D=22#2c2c2c=22 face=3D=22Helvetica, Arial, sans-serif=22><span=
 style=3D=22line-height:19px=22>blog:<b>=C2=A0</b></span></font><a =
href=3D=22http://burtonator.wordpress.com=22>http://burtonator.wordpress.=
com</a>
</div>
<div>=E2=80=A6 or check out my <a href=3D=22https://plus.google.=
com/102718274791889610666/posts=22>Google+ profile</a>
</div>
<div><a href=3D=22http://spinn3r.com=22><img src=3D=22http://spinn3r.=
com/images/spinn3r.jpg=22></a></div>
<p></p>
</div></div></div></div>
</div></font></span>
</div>
</blockquote>
</div>
<br></div>
</blockquote></div><br>
------Nodemailer-0.5.0-?=_1-1420141608991--