cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thamizh <>
Subject Re: Reg row key sorting
Date Wed, 17 Aug 2011 20:53:25 GMT
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;


  Thamizhannal P

--- On Wed, 17/8/11, Konstantin  Naryshkin <> wrote:

From: Konstantin  Naryshkin <>
Subject: Re: Reg row limit & sorting
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, would be, etc) or if you just store them as byte
arrays (so 7C 95 28 00 and 00 00 00 00).

----- Original Message -----
From: "Thamizh" <>
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 format? Does it require custom sorting
Or is there any other way to make it sorted order? 


View raw message