Saved field "engines.time" is invalid for use with the "Date Histogram" aggregation. Please select a new field

Elastic Stack Elasticsearch
1

I am getting this error, while creating index pattern in kibana;

Error: Saved field "engines.time" is invalid for use with the "Date Histogram" aggregation. Please select a new field.
    at FieldParamType._this.deserialize (http://52.36.239.31:5601/36063/bundles/plugin/data/data.plugin.js:1:749585)
    at http://52.36.239.31:5601/36063/bundles/plugin/data/data.plugin.js:1:500490
    at Array.forEach (<anonymous>)
    at AggConfig.setParams (http://52.36.239.31:5601/36063/bundles/plugin/data/data.plugin.js:1:499912)
    at AggConfig.set (http://52.36.239.31:5601/36063/bundles/plugin/data/data.plugin.js:1:506846)
    at AggConfig.setType (http://52.36.239.31:5601/36063/bundles/plugin/data/data.plugin.js:1:506209)
    at new AggConfig (http://52.36.239.31:5601/36063/bundles/plugin/data/data.plugin.js:1:499641)
    at AggConfigs.createAggConfig (http://52.36.239.31:5601/36063/bundles/plugin/data/data.plugin.js:1:258575)
    at http://52.36.239.31:5601/36063/bundles/plugin/data/data.plugin.js:1:258964
    at Array.forEach (<anonymous>)

The index mapping we created is;

    PUT dashboard
    {
      "settings": {
        "number_of_shards": 2
        ,"number_of_replicas": 1
      },
      "mappings": {
        "properties": {
          "engines":{
            "type": "nested",
            "properties": {
              "time":{
                "type": "date",
                "format": "yyyy-MM-dd HH:mm:ss.SSS"
              },
              "cause":{
                "type": "text"
              }
            }
          }
        }
      }
    }

The time format we are trying to parse is; for ex. 2020-08-12 15:35:45.302

2

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