# How to combine Latitude and Longitude columns into one Location Column and make it's type to geo\_point in Elasticsearch and Hive Integration - Elasticsearch & Hive Integration

**URL:** <https://discuss.elastic.co/t/how-to-combine-latitude-and-longitude-columns-into-one-location-column-and-make-its-type-to-geo-point-in-elasticsearch-and-hive-integration-elasticsearch-hive-integration/167595>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [February 8, 2019, 9:16am UTC](https://discuss.elastic.co/t/how-to-combine-latitude-and-longitude-columns-into-one-location-column-and-make-its-type-to-geo-point-in-elasticsearch-and-hive-integration-elasticsearch-hive-integration/167595 "2019-02-08T09:16:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![shivakumar\_kasha](https://avatars.discourse-cdn.com/v4/letter/s/e47c2d/32.png) [@shivakumar\_kasha](https://discuss.elastic.co/u/shivakumar_kasha)\
**Post date:** [February 8, 2019, 9:16am UTC](https://discuss.elastic.co/t/how-to-combine-latitude-and-longitude-columns-into-one-location-column-and-make-its-type-to-geo-point-in-elasticsearch-and-hive-integration-elasticsearch-hive-integration/167595/1 "2019-02-08T09:16:32Z")

</div>

Hi Everyone,

I'm trying to integrate ES-Hadoop plugin to connect Hive and Elasticsearch.  
I'm able to connect the Hive and Elasticsearch. The data i'm getting in My elasticsearch index is having lat and long columns separately but i need them to be combined to one geo\_point type column so that i can plot geo maps.

I tried in the following way:

```
        "LocationLatitude_Tile" : {"type" : "geo_point","copy_to":"Location"},
        "LocationLongitude_Tile" : {"type" : "geo_point","copy_to":"Location"},
        "Location": {"type" : "geo_point" }

```

But it is not working. Lat and Lon values are not copying to Location field.

And the other issue is :  
I've a Hive table integrated with elasticsearch and i loaded the data into the table. Then I'm able to see the data in Elasticsearch but not in Hive after loading the data into hive using insert command.

Could anyone please help me out on these issues.

Thanks in advance !!

--Shivakumar

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 8, 2019, 9:16am UTC](https://discuss.elastic.co/t/how-to-combine-latitude-and-longitude-columns-into-one-location-column-and-make-its-type-to-geo-point-in-elasticsearch-and-hive-integration-elasticsearch-hive-integration/167595/2 "2019-03-08T09:16:33Z")

</div>

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