Re: [influxdb] Not able to view new measurement after creating continuous query

2016-10-12 Thread Sean Beckett
Does SELECT sum("value") as Sumin FROM "data" where metric = 'In_bits' GROUP BY time(15m) return the values you expect? Can you share actual CLI or curl output? This seems like a syntax issue. On Wed, Oct 12, 2016 at 3:00 PM, wrote: > On Wednesday, October 12,

Re: [influxdb] Not able to view new measurement after creating continuous query

2016-10-12 Thread tracyann . monteiro
On Wednesday, October 12, 2016 at 4:52:49 PM UTC-4, Sean Beckett wrote: > CQs only operate on recent data (by timestamp, not write time). Are you > continually inserting new values into "data"? > > > On Wed, Oct 12, 2016 at 1:56 PM, wrote: > On Wednesday, October 12,

Re: [influxdb] Not able to view new measurement after creating continuous query

2016-10-12 Thread Sean Beckett
CQs only operate on recent data (by timestamp, not write time). Are you continually inserting new values into "data"? On Wed, Oct 12, 2016 at 1:56 PM, wrote: > On Wednesday, October 12, 2016 at 3:41:20 PM UTC-4, Sean Beckett wrote: > > To clarify, SELECT * FROM

Re: [influxdb] Not able to view new measurement after creating continuous query

2016-10-12 Thread tracyann . monteiro
On Wednesday, October 12, 2016 at 3:41:20 PM UTC-4, Sean Beckett wrote: > To clarify, SELECT * FROM data.copy expands out to "fetch all fields from the > retention policy named 'data', and the measurement named 'copy'." InfluxDB > supports [.[.]] in the FROM clause, > so if there's a period, it

Re: [influxdb] Not able to view new measurement after creating continuous query

2016-10-12 Thread Sean Beckett
To clarify, SELECT * FROM data.copy expands out to "fetch all fields from the retention policy named 'data', and the measurement named 'copy'." InfluxDB supports [.[.]] in the FROM clause, so if there's a period, it is separating the DB or RP from the measurement. Using double-quotes forces the

Re: [influxdb] Not able to view new measurement after creating continuous query

2016-10-12 Thread Sean Beckett
> After creating this, how do I see the results saved in new measurement data.copy? SELECT * FROM "data.copy" On Wed, Oct 12, 2016 at 8:20 AM, wrote: > I have a measurement that has the following fields in InfluxDB. The > measurement name is data. > > Measurement

[influxdb] Not able to view new measurement after creating continuous query

2016-10-12 Thread tracyann . monteiro
I have a measurement that has the following fields in InfluxDB. The measurement name is data. Measurement name: data Time Device InterfaceMetric Value 2016-10-11T19:00:00Zdevice1_nameint_nameIn_bits10 2016-10-11T19:00:00Z