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 <bur...@spinn3r.com> wrote: > I think the two tables are the same. Correct? > > create table foo ( > > source text, > target text, > primary key( source, target ) > ) > > > vs > > create table foo ( > > source text, > target set<text>, > primary key( source ) > ) > > … meaning that the first one, under the covers is represented the same as > the second. As a slice. > > Am I correct? > > -- > > Founder/CEO Spinn3r.com > Location: *San Francisco, CA* > blog: http://burtonator.wordpress.com > … or check out my Google+ profile > <https://plus.google.com/102718274791889610666/posts> > <http://spinn3r.com> > >
