You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cassandra.apache.org by Michael Cherkasov <mi...@gmail.com> on 2012/04/09 18:39:46 UTC

composite columns vs super columns

Hi all,

Can someone describe difference between super and composite columns?

And describe when each type is preferred to use?

Thanks.

Re: composite columns vs super columns

Posted by aaron morton <aa...@thelastpickle.com>.

Super Columns: top level column to have a list of sub column.
e.g. 
row key: foo
column: bar
sub columns: 
	baz = qux 

Composite columns: data types are defined by combining multiple types, instances of the type are compared by comparing each component in turn.
e.g.
row key: foo
column: <bar:baz> = qux

in general prefer composite columns over super columns. 

Cheers

-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com

On 10/04/2012, at 4:39 AM, Michael Cherkasov wrote:

> Hi all,
> 
> Can someone describe difference between super and composite columns?
> 
> And describe when each type is preferred to use?
> 
> Thanks.