Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 19734 invoked from network); 22 Jul 2010 19:01:57 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 22 Jul 2010 19:01:57 -0000 Received: (qmail 17094 invoked by uid 500); 22 Jul 2010 19:01:55 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 17057 invoked by uid 500); 22 Jul 2010 19:01:55 -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 17045 invoked by uid 99); 22 Jul 2010 19:01:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Jul 2010 19:01:55 +0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FREEMAIL_FROM,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of patricioe@gmail.com designates 209.85.210.44 as permitted sender) Received: from [209.85.210.44] (HELO mail-pz0-f44.google.com) (209.85.210.44) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Jul 2010 19:01:50 +0000 Received: by pzk6 with SMTP id 6so3934808pzk.31 for ; Thu, 22 Jul 2010 12:01:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:in-reply-to :references:from:date:message-id:subject:to:content-type :content-transfer-encoding; bh=Iyxz9Rg0pm66pz+MVSAa2/s8b3SZUfCSLMGKQYMnW24=; b=ObEErMqL0iP690swVwes76Bt0c5jvtuMCvGIxX3FkEMWIYZ2wqpor9rzVBElmfKM0f AHEBIraw99eVlNQVsrU0y8Mz/9mwmnYnreWd11dYGATXUuqubNMbsNyhpYJlacPJTuIk aYmjrPEMSilAWstgQICw96bVVZiRy4bOYvcIc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; b=fT9/LXnt5AZC9DEOxoqo+PScslrGMghDfx//dIuqKblFy/wFDBJ3roD/W8dQ5ORNFs JcKyblSZiL2oGgCieZGLIywd5oVZwcX6WBnnFN/Lud1zgUrmrvw3uKQt5LdvasP9T9jF QP4cml/i0bbREfIIbUpJgjyUU9zacxc8yadvs= Received: by 10.142.199.21 with SMTP id w21mr2792608wff.198.1279825289288; Thu, 22 Jul 2010 12:01:29 -0700 (PDT) MIME-Version: 1.0 Received: by 10.142.173.19 with HTTP; Thu, 22 Jul 2010 12:01:09 -0700 (PDT) In-Reply-To: References: <67ff307f-4be4-ea8a-dc49-ee32ef3c1ff0@me.com> From: =?ISO-8859-1?Q?Patricio_Echag=FCe?= Date: Thu, 22 Jul 2010 12:01:09 -0700 Message-ID: Subject: Re: Is it possible to read from one row, several SuperColumns with all their Columns in one call? To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hey thanks Aaron. It finally worked. The API reference looked a bit confusing to me. I used (as you suggested): ColumnParent parent =3D new ColumnParent( ); SlicePredicate sp =3D new SlicePredicate(); sp.setColumn_names( ); after calling get_slice() ....as result, i got the super columns I passed in the list with ALLl their columns in one call. so now, just IF I WANTED TO, would it be possible to get just a subset of columns contained in those supercolumns instead of all of them assuming that the amount of columns are lot and for performance issues i want to avoid moving a lot of data over the network? 2010/7/22 Patricio Echag=FCe : > Hi Aaron, the problem I have is that those UUIDs are random numbers. > 2,3,4 are not sequential unfortunately. I don't think there is an API > like mutiget_slice for key but for Super Column names. > > Is there any other way to specify a list of super column names to read > where those names are not sequential? > > thanks > > > On Wed, Jul 21, 2010 at 5:58 PM, Aaron Morton w= rote: >> Take a look at the=A0 get_slice=A0 function http://wiki.apache.org/cassa= ndra/API >> >> You could send one with a ColumnParent that only specifies the ColumnFam= ily >> and a SlicePredicate with a SliceRange where the start and finish values= are >> empty strings. Set the count to an appropriate level to get them all (e.= g. >> 1000) or make multiple calls. >> >> >> Aaron >> >> >> On 22 Jul, 2010,at 12:05 PM, Patricio Echag=FCe wr= ote: >> >> Hi all, apologize before hand if this question sounds a bit dumb but I >> don't see what API I should use (if there is any) >> >> this is my model: >> >> row key A: >> SC_UUID_1: >> Col1, Col2, Col3 >> SC_UUID_2: >> Col1, Col2, Col3 >> SC_UUID_3: >> Col1, Col2, Col3 >> SC_UUID_4: >> Col1, Col2, Col3 >> SC_UUID_5: >> Col1, Col2, Col3 >> >> SC_UUID(i) are random UUIDs. >> >> Is there any way to read in one call from row A, the SC 2,3,4 with all >> their columns? The amount of columns in every SuperColumn is not big >> at all. normally less than 20. >> >> Thanks >> -- >> Patricio- >> > > > > -- > Patricio.- > --=20 Patricio.-