I don't believe that would let me query a time of day range, over a date
range, would it? For example, between 8am and 9am, August 1st through
August 10th.
On Fri, Aug 26, 2016 at 11:52 PM, Jonathan Haddad <j...@jonhaddad.com> wrote:
> 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 <pete.figlio...@gmail.com>
> 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
>>
>
