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/ms >> gid/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 -- 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/CALGqCvOQN-ym%3D0YUfnE2fw9B-JQNTLR2ZZa2z0Gr0eyEH3%3DBQw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
