You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Thamizh <tc...@yahoo.co.in> on 2011/08/17 11:47:45 UTC
Reg row limit & sorting
Hi All,
I have two questions on Cassandra,
1. Is there any limit(s) on total no. of rows in a single column family?
I am using Cassandra-0.8.4 version.
[default@tutorials] list User;
Using default limit of 100
It looks, here the default limit is 100. How shall I increase this limit ?
2. I wanted to store row key as IP's of 124.149.40.0/24 format? Does it require custom sorting Or is there any other way to make it sorted order?
Regards,
Thamizhannal
Re: Reg row key sorting
Posted by aaron morton <aa...@thelastpickle.com>.
Rows are sorted according to the order of the partitioner, see http://wiki.apache.org/cassandra/FAQ#range_rp
Cheers
-----------------
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com
On 18/08/2011, at 8:53 AM, Thamizh wrote:
> Hi All,
>
> Thanks a lot.
>
> How to sort row key in CF using CLI / API ? Does it boost the search performance ?
>
> As of now, I am inserting row key( as ByteBuffer ) from Hadoop Map/Reduce. It looks, by default Cassandra does not sort the Row keys.
>
> Below is the cli command, I have used to create CF.
> create column family User with comparator = UTF8Type and subcomparator = UTF8Type and column_type = 'Super' and key_validation_class = UTF8Type;
>
>
> Regards,
> Thamizhannal P
>
> --- On Wed, 17/8/11, Konstantin Naryshkin <ko...@a-bb.net> wrote:
>
> From: Konstantin Naryshkin <ko...@a-bb.net>
> Subject: Re: Reg row limit & sorting
> To: user@cassandra.apache.org
> Date: Wednesday, 17 August, 2011, 6:56 PM
>
> 1. The 100 row limit is for listing (i.e. how many rows that the list command will print). You can give list another limit:
> list User limit 1000;
> This limit has nothing to do with any internal Cassandra limitation. I am not aware of any limitation on the number of rows that you can have.
>
> 2. I believe that you should be fine if you zero pad them (so for example your IP would be 124.149.040.000, 0.0.0.0 would be 000.000.000.000, etc) or if you just store them as byte arrays (so 7C 95 28 00 and 00 00 00 00).
>
> ----- Original Message -----
> From: "Thamizh" <tc...@yahoo.co.in>
> To: user@cassandra.apache.org
> Sent: Wednesday, August 17, 2011 5:47:45 AM
> Subject: Reg row limit & sorting
>
> Hi All,
>
> I have two questions on Cassandra,
>
> 1. Is there any limit(s) on total no. of rows in a single column family?
>
> I am using Cassandra-0.8.4 version.
> [default@tutorials] list User;
> Using default limit of 100
>
> It looks, here the default limit is 100. How shall I increase this limit ?
>
> 2. I wanted to store row key as IP's of 124.149.40.0/24 format? Does it require custom sorting Or is there any other way to make it sorted order?
>
> Regards,
> Thamizhannal
Re: Reg row key sorting
Posted by Thamizh <tc...@yahoo.co.in>.
Hi All,
Thanks a lot.
How to sort row key in CF using CLI / API ? Does it boost the search performance ?
As of now, I am inserting row key( as ByteBuffer ) from Hadoop Map/Reduce. It looks, by default Cassandra does not sort the Row keys.
Below is the cli command, I have used to create CF.
create column family User with comparator = UTF8Type and subcomparator = UTF8Type and column_type = 'Super' and key_validation_class = UTF8Type;
Regards,
Thamizhannal P
--- On Wed, 17/8/11, Konstantin Naryshkin <ko...@a-bb.net> wrote:
From: Konstantin Naryshkin <ko...@a-bb.net>
Subject: Re: Reg row limit & sorting
To: user@cassandra.apache.org
Date: Wednesday, 17 August, 2011, 6:56 PM
1. The 100 row limit is for listing (i.e. how many rows that the list command will print). You can give list another limit:
list User limit 1000;
This limit has nothing to do with any internal Cassandra limitation. I am not aware of any limitation on the number of rows that you can have.
2. I believe that you should be fine if you zero pad them (so for example your IP would be 124.149.040.000, 0.0.0.0 would be 000.000.000.000, etc) or if you just store them as byte arrays (so 7C 95 28 00 and 00 00 00 00).
----- Original Message -----
From: "Thamizh" <tc...@yahoo.co.in>
To: user@cassandra.apache.org
Sent: Wednesday, August 17, 2011 5:47:45 AM
Subject: Reg row limit & sorting
Hi All,
I have two questions on Cassandra,
1. Is there any limit(s) on total no. of rows in a single column family?
I am using Cassandra-0.8.4 version.
[default@tutorials] list User;
Using default limit of 100
It looks, here the default limit is 100. How shall I increase this limit ?
2. I wanted to store row key as IP's of 124.149.40.0/24 format? Does it require custom sorting Or is there any other way to make it sorted order?
Regards,
Thamizhannal
Re: Reg row limit & sorting
Posted by Konstantin Naryshkin <ko...@a-bb.net>.
1. The 100 row limit is for listing (i.e. how many rows that the list command will print). You can give list another limit:
list User limit 1000;
This limit has nothing to do with any internal Cassandra limitation. I am not aware of any limitation on the number of rows that you can have.
2. I believe that you should be fine if you zero pad them (so for example your IP would be 124.149.040.000, 0.0.0.0 would be 000.000.000.000, etc) or if you just store them as byte arrays (so 7C 95 28 00 and 00 00 00 00).
----- Original Message -----
From: "Thamizh" <tc...@yahoo.co.in>
To: user@cassandra.apache.org
Sent: Wednesday, August 17, 2011 5:47:45 AM
Subject: Reg row limit & sorting
Hi All,
I have two questions on Cassandra,
1. Is there any limit(s) on total no. of rows in a single column family?
I am using Cassandra-0.8.4 version.
[default@tutorials] list User;
Using default limit of 100
It looks, here the default limit is 100. How shall I increase this limit ?
2. I wanted to store row key as IP's of 124.149.40.0/24 format? Does it require custom sorting Or is there any other way to make it sorted order?
Regards,
Thamizhannal