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, <tracyann.monte...@gmail.com> 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 <se...@influxdb.com>
> 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,  <tracyann...@gmail.com> 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 influxdb+u...@googlegroups.com.
> >
> > To post to this group, send email to infl...@googlegroups.com.
> >
> > 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 influxdb+unsubscr...@googlegroups.com.
> To post to this group, send email to influxdb@googlegroups.com.
> 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

-- 
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 influxdb+unsubscr...@googlegroups.com.
To post to this group, send email to influxdb@googlegroups.com.
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/CALGqCvN1RGnbUaggk8AafV7GBmveXcXH4ZYZ6Gy4-baffk3PRw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to