Use a timestamp instead of 2 separate fields and you can query on the range.
CREATE TABLE mytable (
sensorname text,
reading_time timestamp,
data MAP<text, int>,
PRIMARY KEY (sensorname, reading_time)
);
On Fri, Aug 26, 2016 at 8:17 PM Peter Figliozzi <[email protected]>
wrote:
> 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
>