On Thursday, November 10, 2016 at 3:50:23 PM UTC-6, Sean Beckett wrote: > I'm saying the following: > You cannot change the tag set on a point once it is written. The tag keys and > values on a point cannot be altered.You can no longer destroy the field set > by overwriting the point, you can only overwrite fields with new values. Any > fields not overwritten will retain their original values.If you want to > exclude test points, they need to have a unique tag or field value at write > time, OR, you can alter the field value later, but that's not advisable as a > frequent activity. Overwriting points is expensive. > > > On Thu, Nov 10, 2016 at 2:27 PM, <[email protected]> wrote: > On Thursday, November 10, 2016 at 12:56:54 PM UTC-6, Sean Beckett wrote: > > > On Wed, Nov 9, 2016 at 5:50 PM, <[email protected]> wrote: > > > We have test points measurements in our metrics. We would like to not > > include these in our queries. Adding the test point ids in the where > > clause will not scale. I read that the way to do something like this is to > > insert again on the same timestamp and setting a field. Is this still the > > preferred way to exclude data? > > > > > > > > > > > > As of InfluxDB 0.13, this will no longer overwrite the field set. Instead, > > it stores the union of the two field sets. > > > Say i have this value > > > > > > task,id=1,status=done,field2=2 value=1234,value2=2 1434055562000000000 > > > > > > > > > > > > and i want to exclude it from my queries , so i would insert it again > > > > > > > > > > > > task,id=1,status=xxx,field2=2 value=1234,value2=2 1434055562000000000 > > > > > > > > > > > > Those are two completely different points. A point is defined by the > > measurement, tag set, and timestamp. You've changed the tag set > > (status=xxx) so it's not the same point. Both points will fully persist. > > > > > > > > > > > > now in my queries i can do > > > > > > > > > > > > select tasks where status !=xxx > > > > > > > > > > > > Can I setup a kapacitor stream to overwrite the field or will that cause > > problems? > > > > > > > > > > > > Can I overwrite the value like this? > > > > > > > > > > > > tasks, status=xxx 1434055562000000000 > > > > > > > > > > > > Or do I have to have a value for every field? > > > > > > > > > > > > As of InfluxDB 0.13, this will no longer overwrite the field set. Instead, > > it stores the union of the two field sets. You would need to overwrite > > every field you wanted to change. > > > > > > > > > > > > Note that it is NOT possible to change tag values. > > > > > > > > > > > > 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/msgid/influxdb/f8973eca-2014-498c-85d1-5a57c20ee3cf%40googlegroups.com. > > > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > > > > > > > > > -- > > > > > > > > > Sean Beckett > > > Director of Support and Professional Services > > > InfluxDB > > > > Version 1.1 of kapacitor, influx 1.02 > > > > Are you saying it is not possible to do this and that I should try to filter > out this data before it gets into influx? > > > > -- > > 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/262e958e-7b2b-4869-9ca0-e2d817461ff7%40googlegroups.com. > > > > For more options, visit https://groups.google.com/d/optout. > > > > > > -- > > > Sean Beckett > Director of Support and Professional Services > InfluxDB
That makes sense. Thanks a lot for the answer. -- 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/fe89fde8-de81-4311-8d92-4edcae50839c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
