# Does InfluxDB automatically drop all records having null value?

**URL:** <https://community.influxdata.com/t/does-influxdb-automatically-drop-all-records-having-null-value/20922>\
**Category:** InfluxDB 2\
**Created:** [July 28, 2021, 2:05am UTC](https://community.influxdata.com/t/does-influxdb-automatically-drop-all-records-having-null-value/20922 "2021-07-28T02:05:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![phandinhcong](https://avatars.discourse-cdn.com/v4/letter/p/f08c70/32.png) [@phandinhcong](https://community.influxdata.com/u/phandinhcong)\
**Post date:** [July 28, 2021, 2:05am UTC](https://community.influxdata.com/t/does-influxdb-automatically-drop-all-records-having-null-value/20922/1 "2021-07-28T02:05:38Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Anaisdg](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/anaisdg/32/6401_2.png) [@Anaisdg](https://community.influxdata.com/u/Anaisdg)\
**Post date:** [July 30, 2021, 5:59pm UTC](https://community.influxdata.com/t/does-influxdb-automatically-drop-all-records-having-null-value/20922/2 "2021-07-30T17:59:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![phandinhcong](https://avatars.discourse-cdn.com/v4/letter/p/f08c70/32.png) [@phandinhcong](https://community.influxdata.com/u/phandinhcong)\
**Post date:** [July 31, 2021, 8:22am UTC](https://community.influxdata.com/t/does-influxdb-automatically-drop-all-records-having-null-value/20922/3 "2021-07-31T08:22:49Z")

</div>

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.