Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of efkarr@gmail.com designates
 209.85.213.169 as permitted sender)
MIME-Version: 1.0
Date: Thu, 26 Dec 2013 10:56:53 +0200
Message-ID: 
 <CA+dzhKBGADjOYx+1tTXamgMTx2TJsxNJToyDnkNqBFpTKS6+ig@mail.gmail.com>
Subject: querying time series from hadoop
From: mete <efkarr@gmail.com>
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a11c1e3d4ae51ae04ee6c2866

--001a11c1e3d4ae51ae04ee6c2866
Content-Type: text/plain; charset=ISO-8859-1

Hello  folks,

i have come up with a basic time series cql schema based on the articles
here:

http://www.datastax.com/dev/blog/advanced-time-series-with-cassandra

so simply put its something like:

rowkey, timestamp, col3, col4 etc...

where rowkey and timestamp are compound keys.

Where i am having issues is to efficiently query this data structure.

When i use cqlsh and query it is perfectly fine:

select * from table where rowkey='row key' and date > xxx and date <= yyy

but when i am using the java driver, the driver already uses row key for
token statements and i cannot execute the query above, therefore it does a
full scan of rows.

The issue that i am having is discussed here:

http://stackoverflow.com/questions/19189649/composite-key-in-cassandra-with-pig

i have gone through the relevant jira issues 6151 and 6311. This behaviour
is supposed to be fixed in 2.0.x but so far it is not there. So now i will
try to patch my cassandra 1.2.11 installation but i just wanted to ask you
guys first, if there is any other solution that does not involve a release.

i assume that this is somewhat a common use case, the articles i referred
seems to be old enough and unless i am missing something obvious i cannot
query this schema efficiently with the current version (1.2.x or 2.0.x)

Does anyone has a similar issue? Any pointers are welcome.

Regards
Mete

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

<div dir=3D"ltr">Hello =A0folks,=A0<div><br></div><div>i have come up with =
a basic time series cql schema based on the articles here:</div><div><br></=
div><div><a href=3D"http://www.datastax.com/dev/blog/advanced-time-series-w=
ith-cassandra">http://www.datastax.com/dev/blog/advanced-time-series-with-c=
assandra</a><br>
</div><div><br></div><div>so simply put its something like:</div><div><br><=
/div><div>rowkey, timestamp, col3, col4 etc...=A0</div><div><br></div><div>=
where=A0rowkey=A0and timestamp are compound keys.</div><div><br></div><div>=
Where i am having issues is to efficiently query this data structure.=A0</d=
iv>
<div><br></div><div>When i use cqlsh and query it is perfectly fine:</div><=
div><br></div><div>select * from table where rowkey=3D&#39;row key&#39; and=
 date &gt; xxx and date &lt;=3D yyy</div><div><br></div><div>but when i am =
using the java driver, the driver already uses row key for token statements=
 and i cannot execute the query above, therefore it does a full scan of row=
s.</div>
<div><br></div><div>The issue that i am having is discussed here:</div><div=
><br></div><div><a href=3D"http://stackoverflow.com/questions/19189649/comp=
osite-key-in-cassandra-with-pig">http://stackoverflow.com/questions/1918964=
9/composite-key-in-cassandra-with-pig</a><br>
</div><div><br></div><div>i have gone through the relevant jira issues 6151=
 and 6311. This behaviour is supposed to be fixed in 2.0.x but so far it is=
 not there. So now i will try to patch my cassandra 1.2.11 installation but=
 i just wanted to ask you guys first, if there is any other solution that d=
oes not involve a release.</div>
<div><br></div><div>i assume that this is somewhat a common use case, the a=
rticles i referred seems to be old enough and unless i am missing something=
 obvious i cannot query this schema efficiently with the current version (1=
.2.x or 2.0.x)</div>
<div><br></div><div>Does anyone has a similar issue? Any pointers are welco=
me.</div><div><br></div><div>Regards</div><div>Mete</div><div><br></div><di=
v><br></div><div><br></div><div><br></div></div>

--001a11c1e3d4ae51ae04ee6c2866--