Thanks for reply Sean. same applies for aggregate by hour as well.?
SELECT SUM(value) FROM campaignstats WHERE event='sent' AND
channel='browser_push' And time >= '2016-11-03T18:30:00Z' AND time <
'2016-11-12T17:07:34.236639Z' GROUP BY time(1h)
result value starting from 6:00:00Z
For any aggregation period, the timestamp returned is the beginning of the
bucket. Regardless of the WHERE time clauses, the buckets start on
pre-determined boundaries unless explicitly shifted.
See
http://docs.influxdata.com/influxdb/v1.0/query_language/data_exploration/#group-by-time-intervals
Hello,
I'd like to use InfluxDB to store IoT data from sensors at home and I have
a OmniOS/illumos (opensolaris derivative) server for that.
However, compiling go under illumos is difficult, it would require
compiling the compiler first, and so on.
I would like to use my Windows PC + Go 1.7.x
I am trying to use influxdb relay in AWS. I am using ELB in the front of
inflxudb-relay processes but problem is that ELB requires health check for
backend services i.e., influxdb relay needs to respond to GET from ELB.
I looked into influxdb-rely code in github but i didnt see any /ping like
Hi
I resolved the problem. It turns out it was the Java client.
I downgraded the client one version and changed the way I was batching and the
problem resolved.
Super fast now with virtually no CPU overhead
Thanks for your help
Steve
--
Remember to include the version number!
---
You