[influxdb] What happens with empty space/values?

[b***@gmail.com]

If I have a measurement that has a lot of fields, and during some of the entries that are a large amount of the fields which are not used. Does influx waste any space by having empty values for those fields. My other option was to split the fields up into different measurements, but then this would increase the series cardinality, because all measurments would have 2 tags, which would each be the same two tags for each measurement.

[j***@gmail.com]

Up to which level is that true? If I have several sensors recording at a different time, I guess I should use the sensor name as a tag instead of having a field for each sensor and only one field filled filled per point? What would be the upsides and downsides of the two solutions?

InfluxDB does not store null values in any way. There is no performance or storage penalty from having a field that appears on only one or some points in a measurement.
Note that if you explicitly write field=0, or field="0" or field="null" the system will store that as a number, string, and string, respectively. A point with field= will be invalid and fail to write. A point that does not mention a field at all will store nothing for that field.
If I have a measurement that has a lot of fields, and during some of the entries that are a large amount of the fields which are not used. Does influx waste any space by having empty values for those fields. My other option was to split the fields up into different measurements, but then this would increase the series cardinality, because all measurments would have 2 tags, which would each be the same two tags for each measurement.
--
Remember to include the InfluxDB version number with all issue reports
---
You received this message because you are subscribed to the Google Groups "InfluxDB" group.
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/b5853037-d612-434d-ac66-6b3cc667d065%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
Sean Beckett
Director of Support and Professional Services
InfluxDB