Re: CQL Reversed and Comparator reversed=true

2012-03-26 Thread Praveen Baratam
Thank you Aaron! On Mon, Mar 26, 2012 at 10:44 PM, aaron morton wrote: > create column family Comments > with comparator = 'CompositeType(UTF8Type(reversed=True), UTF8Type)' > and key_validation_class = 'UTF8Type' > and default_validation_class = 'UTF8Type'; > > Looks ok. > > SELECT F

Re: CQL Reversed and Comparator reversed=true

2012-03-26 Thread aaron morton
> create column family Comments > with comparator = 'CompositeType(UTF8Type(reversed=True), UTF8Type)' > and key_validation_class = 'UTF8Type' > and default_validation_class = 'UTF8Type'; Looks ok. > SELECT FIRST 100 REVERSED 'z'..'0' from Comments where key = 'xyz'; try SELECT FIRST

CQL Reversed and Comparator reversed=true

2012-03-23 Thread Praveen Baratam
Hello, I am a bit confused about how to store and retrieve columns in Reversed order. Currently I store comments for every blog post in a wide row per post. I want to store and retrieve comments for each blog post in reversed/descending order for efficiency as we display comments in descending o