Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of ramya.1255@gmail.com designates
 209.85.216.53 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAPqEvGG1mQWNvH0AfuuuB1ARPri_Op5cJ81xq88J+DmF3+Hsng@mail.gmail.com>
References: 
 <CAK=52a_MQT01Vm_LPGfem5YrkPmO+--bxpXQkt_SztreqH8=Gg@mail.gmail.com>
	<CAPqEvGG1mQWNvH0AfuuuB1ARPri_Op5cJ81xq88J+DmF3+Hsng@mail.gmail.com>
Date: Fri, 3 May 2013 10:29:22 +0530
Message-ID: 
 <CAK=52a8ViDD9p-PR6ochac9+tHvQVejFm7-CkwU5+s_VcrhprA@mail.gmail.com>
Subject: Re: cql query
From: Sri Ramya <ramya.1255@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=047d7b6783ace15b4e04dbc936a8

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

thank you very much. i will try and let you know whether its working or not


On Thu, May 2, 2013 at 7:04 PM, Jabbar Azam <ajazam@gmail.com> wrote:

> Hello Sri,
>
> As far as I know you can if name and age are part of your partition key
> and timestamp is the cluster key e.g.
>
> create table columnfamily (
>     name varchar,
>     age varchar,
>     tstamp timestamp,
>    partition key((name, age), tstamp)
> );
>
>
>
>
> Thanks
>
> Jabbar Azam
>
>
> On 2 May 2013 11:45, Sri Ramya <ramya.1255@gmail.com> wrote:
>
>> hi
>>
>> Can some body tell me is it possible to to do multiple query on cassandra
>> like "Select * from columnfamily where name='foo' and age ='21' and
>> timestamp >= 'unixtimestamp' ";
>>
>> Please tell me some guidence for these kind of queries
>>
>>   Thank you
>>
>
>

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

thank you very much. i will try and let you know whether its working or not=
<br><br><br><div class=3D"gmail_quote">On Thu, May 2, 2013 at 7:04 PM, Jabb=
ar Azam <span dir=3D"ltr">&lt;<a href=3D"mailto:ajazam@gmail.com" target=3D=
"_blank">ajazam@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div><div><div><div><div><d=
iv>Hello Sri,<br><br></div>As far as I know you can if name and age are par=
t of your partition key and timestamp is the cluster key e.g.<br>
<br></div>create table columnfamily (<br>
</div>=A0=A0=A0 name varchar,<br></div>=A0=A0=A0 age varchar,<br></div>=A0=
=A0=A0 tstamp timestamp,<br></div>=A0=A0 partition key((name, age), tstamp)=
<br><div><div><div><div><div>);<br><br><br><div><div><div><br></div></div><=
/div></div></div></div>

</div></div><div class=3D"gmail_extra"><br clear=3D"all"><div><div dir=3D"l=
tr">Thanks<span class=3D"HOEnZb"><font color=3D"#888888"><br><br>Jabbar Aza=
m<br></font></span></div></div><div><div class=3D"h5">
<br><br><div class=3D"gmail_quote">On 2 May 2013 11:45, Sri Ramya <span dir=
=3D"ltr">&lt;<a href=3D"mailto:ramya.1255@gmail.com" target=3D"_blank">ramy=
a.1255@gmail.com</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote"=
 style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

hi<br><br>Can some body tell me is it possible to to do multiple query on c=
assandra<br>like &quot;Select * from columnfamily where name=3D&#39;foo&#39=
; and age =3D&#39;21&#39; and timestamp &gt;=3D &#39;unixtimestamp&#39; &qu=
ot;;<br>


<br>Please tell me some guidence for these kind of queries<br><br>=A0 Thank=
 you <br>
</blockquote></div><br></div></div></div></div>
</blockquote></div><br>

--047d7b6783ace15b4e04dbc936a8--