Need help with simple schema for time-series

[Peter Figliozzi]

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