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