.. and time >= '11:00:00'
> ... and time <= '14:00:00'
> ... allow filtering;
>
> sensorname | date | time | data
> ++---
> range.
>
> CREATE TABLE mytable (
> sensorname text,
> reading_time timestamp,
> data MAP,
> PRIMARY KEY (sensorname, reading_time)
> );
>
>
>
> On Fri, Aug 26, 2016 at 8:17 PM Peter Figliozzi
> wrote:
>
>> I have data from many sen
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,
