Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 69705 invoked from network); 17 Apr 2010 15:46:56 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 17 Apr 2010 15:46:56 -0000 Received: (qmail 65833 invoked by uid 500); 17 Apr 2010 15:46:56 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 65816 invoked by uid 500); 17 Apr 2010 15:46: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 65808 invoked by uid 99); 17 Apr 2010 15:46:55 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 17 Apr 2010 15:46:55 +0000 X-ASF-Spam-Status: No, hits=1.0 required=10.0 tests=RCVD_IN_DNSWL_NONE,SPF_SOFTFAIL X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of sylvain@yakaz.com does not designate 72.14.220.157 as permitted sender) Received: from [72.14.220.157] (HELO fg-out-1718.google.com) (72.14.220.157) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 17 Apr 2010 15:46:49 +0000 Received: by fg-out-1718.google.com with SMTP id l26so958710fgb.7 for ; Sat, 17 Apr 2010 08:46:29 -0700 (PDT) MIME-Version: 1.0 Received: by 10.223.118.81 with HTTP; Sat, 17 Apr 2010 08:46:09 -0700 (PDT) In-Reply-To: <9FB188AF-F9B7-41C3-B067-22A52D538991@di-pentima.com.ar> References: <3A9795EA-61BF-4295-BB0B-A0AB694CC38A@di-pentima.com.ar> <9FB188AF-F9B7-41C3-B067-22A52D538991@di-pentima.com.ar> From: Sylvain Lebresne Date: Sat, 17 Apr 2010 17:46:09 +0200 Received: by 10.223.16.207 with SMTP id p15mr1417742faa.99.1271519189084; Sat, 17 Apr 2010 08:46:29 -0700 (PDT) Message-ID: Subject: Re: Just starting to play with Cassandra: (Surely) Dumb Question To: user@cassandra.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org On Sat, Apr 17, 2010 at 5:38 PM, Lucas Di Pentima wrote: > Hello Sylvain, > > El 17/04/2010, a las 12:09, Sylvain Lebresne escribi=F3: > >> On Sat, Apr 17, 2010 at 4:52 PM, Lucas Di Pentima >> wrote: >>> Hello Jonathan, >>> >>> I supposed the same, that's why I tried the count_columns() call, but w= hen I try it with some big SCF, I get the same error message: >>> >>> Thrift::TransportException: Socket: Timed out reading 4096 bytes from 1= 27.0.0.1:9160 >>> >>> Should I use count_columns() or is there any other way to know how much= columns exists? >> >> get_count() (that, even though I don't know the ruby gem, is most >> probably used by >> count_columns() under the hood) actually query the whole row and >> simply return the number >> of column founded. Hence the only thing you gain by counting columns >> instead of requesting >> them is that you don't have to pull all the columns over the network. >> Hence counting is (roughly) as costly as requesting the whole row and >> as such, it is no wonder >> it timeout in your case. >> > > > Thanks for the explanation, so in the case I need to fetch all the column= s on a big ColumnFamily, I should request a few thousands at a time as Jona= than told me, using the start parameter, until I get no more columns, am I = right? Yes > > > Best regards, > -- > Lucas Di Pentima - Santa Fe, Argentina > Jabber: lucas@di-pentima.com.ar > MSN: ldipenti75@hotmail.com > > > > >