Re: is primary key( foo, bar) the same as primary key ( foo ) with a ‘set' of bars?

2015-01-01 Thread Jens Rantil 
...they have a somewhat different conflict/repair resolutions, too.

On Thu, Jan 1, 2015 at 8:06 PM, DuyHai Doan  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  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,
>> 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
>> 
>> 
>>
>>

Re: is primary key( foo, bar) the same as primary key ( foo ) with a ‘set' of bars?

2015-01-01 Thread Kevin Burton 
AH!!! I had forgotten about both of those issues.  Good points..

On Thu, Jan 1, 2015 at 11:04 AM, DuyHai Doan  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  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,
>> 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
>> 
>> 
>>
>>
>


-- 

Founder/CEO Spinn3r.com
Location: *San Francisco, CA*
blog: http://burtonator.wordpress.com
… or check out my Google+ profile

Re: is primary key( foo, bar) the same as primary key ( foo ) with a ‘set' of bars?

2015-01-01 Thread DuyHai Doan 
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  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,
> 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
> 
> 
>
>

is primary key( foo, bar) the same as primary key ( foo ) with a ‘set' of bars?

2015-01-01 Thread Kevin Burton 
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,
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

Re: Stable cassandra build for production usage

2015-01-01 Thread Neha Trivedi 
Use 2.0.11 for production

On Wed, Dec 31, 2014 at 11:50 PM, Robert Coli  wrote:

> On Wed, Dec 31, 2014 at 8:38 AM, Ajay  wrote:
>
>> For my research and learning I am using Cassandra 2.1.2. But I see couple
>> of mail threads going on issues in 2.1.2. So what is the stable or popular
>> build for production in Cassandra 2.x series.
>>
> https://engineering.eventbrite.com/what-version-of-cassandra-should-i-run/
>
> =Rob
>