Filebeat unable to parse date with timezone

Elastic Stack Beats
1

Hello Elastic Team,

Can you, please, help me to find out why my filebeat can't parse a date with timezone properly?

Sample of data:

{"date": "2020-01-07 05:00:00+03:00", some other JSON fields}

The message I get in logs:

 "reason":"failed to parse date field [2020-01-09 16:30:00+03:00] with format [yyyy-MM-dd HH:mm:ssZ]","caused_by":{"type":"date_time_parse_exception","reason":"Text '2020-01-09 16:30:00+03:00' could not be parsed at index 19"}}}

I have the following mapping for my index:

PUT /scrapper-000001
{
  "settings": {
  	"index": {
  		"number_of_shards": 3,
  		"number_of_replicas": 1
  	}
  },
	"aliases": {
  		"scrapper": {"is_write_index": true}
  	},
  "mappings": {
    "properties": {
      "date": {"type":"date", "format":"yyyy-MM-dd HH:mm:ssZ"}
    }
  }
}

Everything looks legit and works fine till I add a timezone.

2

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