Re: Intresting issue with getting Order By to work...

2013-07-18 Thread Tony Anecito
To: "user@cassandra.apache.org" ; Tony Anecito Sent: Thursday, July 18, 2013 10:16 AM Subject: Re: Intresting issue with getting Order By to work... On Thu, Jul 18, 2013 at 8:12 AM, Tony Anecito wrote:  As I work more with CQL and CLI as some other posting I have seen regarding usage I am t

Re: Intresting issue with getting Order By to work...

2013-07-18 Thread Robert Coli
On Thu, Jul 18, 2013 at 8:12 AM, Tony Anecito wrote: > As I work more with CQL and CLI as some other posting I have seen > regarding usage I am thinking that CLI for keyspace and Column Family setup > and maintenance is best > while CQL for queries/inserts ect is best. Mainly I am thinking this

Re: Intresting issue with getting Order By to work...

2013-07-18 Thread Tony Anecito
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 i

Re: Intresting issue with getting Order By to work...

2013-07-18 Thread Tony Anecito
schema using CLI.   I will look over your links carefully. -Tony   From: aaron morton To: Cassandra User Sent: Thursday, July 18, 2013 2:21 AM Subject: Re: Intresting issue with getting Order By to work... Here are some posts about CQL and Thrift  http

Re: Intresting issue with getting Order By to work...

2013-07-18 Thread Vladimir Prudnikov
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

Re: Intresting issue with getting Order By to work...

2013-07-18 Thread aaron morton
sandra User > Sent: Wednesday, July 17, 2013 4:06 AM > Subject: Re: Intresting issue with getting Order By to work... > > > The use of Order By requires Primary Key which appears to be only supported > > by by using CQL and not Cassandra-cli. > Order By in CQL is the also su

Re: Intresting issue with getting Order By to work...

2013-07-17 Thread Tony Anecito
have also spotted major issues and tried to help understand them for all users.   -Tony From: aaron morton To: Cassandra User Sent: Wednesday, July 17, 2013 4:06 AM Subject: Re: Intresting issue with getting Order By to work... > The use of Order By requires Primary Key which appears to

Re: Intresting issue with getting Order By to work...

2013-07-17 Thread aaron morton
> The use of Order By requires Primary Key which appears to be only supported > by by using CQL and not Cassandra-cli. Order By in CQL is the also supported on the thrift interface. When using thrift the order you get the columns back is the order the Comparator puts them in. If you want them