http://kairosdb.github.io/
Regards,
Noorul
Peter Figliozzi <pete.figlio...@gmail.com> writes:
> I have data from many sensors as time-series:
>
> - Sensor name
> - Date
> - Time
> - value
>
> I want to query windows of both date and time. For example, 8am - 9am from
> Aug. 1st to Aug 10th.
>
> Here's what I did:
>
> CREATE TABLE mykeyspace.mytable (
> sensorname text,
> date date,
> time time,
> data MAP<text, int>,
> PRIMARY KEY (sensorname, date, time)
> );
>
>
> However, when we query this, Cassandra restricts us to an "equal" relation
> for the date, if we are to select a window of time. So with that schema,
> I'd have to query once for each date.
>
>
> What's the right way to do this?? ("Right" defined as extracting a window
> of date and of time in one query.)
>
>
> Thank you,
>
>
> Pete
