Convert field string type to geo_point type

Elastic Stack Elasticsearch
1

I need to convert a field string coordinates to geo_point type to visualize in kibana correctly.
I've tried to convert this field in the hive script, it's possible?

CREATE EXTERNAL TABLE hive_to_es_table
(
id string,
geo_coordinates string
)
STORED BY 'org.elasticsearch.hadoop.hive.EsStorageHandler'
TBLPROPERTIES('es.resource' = 'my_index/my_type',
'es.mapping.id' = 'id',
'es.mapping.names' = 'geo_coordinates:@geo_point',
'es.nodes' = 'minode.corp');

I have not gotten it.
Can anybody help me?
Thanks

2

Could you post your index mappings here? Normally geopoint issues are solved by updating mappings explicitly before a job auto-create's an index.

3

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