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: local policy includes SPF record at
 spf.trusted-forwarder.org)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 7.1 \(1827\))
Subject: Re: querying time series from hadoop
From: Aaron Morton <aaron@thelastpickle.com>
In-Reply-To: 
 <CA+dzhKBGADjOYx+1tTXamgMTx2TJsxNJToyDnkNqBFpTKS6+ig@mail.gmail.com>
Date: Tue, 31 Dec 2013 15:11:22 +1300
Content-Transfer-Encoding: quoted-printable
Message-Id: <7DE7BC71-01FB-4144-9298-2735D926A786@thelastpickle.com>
References: 
 <CA+dzhKBGADjOYx+1tTXamgMTx2TJsxNJToyDnkNqBFpTKS6+ig@mail.gmail.com>
To: Cassandra User <user@cassandra.apache.org>

> 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.
That patch in CASSANDRA-6311 is for 2.0 you cannot apply it to 1.2

> 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  ColumnFamilyRecordReader is designed to read lots of rows, not a =
single row.=20

You should be able to use the java driver from a hadoop task though to =
read a single row. Can you provide some more info on what you are doing =
?=20

Cheers

-----------------
Aaron Morton
New Zealand
@aaronmorton

Co-Founder & Principal Consultant
Apache Cassandra Consulting
http://www.thelastpickle.com

On 26/12/2013, at 9:56 pm, mete <efkarr@gmail.com> wrote:

> Hello  folks,=20
>=20
> i have come up with a basic time series cql schema based on the =
articles here:
>=20
> http://www.datastax.com/dev/blog/advanced-time-series-with-cassandra
>=20
> so simply put its something like:
>=20
> rowkey, timestamp, col3, col4 etc...=20
>=20
> where rowkey and timestamp are compound keys.
>=20
> Where i am having issues is to efficiently query this data structure.=20=

>=20
> When i use cqlsh and query it is perfectly fine:
>=20
> select * from table where rowkey=3D'row key' and date > xxx and date =
<=3D yyy
>=20
> 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.
>=20
> The issue that i am having is discussed here:
>=20
> =
http://stackoverflow.com/questions/19189649/composite-key-in-cassandra-wit=
h-pig
>=20
> 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.
>=20
> 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)
>=20
> Does anyone has a similar issue? Any pointers are welcome.
>=20
> Regards
> Mete
>=20
>=20
>=20
>=20