Convert a string field to geopoint

Elastic Stack Elasticsearch
1

Hi there,

We made a mistake when we were indexing our data. We have about 7.1m documents (8GB of data). Our location information has been stored as string. We want to convert this data to geopoint for visualization.
This is how the data is stored;
t locationLatLon -9.9994516,39.6986348
The field name is "locationLatLon"
The value is "-9.9994516,39.6986348"

We have changed the type to geopoint, but it is still indexing as string. We think it is because the data was already indexed as string. However, for new deployments, the same definition gets the data stored as geopoint.

Is there a simple way to convert the string field to geopoint.

Thanks,
Michael Tarimo

2

Moved to Elasticsearch category.

3

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