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/ms >>> gid/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]. 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/CALGqCvMzVyr1j6yg3G0NsU4ux1Gw6_YKMENZ_8Yh3u-J_DPGqA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
