I tried the continuous query, CREATE CONTINUOUS QUERY "cq1" ON "telegraf" BEGIN SELECT max(*) INTO "mydb"."autogen".test1 FROM "cpu" WHERE cpu = "cpu1" GROUP BY time(1m) END. Its not working. If I remove the Where filter it worked but without Filter its not working.
On Friday, November 4, 2016 at 12:53:37 PM UTC+5:30, Sean Beckett wrote: > > You can use a continuous query: > http://docs.influxdata.com/influxdb/v1.0/query_language/continuous_queries/ > > You'll need one per customer, since each has to go to a specific database. > > On Thu, Nov 3, 2016 at 9:36 PM, Sai Birada <[email protected] > <javascript:>> wrote: > >> Hi Sean Beckett , >> Using customerid as a tag and creating a view with a filter over >> customerid do solve the purpose of having multiple series. >> But my issue here is security, I need to separate this data from main >> database and push into measurements in multiple databases. So that by >> granting each customer access to his database i can make sure that a >> customer can access only his data and not others. >> And due to architectural constraints i cant do this filtering into >> multiple databases at the time of ingesting data into main database. So is >> there some way i could use kapacitor or continous query to achieve this?. >> >> On Thursday, November 3, 2016 at 10:35:25 PM UTC+5:30, Sean Beckett wrote: >>> >>> I'm confused, because what you want is already built into the system. >>> Store the customer as a tag value, and then you can query for just that >>> series whenever you want. There's no value in separating that out into >>> another measurement. >>> >>> > insert mymeasurement,mytag=series1 value=1 >>> > insert mymeasurement,mytag=series2 value=2 >>> > select * from mymeasurement >>> name: mymeasurement >>> ------------------- >>> time mytag value >>> 1478192592201008218 series1 1 >>> 1478192600212960586 series2 2 >>> >>> > select * from mymeasurement where mytag='series1' >>> name: mymeasurement >>> ------------------- >>> time mytag value >>> 1478192592201008218 series1 1 >>> >>> > >>> >>> >>> On Thu, Nov 3, 2016 at 2:12 AM, Sai Birada <[email protected]> wrote: >>> >>>> I had a series which contains data regarding multiple customers and >>>> data will be coming in that format, I want to have multiple series ( A >>>> series for each customer ). Data will be coming into a combined series but >>>> there should be some contionous query kind of thing which filters and >>>> pushes data based on customers into their respective series. >>>> >>>> On Saturday, October 29, 2016 at 3:14:29 AM UTC+5:30, Sean Beckett >>>> wrote: >>>>> >>>>> What are you trying to accomplish with the fanout query? Fanout >>>>> queries don't make any sense with InfluxDB 1.0 schema, as far as I can >>>>> tell. It's likely that what you want to do can be done more easily some >>>>> other way, but you must describe your goal, not the method, for us to >>>>> help. >>>>> >>>>> On Fri, Oct 28, 2016 at 4:28 AM, Sai Birada <[email protected]> >>>>> wrote: >>>>> >>>>>> I had a series in a database in which i have a tag with user name. I >>>>>> want to have a continuous query which will create multiple series for >>>>>> each >>>>>> user from this series. I am trying to write this query but couldnt. I am >>>>>> very new to influxdb. Can some one tell me how to do this or whether >>>>>> this >>>>>> can be possible either by continuous query or by kapacitor. >>>>>> >>>>>> -- >>>>>> 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/987c514d-1837-4e3c-8a73-1a21b8b10510%40googlegroups.com >>>>>> >>>>>> <https://groups.google.com/d/msgid/influxdb/987c514d-1837-4e3c-8a73-1a21b8b10510%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> 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 [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/c6899d40-4148-4717-a08a-dc2023050bee%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/influxdb/c6899d40-4148-4717-a08a-dc2023050bee%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>>> 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 [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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/7ad7fb79-58b5-44b7-a91d-2c18c8a0141c%40googlegroups.com >> >> <https://groups.google.com/d/msgid/influxdb/7ad7fb79-58b5-44b7-a91d-2c18c8a0141c%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> 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 [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/a8eef361-6fe8-4f48-9f56-93c559610de2%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
