I would like to provide a SQL column value that contains concatenated strings (i.e. "value1,value2,value3") and have this value 'split' into an array data type within ElasticSearch.
I've looked at the 'join' mutator and the 'split' function but I can't seem to get it right.
I am currently using a mutator to convert lat/lon to geo_point in another configuration and the syntax makes sense as a whole; I have not been as successful with the above use case, however.
Seems I would need to split and then join. Am I adding new fields as I go and then later removing the temporary fields?
Does anyone have an example of how I might go about this?