Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8814EC096 for ; Thu, 18 Jul 2013 15:16:41 +0000 (UTC) Received: (qmail 13044 invoked by uid 500); 18 Jul 2013 15:16:38 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 12721 invoked by uid 500); 18 Jul 2013 15:16:34 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 12707 invoked by uid 99); 18 Jul 2013 15:16:33 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Jul 2013 15:16:33 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.138.120.56] (HELO nm49.bullet.mail.ne1.yahoo.com) (98.138.120.56) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Jul 2013 15:16:28 +0000 Received: from [127.0.0.1] by nm49.bullet.mail.ne1.yahoo.com with NNFMP; 18 Jul 2013 15:16:02 -0000 Received: from [98.138.101.131] by nm49.bullet.mail.ne1.yahoo.com with NNFMP; 18 Jul 2013 15:12:53 -0000 Received: from [98.138.89.240] by tm19.bullet.mail.ne1.yahoo.com with NNFMP; 18 Jul 2013 15:12:53 -0000 Received: from [127.0.0.1] by omp1013.mail.ne1.yahoo.com with NNFMP; 18 Jul 2013 15:12:52 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 992052.63036.bm@omp1013.mail.ne1.yahoo.com Received: (qmail 50520 invoked by uid 60001); 18 Jul 2013 15:12:52 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1374160372; bh=gdlbFdJBwSrMrn1hPxMw3uqLBSIg2LhnCXYL+CYyi2E=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=PxNIzU21dKiouhshLawBYuC3HFWKKnHI2p3pv6HJdKpdmnQSD8Pje5RfBOI0588Y+u4zmB0W/OzV+O4f5i5qFpl8mTYbZE8MLdCWkO6Ldhq+f7fNwLaFSv40jB3E1o49Xx282lgmYPHVwFk3iVGegVDs8iSE9wsySNHpHAzUZl0= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=x7L2fo4k989NL5K3GUhUXDtmYnpqMldzK/CeRKbqAmqsLbqXAHcXcRCr0wuzKLqGVTdx0klj/8+18BVrrxgRWP3o69+2AwHo7aVR3Ei7Mcu9ZqT6ZFZfTc+roUppLmsiHefe8hTWkeGLfsWcr7sbaAQ2kxt9BO7xd6quZFjNPD0=; X-YMail-OSG: DT2fgXcVM1ncNBHUmE.5vSCf6vAdeMFCQap2Sc0fZuc0nSb emwYrZP5lnFYmevOnivcgPF6jIilE9bzc3cMn.TeusOa4ATohpv0o0vdFeQn 0e1dPNn6p93E7E__B1hUvRSjmwhXE6zEuyNSNiz2f7neZ09FXnu1xnYhrBRe HdEpkpuHqn6PzmFy4SR73n4wuDD3ai2UAo2XjzyO1Dwkxmw_iG3zoo3qSGOk qLiWQHJ0_hc0ghvi_2eUFHS.9KwdAuKT0qDzeqwsp.GSgm0UVUqNQk3xoyAj RJo.cknYYCi91JnmXD676tK64BFLMjIE0mmLSUYY0Z_PDdzNL7JVh1pCc5yr mAMdomYagSxRxizFiZOMlJE4cfZJj0E2rvJ2Ap3Fq_WVx0XpeWlXWRWFQPen IJgLY.nx6Tgc6yR.KStdpiQwN0C79ZLQDyLuIfLaYNZ19YuXID0QAfr0C7c6 IxH3miHX5gUqFUHYs7GUvMAOoMV1fcxPSengo9qJhLNpPz9cNKJJSUytZew. c9ZISiJB4fhJEuRZHu6fTZr99FuET1ZxTDfLNX6IZSa8GwWmXtKk0gDF73mL WsacSGRnmUbtJ8fGjV6nmOXOAxeP8jKkP5uibddTNz2hbZqqheGI46fRRqDV KihN07c79mGvPHb4CeRmN2rM7cF5ACFTOEx5G253GZ2DSkGquGgjv5.l7WRY QEdcOIDU2Ho_OMg0kAY.UKejNHnBJHmPmizYPNg0euuPoNJr8KxtRxyvcLj1 GekLuQBd07ajjqKEZ2Zn.8duabrpkSFNy Received: from [173.164.68.81] by web121801.mail.ne1.yahoo.com via HTTP; Thu, 18 Jul 2013 08:12:52 PDT X-Rocket-MIMEInfo: 002.001,TWFueSBUaGFua3MgQWFyb24hIQrCoApBcyBJIHdvcmsgbW9yZSB3aXRoIENRTCBhbmQgQ0xJIGFzIHNvbWUgb3RoZXIgcG9zdGluZyBJIGhhdmUgc2VlbiByZWdhcmRpbmcgdXNhZ2UgSSBhbSB0aGlua2luZyB0aGF0IENMSSBmb3Iga2V5c3BhY2UgYW5kIENvbHVtbiBGYW1pbHkgc2V0dXAgYW5kIG1haW50ZW5hbmNlIGlzIGJlc3QKwqB3aGlsZSBDUUwgZm9yIHF1ZXJpZXMvaW5zZXJ0cyBlY3QgaXMgYmVzdC4gTWFpbmx5IEkgYW0gdGhpbmtpbmcgdGhpcyBiZWNhdXNlIG9mIGJldHRlciBjb250cm9sIG92ZXIBMAEBAQE- X-Mailer: YahooMailWebService/0.8.149.560 References: <1374032699.76383.YahooMailNeo@web121806.mail.ne1.yahoo.com> <66ACB46D-A448-466A-99C1-1555C7A600FC@thelastpickle.com> <1374061085.16801.YahooMailNeo@web121804.mail.ne1.yahoo.com> Message-ID: <1374160372.50426.YahooMailNeo@web121801.mail.ne1.yahoo.com> Date: Thu, 18 Jul 2013 08:12:52 -0700 (PDT) From: Tony Anecito Reply-To: Tony Anecito Subject: Re: Intresting issue with getting Order By to work... To: "user@cassandra.apache.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-433406958-283643928-1374160372=:50426" X-Virus-Checked: Checked by ClamAV on apache.org ---433406958-283643928-1374160372=:50426 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Many Thanks Aaron!!=0A=A0=0AAs I work more with CQL and CLI as some other p= osting I have seen regarding usage I am thinking that CLI for keyspace and = Column Family setup and maintenance is best=0A=A0while CQL for queries/inse= rts ect is best. Mainly I am thinking this because of better control over t= he schema using CLI.=0A=A0=0AI will look over your links carefully.=0A-Tony= =0A=A0 =0A=0A________________________________=0A From: aaron morton =0ATo: Cassandra User =0ASent= : Thursday, July 18, 2013 2:21 AM=0ASubject: Re: Intresting issue with gett= ing Order By to work...=0A =0A=0A=0AHere are some posts about CQL and Thri= ft=0A=0A=A0http://thelastpickle.com/2013/01/11/primary-keys-in-cql/=0Ahttp:= //www.datastax.com/dev/blog/cql3-for-cassandra-experts=0Ahttp://www.datasta= x.com/dev/blog/thrift-to-cql3=0A=0AHope that helps.=A0=0A=0A---------------= --=0AAaron Morton=0ACassandra Consultant=0ANew Zealand=0A=0A@aaronmorton=0A= http://www.thelastpickle.com/ =0A=0AOn 17/07/2013, at 11:38 PM, Tony Aneci= to wrote:=0A=0AThanks for the answers. =0A>=A0 =0A>Th= e reason why I ask is it is stated the composite keys are not the same as P= rimary Key. I found no examples for thrift where it specifcally said the co= mposite key is a primary key required by order by. All the examples where t= he words primary key were used were with CQL examples and=A0I am seeing pos= tings where people had issues with Order By but no answers like what you sa= id. =0A>=A0 =0A>If there was better documentation for Cassandra with workin= g examples and explnations about the differences between CQL and CLI I woul= d not need to ask questions on the users groups. I have also spotted major = issues and tried to help understand them for all users. =0A>=A0 =0A>-Tony = =0A>=0A> =0A>=0A>________________________________=0A>From: aaron morton =0A>To: Cassandra User = =0A>Sent: Wednesday, July 17, 2013 4:06 AM=0A>Subject: Re: Intresting issue= with getting Order By to work...=0A> =0A>=0A>> The use of Order By require= s Primary Key which appears to be only supported by by using CQL and not Ca= ssandra-cli. =0A>Order By in CQL is the also supported on the thrift interf= ace. =0A>=0A>When using thrift the order you get the columns back is the or= der the Comparator puts them in. If you want them reversed the thrift API s= upports that. =0A>=0A>> I read that thrift clients will not work with CQL c= reated tables due to extra things created by the CQL. If so how can I creat= e Primary Keys and be supported by thrift based clients??=0A>No.=0A>Do not = access CQL tables with the thrift API. =0A>=0A>> Seems like Cassandra-cli s= hould support creation of compound primary keys or=0A>It does. =0A>See help= on the CompositeType=0A>=0A>> Also CQL tables are not visible via cli.so I= can not see details on what was created by CQL and the cqlsh script has er= rors according to the latest Python windows program I tried.=0A>They=0A are= visible for read access. =0A>=0A>> I will post to Datastax the same questi= on =0A>Please ask questions to one group at a time so people do not waste t= heir time providing answers you already have. =0A>=0A>Cheers=0A>=0A>=0A>---= --------------=0A>Aaron Morton=0A>Cassandra Consultant=0A>New Zealand=0A>= =0A>@aaronmorton=0A>http://www.thelastpickle.com/=0A>=0A>On 17/07/2013, at = 3:44 PM, Tony Anecito wrote:=0A>=0A>> Hi All,=0A>> = =0A>> Well I got most everything working I wanted using Cassandra then disc= overed I needed to use an Order By. I am using Cassandra 1.2.5.=0A>> The us= e 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 a= nd used CQL and was able to create a "Table". But when I went=0A to insert = data that worked fine on the cli created table I now get an exception:=0A>>= Error while inserting com.datastax.driver.core.exceptions.InvalidQueryExce= ption: Unknown identifier type.=0A>> =0A>> I read that thrift clients will = not work with CQL created tables due to extra things created by the CQL. If= so how can I create Primary Keys and be supported by thrift based clients?= ?=0A>> =0A>> I will post to Datastax the same question but trying to unders= tand how to resolve cli vs CQL issue like this. Seems like Cassandra-cli sh= ould support creation of compound primary keys or CQL should create tables = readable by thrift based clients. Is there some meta column info people sho= uld add?=0A>> Also CQL tables are not visible via cli.so I can not see deta= ils on what was created by CQL and the cqlsh script has errors according to= the latest Python windows program I tried.=0A>> =0A>> Thanks,=0A>> -Tony= =0A>> =0A>> =0A>=0A>=0A> ---433406958-283643928-1374160372=:50426 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Many Thank= s Aaron!!
 
As I work mo= re 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 b= est
 while CQL for queries/inserts ect is best. Mainl= y I am thinking this because of better control over the schema using CLI.
 
I will look over your links carefully.
= -Tony
 
From: aaron mor= ton <aaron@thelastpickle.com>
To: Cassandra User <user@cassandra.apache.org>
= Sent: Thursday, July 18, 2013= 2:21 AM
Subject: Re: = Intresting issue with getting Order By to work...

Here are some p= osts about CQL and Thrift

 http://thelastpickle.com/2013/01/11/primary-keys-in-cql/

Hope that helps. 
=0A
-----------------
Aaron Morton
Cassandra = Consultant
New Zealand

=0A
=0A
On 17/07/2013, at 11:38 PM, Tony Anecito <adanecito@yahoo.com> wrote:

Thanks for the answers.<= /div>=0A
 
=0A
The reason why I ask is it is stated = the composite keys are not the same as Primary Key. I found no examples for= thrift where it specifcally said the composite key is a primary key requir= ed by order by. All the examples where the words primary key were used were= with CQL examples and I am seeing postings where people had issues wi= th Order By but no answers like what you said.
=0A
 
=0A
If there was better documentation for Cassan= dra with working examples and explnations about the differences between CQL= and CLI I would not need to ask questions on the users groups. I have also spotted major issues and trie= d to help understand them for all users.
=0A
&= nbsp;
=0A
-Tony
=0A

=0A
=0A
=0A
=0A
From: aaron morton = <aaron@thelastpickle.com>
To: Cassandra Us= er <user@cassandra.a= pache.org>
Sent: Wednesday, July 17, 2013 4:06 AM
Subject: Re: Intresting issue with getting Order By to work...<= br>
=0A

> 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 suppor= ted on the thrift interface.

When using thrift the order you get th= e columns back is the order the Comparator puts them in. If you want them r= eversed the thrift API supports that.

> I read that thrift clien= ts will not work with CQL created tables due to extra things created by the= CQL. If so how can I create Primary Keys and be supported by thrift based = clients??
No.
Do not access CQL tables with the thrift API.

&= gt; Seems like Cassandra-cli should support creation of compound primary ke= ys or
It does.
See help on the CompositeType

> Also CQL ta= bles are not visible via cli.so I can not see details on what was created b= y CQL and the cqlsh script has errors according to the latest Python window= s program I tried.
They=0A are visible for read access.

> I will post to= Datastax the same question
Please ask questions to one group at a time= so people do not waste their time providing answers you already have.
=
Cheers


-----------------
Aaron Morton
Cassandra Consul= tant
New Zealand

@aaronmorton
http://www.thelastpickle.com/<= /a>

On 17/07/2013, at 3:44 PM, Tony Anecito <adanecito@yahoo.com> wrote:

> 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 sup= ported by by using CQL and not Cassandra-cli. So I dropped my table created= uisng CLI and used CQL and was able to create a "Table". But when I went=0A to insert data that w= orked fine on the cli created table I now get an exception:
> Error w= hile inserting com.datastax.driver.core.exceptions.InvalidQueryException: U= nknown identifier type.
>
> I read that thrift clients will no= t work with CQL created tables due to extra things created by the CQL. If s= o how can I create Primary Keys and be supported by thrift based clients??<= br>>
> I will post to Datastax the same question but trying to un= derstand how to resolve cli vs CQL issue like this. Seems like Cassandra-cl= i should support creation of compound primary keys or CQL should create tab= les readable by thrift based clients. Is there some meta column info people= should add?
> Also CQL tables are not visible via cli.so I can not s= ee details on what was created by CQL and the cqlsh script has errors accor= ding to the latest Python windows program I tried.
>
> Thanks,=
> -Tony
>
>=0A





---433406958-283643928-1374160372=:50426--