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] > <javascript:>> 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] <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/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]. 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/7ad7fb79-58b5-44b7-a91d-2c18c8a0141c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
