Re: [influxdb] Measurement Schema Design

2016-09-30 Thread Sean Beckett
On Fri, Sep 30, 2016 at 9:50 AM, Sean Fitts wrote: > Sean, hi. > > Thanks for the responses. If you have the time I have some follow-ups > below... > > On Thursday, September 29, 2016 at 8:25:23 PM UTC-7, Sean Beckett wrote: >> >> For multi-tenant my first thought is each tenant gets their own d

Re: [influxdb] Measurement Schema Design

2016-09-30 Thread Sean Fitts
Sean, hi. Thanks for the responses. If you have the time I have some follow-ups below... On Thursday, September 29, 2016 at 8:25:23 PM UTC-7, Sean Beckett wrote: > > For multi-tenant my first thought is each tenant gets their own database. > It does lead to significant series duplication, but

Re: [influxdb]

2016-09-30 Thread nathaniel
The stats show that Kapacitor is receiving data for the _kapacitor database which is internal to Kapacitor but it is not receiving any data from InfluxDB. Can you share the output of `show subscriptions` and `show databases` on the InfluxDB host? On Thursday, September 29, 2016 at 4:30:39 PM U

Re: [influxdb] Possible to take derivative of time?

2016-09-30 Thread William Cork
Exactly what I needed. For future reference, this worked great: > SELECT DERIVATIVE(ELAPSED(value),1u) FROM BPM WHERE pvName = 'BR1:BPM2:ADC0:clip' AND time > '2016-09-12T18:03:27.012265443Z' and time < '2016-09-12T18:08:04.808883428Z' GROUP BY time(1u) name: BPM - time derivative 2016-0