Converting a string field of already ingested documents to an integer field

Hi,

I'm trying to convert the type of a field of already ingested documents to another type.

The pipeline incorrectly ingested documents with integers as strings, like "1" or "2" (or any other integer as string). I already corrected my logstash config file, but now I want to correct the type of the field of all the stored documents, as now I have a mapping conflict in my index pattern, and cannot do proper aggregations.

I am completely sure the conversion will never fail as the field will always have strings as "1", "2" or "3" (or any other integer number). This only happens in one index, in one field.

My Elasticsearch version is 7.3.2, Logstash 7.3.2, Kibana 7.3.2.

What is the easiest way to accomplish this?

Thanks in advance and Regards,

Jorge

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