Many thanks Vladimir I am starting to see what you are talking about.
Yeah all I want to do is a simple Order By via SQL but having the column family setup using CLI to support that is a bit of a challenge for me at the moment since the two are at different levels but I prefer CLI for column family setup and just need an example of one at CLI level setup that translates to working Order By at CQL level.
From: Vladimir Prudnikov <firstname.lastname@example.org>
Sent: Thursday, July 18, 2013 3:54 AM
Subject: Re: Intresting issue with getting Order By to work...
I'm not an expert, still learning C* but can tell something about your questions.
1) You have to understand that CQL row is not the same as row that C* uses to store data and which is accessible through the Trift interface. Primary key in terms of CQL is not the same as Row key.
2) You have to be clear what you want to order: raw columns, rows or CQL rows. If you want to get ordered slices of raw rows you have to use Order Preserving Partitioner (which is not recommended, depends on you schema); If you want to order columns, it can be done easily; If you want to order CQL rows you have to have a composite primary key with at least 2 columns and you can order only by the second column in primary key.
3) As far as I know column families created from CLI or Thrift will be accessible from CQL, but not opposite.
I hope experts will correct me if I'm wrong.