Return-Path: Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: (qmail 79811 invoked from network); 1 Dec 2010 23:17:06 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 1 Dec 2010 23:17:06 -0000 Received: (qmail 76937 invoked by uid 500); 1 Dec 2010 23:17:04 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 76916 invoked by uid 500); 1 Dec 2010 23:17:04 -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 76908 invoked by uid 99); 1 Dec 2010 23:17:04 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Dec 2010 23:17:04 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,MIME_QP_LONG_LINE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a53.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 01 Dec 2010 23:16:55 +0000 Received: from homiemail-a53.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a53.g.dreamhost.com (Postfix) with ESMTP id D217A138062 for ; Wed, 1 Dec 2010 15:16:28 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=to:from :subject:date:message-id:content-type:mime-version:in-reply-to; q=dns; s=thelastpickle.com; b=GjpnVZU8r0mld676RKaAprtZmzLEmBiaW axfls4hfvMj+TL/jtwfSI41/YmAYAIeYzhjv6Zrz8O89tvPjKOCzRWDARlEFR9IQ i6zrTcY1LqoBPHbuANu6+/yGzUx+EY131HfKYYOo3W5hZ30gfMNm+lY6JPs0nZ28 WTVwVo3CbQ= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h=to :from:subject:date:message-id:content-type:mime-version: in-reply-to; s=thelastpickle.com; bh=0Q9o/j773WqFs6t8MVuDjYUqf+4 =; b=HGFicpirzNIeS0mhY+ox8OTh/z6Qr7n0jimjoKlaMZLx+NyVhC9476WOsSb vYJbf5t4TpkVRKLiQu8QG43TWnYl5tzI7N0AORS1R4rzP5407lCS3Wg/oxUKq3Pp SC0YfOWrN55w9NyBJm5T+CJzdFY7tQwalUTCN6evRfYPycfo= Received: from localhost (webms.mac.com [17.148.16.116]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a53.g.dreamhost.com (Postfix) with ESMTPSA id A492D13805C for ; Wed, 1 Dec 2010 15:16:28 -0800 (PST) To: user@cassandra.apache.org From: Aaron Morton Subject: Re: Range Queries in RP on SCF in 0.7 with UUID SCs Date: Wed, 01 Dec 2010 23:16:27 GMT X-Mailer: MobileMe Mail (1C3207) Message-id: <54867049-55a7-cdd7-c294-b45263b3904d@me.com> Content-Type: multipart/alternative; boundary=Apple-Webmail-42--8c749a29-71de-c587-99cc-ea2bb935794b MIME-Version: 1.0 In-Reply-To: X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Webmail-42--8c749a29-71de-c587-99cc-ea2bb935794b Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=ISO-8859-1; format=flowed When you say "I want to get rows starting from a Super Column..." it's a b= it confusing. Do you want to get super columns from a single row, or multi= ple rows? I'm assuming you are talking about getting columns from a single= row / key as that's what your code does.=0A=0AFor the pelops code, it loo= ks OK but I've not used Pelops. You can turn the logging up on the server = and check the command that is sent to it. I'm would guess there is somethi= ng wrong with the way you are transforming the start key.=A0=0A=0AFor your= cli example what was the command you executed ?=A0=0A=0AAaron=0A=0AOn 02 = Dec, 2010,at 11:03 AM, Frank LoVecchio wrote:=0A=0AHe= y Aaron,=A0=0A=0AYes, in regards to SCF definition, you are correct: =A0=0A= =0Aname: Sensor=0A=A0=A0 =A0 =A0column_type: Super=0A=A0=A0 =A0 =A0compare= _with: TimeUUIDType=0A=A0=A0 =A0 =A0gc_grace_seconds: 864000=0A=A0=A0 =A0 = =A0keys_cached: 10000.0=0A=A0=A0 =A0 =A0read_repair_chance: 1.0=0A=A0=A0 =A0= =A0rows_cached: 0.0=0A=0AI'm not quite sure I follow you, though, as I th= ink I'm doing what you specify. =A0The Pelops code is below. =A0Basically,= I want to get rows starting from a Super Column with a specific UUID and = limit the number, just as you inferred. =A0When I run this code I just get= the last N values (25 in this case) if non-reversed, and the first N valu= es if reversed. =A0However, regardless of what start param we use (Super C= olumn UUID is String startKey below), we still get the same values for the= specified amount (e.g. the same 25). =A0=0A=0Apublic=A0void=A0getSuperRow= Keys(String rowKey, String columnFamily,=A0int=A0limit, String startKey)=A0= throws=A0Exception {=0A =0A byte[] byteArray =3D UuidHelper.timeUuidStrin= gToBytes(startKey);=0A ByteBuffer bb =3D ByteBuffer.wrap(byteArray);=0A = new=A0UUID (bb.getLong(), bb.getLong());=0A =0A =0A List c= ols =3D=A0selector.getPageOfSuperColumnsFromRow(columnFamily, rowKey, Byte= s.fromByteBuffer(bb),=A0false, limit, ConsistencyLevel.ONE);=0A=0A =0A fo= r=A0(SuperColumn col : cols) {=0A if=A0(col.getName() !=3D=A0null) {=0A=0A= System.out.println("NAME: "=A0+ UUID.nameUUIDFromBytes(col.getName()))= ;=0A=0A for=A0(Column c : col.columns) {=0A System.out.println("\t\= tName: "=A0+ Bytes.toUTF8(c.getName())=0A +=A0" Value: "=A0+ Bytes.t= oUTF8(c.getValue())=0A +=A0" timestamp: "=A0+ c.timestamp);=0A=0A = }=0A=0A }=0A }=0A=0A }=0A=0AHere is some example data from the CLI. =A0= If we specify=A02f814d30-f758-11df-2f81-4d30f75811df as the start param (s= econd super column down), we still get=A052e6540-f759-11df-952e-6540f75911= df (first super column) returned.=0A=0A=3D> (super_column=3D952e6540-f759-= 11df-952e-6540f75911df,=0A=A0=A0 =A0 (column=3D64617465, value=3D323031302= d31312d32332032333a32393a30332e303030, timestamp=3D1290554997141000)=0A=A0= =A0 =A0 (column=3D65787472615f696e666f, value=3D6e6f6e65, timestamp=3D1290= 554997141000)=0A=A0=A0 =A0 (column=3D726561736f6e, value=3D6e6f6e65, times= tamp=3D1290554997141000)=0A=A0=A0 =A0 (column=3D7365636f6e64735f746f5f6e65= 7874, value=3D373530, timestamp=3D1290554997141000)=0A=A0=A0 =A0 (column=3D= 73657269616c, value=3D393135353032353731, timestamp=3D1290554997141000)=0A= =A0=A0 =A0 (column=3D737461747573, value=3D5550, timestamp=3D1290554997141= 000)=0A=A0=A0 =A0 (column=3D74797065, value=3D486561727462656174, timestam= p=3D1290554997141000))=0A=3D> (super_column=3D2f814d30-f758-11df-2f81-4d30= f75811df,=0A=A0=A0 =A0 (column=3D64617465, value=3D323031302d31312d3233203= 2333a31393a30332e303030, timestamp=3D1290554397060000)=0A=A0=A0 =A0 (colum= n=3D65787472615f696e666f, value=3D6e6f6e65, timestamp=3D1290554397060000)=0A= =A0=A0 =A0 (column=3D726561736f6e, value=3D6e6f6e65, timestamp=3D129055439= 7060000)=0A=A0=A0 =A0 (column=3D7365636f6e64735f746f5f6e657874, value=3D37= 3530, timestamp=3D1290554397060000)=0A=A0=A0 =A0 (column=3D73657269616c, v= alue=3D393135353032353731, timestamp=3D1290554397060000)=0A=A0=A0 =A0 (col= umn=3D737461747573, value=3D5550, timestamp=3D1290554397060000)=0A=A0=A0 =A0= (column=3D74797065, value=3D486561727462656174, timestamp=3D1290554397060= 000))=0A=3D> (super_column=3D7c959f00-f757-11df-7c95-9f00f75711df,=0A=A0=A0= =A0 (column=3D64617465, value=3D323031302d31312d32332032333a31343a30332e3= 03030, timestamp=3D1290554096881000)=0A=A0=A0 =A0 (column=3D65787472615f69= 6e666f, value=3D6e6f6e65, timestamp=3D1290554096881000)=0A=A0=A0 =A0 (colu= mn=3D726561736f6e, value=3D6e6f6e65, timestamp=3D1290554096881000)=0A=A0=A0= =A0 (column=3D7365636f6e64735f746f5f6e657874, value=3D373530, timestamp=3D= 1290554096881000)=0A=A0=A0 =A0 (column=3D73657269616c, value=3D39313535303= 2353731, timestamp=3D1290554096881000)=0A=A0=A0 =A0 (column=3D737461747573= , value=3D5550, timestamp=3D1290554096881000)=0A=A0=A0 =A0 (column=3D74797= 065, value=3D486561727462656174, timestamp=3D1290554096881000))=0A=3D> (su= per_column=3Dc9be6330-f756-11df-c9be-6330f75611df,=0A=A0=A0 =A0 (column=3D= 64617465, value=3D323031302d31312d32332032333a30393a30332e303030, timestam= p=3D1290553796836000)=0A=A0=A0 =A0 (column=3D65787472615f696e666f, value=3D= 6e6f6e65, timestamp=3D1290553796836000)=0A=A0=A0 =A0 (column=3D726561736f6= e, value=3D6e6f6e65, timestamp=3D1290553796836000)=0A=A0=A0 =A0 (column=3D= 7365636f6e64735f746f5f6e657874, value=3D373530, timestamp=3D12905537968360= 00)=0A=A0=A0 =A0 (column=3D73657269616c, value=3D393135353032353731, times= tamp=3D1290553796836000)=0A=A0=A0 =A0 (column=3D737461747573, value=3D5550= , timestamp=3D1290553796836000)=0A=A0=A0 =A0 (column=3D74797065, value=3D4= 86561727462656174, timestamp=3D1290553796836000))=0A=3D> (super_column=3D1= 7108150-f756-11df-1710-8150f75611df,=0A=A0=A0 =A0 (column=3D64617465, valu= e=3D323031302d31312d32332032333a30343a30332e303030, timestamp=3D1290553497= 067000)=0A=A0=A0 =A0 (column=3D65787472615f696e666f, value=3D6e6f6e65, tim= estamp=3D1290553497067000)=0A=A0=A0 =A0 (column=3D726561736f6e, value=3D6e= 6f6e65, timestamp=3D1290553497067000)=0A=A0=A0 =A0 (column=3D7365636f6e647= 35f746f5f6e657874, value=3D373530, timestamp=3D1290553497067000)=0A=A0=A0 = =A0 (column=3D73657269616c, value=3D393135353032353731, timestamp=3D129055= 3497067000)=0A=A0=A0 =A0 (column=3D737461747573, value=3D5550, timestamp=3D= 1290553497067000)=0A=A0=A0 =A0 (column=3D74797065, value=3D486561727462656= 174, timestamp=3D1290553497067000))=0A=3D> (super_column=3D641da730-f755-1= 1df-641d-a730f75511df,=0A=A0=A0 =A0 (column=3D64617465, value=3D323031302d= 31312d32332032323a35393a30332e303030, timestamp=3D1290553196836000)=0A=A0=A0= =A0 (column=3D65787472615f696e666f, value=3D6e6f6e65, timestamp=3D1290553= 196836000)=0A=A0=A0 =A0 (column=3D726561736f6e, value=3D6e6f6e65, timestam= p=3D1290553196836000)=0A=A0=A0 =A0 (column=3D7365636f6e64735f746f5f6e65787= 4, value=3D373530, timestamp=3D1290553196836000)=0A=A0=A0 =A0 (column=3D73= 657269616c, value=3D393135353032353731, timestamp=3D1290553196836000)=0A=A0= =A0 =A0 (column=3D737461747573, value=3D5550, timestamp=3D1290553196836000= )=0A=A0=A0 =A0 (column=3D74797065, value=3D486561727462656174, timestamp=3D= 1290553196836000))=0A=3D> (super_column=3D4bce9420-f753-11df-4bce-9420f753= 11df,=0A=A0=A0 =A0 (column=3D64617465, value=3D323031302d31312d32332032323= a34343a30332e303030, timestamp=3D1290552297060000)=0A=A0=A0 =A0 (column=3D= 65787472615f696e666f, value=3D6e6f6e65, timestamp=3D1290552297060000)=0A=A0= =A0 =A0 (column=3D726561736f6e, value=3D6e6f6e65, timestamp=3D129055229706= 0000)=0A=A0=A0 =A0 (column=3D7365636f6e64735f746f5f6e657874, value=3D37353= 0, timestamp=3D1290552297060000)=0A=A0=A0 =A0 (column=3D73657269616c, valu= e=3D393135353032353731, timestamp=3D1290552297060000)=0A=A0=A0 =A0 (column= =3D737461747573, value=3D5550, timestamp=3D1290552297060000)=0A=A0=A0 =A0 = (column=3D74797065, value=3D486561727462656174, timestamp=3D12905522970600= 00))=0A=0AOn Wed, Dec 1, 2010 at 2:25 PM, Aaron Morton wrote:=0AThe Partitioner applies to the row keys, not the columns. = Their order is determined by the compare_with and compare_subcolumns_with = CF settings=A0=0A=0ASo where you say "get the last 25 inserts for a key" I= 'm translating that into "get the most recent 25 super columns for a row, = where the super column names are UUID's and the CF definition has compare_= with: =A0TimeUUIDType"=A0=0A=0AYou can send a get_slice where the SliceRan= ge has count=3D25 and reversed=3DTrue. If you know the 25th col name you c= an use it as the start param, and AFAIK the operation would go faster. Not= sure how this translates into calls against Pelops.=A0=0A=0AThis assumes = you are using time / v1 UUID's that have an increasing order.=A0=0A=0AHope= that helps.=A0=0A=0AAaron=0A=0A=0A=0AOn 02 Dec, 2010,at 09:19 AM, Frank L= oVecchio wrote:=0A=0AIs it possible to perform pagina= ted queries using Random Partitioner in 0.7 with Super Column Families who= se Super Columns are UUID's? =A0I don't believe it is, based on this artic= le:=A0http://ria101.wordpress.com/2010/02/22/cassandra-randompartitioner-v= s-orderpreservingpartitioner, and my attempts with Pelops.=0A=0ALet's say = I get the last 25 inserts for a key. =A0I now know the 25th Super Column U= UID, and I want to start from there and get the next 25 inserts. =A0Do I h= ave to change over to Order Preserving Partitioner? =A0I'd like to avoid t= his at all costs.=0A=0AThanks,=0A=0AFrank=0A=0A --Apple-Webmail-42--8c749a29-71de-c587-99cc-ea2bb935794b Content-Type: multipart/related; type="text/html"; boundary=Apple-Webmail-86--8c749a29-71de-c587-99cc-ea2bb935794b --Apple-Webmail-86--8c749a29-71de-c587-99cc-ea2bb935794b Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1;
When you say "I want to get rows starting from a Super Column..." it'= s a bit confusing. Do you want to get super columns from a single row, or = multiple rows? I'm assuming you are talking about getting columns from a s= ingle row / key as that's what your code does.

For the p= elops code, it looks OK but I've not used Pelops. You can turn the logging= up on the server and check the command that is sent to it. I'm would gues= s there is something wrong with the way you are transforming the start key=  

For your cli example what was the command= you executed ? 

Aaron

On 02 D= ec, 2010,at 11:03 AM, Frank LoVecchio <frank@isidorey.com> wrote:

=0AHey Aaron, 

=0A

=0AYes, in regards to SCF definition, you are c= orrect:  

=0A

=0Aname: Sensor

=0A

      c= olumn_type: Super

=0A

      compare_wit= h: TimeUUIDType

=0A

      gc_grace_se= conds: 864000

=0A

      keys_cached: = 10000.0

=0A

      read_repair_chance:= 1.0

=0A

      rows_cached: 0.0

=0A

=0AI'm not quite sure I follow you, th= ough, as I think I'm doing what you specify.  The Pelops code is belo= w.  Basically, I want to get rows starting fro= m a Super Column with a specific UUID and limit the number, just as you in= ferred.  When I run this code I just get the last N values (25 in thi= s case) if non-reversed, and the first N values if reversed.  However= , regardless of what start param we use (Super Column UUID is String start= Key below), we still get the same values for the specified amount (e.g. th= e same 25).  
=0A
<= span class=3D"Apple-style-span" style=3D"font-size: 12.5px; " _mce_style=3D= "font-size: 12.5px;">

=0Apublic void getSuperRowKeys(String rowKey, String columnFamily, int<= /b> limit, String startKey) thr= ows Exception {

=0A

=0A

=0A byte[] byteArray =3D UuidHelpe= r.timeUuidStringToBytes(startKey);

=0A ByteBuffer bb =3D B= yteBuffer.wrap(byteArray);

=0A new UUID= (bb.getLong(), bb.getLong());

=0A <= /span>

=0A

=0A List= <SuperColumn> cols =3D selector.getPageOfSuperColumnsFromR= ow(columnFamily, rowKey, Bytes.fromByteBuffer(bb), false, limit, ConsistencyLevel.ONE);

=0A

=0A

=0A

=

=0A for (SuperColumn col : cols) {

=0A = = if (col.getName() !=3D null) {

=0A

=0A System.out.= println("NAME: " + UUID.nameUUIDFromBytes(col.getName())= );

=0A

=0A

for (Column c : col.columns) {

=0A

System.out.println("\t\tName: " + Bytes.toUTF8(c.getName())=0A

" Value: " + Bytes.toUTF8(c.getVa= lue())

=0A

+ " timestamp: " + c.timestamp= );

=0A

=0A

}

=0A

=0A

}

=0A

}

=0A

=0A

}

=0A

Here is some example data from the CLI.  If we spec= ify 2f814d30-f758-11df-2f81-4d30f75811df as the start param (s= econd super column down), we still get 52e6540-f759-11df-952e-6540f75= 911df (first super column) returned.
=0A

=0A
= =3D> (super_column=3D952e6540-f759-11df-952e-6540f75911df,
&n= bsp;    (column=3D64617465, value=3D323031302d31312d32332032333a= 32393a30332e303030, timestamp=3D1290554997141000)
   &= nbsp; (column=3D65787472615f696e666f, value=3D6e6f6e65, timestamp=3D129055= 4997141000)
=0A
     (column=3D726561736f6e, value= =3D6e6f6e65, timestamp=3D1290554997141000)
     (= column=3D7365636f6e64735f746f5f6e657874, value=3D373530, timestamp=3D12905= 54997141000)
     (column=3D73657269616c, value=3D= 393135353032353731, timestamp=3D1290554997141000)
=0A
  = ;   (column=3D737461747573, value=3D5550, timestamp=3D129055499714100= 0)
     (column=3D74797065, value=3D4865617274626= 56174, timestamp=3D1290554997141000))
=3D> (super_column=3D2f= 814d30-f758-11df-2f81-4d30f75811df,
=0A
     (colu= mn=3D64617465, value=3D323031302d31312d32332032333a31393a30332e303030, tim= estamp=3D1290554397060000)
     (column=3D6578747= 2615f696e666f, value=3D6e6f6e65, timestamp=3D1290554397060000)
&= nbsp;    (column=3D726561736f6e, value=3D6e6f6e65, timestamp=3D1= 290554397060000)
=0A
     (column=3D7365636f6e6473= 5f746f5f6e657874, value=3D373530, timestamp=3D1290554397060000)
=      (column=3D73657269616c, value=3D393135353032353731, ti= mestamp=3D1290554397060000)
     (column=3D737461= 747573, value=3D5550, timestamp=3D1290554397060000)
=0A
 &nb= sp;   (column=3D74797065, value=3D486561727462656174, timestamp=3D129= 0554397060000))
=3D> (super_column=3D7c959f00-f757-11df-7c95-= 9f00f75711df,
     (column=3D64617465, value=3D32= 3031302d31312d32332032333a31343a30332e303030, timestamp=3D1290554096881000= )
=0A
     (column=3D65787472615f696e666f, value=3D= 6e6f6e65, timestamp=3D1290554096881000)
     (col= umn=3D726561736f6e, value=3D6e6f6e65, timestamp=3D1290554096881000)
<= div>     (column=3D7365636f6e64735f746f5f6e657874, value=3D= 373530, timestamp=3D1290554096881000)
=0A
     (co= lumn=3D73657269616c, value=3D393135353032353731, timestamp=3D1290554096881= 000)
     (column=3D737461747573, value=3D5550, t= imestamp=3D1290554096881000)
     (column=3D74797= 065, value=3D486561727462656174, timestamp=3D1290554096881000))
=0A=3D> (super_column=3Dc9be6330-f756-11df-c9be-6330f75611df,
     (column=3D64617465, value=3D323031302d31312d323320323= 33a30393a30332e303030, timestamp=3D1290553796836000)
  = ;   (column=3D65787472615f696e666f, value=3D6e6f6e65, timestamp=3D129= 0553796836000)
=0A
     (column=3D726561736f6e, va= lue=3D6e6f6e65, timestamp=3D1290553796836000)
    = ; (column=3D7365636f6e64735f746f5f6e657874, value=3D373530, timestamp=3D12= 90553796836000)
     (column=3D73657269616c, valu= e=3D393135353032353731, timestamp=3D1290553796836000)
=0A
 &= nbsp;   (column=3D737461747573, value=3D5550, timestamp=3D12905537968= 36000)
     (column=3D74797065, value=3D486561727= 462656174, timestamp=3D1290553796836000))
=3D> (super_column=3D= 17108150-f756-11df-1710-8150f75611df,
=0A
     (co= lumn=3D64617465, value=3D323031302d31312d32332032333a30343a30332e303030, t= imestamp=3D1290553497067000)
     (column=3D65787= 472615f696e666f, value=3D6e6f6e65, timestamp=3D1290553497067000)
     (column=3D726561736f6e, value=3D6e6f6e65, timestamp=3D= 1290553497067000)=0A
     (column=3D7365636f6e647= 35f746f5f6e657874, value=3D373530, timestamp=3D1290553497067000)
     (column=3D73657269616c, value=3D393135353032353731, t= imestamp=3D1290553497067000)
     (column=3D73746= 1747573, value=3D5550, timestamp=3D1290553497067000)
=0A
 &n= bsp;   (column=3D74797065, value=3D486561727462656174, timestamp=3D12= 90553497067000))
=3D> (super_column=3D641da730-f755-11df-641d= -a730f75511df,
     (column=3D64617465, value=3D3= 23031302d31312d32332032323a35393a30332e303030, timestamp=3D129055319683600= 0)
=0A
     (column=3D65787472615f696e666f, value=3D= 6e6f6e65, timestamp=3D1290553196836000)
     (col= umn=3D726561736f6e, value=3D6e6f6e65, timestamp=3D1290553196836000)
<= div>     (column=3D7365636f6e64735f746f5f6e657874, value=3D= 373530, timestamp=3D1290553196836000)=0A
     (co= lumn=3D73657269616c, value=3D393135353032353731, timestamp=3D1290553196836= 000)
     (column=3D737461747573, value=3D5550, t= imestamp=3D1290553196836000)
     (column=3D74797= 065, value=3D486561727462656174, timestamp=3D1290553196836000))
=0A=3D> (super_column=3D4bce9420-f753-11df-4bce-9420f75311df,     (column=3D64617465, value=3D323031302d31312d323320323= 23a34343a30332e303030, timestamp=3D1290552297060000)
  = ;   (column=3D65787472615f696e666f, value=3D6e6f6e65, timestamp=3D129= 0552297060000)
=0A
     (column=3D726561736f6e, va= lue=3D6e6f6e65, timestamp=3D1290552297060000)
    = ; (column=3D7365636f6e64735f746f5f6e657874, value=3D373530, timestamp=3D12= 90552297060000)
     (column=3D73657269616c, valu= e=3D393135353032353731, timestamp=3D1290552297060000)
=0A
 &= nbsp;   (column=3D737461747573, value=3D5550, timestamp=3D12905522970= 60000)
     (column=3D74797065, value=3D486561727= 462656174, timestamp=3D1290552297060000))

On Wed, Dec 1, 2010 at 2:25 PM, Aaron Morton &= lt;aaron@thelastpickle.com> wrote:
=0A
The Partitioner applies to = the row keys, not the columns. Their order is determined by the compare_wi= th and compare_subcolumns_with CF settings 
=0A

So where you say "get the last 25 inserts for a key" I'm translating th= at into "get the most recent 25 super columns for a row, where the super c= olumn names are UUID's and the CF definition has compare_with:  TimeU= UIDType" 
=0A
You can send a get_slice where the Sli= ceRange has count=3D25 and reversed=3DTrue. If you know the 25th col name = you can use it as the start param, and AFAIK the operation would go faster= Not sure how this translates into calls against Pelops. 
=0A
This assumes you are using time / v1 UUID's that have an= increasing order. 

Hope that helps. 

Aaron

=0A


On 02 Dec, 2010,a= t 09:19 AM, Frank LoVecchio <frank@isidorey.com> wrote:

=0A=0A= =0A

Let's say I get the last 25 ins= erts for a key.  I now know the 25th Super Column UUID, and I want to= start from there and get the next 25 inserts.  Do I have to change o= ver to Order Preserving Partitioner?  I'd like to avoid this at all c= osts.
=0A=0A

Thanks,
=0A
F= rank
=0A

=0A --Apple-Webmail-86--8c749a29-71de-c587-99cc-ea2bb935794b-- --Apple-Webmail-42--8c749a29-71de-c587-99cc-ea2bb935794b--