Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 37000 invoked from network); 6 Oct 2010 07:59:28 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 6 Oct 2010 07:59:28 -0000 Received: (qmail 22315 invoked by uid 500); 6 Oct 2010 07:59:26 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 22223 invoked by uid 500); 6 Oct 2010 07:59:23 -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 22215 invoked by uid 99); 6 Oct 2010 07:59:23 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Oct 2010 07:59:23 +0000 X-ASF-Spam-Status: No, hits=4.4 required=10.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of cbertu81@libero.it designates 212.52.84.103 as permitted sender) Received: from [212.52.84.103] (HELO cp-out3.libero.it) (212.52.84.103) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Oct 2010 07:59:13 +0000 Received: from wmail50 (172.31.0.240) by cp-out3.libero.it (8.5.107) (authenticated as cbertu81@libero.it) id 4CA1F3CA008A99A7 for user@cassandra.apache.org; Wed, 6 Oct 2010 09:58:53 +0200 Message-ID: <24855219.2942211286351933398.JavaMail.defaultUser@defaultHost> Date: Wed, 6 Oct 2010 09:58:53 +0200 (CEST) From: "cbertu81@libero.it" Reply-To: "cbertu81@libero.it" To: Subject: R: Re: Sorting in Cassandra MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_263145_17712037.1286351933397" X-SenderIP: 212.48.3.164 X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_263145_17712037.1286351933397 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Aaron, first of all thanks for your time. 1. You cannot return just the super columns, you have to get their sub columns as well. The returned data is ordered, please provide and example of where it is not. I don't know what I did before but now I checked and data are sorted as I expected them to be :-o. I know I can't get a SC without their sub columns and this is ok. 2. Pull back the entire row and filter/sort the columns client side. It's not possible to return columns of the same name from different super columns (I think that's what you are asking). Let me know if you think you have too much data per row to do that. Probably I explained myself wrong. What I want is to get the entire ROW back but already ordered on the base of a specific column key and not on the base of the SCKey ... example UID (ROW) { Company0 { name: zaz, address: street x, phone: 123, other cols } Company1 { name: abacus, address: street y, phone: 234, other cols } Company2 { name: more, address: street x, phone: 345, other cols }} What I want is to get all the data back from cassandra sorted by the name of the company, and not of the SC ... UID (ROW) { Company1 { name: abacus, address: street y, phone: 234, other cols } Company2 { name: more, address: street x, phone: 345, other cols } Company0 { name: zaz, address: street x, phone: 123, other cols } } As far as I know Cassandra I don't think it's possible since I cannot be sure that each SC contains the specific Column (name), right? Is the only way to sort them on client-side? Best Regards ------=_Part_263145_17712037.1286351933397 Content-Type: text/html;charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Aaron,

first of all thanks for your time.


1. = You cannot return just the super columns, you have to get their sub columns= as well. The returned data is ordered, please provide and example of where= it is not. 
<= div>
I don't know what I did before but now I checked and dat= a are sorted as I expected them to be :-o.
I know I can't get a SC with= out their sub columns and this is ok.

2. P= ull back the entire row and filter/sort the columns client side. It's not p= ossible to return columns of the same name from different super columns (I = think that's what you are asking). Let me know if you think you have too mu= ch data per row to do that. 

Probably I e= xplained myself wrong. What I want is to get the entire ROW back but alread= y ordered on the base of a specific column key and not on the base of the S= CKey ... example

UID (ROW) {
   = Company0 { name: zaz, address: street x, phone: 123, other cols }
    Company1 { name: abacus, address: street y, phone: 234= , other cols }
    Company2 { name: more, address:= street x, phone: 345, other cols }
}

Wh= at I want is to get all the data back from cassandra sorted by the name of = the company, and not of the SC  ...

UID = (ROW) {
    Company1 { name: abacus, address: street y, phone= : 234, other cols }
    Company2 { name: more, add= ress: street x, phone: 345, other cols }
    Company0 {= name: zaz, address: street x, phone: 123, other cols }
}

As far as I know Cassandra I don't th= ink it's possible since I cannot be sure that each SC contains the specific= Column (name), right?
Is the only way to sort them on client-si= de?

Best Regards



------=_Part_263145_17712037.1286351933397--