From user-return-33243-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Fri Apr 5 17:00:12 2013 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 F37FAF157 for ; Fri, 5 Apr 2013 17:00:11 +0000 (UTC) Received: (qmail 17561 invoked by uid 500); 5 Apr 2013 17:00:09 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 17541 invoked by uid 500); 5 Apr 2013 17:00:09 -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 17530 invoked by uid 99); 5 Apr 2013 17:00:09 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Apr 2013 17:00:09 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,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-a80.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Apr 2013 17:00:02 +0000 Received: from homiemail-a80.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a80.g.dreamhost.com (Postfix) with ESMTP id 30A9137A078 for ; Fri, 5 Apr 2013 09:59:41 -0700 (PDT) Received: from [10.65.15.205] (unknown [59.164.97.108]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a80.g.dreamhost.com (Postfix) with ESMTPSA id DA02A37A020 for ; Fri, 5 Apr 2013 09:59:39 -0700 (PDT) From: aaron morton Content-Type: multipart/alternative; boundary="Apple-Mail=_66DD58BC-527C-4CF4-A887-CA39918E4100" Message-Id: <86A55CA2-F303-4EE1-8B32-CF0C6E73956D@thelastpickle.com> Mime-Version: 1.0 (Mac OS X Mail 6.2 \(1499\)) Subject: Re: Data Model and Query Date: Fri, 5 Apr 2013 22:29:35 +0530 References: To: user@cassandra.apache.org In-Reply-To: X-Mailer: Apple Mail (2.1499) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_66DD58BC-527C-4CF4-A887-CA39918E4100 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 > Whats the recommendation on querying a data model like StartDate > = =93X=94 and counter > =93Y=94 . >=20 >=20 it's not possible.=20 If you are using secondary indexes you have to have an equals clause in = the statement.=20 Cheers ----------------- Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 4/04/2013, at 6:53 AM, shubham srivastava = wrote: > Hi, >=20 > =20 > Whats the recommendation on querying a data model like StartDate > = =93X=94 and counter > =93Y=94 . Its kind of range queries across = multiple columns and key. >=20 > I have the flexibility for modelling the data for the above query = accordingly. >=20 >=20 > =20 > Regards, >=20 > Shubham >=20 --Apple-Mail=_66DD58BC-527C-4CF4-A887-CA39918E4100 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252

Whats the = recommendation on querying a data model like  StartDate > =93X=94 = and counter > =93Y=94 .


it's not = possible. 

If you are using secondary indexes = you have to have an equals clause in the = statement. 

Cheers

http://www.thelastpickle.com

On 4/04/2013, at 6:53 AM, shubham srivastava <shubham.k@gmail.com> = wrote:

Hi,

 

Whats the = recommendation on querying a data model like  StartDate > =93X=94 = and counter > =93Y=94 . Its kind of range queries across multiple = columns and key.

I have the flexibility for modelling = the data for the above query accordingly.


 

Regards,

Shubham


= --Apple-Mail=_66DD58BC-527C-4CF4-A887-CA39918E4100--