# Load Null values to Index Key column

**URL:** https://discuss.elastic.co/t/load-null-values-to-index-key-column/352879
**Category:** Elasticsearch
**Created:** [February 8, 2024, 4:38pm UTC](https://discuss.elastic.co/t/load-null-values-to-index-key-column/352879 "2024-02-08T16:38:29Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Debasis\_Mallick](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/debasis_mallick/32/123723_2.png) [@Debasis\_Mallick](https://discuss.elastic.co/u/Debasis_Mallick)
#### Post date: [February 8, 2024, 4:38pm UTC](https://discuss.elastic.co/t/load-null-values-to-index-key-column/352879/1 "2024-02-08T16:38:29Z")

</div>

Hi Team,

we had created index with location\_timestamp as key of type date and format "epoch\_millis" as below.

```
  "location_timestamp":{
    "type": "date",
    "format": "epoch_millis"
  },

```

But while loading data from csv file the 127th field which contains the value of location\_timestamp is null.  
so we are getting error as below in filebeat logs but the other field values getting loaded to the index.

`\"reason\":\"failed to parse date field [location_timestamp] with format [epoch_millis]\",\"caused_by\":{\"type\":\"date_time_parse_exception\",\"reason\":\"date_time_parse_exception: Failed to parse with all enclosed parsers\"}}}, dropping event!","service.name":"filebeat","ecs.version":"1.6.0"}`

During the process of querying the sequence key from the index, the RHS side panel of the development console displays all other keys and their corresponding values. However, the field for location\_timestamp is notably absent from the RHS side panel.

```auto
GET /myindex/_search
{
"query" : {
    "term" : { "sequence" : "38583362" }
	}
}

```

Our requirement is how we can loaded location\_timestamp field with these null values.

Thanks,  
Debasis

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 7, 2024, 4:39pm UTC](https://discuss.elastic.co/t/load-null-values-to-index-key-column/352879/2 "2024-03-07T16:39:23Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.