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, <[email protected]> wrote: > 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 [<database>.[<retention_policy>.]]<measurement> 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 query interpreter to parse that as a single > > identifier, and thus just the measurement name. > > > > > > > > > On Wed, Oct 12, 2016 at 1:29 PM, Sean Beckett <[email protected]> wrote: > > > > > > > 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, <[email protected]> wrote: > > > I have a measurement that has the following fields in InfluxDB. The > > measurement name is data. > > > > > > > > > > > > Measurement name: data > > > > > > Time Device Interface > > Metric Value > > > > > > 2016-10-11T19:00:00Z device1_name int_name In_bits 10 > > > > > > 2016-10-11T19:00:00Z device2_name int_name In_bits 5 > > > > > > . > > > > > > . > > > > > > . > > > > > > > > > > > > I have created a continuous query as follows: > > > > > > > > > > > > CREATE CONTINUOUS QUERY "test_query" ON "db_name" BEGIN SELECT sum("value") > > as Sumin INTO "data.copy" FROM "data" where metric = 'In_bits' GROUP BY > > time(15m), device END > > > > > > > > > > > > After creating this, how do I see the results saved in new measurement > > data.copy? After creating this query, I am not able to find the new > > measurement that has been created. If I'm doing something wrong, I would > > like to get more input on this matter. Thanks! > > > > > > > > > > > > -- > > > > > > Remember to include the version number! > > > > > > --- > > > > > > You received this message because you are subscribed to the Google Groups > > "InfluxData" group. > > > > > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [email protected]. > > > > > > To post to this group, send email to [email protected]. > > > > > > Visit this group at https://groups.google.com/group/influxdb. > > > > > > To view this discussion on the web visit > > https://groups.google.com/d/msgid/influxdb/8dd70a88-f5ae-43ed-8f21-083b1aedff7d%40googlegroups.com. > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > > > > > > > -- > > > > > > > > > Sean Beckett > > > Director of Support and Professional Services > > > InfluxDB > > > > > > > > > > > > > > > > > > -- > > > > > > > > > Sean Beckett > > > Director of Support and Professional Services > > > InfluxDB > > > > Hi, > > Thank you for that input. The version number is 1.0.0 > > And I have modified the continuous query to put the results into a new > measurement - "data_copy" > > If I do a "select * from data_copy" it shows - "success! (no results to > display)" > > If I do ""show measurements" I am unable to see "data_copy" > > If I just run the select statement, it does return results. However, for the > continuous query, it doesn't put it into a new measurement which is what I > want it to do. > > > > -- > > Remember to include the version number! > > --- > > You received this message because you are subscribed to the Google Groups > "InfluxData" group. > > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > > To post to this group, send email to [email protected]. > > Visit this group at https://groups.google.com/group/influxdb. > > To view this discussion on the web visit > https://groups.google.com/d/msgid/influxdb/e58f7c72-f7c2-4a01-a760-520ec13f9e98%40googlegroups.com. > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > -- > > > Sean Beckett > Director of Support and Professional Services > InfluxDB
Yes, I have a cron job that runs the python script that posts new data every 5 minutes. -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/3008622c-8d60-4242-9211-dd245da6516f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
