incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Reg row key sorting
Date Wed, 17 Aug 2011 23:32:23 GMT
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 <konstantinn@a-bb.net> wrote:
> 
> From: Konstantin Naryshkin <konstantinn@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" <tcegrid@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 


Mime
View raw message