Intresting issue with getting Order By to work...

2013-07-30 Thread Tony Anecito
Hi All, I am trying to have a table that I can have a key for one CQL to get a row based on a key and another CQL to where I have a list of keys using the "IN" keyword and have an ORDER BY clause. The data I am getting is from the Column value not the Column Name. The issue I am having is tryin

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

Intresting issue with getting Order By to work...

2013-07-16 Thread Tony Anecito
Hi All, Well I got most everything working I wanted using Cassandra then discovered I needed to use an Order By. I am using Cassandra 1.2.5. The use of Order By requires Primary Key which appears to be only supported by by using CQL and not Cassandra-cli. So I dropped my table created uisng CLI