http://kairosdb.github.io/
Regards,
Noorul
Peter Figliozzi writes:
> 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
Thanks, guys, for your help. I tried the filtering method and it works
great.
Sincerely,
Pete
On Sat, Aug 27, 2016 at 12:36 AM, Jonathan Haddad wrote:
> Ah, i see what you're looking for. No, my schema wouldn't work for that.
> I had read through your question a little quickly.
>
> In cassandr
Ah, i see what you're looking for. No, my schema wouldn't work for that.
I had read through your question a little quickly.
In cassandra 3.5 support was added for more flexible ALLOW FILTERING
statements. Here's an example:
CREATE TABLE mytable (
sensorname text,
date date,
time tim
Figliozzi
Reply-To: "user@cassandra.apache.org"
Date: Friday, August 26, 2016 at 10:02 PM
To: "user@cassandra.apache.org"
Subject: Re: Need help with simple schema for time-series
I don't believe that would let me query a time of day range, over a date range,
would it?
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 wrote:
> Use a timestamp instead of 2 separate fields and you can query on the
> range.
>
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,
PRIMARY KEY (sensorname, reading_time)
);
On Fri, Aug 26, 2016 at 8:17 PM Peter Figliozzi
wrote:
> I have data from many senso
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,
