Importing csv met date format error

Elastic Stack Kibana
1

I'm quite new on kibana and I met the following error when importing csv file:

    File could not be read
        [illegal_argument_exception] failed to parse date field [3/3/2021 21:40:25.76] with 
        format [d/M/yyyy HH:mm:ss||dd/M/yyyy HH:mm:ss.SSS||dd/M/yyyy 
        HH:mm:ss||d/M/yyyy HH:mm:ss.SSS||dd/MM/yyyy HH:mm:ss.SSS||dd/MM/yyyy 
        HH:mm:ss]

I did some search but did not find solution. Seems I can change the date format settings, but I don't know how.

Could anyone shed some lights here?

I started the kibana and elasticsearch locally by docker-compose up -d where the docker-compose.yaml file is as follow:

version: "3"
services:
  elasticsearch:
    image: docker.elastic.co/elasticsearch/elasticsearch:7.9.2-amd64
    env_file:
      - elasticsearch.env
    volumes:
      - ./data/elasticsearch:/usr/share/elasticsearch/data
    ports:
    - 9200:9200
    - 9300:9300

  kibana:
    image: docker.elastic.co/kibana/kibana:7.9.2
    env_file:
      - kibana.env
    ports:
      - 5601:5601
2

There is a special character in date format: dd/MM/y`yyy HH:mm:ss.SSS
Can u correct and check if the error is from the above?

3

Sorry it's typo. Now I've updated the question body.

4

If you are using 1 date format you have follow that for all data records.
Incase you are using more than 1 date format, You have to define it in mapping:

PUT my-index-000001
{
  "mappings": {
    "properties": {
      "date": {
        "type":   "date",
        "format": "yyyy-MM-dd HH:mm:ss||yyyy-MM-dd||epoch_millis"
      }
    }
  }
}

You can check out more details at:

5

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