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 3878F9293 for ; Mon, 19 Mar 2012 13:44:05 +0000 (UTC) Received: (qmail 44471 invoked by uid 500); 19 Mar 2012 13:44:02 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 44448 invoked by uid 500); 19 Mar 2012 13:44:02 -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 44439 invoked by uid 99); 19 Mar 2012 13:44:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Mar 2012 13:44:02 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of Stephen.Pope@quest.com designates 12.106.87.93 as permitted sender) Received: from [12.106.87.93] (HELO alvetxw01.quest.com) (12.106.87.93) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Mar 2012 13:43:56 +0000 Received: from ALVHTXW01.prod.quest.corp (10.1.135.17) by alvetxw01.quest.com (10.1.100.93) with Microsoft SMTP Server (TLS) id 14.1.355.2; Mon, 19 Mar 2012 06:41:29 -0700 Received: from ALVMBXW01.prod.quest.corp ([fe80::48dd:e065:86b3:9cee]) by ALVHTXW01.prod.quest.corp ([::1]) with mapi id 14.01.0355.002; Mon, 19 Mar 2012 06:43:35 -0700 From: Stephen Pope To: "user@cassandra.apache.org" Subject: RE: Get few rows by composite key. Thread-Topic: Get few rows by composite key. Thread-Index: AQHNBdSPuDnuXySYzUWnJspHGkmrl5ZxoImw Date: Mon, 19 Mar 2012 13:43:34 +0000 Message-ID: <654A67E918314D418D96AC894A5B0F0D209D61@ALVMBXW01.prod.quest.corp> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.4.60.53] Content-Type: multipart/alternative; boundary="_000_654A67E918314D418D96AC894A5B0F0D209D61ALVMBXW01prodques_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_654A67E918314D418D96AC894A5B0F0D209D61ALVMBXW01prodques_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I'm not sure about Hector code (somebody else can chime in here), but to fi= nd the keys you're after you can slice to get the keys from AA:BB to BB:AA. Cheers, Steve From: Michael Cherkasov [mailto:michael.cherkasov@gmail.com] Sent: Monday, March 19, 2012 9:30 AM To: user@cassandra.apache.org Subject: Get few rows by composite key. Hello, Assume that we have table like this one: Key: Columns names: AA:AA 1:A 1:B 1:C 2:A 2:C AA:BB 1:C 2:A 2:C AA:CC 2:A 2:C AA:DD 1:A 1:B 1:C BB:AA 1:A 1:B 2:C BB:BB 1:A 1:B 1:C 2:C BB:CC 1:A 2:A 2:C BB:DD 1:A 1:C 2:A 2:C Is there any way to take rows with first key's part equals AA and second mo= re or equal BB? I'm interesting about Hector code. --_000_654A67E918314D418D96AC894A5B0F0D209D61ALVMBXW01prodques_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I’m not sure about = Hector code (somebody else can chime in here), but to find the keys youR= 17;re after you can slice to get the keys from AA:BB to BB:AA.

<= /p>

Cheers,=

Steve

<= /p>

From: Michael = Cherkasov [mailto:michael.cherkasov@gmail.com]
Sent: Monday, March 19, 2012 9:30 AM
To: user@cassandra.apache.org
Subject: Get few rows by composite key.

Hello,

Assume that we have table like this one:<= /p>

Key: Columns names:<= /o:p>

AA:AA 1:A 1:B 1:C 2:A 2:C <= /o:p>

AA:BB 1:C 2:A 2:C

AA:CC 2:A 2:C

AA:DD 1:A 1:B 1:C

BB:AA 1:A 1:B 2:C

BB:BB 1:A 1:B 1:C 2:C<= /p>

BB:CC 1:A 2:A 2:C

BB:DD 1:A 1:C 2:A 2:C<= /o:p>

Is there any way to take rows with first key's part = equals AA and second more or equal BB?

I'm interesting about Hector code.

--_000_654A67E918314D418D96AC894A5B0F0D209D61ALVMBXW01prodques_--