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 6F5F69BCC for ; Tue, 14 Feb 2012 20:23:54 +0000 (UTC) Received: (qmail 92794 invoked by uid 500); 14 Feb 2012 20:23:52 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 92761 invoked by uid 500); 14 Feb 2012 20:23:52 -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 92752 invoked by uid 99); 14 Feb 2012 20:23:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Feb 2012 20:23:52 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.212.44] (HELO mail-vw0-f44.google.com) (209.85.212.44) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Feb 2012 20:23:46 +0000 Received: by vbbfr13 with SMTP id fr13so315376vbb.31 for ; Tue, 14 Feb 2012 12:23:25 -0800 (PST) MIME-Version: 1.0 Received: by 10.52.77.39 with SMTP id p7mr4186449vdw.63.1329251005394; Tue, 14 Feb 2012 12:23:25 -0800 (PST) Received: by 10.52.35.75 with HTTP; Tue, 14 Feb 2012 12:23:25 -0800 (PST) In-Reply-To: References: Date: Tue, 14 Feb 2012 21:23:25 +0100 Message-ID: Subject: Re: timed-out retrieving a giant row. From: "R. Verlangen" To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=20cf3071cecafe6d4904b8f25d33 X-Gm-Message-State: ALoCoQkK4GEB7usbGMh0xV5POAVDyRkrd9bEHiqdjncr10llQz6FKjo657pIg7UUVY8KlDLDK/+p X-Virus-Checked: Checked by ClamAV on apache.org --20cf3071cecafe6d4904b8f25d33 Content-Type: text/plain; charset=ISO-8859-1 Of course you should set your limit to 100 or something like that, not Integer.MAX_VALUE ;-) 2012/2/14 R. Verlangen > I'm familiar to this in PHPCassa, but with Hector it would be something > like this: > > Query you CF with a range.setStart(lastColName) and > range.setFinish(StringUtils.byte("") where the " lastColName " is the name > of the column from the previous read. > > You can continue this until you run out of results. > > > 2012/2/14 Yuhan Zhang > >> Hi all, >> >> I'm using the Hector client 0.8, trying to retrieve a list of IDs from a >> gaint row. each ID is a columnName in the row >> It works ok when there's not many IDs, but SliceQuery starts to time-out >> after the row becomes big. >> >> Is this approach the correct way to store a list of IDs? are there some >> settings that I'm missing? >> by looking at the code, it sets the range of the columnNames to be >> setRange(null, null, false, Integer.MAX_VALUE); >> >> is there a way in cassandra to retrieve the first 100 columns, then the >> next 100 columns, and so forth? >> >> >> Thank you. >> >> Yuhan >> > > --20cf3071cecafe6d4904b8f25d33 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Of course you should set your limit to 100 or something like that, not=A0 Integer.MAX_VALUE=A0;-)

2012/2/14 R. Verlangen <robin@us2.nl>
I'm familiar to this in PHPCassa, but with Hector it would be some= thing like this:

Query you CF with a=A0range.setStart(l= astColName) and range.setFinish(StringUtils.byte("") where the &q= uot; lastColName=A0" is the name of the column from the previous read.=A0
You can continue this until you run out of results.
<= div class=3D"h5">

2012/2/14 Yuhan Zhang <= span dir=3D"ltr"><yzhang@onescreen.com>
Hi all,

I'm using the Hector clie= nt 0.8, trying to retrieve a list of IDs from a gaint row. each ID is a col= umnName in the row
It works ok when there's not many IDs, but SliceQuery starts to time-ou= t after the row becomes big.

Is this approach the correct way to store a list of IDs? are there some= settings that I'm missing?
by looking at the code, it sets the rang= e of the columnNames to be setRange(null, null, false, Integer.MAX_VALUE);<= br>
is there a way in cassandra to retrieve the first 100 columns, then the nex= t 100 columns, and so forth?


Thank you.

Yuhan


--20cf3071cecafe6d4904b8f25d33--