You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cassandra.apache.org by J Ramesh Kumar <ra...@gmail.com> on 2013/09/06 07:20:56 UTC
Help on Cassandra Limitaions
Hi,
http://wiki.apache.org/cassandra/CassandraLimitations
In the above link, I found the below limitation,
"The maximum number of cells (rows x columns) in a single partition is 2
billion.".
Here what does "partition" mean ? Is it node (or) column family (or)
anything else ?
Thanks,
Ramesh
Re: Help on Cassandra Limitaions
Posted by Shahab Yunus <sh...@gmail.com>.
Also, Sylvain, you have couple of great posts about relationships between
CQL3/Thrift entities and naming issues:
http://www.datastax.com/dev/blog/cql3-for-cassandra-experts
http://www.datastax.com/dev/blog/thrift-to-cql3
I always refer to them when I get confuse :)
Regards,
Shahab
On Fri, Sep 6, 2013 at 3:04 AM, Hannu Kröger <hk...@gmail.com> wrote:
> Hi,
>
> Well, that was a word to word quotation. :)
>
> Anyways, I think what you just said is a better explanation than those two
> previous ones. I hope it ends up on the wiki page because what it says
> there now is causing confusion, no matter how correct it technically is :)
>
> Cheers,
> Hannu
>
>
> 2013/9/6 Sylvain Lebresne <sy...@datastax.com>
>
>> Well, I don't know if that's what Patrick replied but that's not correct.
>> The wording *is* correct, though it does uses CQL3 terms.
>> For CQL3, the term "partition" is used to describe all the (CQL) rows
>> that share the same partition key (If you don't know what the latter is:
>> http://cassandra.apache.org/doc/cql3/CQL.html).
>> So it says that all the rows sharing a particular partition key
>> multiplied by their number of effective columns is capped at 2 billions.
>>
>> In the thrift terminology, this means a 'thrift row' (not to be confused
>> with a CQL3 row) cannot have more that 2 billions thrift columns'.
>>
>> --
>> Sylvain
>>
>>
>> On Fri, Sep 6, 2013 at 7:55 AM, Hannu Kröger <hk...@gmail.com> wrote:
>>
>>> I asked the same thing earlier and this is what patrick mcfadin replied:
>>> "It's not worded well. Essentially it's saying there is a 2B limit on a
>>> row. It should be worded a 'CQL row'"
>>>
>>> I hope helps.
>>>
>>> Cheers,
>>> Hannu
>>>
>>> On 6.9.2013, at 8.20, J Ramesh Kumar <ra...@gmail.com> wrote:
>>>
>>> Hi,
>>>
>>> http://wiki.apache.org/cassandra/CassandraLimitations
>>>
>>> In the above link, I found the below limitation,
>>>
>>> "The maximum number of cells (rows x columns) in a single partition is 2
>>> billion.".
>>>
>>> Here what does "partition" mean ? Is it node (or) column family (or)
>>> anything else ?
>>>
>>> Thanks,
>>> Ramesh
>>>
>>>
>>
>
Re: Help on Cassandra Limitaions
Posted by Hannu Kröger <hk...@gmail.com>.
Hi,
Well, that was a word to word quotation. :)
Anyways, I think what you just said is a better explanation than those two
previous ones. I hope it ends up on the wiki page because what it says
there now is causing confusion, no matter how correct it technically is :)
Cheers,
Hannu
2013/9/6 Sylvain Lebresne <sy...@datastax.com>
> Well, I don't know if that's what Patrick replied but that's not correct.
> The wording *is* correct, though it does uses CQL3 terms.
> For CQL3, the term "partition" is used to describe all the (CQL) rows that
> share the same partition key (If you don't know what the latter is:
> http://cassandra.apache.org/doc/cql3/CQL.html).
> So it says that all the rows sharing a particular partition key multiplied
> by their number of effective columns is capped at 2 billions.
>
> In the thrift terminology, this means a 'thrift row' (not to be confused
> with a CQL3 row) cannot have more that 2 billions thrift columns'.
>
> --
> Sylvain
>
>
> On Fri, Sep 6, 2013 at 7:55 AM, Hannu Kröger <hk...@gmail.com> wrote:
>
>> I asked the same thing earlier and this is what patrick mcfadin replied:
>> "It's not worded well. Essentially it's saying there is a 2B limit on a
>> row. It should be worded a 'CQL row'"
>>
>> I hope helps.
>>
>> Cheers,
>> Hannu
>>
>> On 6.9.2013, at 8.20, J Ramesh Kumar <ra...@gmail.com> wrote:
>>
>> Hi,
>>
>> http://wiki.apache.org/cassandra/CassandraLimitations
>>
>> In the above link, I found the below limitation,
>>
>> "The maximum number of cells (rows x columns) in a single partition is 2
>> billion.".
>>
>> Here what does "partition" mean ? Is it node (or) column family (or)
>> anything else ?
>>
>> Thanks,
>> Ramesh
>>
>>
>
Re: Help on Cassandra Limitaions
Posted by Sylvain Lebresne <sy...@datastax.com>.
Well, I don't know if that's what Patrick replied but that's not correct.
The wording *is* correct, though it does uses CQL3 terms.
For CQL3, the term "partition" is used to describe all the (CQL) rows that
share the same partition key (If you don't know what the latter is:
http://cassandra.apache.org/doc/cql3/CQL.html).
So it says that all the rows sharing a particular partition key multiplied
by their number of effective columns is capped at 2 billions.
In the thrift terminology, this means a 'thrift row' (not to be confused
with a CQL3 row) cannot have more that 2 billions thrift columns'.
--
Sylvain
On Fri, Sep 6, 2013 at 7:55 AM, Hannu Kröger <hk...@gmail.com> wrote:
> I asked the same thing earlier and this is what patrick mcfadin replied:
> "It's not worded well. Essentially it's saying there is a 2B limit on a
> row. It should be worded a 'CQL row'"
>
> I hope helps.
>
> Cheers,
> Hannu
>
> On 6.9.2013, at 8.20, J Ramesh Kumar <ra...@gmail.com> wrote:
>
> Hi,
>
> http://wiki.apache.org/cassandra/CassandraLimitations
>
> In the above link, I found the below limitation,
>
> "The maximum number of cells (rows x columns) in a single partition is 2
> billion.".
>
> Here what does "partition" mean ? Is it node (or) column family (or)
> anything else ?
>
> Thanks,
> Ramesh
>
>
Re: Help on Cassandra Limitaions
Posted by Sylvain Lebresne <sy...@datastax.com>.
Well, I don't know if that's what Patrick replied but that's not correct.
The wording *is* correct, though it does uses CQL3 terms.
For CQL3, the term "partition" is used to describe all the (CQL) rows that
share the same partition key (If you don't know what the latter is:
http://cassandra.apache.org/doc/cql3/CQL.html).
So it says that all the rows sharing a particular partition key multiplied
by their number of effective columns is capped at 2 billions.
In the thrift terminology, this means a 'thrift row' (not to be confused
with a CQL3 row) cannot have more that 2 billions thrift columns'.
--
Sylvain
On Fri, Sep 6, 2013 at 7:55 AM, Hannu Kröger <hk...@gmail.com> wrote:
> I asked the same thing earlier and this is what patrick mcfadin replied:
> "It's not worded well. Essentially it's saying there is a 2B limit on a
> row. It should be worded a 'CQL row'"
>
> I hope helps.
>
> Cheers,
> Hannu
>
> On 6.9.2013, at 8.20, J Ramesh Kumar <ra...@gmail.com> wrote:
>
> Hi,
>
> http://wiki.apache.org/cassandra/CassandraLimitations
>
> In the above link, I found the below limitation,
>
> "The maximum number of cells (rows x columns) in a single partition is 2
> billion.".
>
> Here what does "partition" mean ? Is it node (or) column family (or)
> anything else ?
>
> Thanks,
> Ramesh
>
>
Re: Help on Cassandra Limitaions
Posted by Hannu Kröger <hk...@gmail.com>.
I asked the same thing earlier and this is what patrick mcfadin replied: "It's not worded well. Essentially it's saying there is a 2B limit on a row. It should be worded a 'CQL row'"
I hope helps.
Cheers,
Hannu
On 6.9.2013, at 8.20, J Ramesh Kumar <ra...@gmail.com> wrote:
> Hi,
>
> http://wiki.apache.org/cassandra/CassandraLimitations
>
> In the above link, I found the below limitation,
>
> "The maximum number of cells (rows x columns) in a single partition is 2 billion.".
>
> Here what does "partition" mean ? Is it node (or) column family (or) anything else ?
>
> Thanks,
> Ramesh