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 <konstant...@a-bb.net> wrote: From: Konstantin Naryshkin <konstant...@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" <tceg...@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
