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