Background: we’ve recently switched to Influx 2.0 from 1.8.
Problem: writing NULL point into measurement is not possible anymore in Influx 2.0? At least such insertion
myMeasurement,tag1=value1,tag2=value2 fieldKey2=null 1620404467677 will fail.
Discussion: whether it makes sense to write NULL (or not) in time series database is somehow related to the problem I am reporting. Basically NULL means anything so it is not so useful from data analytics point of view. On the other hand a point in time with value NULL also means that an event has occurred at that point in time, which could be enough in some cases (ie. reporting heartbeat without any meaningful value).
Another interesting point is that the Flux QL has support for handling NULLs. That could be from the legacy reasons (to support legacy DBs), but in order to do so, they first would need to be migrated into the 2.0 version, using the 2.0 interface which disallow NULLs…?