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 6DBE09140 for ; Mon, 19 Mar 2012 13:42:04 +0000 (UTC) Received: (qmail 35392 invoked by uid 500); 19 Mar 2012 13:42:02 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 35366 invoked by uid 500); 19 Mar 2012 13:42: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 35358 invoked by uid 99); 19 Mar 2012 13:42:02 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Mar 2012 13:42:02 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of michael.cherkasov@gmail.com designates 209.85.213.172 as permitted sender) Received: from [209.85.213.172] (HELO mail-yx0-f172.google.com) (209.85.213.172) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Mar 2012 13:41:54 +0000 Received: by yenm5 with SMTP id m5so6151194yen.31 for ; Mon, 19 Mar 2012 06:41:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=nZUMgJ08z97uhTexLjdFdRgqA9OMcbmIgjHgqrMn2sg=; b=d16tc9/AhmXOU420QRSUcKwZ1zOc8cx6dNkFp9ykgc+pEmaArkPIfIEt/JKo1kIqG+ xd4eJzzMWtk02adAO06FBV+aDBG4e0lpswh4a/Za9/o23qlaPPumGEkFrLfhSdTsnh9B XccnBAdEzwuXRRzE58eiv45Kc5ZQokVB5X50UINXYTQt4/g2NXh7X67+PbR4zi3XL7hN jc83IZtyDsZnTeZgRzPtGLZfyKZRTfZdsKxkmw/lLSDpG3Zrpt0Yf6Zhpg7AWL48n/bS EQNj0rqnZdOxJyZ7yQRYOFBpQ7GE8ZvhKJX0MfgfuyN8msvPwho+Qp9dijOoZs+ddAoU 1aOg== Received: by 10.68.191.230 with SMTP id hb6mr40261694pbc.87.1332164493419; Mon, 19 Mar 2012 06:41:33 -0700 (PDT) MIME-Version: 1.0 Received: by 10.143.157.15 with HTTP; Mon, 19 Mar 2012 06:41:13 -0700 (PDT) In-Reply-To: References: From: Michael Cherkasov Date: Mon, 19 Mar 2012 17:41:13 +0400 Message-ID: Subject: Re: Get few rows by composite key. To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=e89a8ff1c07869a3b904bb98b7f1 X-Virus-Checked: Checked by ClamAV on apache.org --e89a8ff1c07869a3b904bb98b7f1 Content-Type: text/plain; charset=ISO-8859-1 Also one more question: Can someone show query that will fetch all rows match to this condition: ( AA:(part 2>= BB) ) or ( key == (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 > more or equal BB? > I'm interesting about Hector code. > --e89a8ff1c07869a3b904bb98b7f1 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Also one more question:
Can someone show query that will fetch all rows= match to this condition: =A0( AA:(part 2>=3D BB) =A0) or ( key =3D=3D (= BB:CC) )

2012/3/19 Michael Cherkasov <michael.ch= erkasov@gmail.com>
Hello,=A0
Assume that we have table like= this one:

Key: =A0 =A0 =A0 =A0Columns names:
AA:AA =A0 =A0 1:A 1:B 1:C 2:A 2:C =A0
AA:BB =A0 =A0=A01:C 2:A 2:C
AA:CC =A0 =A0=A02:A 2:C
AA:DD =A0 =A0=A01:A 1:B 1:C
BB:AA =A0 =A0=A01:A 1:B 2:C
BB:BB =A0 =A0=A01:A 1:B 1:C 2:C<= /div>
BB:CC =A0 =A0=A01:A =A02:A 2:C
BB:DD =A0 =A0=A01:A =A01= :C 2:A 2:C

Is there any way to take rows with firs= t key's part equals AA and second more or equal BB?
I'm=A0interesting=A0about Hector code.

--e89a8ff1c07869a3b904bb98b7f1--