Does InfluxDB automatically drop all records having null value?

InfluxDB 2
1

Hi, I’m new to Influx 2.0. I haved tried to create a bucket and filled some fake data to my bucket from CSV file. My field column contained a list of integer numbers, but I set some null values randomly at some records. I used python code to insert data. However, my bucket only showed the records having integer values. All records containing null values were dropped.

2

Hello @phandinhcong,
Welcome. Yes you’re correct. InfluxDB doesn’t support nulls upon write, however you can return nulls.

3

Thanks for your reply. The reason I inserted some null values is to explore the alert function. I mean if we see the gap between data, it might have occurred some errors.