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 D93A492C3 for ; Mon, 19 Mar 2012 13:45:31 +0000 (UTC) Received: (qmail 49189 invoked by uid 500); 19 Mar 2012 13:45:29 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 49122 invoked by uid 500); 19 Mar 2012 13:45:29 -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 49114 invoked by uid 99); 19 Mar 2012 13:45:29 -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:45:29 +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.94 as permitted sender) Received: from [12.106.87.94] (HELO alvetxw02.quest.com) (12.106.87.94) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Mar 2012 13:45:23 +0000 Received: from ALVHTXW03.prod.quest.corp (10.1.135.19) by alvetxw02.quest.com (10.1.100.94) with Microsoft SMTP Server (TLS) id 14.1.355.2; Mon, 19 Mar 2012 06:31:38 -0700 Received: from ALVMBXW01.prod.quest.corp ([fe80::48dd:e065:86b3:9cee]) by ALVHTXW03.prod.quest.corp ([::1]) with mapi id 14.01.0355.002; Mon, 19 Mar 2012 06:45:02 -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: AQHNBdSPuDnuXySYzUWnJspHGkmrl5ZyFZaA//+LdtA= Date: Mon, 19 Mar 2012 13:45:01 +0000 Message-ID: <654A67E918314D418D96AC894A5B0F0D209D72@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_654A67E918314D418D96AC894A5B0F0D209D72ALVMBXW01prodques_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_654A67E918314D418D96AC894A5B0F0D209D72ALVMBXW01prodques_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Those are going to have to be separate queries, since the first is a slice,= and the second is a fetch. Cheers, Steve From: Michael Cherkasov [mailto:michael.cherkasov@gmail.com] Sent: Monday, March 19, 2012 9:41 AM To: user@cassandra.apache.org Subject: Re: Get few rows by composite key. Also one more question: Can someone show query that will fetch all rows match to this condition: (= AA:(part 2>=3D BB) ) or ( key =3D=3D (BB:CC) ) 2012/3/19 Michael Cherkasov > 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_654A67E918314D418D96AC894A5B0F0D209D72ALVMBXW01prodques_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Those are going to have t= o be separate queries, since the first is a slice, and the second is a fetc= h.

 <= /p>

Cheers,=

Steve

 <= /p>

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

 

Also one more question:

Can someone show quer= y that will fetch all rows match to this condition:  ( AA:(part 2>= =3D BB)  ) or ( key =3D=3D (BB:CC) )

2012/3/19 Michael Cherkasov <michael.cherkasov@gmail.com>

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_654A67E918314D418D96AC894A5B0F0D209D72ALVMBXW01prodques_--