Return-Path: 
 <user-return-37738-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
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 3740F105FF
	for <apmail-cassandra-user-archive@www.apache.org>;
 Thu, 28 Nov 2013 05:18:33 +0000 (UTC)
Received: (qmail 10228 invoked by uid 500); 28 Nov 2013 05:18:28 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 10182 invoked by uid 500); 28 Nov 2013 05:18:21 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 10172 invoked by uid 99); 28 Nov 2013 05:18:18 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Nov 2013 05:18:18 +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 (athena.apache.org: domain of
 ravikumar.govindarajan@gmail.com designates 209.85.214.44 as permitted
 sender)
Received: from [209.85.214.44] (HELO mail-bk0-f44.google.com) (209.85.214.44)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Nov 2013 05:18:13 +0000
Received: by mail-bk0-f44.google.com with SMTP id d7so3626011bkh.3
        for <user@cassandra.apache.org>; Wed, 27 Nov 2013 21:17:52 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=bNK1sKiN/wo77s2paMXc5/jrTCB5XboIvVBBvp8GSFc=;
        b=svo2t1PXITt92r56gf1IfW15/DNIDSIYYdaGUh28mu7XK+qel6Fc1H9D4TbeN9f4Z7
         RaGhqXB9YCP7T+zQYWDtloF8sWCoo2saXhLg1QJRAk/OARPrLamQgGyD1zZfznL0ttXc
         4AkNQH4iFZBoVuhRFl0Bv3+yD0IQE4gaChYK8bsep4a554wiP86zwxnfoy56XqjNfIkr
         wCuDzEYRQaOu1WcTIRV/SG1oqrP/FQOMX8Aq5ovfJDXtFmdWB7n74+IkcPjHDM6g/o08
         swTqRxsxR5SyLU6uAqfyuSdLbkyfAY6y4dJ16vOK/smuqg4zH/DAY8TUH31E4vq5GHI7
         AG1Q==
MIME-Version: 1.0
X-Received: by 10.204.118.67 with SMTP id u3mr3888684bkq.41.1385615872145;
 Wed, 27 Nov 2013 21:17:52 -0800 (PST)
Received: by 10.205.102.198 with HTTP; Wed, 27 Nov 2013 21:17:52 -0800 (PST)
Date: Thu, 28 Nov 2013 10:47:52 +0530
Message-ID: 
 <CAGW2whRV55hfBjFJHiSoxUEgMTJEVWBg=qAx9Y2uiJv66B+SHQ@mail.gmail.com>
Subject: Multi-range of composite query possible?
From: Ravikumar Govindarajan <ravikumar.govindarajan@gmail.com>
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=047d7bea4532dae12b04ec35d5f9
X-Virus-Checked: Checked by ClamAV on apache.org

--047d7bea4532dae12b04ec35d5f9
Content-Type: text/plain; charset=ISO-8859-1

We have the following structure in a composite CF, comprising 2 parts

Key=123  -> A:1, A:2, A:3,B:1, B:2, B:3, B:4, C:1, C:2, C:3,....

Our application provides the following inputs for querying on the
first-part of composite column

key=123, [(colName=A, range=2), (colName=B, range=3), (colName=C, range=1)]

The below output is desired

key=123 --> A:1, A:2 [Get first 2 composite cols for prefix 'A']

                   B:1, B:2, B:3 [Get first 3 composite cols for prefix 'B']

                   C:1 [Get the first composite col for prefix 'C']

I see that this akin to a "range-of-range" query via composite columns. Is
something like this possible in cassandra, may be in latest versions?

--
Ravi

--047d7bea4532dae12b04ec35d5f9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">We have the following structure in a composite CF, compris=
ing 2 parts<div><br></div><div>Key=3D123 =A0-&gt; A:1, A:2, A:3,B:1, B:2, B=
:3, B:4, C:1, C:2, C:3,....</div><div><br></div><div>Our application provid=
es the following inputs for querying on the first-part of composite column<=
/div>
<div><br></div><div>key=3D123, [(colName=3DA, range=3D2), (colName=3DB, ran=
ge=3D3), (colName=3DC, range=3D1)]</div><div><br></div><div><div>The below =
output is desired</div><div><br></div><div>key=3D123 --&gt; A:1, A:2 [Get f=
irst 2 composite cols for prefix &#39;A&#39;]</div>
<div><br></div><div>=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0B:1, B:2, B:3 [G=
et first 3 composite cols for prefix &#39;B&#39;]</div><div><br></div><div>=
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0C:1 [Get the first composite col for=
 prefix &#39;C&#39;]</div></div><div>
<br></div><div>I see that this akin to a &quot;range-of-range&quot; query v=
ia composite columns. Is something like this possible in cassandra, may be =
in latest versions?=A0</div><div><br></div><div>--</div><div>Ravi</div></di=
v>

--047d7bea4532dae12b04ec35d5f9--